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(71) AND in_stock_ > 0 GROUP BY brand