|
1054 - Unknown column 'p.products_code' in 'on clause' select count(*) as total from products p, specials s LEFT JOIN products AS p2 ON ((p.products_code=p2.products_code) AND (p2.products_type='M')) left join manufacturers as m on (p.manufacturers_id=m.manufacturers_id) where p.products_status = '1' and s.products_id = p.products_id and s.status = '1' [TEP STOP] |