NVU - EAU guidelines online

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.115', '1284140733', '1284144333', 'INIt_naBzwls7lwlw5sxMw']
query 4: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['root/news4/eau-guidelines-online']
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:  ['Lnd2hW2mKwqOsthcF2kxiA', '']
query 7: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 8: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
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_5bc9c0260961f7fe', '']
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:  ['Lnd2hW2mKwqOsthcF2kxiA', '']
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:  ['Lnd2hW2mKwqOsthcF2kxiA', '1']
query 38: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4/eau-guidelines-online', 'Lnd2hW2mKwqOsthcF2kxiA']
query 39: 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 40: 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='4314',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='

EAU guidelines

',text1=NULL,HTMLArea9=NULL,text2=NULL,integer10='0',text13=NULL,HTMLArea4=NULL where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate=1268125898
query 41: 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 42: update assetData set assetSize=4008 where assetId='Lnd2hW2mKwqOsthcF2kxiA' and revisionDate='1268125898'
query 43: select count(url) from assetData where url=? and assetId<>?
  with placeholders:  ['root/news4', 'pBOuKv6BqKRqlb-bHfOZbA']
query 44: 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 45: update wobject set description=NULL,displayTitle='0',styleTemplateId='UTEQP6nRGdb9cqqDNuM8hA',printableStyleTemplateId='PBtmpl0000000000000060' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 46: update RSSCapable set rssCapableRssEnabled='1',rssCapableRssTemplateId='PBtmpl0000000000000142',rssCapableRssFromParentId='GBE0gJNcPjqC41KLAcSbdA' where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate=1266496175
query 47: 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='146428',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 48: update assetData set assetSize=698 where assetId='pBOuKv6BqKRqlb-bHfOZbA' and revisionDate='1266496175'
query 49: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['INIt_naBzwls7lwlw5sxMw', 'discussionLayout', '']
query 50: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['Lnd2hW2mKwqOsthcF2kxiA', '38.107.191.115']
query 51: select groupId from groups where groupId=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
query 52: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'UpIFcx5_xmU8dWG_sstQIQ']
query 53: select * from groups where groupId=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
query 54: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['UpIFcx5_xmU8dWG_sstQIQ']
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 '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 56: 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 57: select className from asset where assetId='pBOuKv6BqKRqlb-bHfOZbA'
query 58: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['pBOuKv6BqKRqlb-bHfOZbA', '']
query 59: 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 60: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['Lnd2hW2mKwqOsthcF2kxiA', '38.107.191.115']
query 61: 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 62: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['sUrl', 'INIt_naBzwls7lwlw5sxMw']