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 '' at line 15
SELECT
a.products_id as pID,
a.products_category_main,
b.products_name,
c.categories_name
FROM
products a
JOIN
products_description b ON a.products_id = b.products_id
LEFT OUTER JOIN
categories_description c ON a.products_category_main = c.categories_id
WHERE
b.language_id = '1'
AND
a.products_id =