Unknown column 'in_stock_' in 'where clause' SQL query : SELECT COUNT(brand) as cnt, brand FROM A_products 
                                WHERE enabled='1' AND brand!='' AND categoryID!=1 AND categoryID IN(60,211,215,212,213,214,216) AND in_stock_ > 0 GROUP BY brand