{
    "urlProxy" : "root/news4/eau-guidelines-online"
}

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.119', '1283950589', '1283954189', '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 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/eau-guidelines-online']
query 39: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['Lnd2hW2mKwqOsthcF2kxiA', '']
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:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'desUrl', '/leden/nieuws/proxy/item']
query 43: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['sUrl', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 44: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', '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:  ['Lnd2hW2mKwqOsthcF2kxiA', '1']
query 47: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4/eau-guidelines-online', 'Lnd2hW2mKwqOsthcF2kxiA']
query 48: update assetData set title='EAU guidelines online',menuTitle='EAU guidelines online',url='root/news4/eau-guidelines-online',isHidden='0',newWindow='0',encryptPage='0',ownerUserId='oZHgyJ2D4IwayuEmMAuLJA',groupIdView='7',groupIdEdit='3',synopsis='De nieuwe (geupdate) EAU guidelines zijn nu online toegankelijk voor iedereen. Onder leiding van de Gunnar Aus is de EAU guidelines committee erin geslaagd weer een indrukwekkend boekwerk voor de dagelijkse urologische praktijk af te leveren. Alle facetten van de urologie komen in dit lijfige naslagwerk aan bod. Voor de overzichtelijkheid is zijn de guidelines nu ook online te raadplegen. Over een PDA versie wordt nagedacht. Anders dan voorheen zijn de guidelines het resultaat van een terdege uitgevoerde literatuur studie van de verschillende subgroepen van de committee. Niet alleen heel bruikbaar voor de dagelijkse praktijk maar ook zeer nuttig als bron voor bij- en nascholingen. Begin 2008 zal de volgende editie van de guidelines verschijnen. Meer dan 80% van de subgroep voorzitters heeft al laten weten dan wederom een update van hun onderwerp te zullen verzorgen (HvdP). EAU guidelines ',extraHeadTags=NULL,isPackage='0',isPrototype='0',status='approved',assetSize='4008' where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate=1268125898
query 49: update EwisePost set dateUpdated='1268125898',text26=NULL,content='
De nieuwe (geupdate) EAU guidelines zijn nu online toegankelijk voor iedereen. Onder leiding van de Gunnar Aus is de EAU guidelines committee erin geslaagd weer een indrukwekkend boekwerk voor de dagelijkse urologische praktijk af te leveren. Alle facetten van de urologie komen in dit lijfige naslagwerk aan bod. Voor de overzichtelijkheid is zijn de guidelines nu ook online te raadplegen. Over een PDA versie wordt nagedacht. Anders dan voorheen zijn de guidelines het resultaat van een terdege uitgevoerde literatuur studie van de verschillende subgroepen van de committee. Niet alleen heel bruikbaar voor de dagelijkse praktijk maar ook zeer nuttig als bron voor bij- en nascholingen. Begin 2008 zal de volgende editie van de guidelines verschijnen. Meer dan 80% van de subgroep voorzitters heeft al laten weten dan wederom een update van hun onderwerp te zullen verzorgen (HvdP).

EAU guidelines

',text29=NULL,HTMLArea7=NULL,HTMLArea6=NULL,threadId='Lnd2hW2mKwqOsthcF2kxiA',text24=NULL,HTMLArea5=NULL,text37=NULL,integer5='0',integer2='0',text40=NULL,integer3='0',text25=NULL,username='NVUwebmaster',text15=NULL,integer4='0',storageId='jHb7ZEjF7l7p6b_mDpSg1w',text32=NULL,text3=NULL,text21=NULL,integer6='0',dateSubmitted='1178363016',text39=NULL,text11=NULL,views='4308',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='1268089200',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='
De nieuwe (geupdate) EAU guidelines zijn nu online toegankelijk voor iedereen. Onder leiding van de Gunnar Aus is de EAU guidelines committee erin geslaagd weer een indrukwekkend boekwerk voor de dagelijkse urologische praktijk af te leveren. Alle facetten van de urologie komen in dit lijfige naslagwerk aan bod. Voor de overzichtelijkheid is zijn de guidelines nu ook online te raadplegen. Over een PDA versie wordt nagedacht. Anders dan voorheen zijn de guidelines het resultaat van een terdege uitgevoerde literatuur studie van de verschillende subgroepen van de committee. Niet alleen heel bruikbaar voor de dagelijkse praktijk maar ook zeer nuttig als bron voor bij- en nascholingen. Begin 2008 zal de volgende editie van de guidelines verschijnen. Meer dan 80% van de subgroep voorzitters heeft al laten weten dan wederom een update van hun onderwerp te zullen verzorgen (HvdP).

EAU guidelines

',text1=NULL,HTMLArea9=NULL,text2=NULL,integer10='0',text13=NULL,HTMLArea4=NULL where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate=1268125898
query 50: update EwiseThread set lastPostDate=NULL,isLocked='0',karma='0',replies='0',isSticky='0',lastPostId=NULL,subscriptionGroupId='UpIFcx5_xmU8dWG_sstQIQ',karmaScale='1',karmaRank='0.000000' where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate=1268125898
query 51: update assetData set assetSize=4008 where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate='1268125898'
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='145916',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:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'discussionLayout', '']
query 59: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['Lnd2hW2mKwqOsthcF2kxiA', '38.107.191.119']
query 60: select groupId from groups where groupId=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
query 61: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'UpIFcx5_xmU8dWG_sstQIQ']
query 62: select * from groups where groupId=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
query 63: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
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 '000001000002000002000006000002000005%' 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=1268125898) and (asset.assetId=EwisePost.assetId and EwisePost.revisionDate=1268125898) and (asset.assetId=assetData.assetId and assetData.revisionDate=1268125898)
  with placeholders:  ['Lnd2hW2mKwqOsthcF2kxiA']
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:  ['Lnd2hW2mKwqOsthcF2kxiA', '38.107.191.119']
query 70: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['desUrl', 'ke_QWOa1uTMARZ5T2WHGwQ']