{
    "urlProxy" : "root/news4/paneldag-selectieprocedure-2010"
}

query 1: select * from userSession where sessionId=?
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ']
query 2: select * from settings
query 3: update userSession set adminOn=?, userId=?, lastIP=?, lastPageView=?, expires=? where sessionId=?
  with placeholders:  ['0', '1', '38.107.191.115', '1283949521', '1283953121', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 4: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/proxy']
query 5: select name,value from userSessionScratch where sessionId=?
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ']
query 6: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['okV4vDN0H2Nbyhti0C41Tg', '']
query 7: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='okV4vDN0H2Nbyhti0C41Tg')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 8: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='okV4vDN0H2Nbyhti0C41Tg')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 9: select groupId from groups where groupId=?
  with placeholders:  ['3']
query 10: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='okV4vDN0H2Nbyhti0C41Tg')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 11: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000054', '']
query 12: select groupId from groups where groupId=?
  with placeholders:  ['2']
query 13: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['UTEQP6nRGdb9cqqDNuM8hA', '']
query 14: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 15: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 16: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['menu']
query 17: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['cM8Lblc9XE-tDX57zNIIyg', '']
query 18: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ZQ_RHjZxwX0bhwaDnHQ8iA', '']
query 19: select assetId, className from asset where lineage=?
  with placeholders:  ['000001']
query 20: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBasset000000000000001', '']
query 21: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and ( (asset.parentId='infinity' and asset.assetId<>'PBasset000000000000001') or (asset.lineage in ('000001')) or (asset.lineage like '000001%' and asset.lineage<>'000001' and length(asset.lineage) <= 30)) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 22: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1177402350) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1177402350) and (asset.assetId=assetData.assetId and assetData.revisionDate=1177402350)
  with placeholders:  ['nlT_C0BPRcd8C9nGFwf5NA']
query 23: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1181717329) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1181717329) and (asset.assetId=assetData.assetId and assetData.revisionDate=1181717329)
  with placeholders:  ['LXAowT90yPDGd1fQY_tMnw']
query 24: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1195830665) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1195830665) and (asset.assetId=assetData.assetId and assetData.revisionDate=1195830665)
  with placeholders:  ['vnoSXQsq0kfMfhk6OMxBkQ']
query 25: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1197026005) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1197026005) and (asset.assetId=assetData.assetId and assetData.revisionDate=1197026005)
  with placeholders:  ['nqqUyLe7STYrXOnFnqBTbw']
query 26: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1218014217) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1218014217) and (asset.assetId=assetData.assetId and assetData.revisionDate=1218014217)
  with placeholders:  ['hVvLhUiU3sAa3KKaVxEyVQ']
query 27: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['okV4vDN0H2Nbyhti0C41Tg', '']
query 28: select groupId from groups where groupId=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 29: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['EJXz1AlMsEokBzanJSvVqw', '']
query 30: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['h8DIZynbkMmPccJl2R-6CQ', '']
query 31: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['YgsXv3za5yXvC1s7KXv0Lg', '']
query 32: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 33: select groupId from groups where groupId=?
  with placeholders:  ['a5mzxJmC0jcMkaF0nC_nRA']
query 34: select groupId from groups where groupName=?
  with placeholders:  ['Registered Users']
query 35: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 36: select groupId from groups where groupName=?
  with placeholders:  ['Turn Admin On']
query 37: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/top5']
query 38: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['2kUJPcAVqjqDCjWVwDTAkw', '']
query 39: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_286576fbf1e62b54', '']
query 40: select title, epoch1 as date, url

from EwiseThread

left join asset on EwiseThread.assetId=asset.assetId
left join EwisePost on EwisePost.assetId=EwiseThread.assetId and EwiseThread.revisionDate = EwisePost.revisionDate
left join assetData on assetData.assetId=EwiseThread.assetId and EwiseThread.revisionDate = assetData.revisionDate

where asset.parentId='pBOuKv6BqKRqlb-bHfOZbA' and
asset.state='published' and
asset.className='WebGUI::Asset::EwisePost::EwiseThread' and
assetData.revisionDate=(SELECT max(revisionDate) from assetData
where assetData.assetId=asset.assetId) and (assetData.status='approved' or assetData.tagId=NULL)
group by assetData.assetId
order by epoch1 desc LIMIT 5

query 41: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/congresagenda/top5']
query 42: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['vlksBAvBdwAnxA5JMuQqeA', '']
query 43: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['root/news4/paneldag-selectieprocedure-2010']
query 44: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['wRXnaowOjvlROZ0pVwGNRw', '']
query 45: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 46: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
query 47: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'desUrl', '/leden/nieuws/proxy/item']
query 48: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['sUrl', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 49: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'sUrl', '']
query 50: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_5bc9c0260961f7fe', '']
query 51: replace into EwiseThread_read (threadId, userId) values (?,?)
  with placeholders:  ['wRXnaowOjvlROZ0pVwGNRw', '1']
