LUTS/BPH (4-11-05)
{
    "objectSynopsis" : ""
}
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', '1283949836', '1283953436', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 4: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['root/item114/luts/bph-4-11-05']
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:  ['8n857Fqau-OvuQXjNNYNmw', '']
query 7: select className from asset where assetId='XIqzN5NDrRumChSqNsyIVA'
query 8: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['XIqzN5NDrRumChSqNsyIVA', '']
query 9: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 10: select groupId from groups where groupId=?
  with placeholders:  ['3']
query 11: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_9716b243d688fcf4', '']
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:  ['PwNXWFH4E7CKrG614tZW8A', '']
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:  ['8n857Fqau-OvuQXjNNYNmw', '']
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:  ['a5mzxJmC0jcMkaF0nC_nRA']
query 28: select groupId from groups where groupName=?
  with placeholders:  ['Registered Users']
query 29: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 30: select groupId from groups where groupName=?
  with placeholders:  ['Turn Admin On']
query 31: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/top5']
query 32: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['2kUJPcAVqjqDCjWVwDTAkw', '']
query 33: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_286576fbf1e62b54', '']
query 34: 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 35: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/congresagenda/top5']
query 36: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['vlksBAvBdwAnxA5JMuQqeA', '']
query 37: replace into EwiseThread_read (threadId, userId) values (?,?)
  with placeholders:  ['8n857Fqau-OvuQXjNNYNmw', '1']
query 38: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/item114/luts/bph-4-11-05', '8n857Fqau-OvuQXjNNYNmw']
query 39: update assetData set title='LUTS/BPH (4-11-05) ',menuTitle='LUTS/BPH (4-11-05) ',url='root/item114/luts/bph-4-11-05',isHidden='1',newWindow='0',encryptPage='0',ownerUserId='3',groupIdView='7',groupIdEdit='3',synopsis=NULL,extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='421' where assetId='8n857Fqau-OvuQXjNNYNmw' and revisionDate=1177402358
query 40: update EwisePost set dateUpdated='1177402358',text26=NULL,content=NULL,text29=NULL,HTMLArea7=NULL,HTMLArea6=NULL,threadId='8n857Fqau-OvuQXjNNYNmw',text24=NULL,HTMLArea5=NULL,text37=NULL,integer5='0',integer2='0',text40=NULL,integer3='0',text25=NULL,username='NVUwebmaster',text15=NULL,integer4='0',storageId='SVcAWD4KpE0i76r88J-H_g',text32=NULL,text3=NULL,text21=NULL,integer6='0',dateSubmitted='1171360461',text39=NULL,text11=NULL,views='892',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=NULL,textarea1=NULL,epoch4=NULL,text33=NULL,integer1='0',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=NULL,text1=NULL,HTMLArea9=NULL,text2=NULL,integer10='0',text13=NULL,HTMLArea4=NULL where assetId='8n857Fqau-OvuQXjNNYNmw' and revisionDate=1177402358
query 41: update EwiseThread set lastPostDate=NULL,isLocked='0',karma='0',replies='0',isSticky='0',lastPostId=NULL,subscriptionGroupId='m4qUeMfcPeBqVzCORwdeBA',karmaScale='1',karmaRank='0.000000' where assetId='8n857Fqau-OvuQXjNNYNmw' and revisionDate=1177402358
query 42: update assetData set assetSize=421 where assetId='8n857Fqau-OvuQXjNNYNmw' and revisionDate='1177402358'
query 43: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/item114', 'XIqzN5NDrRumChSqNsyIVA']
query 44: update assetData set title='Item',menuTitle='Item',url='root/item114',isHidden='1',newWindow='0',encryptPage='0',ownerUserId='3',groupIdView='7',groupIdEdit='3',synopsis=NULL,extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='941' where assetId='XIqzN5NDrRumChSqNsyIVA' and revisionDate=1265367390
query 45: update wobject set description='Overzicht NVU-richtlijnen
Hieronder treft u een overzicht aan van de reeds verschenen richtlijnen van de NVU. Deze richtlijnen kunt u downloaden en printen (PDF) door op het icoon of de titel van de richtlijn te klikken.
',displayTitle='0',styleTemplateId='PwNXWFH4E7CKrG614tZW8A',printableStyleTemplateId='PBtmpl0000000000000060' where assetId='XIqzN5NDrRumChSqNsyIVA' and revisionDate=1265367390
query 46: update RSSCapable set rssCapableRssEnabled='1',rssCapableRssTemplateId='PBtmpl0000000000000142',rssCapableRssFromParentId='UuhOKq6Lv0ph67w8ZPD4vA' where assetId='XIqzN5NDrRumChSqNsyIVA' and revisionDate=1265367390
query 47: update EwiseCollaboration set rssTemplateId='PBtmpl0000000000000142',postFormTemplateId='ewise_df9c18388e5f8290',sortBy='dateSubmitted',approvalWorkflow='pbworkflow000000000003',replies='0',displayLastReply='0',getMail='0',allowReplies='1',sortOrder='asc',notificationTemplateId='PBtmpl0000000000000027',collaborationTemplateId='ewise_ea92e98a7df3ad26',filterCode='javascript',visitorCacheTimeout='3600',mailAddress=NULL,karmaPerPost='0',getMailCronId='Neq4tW_cwyuQPEfC-f4jrg',searchTemplateId='PBtmpl0000000000000031',threadsPerPage='30',mailServer=NULL,useContentFilter='1',karmaSpentToRate='0',mailPrefix=NULL,mailPassword=NULL,requireSubscriptionForEmailPosting='1',OrderByAssetTree='0',lastPostDate='1242386902',mailAccount=NULL,postsPerPage='10',rating='0',views='15834',autoSubscribeToThread='1',attachmentsPerPost='5',editPostGroupId='yCPQyxIuP00BOqeT2hTJZg',usePreview='0',subscriptionGroupId='yMPaWbSQXS7kk4-AedUBpg',threadTemplateId='ewise_9716b243d688fcf4',avatarsEnabled='0',defaultKarmaScale='1',getMailInterval='300',richEditor='PBrichedit000000000002',archiveAfter='31536000',threads='17',postGroupId='yCPQyxIuP00BOqeT2hTJZg',editTimeout='3600',karmaRatingMultiplier='0',lastPostId='rGSMKWmsyJgJtIsVmSChNQ',addEditStampToPosts='0' where assetId='XIqzN5NDrRumChSqNsyIVA' and revisionDate=1265367390
query 48: update assetData set assetSize=941 where assetId='XIqzN5NDrRumChSqNsyIVA' and revisionDate='1265367390'
query 49: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'discussionLayout', '']
query 50: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['8n857Fqau-OvuQXjNNYNmw', '38.107.191.115']
query 51: select groupId from groups where groupId=?
  with placeholders:  ['m4qUeMfcPeBqVzCORwdeBA']
