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 ( (e.access_id in (2) or (e.owner_guid = -1) or (e.access_id = 0 and e.ow' at line 8 QUERY: SELECT count(distinct e.guid) as total
from elggentities e
JOIN elggmetadata m on e.guid = m.entity_guid
JOIN elggmetadata m2 on e.guid = m2.entity_guid
JOIN elggmetastrings v on v.id = m.value_id JOIN elggmetastrings v2 on v2.id = m2.value_id
where e.type='object' and e.subtype=8 and m.name_id='20760' and m2.name_id='20762' and ((v.string >= 1337810400)
OR (v2.string >= 2145913200)
OR (v.string <= 1337810400 AND v2.string >= 1337810400)) and e.site_guid = 1 and (e.owner_guid = ) and ( (e.access_id in (2) or (e.owner_guid = -1) or (e.access_id = 0 and e.owner_guid = -1)) and e.enabled='yes') and ( (m.access_id in (2) or (m.owner_guid = -1) or (m.access_id = 0 and m.owner_guid = -1)) and m.enabled='yes') and ( (m2.access_id in (2) or (m2.owner_guid = -1) or (m2.access_id = 0 and m2.owner_guid = -1)) and m2.enabled='yes')