1054 - Unknown column 'p.products_id' in 'on clause'
SELECT p.products_id, p.products_ordered, p.products_model, p.products_price, p.prix_factice, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.status, pd.products_name, p2c.categories_id, cd.categories_name FROM products p, products_description pd, products_to_categories p2c, categories_description cd left join specials s on p.products_id = s.products_id WHERE p.products_id = pd.products_id AND p.products_id = p2c.products_id AND p2c.categories_id = cd.categories_id AND p.products_status = 1 AND (p2c.categories_id = '44' or p2c.categories_id = '45' or p2c.categories_id = '46' or p2c.categories_id = '71' or p2c.categories_id = '111' or p2c.categories_id = '112' or p2c.categories_id = '113' or p2c.categories_id = '114' or p2c.categories_id = '118' or p2c.categories_id = '123' or p2c.categories_id = '139' or p2c.categories_id = '141' or p2c.categories_id = '142' or p2c.categories_id = '143' or p2c.categories_id = '144' or p2c.categories_id = '145' or p2c.categories_id = '146' or p2c.categories_id = '147' or p2c.categories_id = '169' or p2c.categories_id = '196' or p2c.categories_id = '212' or p2c.categories_id = '232' or p2c.categories_id = '238' or p2c.categories_id = '248' or p2c.categories_id = '250' or p2c.categories_id = '269' or p2c.categories_id = '271' or p2c.categories_id = '285' or p2c.categories_id = '286' or p2c.categories_id = '287' or p2c.categories_id = '288' or p2c.categories_id = '289' or p2c.categories_id = '290' or p2c.categories_id = '28') AND pd.language_id = FLOOR(4) ORDER BY cd.categories_name, p.products_price ASC