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 enabled ='yes' ORDER BY elgggroups_entity.guid DESC LIMIT 0,6' at line 1 QUERY: SELECT elgggroups_entity.guid,name,description FROM elgggroups_entity JOIN elggentities ON elgggroups_entity.guid = elggentities.guid WHERE rex_society_id IN () AND enabled ='yes' ORDER BY elgggroups_entity.guid DESC LIMIT 0,6