query 52: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'm4qUeMfcPeBqVzCORwdeBA']
query 53: select * from groups where groupId=?
  with placeholders:  ['m4qUeMfcPeBqVzCORwdeBA']
query 54: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['m4qUeMfcPeBqVzCORwdeBA']
query 55: 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 '000001000014000002000001000008000002000001000016%' 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 56: select * from asset,EwiseThread,EwisePost,assetData where asset.assetId=? and (asset.assetId=EwiseThread.assetId and EwiseThread.revisionDate=1177402358) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1177402358) and (asset.assetId=assetData.assetId and assetData.revisionDate=1177402358)
  with placeholders:  ['8n857Fqau-OvuQXjNNYNmw']
query 57: select className from asset where assetId='XIqzN5NDrRumChSqNsyIVA'
query 58: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['XIqzN5NDrRumChSqNsyIVA', '']
query 59: select * from asset,EwiseCollaboration,RSSCapable,wobject,assetData where asset.assetId=? and (asset.assetId=EwiseCollaboration.assetId and EwiseCollaboration.revisionDate=1265367390) and (asset.assetId=RSSCapable.assetId and RSSCapable.revisionDate=1265367390) and (asset.assetId=wobject.assetId and wobject.revisionDate=1265367390) and (asset.assetId=assetData.assetId and assetData.revisionDate=1265367390)
  with placeholders:  ['XIqzN5NDrRumChSqNsyIVA']
query 60: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['8n857Fqau-OvuQXjNNYNmw', '38.107.191.115']
query 61: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['sUrl', 'ke_QWOa1uTMARZ5T2WHGwQ']