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 CURRENT_DATE <= p.date_expired AND us.iPackageType in(13,14,22) AND p.project_id in() GROUP BY p.project_id ' in in /home/realopedia/public_html/system/database/mysqli.php on line 40