1064 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 'SELECT DISTINCT p.products_id,p.products_image,p.products_model,p.products_quan' at line 1
in:
[select count(distinct p.products_id) as total SELECT DISTINCT p.products_id,p.products_image,p.products_model,p.products_quantity,p.master_categories_id,p.products_id,p.products_price,p.products_price_retail,p.products_quantity_order_min, p.products_price_sorter, p.products_qty_box_status, p.jia_sold,p.master_categories_id,p.retale_model,p.selectid ,p.star,p.caizhi_en,p.chicunFROM products p , products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 3 AND ( (pd.products_name LIKE '%%') OR (p.products_model LIKE '%%')) ]