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

SELECT MIN(spe.specials_new_products_price) as specials_price,p.products_id FROM products p, categories_description cd, products_to_categories p2c, ef_fonts ef_f, ef_fonts ef_df, ef_shops ef_s LEFT JOIN specials spe ON spe.products_id = p.products_id WHERE p2c.categories_id =748 AND p.products_shops_id = ef_s.shops_id AND p.products_id = p2c.products_id AND p.products_shops_id =2 AND cd.categories_id = p2c.categories_id AND ef_f.fonts_products_id = p2c.products_id AND p.products_status =1 AND cd.language_id =2 AND (spe.expires_date >= CURDATE( ) OR spe.expires_date = '0000-00-00 00:00:00') GROUP BY p.products_id ORDER BY specials_price LIMIT 1

[TEP STOP]