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 d.published = 1 AND d.access<=0 AND c.name=\'FestaTravel\'\' at line 1 SQL=SELECT jos_estateagent.id, d.* FROM jos_contact_details AS d LEFT JOIN jos_categories AS c ON (d.catid = c.id) WHERE d.user_id = AND d.published = 1 AND d.access<=0 AND c.name=\'FestaTravel\' Notice: Undefined variable: cntry in /home/radfesta/public_html/festa2/administrator/components/com_estateagent/classes/object.estateagent.php on line 212