{
    "urlProxy" : "root/news4/gebruik-simulatoren-in-opleiding-urologie-belangrijke-vooruitgang"
}

query 1: select * from userSession where sessionId=?
  with placeholders:  ['INIt_naBzwls7lwlw5sxMw']
query 2: select * from settings
query 3: update userSession set adminOn=?, userId=?, lastIP=?, lastPageView=?, expires=? where sessionId=?
  with placeholders:  ['0', '1', '38.107.191.118', '1284140038', '1284143638', 'INIt_naBzwls7lwlw5sxMw']
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:  ['INIt_naBzwls7lwlw5sxMw']
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 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 23: select groupId from groups where groupId=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 24: 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 25: 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 26: 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 27: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 28: select groupId from groups where groupId=?
  with placeholders:  ['a5mzxJmC0jcMkaF0nC_nRA']
query 29: select groupId from groups where groupName=?
  with placeholders:  ['Registered Users']
query 30: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 31: select groupId from groups where groupName=?
  with placeholders:  ['Turn Admin On']
query 32: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/top5']
query 33: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['2kUJPcAVqjqDCjWVwDTAkw', '']
query 34: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_286576fbf1e62b54', '']
query 35: 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 36: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/congresagenda/top5']
query 37: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['vlksBAvBdwAnxA5JMuQqeA', '']
query 38: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['root/news4/gebruik-simulatoren-in-opleiding-urologie-belangrijke-vooruitgang']
query 39: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['miVii0JPpZlOGd-ZlvGf1w', '']
query 40: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 41: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
query 42: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['INIt_naBzwls7lwlw5sxMw', 'desUrl', '/leden/nieuws/proxy/item']
query 43: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['sUrl', 'INIt_naBzwls7lwlw5sxMw']
query 44: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['INIt_naBzwls7lwlw5sxMw', 'sUrl', '']
query 45: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_5bc9c0260961f7fe', '']
query 46: replace into EwiseThread_read (threadId, userId) values (?,?)
  with placeholders:  ['miVii0JPpZlOGd-ZlvGf1w', '1']
query 47: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4/gebruik-simulatoren-in-opleiding-urologie-belangrijke-vooruitgang', 'miVii0JPpZlOGd-ZlvGf1w']
query 48: update assetData set title='Gebruik simulatoren in opleiding urologie belangrijke vooruitgang ',menuTitle='Gebruik simulatoren in opleiding urologie belangrijke vooruitgang ',url='root/news4/gebruik-simulatoren-in-opleiding-urologie-belangrijke-vooruitgang',isHidden='0',newWindow='0',encryptPage='0',ownerUserId='oZHgyJ2D4IwayuEmMAuLJA',groupIdView='7',groupIdEdit='3',synopsis='Bron: VU Medisch Centrum - 3/03/2010 De aanpak en invoering van training in een skills lab en op simulatoren in de opleiding van urologen is zeer wenselijk en levert belangrijke voordelen op. Lees meer... ',extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='1814' where assetId='miVii0JPpZlOGd-ZlvGf1w' and revisionDate=1267695751
query 49: update EwisePost set dateUpdated='1267695751',text26=NULL,content='',text29=NULL,HTMLArea7=NULL,HTMLArea6=NULL,threadId='miVii0JPpZlOGd-ZlvGf1w',text24=NULL,HTMLArea5=NULL,text37=NULL,integer5='0',integer2='0',text40=NULL,integer3='0',text25=NULL,username='NVUwebmaster',text15=NULL,integer4='0',storageId='XoFrzO74yx7pKNESMFhdiw',text32=NULL,text3=NULL,text21=NULL,integer6='0',dateSubmitted='1267695674',text39=NULL,text11=NULL,views='772',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='1267657200',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='',text1=NULL,HTMLArea9=NULL,text2=NULL,integer10='0',text13=NULL,HTMLArea4=NULL where assetId='miVii0JPpZlOGd-ZlvGf1w' and revisionDate=1267695751
query 50: update EwiseThread set lastPostDate=NULL,isLocked='0',karma='0',replies='0',isSticky='0',lastPostId=NULL,subscriptionGroupId='f_HSp0kg6bikAHz-zz9MSA',karmaScale='1',karmaRank='0.000000' where assetId='miVii0JPpZlOGd-ZlvGf1w' and revisionDate=1267695751
query 51: update assetData set assetSize=1814 where assetId='miVii0JPpZlOGd-ZlvGf1w' and revisionDate='1267695751'
query 52: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4', 'pBOuKv6BqKRqlb-bHfOZbA']
query 53: 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 54: update wobject set description=NULL,displayTitle='0',styleTemplateId='UTEQP6nRGdb9cqqDNuM8hA',printableStyleTemplateId='PBtmpl0000000000000060' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 55: update RSSCapable set rssCapableRssEnabled='1',rssCapableRssTemplateId='PBtmpl0000000000000142',rssCapableRssFromParentId='GBE0gJNcPjqC41KLAcSbdA' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 56: 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='146425',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 57: update assetData set assetSize=698 where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate='1266496175'
query 58: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['INIt_naBzwls7lwlw5sxMw', 'discussionLayout', '']
query 59: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['miVii0JPpZlOGd-ZlvGf1w', '38.107.191.118']
query 60: select groupId from groups where groupId=?
  with placeholders:  ['f_HSp0kg6bikAHz-zz9MSA']
query 61: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'f_HSp0kg6bikAHz-zz9MSA']
query 62: select * from groups where groupId=?
  with placeholders:  ['f_HSp0kg6bikAHz-zz9MSA']
query 63: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['f_HSp0kg6bikAHz-zz9MSA']
query 64: 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 '000001000002000002000006000002000081%' 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 65: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1267695751) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1267695751) and (asset.assetId=assetData.assetId and assetData.revisionDate=1267695751)
  with placeholders:  ['miVii0JPpZlOGd-ZlvGf1w']
query 66: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 67: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
query 68: 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 69: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['miVii0JPpZlOGd-ZlvGf1w', '38.107.191.118']
query 70: Select asset.*,assetData.*,EwiseThread.*,username,content,EwisePost.storageId,EwisePost.dateSubmitted,EwisePost.dateUpdated,EwisePost.assetId,EwisePost.revisionDate,EwisePost.threadId,EwisePost.rating,EwisePost.views ,HTMLArea1 From asset
Inner Join EwisePost ON EwisePost.assetId = asset.assetId
Inner Join assetData on assetData.assetId = asset.assetId and assetData.revisionDate= EwisePost.revisionDate
Inner Join EwiseThread on EwiseThread.assetId = asset.assetId and EwiseThread.revisionDate= EwisePost.revisionDate
where asset.parentId='9lbnlyYVk0Gn-2Y_-U3CfQ' and asset.className='WebGUI::Asset::EwisePost::EwiseThread' and state='published' and (assetData.status='approved'
or assetData.tagId=NULL) and EwisePost.revisionDate=( select max(EwisePost.revisionDate) From EwisePost where EwisePost.assetId=asset.assetId ) order by EwiseThread.isSticky desc, dateSubmitted asc
query 71: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['desUrl', 'INIt_naBzwls7lwlw5sxMw']