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.products_id = p2c.products_id group by p.products_id' at line 15
SELECT p.products_image, p.products_model, p.products_id, p.manufacturers_id, p.products_price, pd.products_url, 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 FROM products_description pd, products p LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN specials s ON p.products_id = s.products_id, products_to_categories p2c WHERE p.products_status = '1' AND AND p.products_id = p2c.products_id group by p.products_id
[TEP STOP]
SELECT p.products_image, p.products_model, p.products_id, p.manufacturers_id, p.products_price, pd.products_url, 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 FROM products_description pd, products p LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN specials s ON p.products_id = s.products_id, products_to_categories p2c WHERE p.products_status = '1' AND AND p.products_id = p2c.products_id group by p.products_id
[TEP STOP]