Commissies

{
    "op" : "makePrintable"
}

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.117', '1283950428', '1283954028', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 4: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['root/commissies']
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:  ['nI1KsJ8OWcSxk1HWdf2T8A', '']
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='nI1KsJ8OWcSxk1HWdf2T8A')) 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='nI1KsJ8OWcSxk1HWdf2T8A')) 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='nI1KsJ8OWcSxk1HWdf2T8A')) 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:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 13: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 14: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBasset000000000000001', '']
query 15: select className from asset where assetId=?
  with placeholders:  ['PBasset000000000000001']
query 16: select groupId from groups where groupId=?
  with placeholders:  ['2']
query 17: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000060', '']
query 18: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['flexmenu']
query 19: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBnav00000000000000014', '']
query 20: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 21: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000048', '']
query 22: 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.lineage like '000001000009%' and length(asset.lineage)=18))) 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 23: 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:  ['nI1KsJ8OWcSxk1HWdf2T8A', '']
query 24: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000043', '']
query 25: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000037', '']
query 26: select className from asset where assetId='6RXJbrOVpMwAa3qVU0EQDg'
query 27: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['6RXJbrOVpMwAa3qVU0EQDg', '']
query 28: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000042', '']