query 52: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4/paneldag-selectieprocedure-2010', 'wRXnaowOjvlROZ0pVwGNRw']
query 53: update assetData set title='Paneldag selectieprocedure 2010',menuTitle='Paneldag selectieprocedure 2010',url='root/news4/paneldag-selectieprocedure-2010',isHidden='0',newWindow='0',encryptPage='0',ownerUserId='oZHgyJ2D4IwayuEmMAuLJA',groupIdView='7',groupIdEdit='3',synopsis='INFORMATIE SELECTIEPROCEDURE UROLOGIE 2010 De procedure omvat drie onderdelen: a. Schriftelijke aanmelding en voorselectie op basis van het aanmeldingsformulier. Het formulier is binnenkort hier te downloaden en moet uiterlijk 15 februari 2010 bij de NVU ontvangen zijn. b. Centrale selectie in Utrecht door middel van een interview met een panel van urologen. Deze vindt plaats op 23 april 2010. c. Sollicitatie in de clusters van keuze ',extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='3711' where assetId='wRXnaowOjvlROZ0pVwGNRw' and revisionDate=1260450619
query 54: update EwisePost set dateUpdated='1260450619',text26=NULL,content='

INFORMATIE SELECTIEPROCEDURE UROLOGIE  2010

De procedure omvat drie onderdelen:

a.      Schriftelijke aanmelding en voorselectie op basis van het aanmeldingsformulier. Het formulier is binnenkort hier te downloaden en moet uiterlijk 15 februari 2010 bij de NVU ontvangen zijn.

b.      Centrale selectie in Utrecht door middel van een interview met een panel van urologen. Deze vindt plaats op 23 april 2010.

c.      Sollicitatie in de clusters van keuze ',text29=NULL,HTMLArea7=NULL,HTMLArea6=NULL,threadId='wRXnaowOjvlROZ0pVwGNRw',text24=NULL,HTMLArea5=NULL,text37=NULL,integer5='0',integer2='0',text40=NULL,integer3='0',text25=NULL,username='NVUwebmaster',text15=NULL,integer4='0',storageId='PbCxKUfjTHqZbNuC931Fqw',text32=NULL,text3=NULL,text21=NULL,integer6='0',dateSubmitted='1254214380',text39=NULL,text11=NULL,views='2970',text19=NULL,integer7='0',text7=NULL,text20=NULL,text8=NULL,textarea3=NULL,text30=NULL,text10=NULL,HTMLArea8=NULL,text22=NULL,text9=NULL,text28=NULL,text27=NULL,epoch8=NULL,epoch7=NULL,epoch6=NULL,text35=NULL,integer9='0',epoch10='1577898000',integer8='0',epoch9=NULL,text4=NULL,epoch1='1271973600',textarea1=NULL,epoch4=NULL,text33=NULL,integer1='1',text12=NULL,textarea2=NULL,HTMLArea3=NULL,text17=NULL,text5=NULL,text38=NULL,text18=NULL,rating='0',text36=NULL,HTMLArea2=NULL,HTMLArea10=NULL,epoch3=NULL,text16=NULL,text14=NULL,epoch5=NULL,text23=NULL,text6=NULL,contentType='mixed',text31=NULL,epoch2=NULL,text34=NULL,HTMLArea1='

INFORMATIE SELECTIEPROCEDURE UROLOGIE  2010

De procedure omvat drie onderdelen:

a.      Schriftelijke aanmelding en voorselectie op basis van het aanmeldingsformulier.
Het formulier kunt u hier downloaden en moet uiterlijk 15 februari 2010 bij de NVU ontvangen zijn.

b.      Centrale selectie in Utrecht door middel van een interview met een panel van urologen. Deze vindt plaats op 23 april 2010.

c.      Sollicitatie in de clusters van keuze

