1054 - Unknown column 'p.products_id' in 'on clause'

SELECT p.products_image, p.products_link, pd.products_name, p.products_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price, IF(s.status, p.products_price, NULL) as price_old, p2c.categories_id FROM products_description AS pd, products AS p, products_to_categories AS p2c LEFT JOIN specials AS s ON (p.products_id = s.products_id) WHERE p.products_status = 1 AND p.products_id = p2c.products_id AND p.products_id = pd.products_id AND pd.language_id = 4 AND p.manufacturers_id = 1084 ORDER BY s.specials_new_products_price DESC, p.products_price ASC

[TEP STOP]