Unknown column 'p.brief_description' in 'where clause' SQL query : select count(*) from SS_products p   where 1  AND  p.enabled=1 AND  p.brief_description LIKE '%(%C4%E5%F2%F1%EA%E8%E9)%'  AND p.categoryID IN (2) order by Price, p.name_ru