1054 - Unknown column 'p.products_date_expire' in 'field list'

select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_date_expire, p.products_does_expire from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_does_expire = '1' and p.products_date_expire like '2012-05-%' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_expire ASC, pd.products_name

[TEP STOP]