1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT p.products_id, p.products_image, pd.products_name FROM (zen_produc' at line 1
in:
[select count(*) as total SELECT p.products_id, p.products_image, pd.products_name FROM (zen_products p LEFT JOIN zen_specials s on p.products_id = s.products_id LEFT JOIN zen_products_description pd on p.products_id = pd.products_id ) WHERE p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1' AND s.status = 1 AND pd.language_id = 2 ORDER BY s.specials_date_added DESC]