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(229,253,150,63,73,62,267,64,76,60,77,79,74,59,71,82,75,254,65,61,80,195,81,180,111,270,273,274,269,275,276,271,272,268,228,266,265,264,263,262,261,260,259,257,256,255,251,250,249,248,243,242,241,237,236,234,233,225,224,223,221,220,218,217,216,215,214,213,212,211,210,209,208,207,206,205,204,202,201,200,199,198,197,196,194,193,192,191,190,189,188,187,186,185,184,183,182) AND in_stock_ > 0 GROUP BY brand