',text1=NULL,HTMLArea9=NULL,text2=NULL,integer10='0',text13=NULL,HTMLArea4=NULL where assetId='wRXnaowOjvlROZ0pVwGNRw' and revisionDate=1260450619
query 55: update EwiseThread set lastPostDate=NULL,isLocked='0',karma='0',replies='0',isSticky='0',lastPostId=NULL,subscriptionGroupId='VJY8-7PT8NrvEIIh9V3zTQ',karmaScale='1',karmaRank='0.000000' where assetId='wRXnaowOjvlROZ0pVwGNRw' and revisionDate=1260450619
query 56: update assetData set assetSize=3711 where assetId='wRXnaowOjvlROZ0pVwGNRw' and revisionDate='1260450619'
query 57: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4', 'pBOuKv6BqKRqlb-bHfOZbA']
query 58: update assetData set title='News',menuTitle='News',url='root/news4',isHidden='1',newWindow='0',encryptPage='0',ownerUserId='3',groupIdView='7',groupIdEdit='3',synopsis='pBOuKv6BqKRqlb-bHfOZbA',extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='698' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 59: update wobject set description=NULL,displayTitle='0',styleTemplateId='UTEQP6nRGdb9cqqDNuM8hA',printableStyleTemplateId='PBtmpl0000000000000060' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 60: update RSSCapable set rssCapableRssEnabled='1',rssCapableRssTemplateId='PBtmpl0000000000000142',rssCapableRssFromParentId='GBE0gJNcPjqC41KLAcSbdA' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 61: update EwiseCollaboration set rssTemplateId='PBtmpl0000000000000142',postFormTemplateId='ewise_9d82434c3a4ec62e',sortBy='epoch1',approvalWorkflow='pbworkflow000000000003',replies='0',displayLastReply='0',getMail='0',allowReplies='1',sortOrder='desc',notificationTemplateId='PBtmpl0000000000000027',collaborationTemplateId='ewise_bb8661e8d206474c',filterCode='javascript',visitorCacheTimeout='3600',mailAddress=NULL,karmaPerPost='0',getMailCronId='IgT59hQfKMYMR8XbA37yrw',searchTemplateId='PBtmpl0000000000000031',threadsPerPage='300',mailServer=NULL,useContentFilter='1',karmaSpentToRate='0',mailPrefix=NULL,mailPassword=NULL,requireSubscriptionForEmailPosting='1',OrderByAssetTree='0',lastPostDate='1283869182',mailAccount=NULL,postsPerPage='10',rating='0',views='145912',autoSubscribeToThread='1',attachmentsPerPost='10',editPostGroupId='yCPQyxIuP00BOqeT2hTJZg',usePreview='0',subscriptionGroupId='2MaQk_5a8IPDRXqc9NyyBA',threadTemplateId='ewise_5bc9c0260961f7fe',avatarsEnabled='0',defaultKarmaScale='1',getMailInterval='300',richEditor='PBrichedit000000000001',archiveAfter='315360000',threads='89',postGroupId='yCPQyxIuP00BOqeT2hTJZg',editTimeout='3600',karmaRatingMultiplier='0',lastPostId='q8WMBcNkJsvHIVjYbczlQw',addEditStampToPosts='0' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 62: update assetData set assetSize=698 where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate='1266496175'
query 63: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'discussionLayout', '']
query 64: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['wRXnaowOjvlROZ0pVwGNRw', '38.107.191.115']
query 65: select groupId from groups where groupId=?
  with placeholders:  ['VJY8-7PT8NrvEIIh9V3zTQ']
query 66: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'VJY8-7PT8NrvEIIh9V3zTQ']
query 67: select * from groups where groupId=?
  with placeholders:  ['VJY8-7PT8NrvEIIh9V3zTQ']
query 68: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['VJY8-7PT8NrvEIIh9V3zTQ']
query 69: select asset.assetId, asset.className, assetData.revisionDate as revisionDate, assetData.url as url from asset
left join assetData on assetData.assetId=asset.assetId
left join EwisePost on EwisePost.assetId=assetData.assetId and assetData.revisionDate=EwisePost.revisionDate
where asset.lineage like '000001000002000002000006000002000060%' and asset.state='published'
and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId
and (
assetData.status in ('approved','archived')
or assetData.tagId=NULL or (assetData.ownerUserId='1' and assetData.ownerUserId<>'1')
))
group by assetData.assetId
order by asset.lineage
query 70: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1260450619) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1260450619) and (asset.assetId=assetData.assetId and assetData.revisionDate=1260450619)
  with placeholders:  ['wRXnaowOjvlROZ0pVwGNRw']
query 71: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 72: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
query 73: select * from asset,EwiseCollaboration,RSSCapable,wobject,assetData where asset.assetId=? and (asset.assetId=EwiseCollaboration.assetId and EwiseCollaboration.revisionDate=1266496175) and (asset.assetId=RSSCapable.assetId and RSSCapable.revisionDate=1266496175) and (asset.assetId=wobject.assetId and wobject.revisionDate=1266496175) and (asset.assetId=assetData.assetId and assetData.revisionDate=1266496175)
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA']
query 74: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['wRXnaowOjvlROZ0pVwGNRw', '38.107.191.115']
query 75: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['desUrl', 'ke_QWOa1uTMARZ5T2WHGwQ']