{"error":"error ocurred [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND acl.structureTimestamp=''\r\n\t\t\t\t\t\t\t\t\t\tAND `user`.`hash` NOT IN(\r\n\t\t\t\t\t\t\t\t\t\t\tS' at line 30] [SELECT \r\n\t\t\t\t\t\t\t\t\t\t`user`.`username`,\r\n\t\t\t\t\t\t\t\t\t\t`user`.`surname`,\r\n\t\t\t\t\t\t\t\t\t\t`user`.`name`,\r\n\t\t\t\t\t\t\t\t\t\tCONCAT_WS(' ',`user`.`title`,`user`.`surname`,`user`.`secondName`,`user`.`name`,`user`.`titleAfter`) AS fullName,\r\n\t\t\t\t\t\t\t\t\t\t`user`.`hash`,\r\n\t\t\t\t\t\t\t\t\t\t`acl`.*,\r\n\t\t\t\t\t\t\t\t\t\tIF(acl.permission='read' AND acl.allowItemRelation='yes',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'readAllowItemRelation',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(acl.permission='read' AND acl.createChilds='yes' AND acl.invisibility='yes',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'readCreateChildsHidden',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(acl.permission='read' AND acl.createChilds='yes',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'readCreateChilds',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(acl.permission='read' AND acl.invisibility='yes',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'readHidden',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIF(acl.permission='write' AND acl.createChilds='yes',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'writeCreateChilds',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tacl.permission\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t) AS permission\r\n\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t`aclUserStructure` acl\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `xeuUsers` `user` ON acl.userHash=user.hash\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `aclGroupUser` `aclGroup` ON `user`.`hash`=`aclGroup`.`userHash`\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `aclUserUser` `aclUser` ON `user`.`hash`=`aclUser`.`accessedUserHash`\r\n\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\tacl.structureId= AND acl.structureTimestamp=''\r\n\t\t\t\t\t\t\t\t\t\tAND `user`.`hash` NOT IN(\r\n\t\t\t\t\t\t\t\t\t\t\tSELECT `user1`.`hash`\r\n\t\t\t\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`xeuUsers` `user1`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `xeuGroupMembers` `rel` ON `user1`.`hash`=`rel`.`userHash`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `xeuGroups` `group` ON `group`.`hash`=`rel`.`groupHash`\r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t`user1`.`hash` = `user`.`hash`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(`group`.`type`='system' AND `group`.`level`='admin')\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tOR `user1`.`hash` = ''\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\tAND (aclUser.userHash='' OR aclGroup.groupHash IN('4c9184f37cff01bcdc32dc486ec36961'))\r\n\t\t\t\t\t\t\t\t\t\tAND (aclUser.permission IN ('read','write') OR aclGroup.permission IN ('read','write'))\r\n\t\t\t\t\t\t\t\t\t\tAND `user`.`hash` NOT IN(SELECT\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser.hash\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`xeuUsers` `user`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `aclGroupUser` `aclGroup` ON `user`.`hash`=`aclGroup`.`userHash`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `aclUserUser` `aclUser` ON `user`.`hash`=`aclUser`.`accessedUserHash`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(aclUser.permission ='deny' AND aclUser.userHash='')\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tOR \t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(aclGroup.permission ='deny' AND aclGroup.groupHash IN('4c9184f37cff01bcdc32dc486ec36961'))\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(aclGroup.invisibility ='yes' AND aclGroup.groupHash IN('4c9184f37cff01bcdc32dc486ec36961'))\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(aclUser.invisibility ='yes' AND aclUser.userHash='')\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\tGROUP BY\r\n\t\t\t\t\t\t\t\t\t\t`user`.`hash`\r\n\t\t\t\t\t\t\t\t\tORDER BY\r\n\t\t\t\t\t\t\t\t\t\t`user`.`surname`\r\n\t\t\t\t\t\t\t\t\t]"}