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 ')) group by msvalue.string having total > 0 order by total desc limit 10' at line 1 QUERY: SELECT msvalue.string as tag, count(msvalue.id) as total FROM entities e join metadata md on md.entity_guid = e.guid join entity_subtypes subtype on subtype.id = e.subtype join metastrings msvalue on msvalue.id = md.value_id where 1 and md.name_id = 50 and e.site_guid = 1 and e.subtype = 1 and e.type = 'object' and e.container_guid = 25873 and (e.access_id in (2,3,4,5,6,7,8,10,11,12,13,14,15,17,18,19,21,25) or (e.access_id = 0 and e.owner_guid = )) group by msvalue.string having total > 0 order by total desc limit 10