Database error: Invalid SQL: SELECT count(*) as num_rows
FROM product p, product_category pc, category c, product_price e
WHERE AND p.product_id=pc.product_id
AND pc.category_id=c.category_id
AND p.product_id=e.product_id
AND p.product_status=2
AND e.price>0
ORDER BY e.price, p.product_company MySQL Error: 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 'AND p.product_id=pc.product_id
AND pc.category_id=c.category_id
AND p.prod' at line 3)