Invalid query:
Error Number: 1064
Error Message: 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 tbl_producttype.typeid =
AND tbl_product.active = 1
ORDER BY tbl_p' at line 7
Whole query:
SELECT tbl_product.*, tbl_producttype.name as type, tbl_producttype.description as typedescription, tbl_producttype.nameid as typenameid,
tbl_productcategory.name AS categoryname, tbl_productcategory.nameid AS categorynameid
FROM tbl_product
INNER JOIN tbl_producttype ON tbl_producttype.typeid = tbl_product.typeid
INNER JOIN tbl_productcategory ON tbl_productcategory.categoryid = tbl_producttype.categoryid
WHERE tbl_producttype.categoryid =
AND tbl_producttype.typeid =
AND tbl_product.active = 1
ORDER BY tbl_producttype.position, tbl_product.position;










