SELECT SQL_CALC_FOUND_ROWS p.*,
pp.price,
bs.route AS series_route,
b.route AS brand_route,
bs.name_chi AS series_name,
b.color
FROM tbl_product AS p
LEFT JOIN tbl_product_brand_series AS bs ON bs.id = p.series_id
LEFT JOIN tbl_product_price AS pp ON pp.product_id = p.id
LEFT JOIN tbl_product_brand AS b ON b.id = p.brand_id
WHERE p.brand_id =
AND p.status = 1
AND p.approved = 1
AND p.delete_staff_id = 0
AND p.latest_version = 1
ORDER BY p.count DESC,p.ordering LIMIT 0, 12 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 'AND p.status = 1
AND p.approved = 1
' at line 12