1054 - Unknown column '308921cyCHF' in 'where clause'

SELECT p.products_id,products_price,products_image,products_tax_class_id, IF(s.status = 1 AND (s.expires_date > NOW() OR s.expires_date = '0000-00-00 00:00:00'), s.specials_new_products_price, p.products_price) AS final_price, IF(s.status = 1 and (s.expires_date > NOW() OR s.expires_date = '0000-00-00 00:00:00'), 1, 0) AS final_special_status,pd.products_name,cp.favorite_cnt,cp.picture_url FROM customers_pictures cp LEFT JOIN products p ON cp.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id LEFT JOIN specials s ON s.products_id = p.products_id where cp.picture_id = 308921cyCHF order by cp.favorite_cnt desc limit 0,1

[TEP STOP]