Fatal error: Uncaught exception 'ErrorException' with message 'Error: 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 p.project_id' at line 12<br />Error No: 1064<br />SELECT count(*) AS total
FROM project p
LEFT JOIN project_description pd ON (p.project_id = pd.project_id)
LEFT JOIN property_new ppn ON (ppn.project_id = p.project_id)
LEFT JOIN property_unit_type pt ON (pd.attribute_residential_property_type = pt.unit_type_id)
LEFT JOIN company u ON (u.user_id = pd.user_id)
LEFT JOIN user ur ON (ur.user_id = pd.user_id)
LEFT JOIN users_subscriptions us ON (us.iUserId = ur.user_id)
LEFT JOIN country con ON (con.country_id = pd.country_id)
LEFT JOIN zone z ON (z.zone_id = pd.zone_id)
LEFT JOIN city c ON (c.city_id = pd.city_id)
WHERE pd.status = 1 and ur.status = 1 AND us.iPackageType in(13,14,22) AND p.project_id in() GROUP BY p.project_id ' in /home/realopedia/public_html/syst in /home/realopedia/public_html/system/database/mysqli.php on line 40