Inloggen

{
    "method" : "login",
    "op" : "auth"
}

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.118', '1283949752', '1283953352', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 4: select name,value from userSessionScratch where sessionId=?
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ']
query 5: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['auth_ewise000000000006', '']
query 6: select groupId from groups where groupId=?
  with placeholders:  ['2']
query 7: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['UTEQP6nRGdb9cqqDNuM8hA', '']
query 8: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 9: select groupId from groups where groupId=?
  with placeholders:  ['3']
query 10: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 11: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['menu']
query 12: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['cM8Lblc9XE-tDX57zNIIyg', '']
query 13: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ZQ_RHjZxwX0bhwaDnHQ8iA', '']
query 14: select className from asset where assetId='6RXJbrOVpMwAa3qVU0EQDg'
query 15: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['6RXJbrOVpMwAa3qVU0EQDg', '']
query 16: select assetId, className from asset where lineage=?
  with placeholders:  ['000001']
query 17: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBasset000000000000001', '']
query 18: 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 19: 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:  ['6RXJbrOVpMwAa3qVU0EQDg', '']
query 20: select groupId from groups where groupId=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 21: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'YWnUFSm5b6V3VHyIrKzHAw']
query 22: select * from groups where groupId=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 23: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 24: select groupId from groups where groupId=?
  with placeholders:  ['OThqNeYegY1IrD8lTKtbCA']
query 25: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', 'OThqNeYegY1IrD8lTKtbCA']
query 26: select * from groups where groupId=?
  with placeholders:  ['OThqNeYegY1IrD8lTKtbCA']
query 27: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['OThqNeYegY1IrD8lTKtbCA']
query 28: select groupId from groups where groupId=?
  with placeholders:  ['-ThUqvy-pnJUqLfNhjVTBg']
query 29: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '-ThUqvy-pnJUqLfNhjVTBg']
query 30: select * from groups where groupId=?
  with placeholders:  ['-ThUqvy-pnJUqLfNhjVTBg']
query 31: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['-ThUqvy-pnJUqLfNhjVTBg']
query 32: select groupId from groups where groupId=?
  with placeholders:  ['3r4smP5ErwFDGOg5WGPL9g']
query 33: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '3r4smP5ErwFDGOg5WGPL9g']
query 34: select * from groups where groupId=?
  with placeholders:  ['3r4smP5ErwFDGOg5WGPL9g']
query 35: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['3r4smP5ErwFDGOg5WGPL9g']
query 36: select groupId from groups where groupId=?
  with placeholders:  ['a5mzxJmC0jcMkaF0nC_nRA']
query 37: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 38: 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 39: 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 40: 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 41: select groupId from groups where groupName=?
  with placeholders:  ['Registered Users']
query 42: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 43: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', '12']
query 44: select * from groups where groupId=?
  with placeholders:  ['12']
query 45: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['12']
query 46: select groupId from groups where groupId=?
  with placeholders:  ['4']
query 47: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '4']
query 48: select * from groups where groupId=?
  with placeholders:  ['4']
query 49: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['4']
query 50: select groupId from groups where groupId=?
  with placeholders:  ['6']
query 51: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '6']
query 52: select * from groups where groupId=?
  with placeholders:  ['6']
query 53: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['6']
query 54: select groupId from groups where groupId=?
  with placeholders:  ['8']
query 55: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '8']
query 56: select * from groups where groupId=?
  with placeholders:  ['8']
query 57: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['8']
query 58: select groupId from groups where groupId=?
  with placeholders:  ['11']
query 59: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['1283949753', '11']
query 60: select * from groups where groupId=?
  with placeholders:  ['11']
query 61: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['11']
query 62: select groupId from groups where groupName=?
  with placeholders:  ['Turn Admin On']
query 63: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/top5']
query 64: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['2kUJPcAVqjqDCjWVwDTAkw', '']
query 65: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_286576fbf1e62b54', '']
query 66: 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 67: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/congresagenda/top5']
query 68: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['vlksBAvBdwAnxA5JMuQqeA', '']