1054 - Unknown column 'pcp.products_compared_price_id' in 'field list'

select p.products_id, p.products_status, pd.products_name, pd.products_description, pd.products_short_description, p.products_model, p.products_others_model, p.products_discount_points, p.products_quantity, p.products_quantity_alert, p.products_discount_quantity, p.products_image, p.products_image_details, p.products_image_extracted, pd.products_url, IF(s.status, s.specials_new_products_price, p.products_price) as products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(pcp.products_compared_price_id, TRUE, FALSE) as products_compared_price_status, IF(pn.products_id, pn.products_id, NULL) as products_notification_id, IF(p.products_first_price > p.products_price, p.products_first_price, p.products_price) as products_first_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pc.categories_id, m.manufacturers_name, m.manufacturers_discount, m.manufacturers_sale_price, cd.categories_name, g.gift_vouchers_value, g.gift_vouchers_orders_value from (products p, manufacturers m, manufacturers_info mi, products_description pd, products_to_categories pc, categories_description cd) left join specials s on p.products_id = s.products_id left join gift_vouchers g on p.products_price > g.gift_vouchers_orders_value where p.products_status > 0 and p.products_id = '4626' and pd.products_id = p.products_id and pd.language_id = '2' and m.manufacturers_id = p.manufacturers_id and pc.products_id = p.products_id and pc.categories_id = cd.categories_id and cd.language_id = '2' order by g.gift_vouchers_value asc limit 0,1

[TEP STOP]