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 '%(�������)%'  AND p.categoryID IN (2) order by Price, p.name_ru