SELECT p.* FROM shop_product_related spr LEFT JOIN shop_product p ON p.id = spr.related_id LEFT JOIN shop_product_to_category spc ON spc.product_id = spr.related_id WHERE spr.product_id = AND p.public = '1' AND spr.public_pl=1 GROUP BY p.id ORDER BY spc.position 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.public = '1' AND spr.public_pl=1 GROUP BY p.id ORDER BY spc.positi' at line 5