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 20
SELECT DISTINCT(p.products_id), p.products_image, m.manufacturers_name, pd.products_name, pd.products_description, p.products_quantity, p.products_promo_take,
p.products_promo_pay, p.manufacturers_id, p.products_price, p.products_tax_class_id,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
p.id_gama_productos, p.principal_gama_productos, m.manufacturers_show_discount
FROM products p
LEFT JOIN specials s
ON p.products_id = s.products_id
LEFT JOIN products_to_categories p2c
ON p.products_id = p2c.products_id,
products_description pd,
manufacturers m
WHERE p.principal_gama_productos = 1 AND if(p.id_gama_productos is null, p.products_status = '1',1) AND
p.products_regalo = '0'
AND p.products_status = 1
AND p.products_in_catalog = 1
AND p.manufacturers_id = m.manufacturers_id
AND p.products_id = pd.products_id
AND p.products_vip<='0'
AND pd.language_id = '3' AND m.manufacturers_id = '281' GROUP BY p.products_id ORDER BY