1054 - Unknown column 'pd.products_id' in 'on clause'
SELECT p.products_id, p.products_price, specials.specials_new_products_price, pd.products_name, pc.categories_id FROM products p, products_description pd, products_to_categories pc LEFT JOIN specials ON pd.products_id = specials.products_id WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR(4) ORDER BY pc.categories_id, pd.products_name
