facebook
SELECT p.*,d.title,d.description,d1.cat_id as pkgcat_id FROM tbl_packages AS p LEFT JOIN tbl_packages_data as d ON p.package_id = d.package_id LEFT JOIN tbl_packages_cats_pkg_data as d1 ON p.package_id = d1.pkg_id GROUP BY p.package_idWHERE p.is_delete=0 AND d.lang_id='1' AND is_active=1 AND validity_end > 2020-02-26 ORDER BY p.package_id DESC 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 'p.is_delete=0 AND d.lang_id='1' AND is_active=1 AND validity_end > 2020-02-26 ' at line 1
------------------------------------
SELECT p.*,d.title,d.description,d1.cat_id as pkgcat_id FROM tbl_packages AS p LEFT JOIN tbl_packages_data as d ON p.package_id = d.package_id LEFT JOIN tbl_packages_cats_pkg_data as d1 ON p.package_id = d1.pkg_id GROUP BY p.package_idWHERE p.is_delete=0 AND d.lang_id='1' AND is_active=1 AND validity_end > 2020-02-26 ORDER BY p.package_id DESC