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(62,256,257,260,259,261,262,225,224,265,223,264,266,221,263) AND in_stock_ > 0 GROUP BY brand