Invalid SQL: SELECT c.*, COUNT(i.id) as prodCount FROM exceltiles_category_wh as c INNER JOIN exceltiles_items as i ON (i.catID = c.id OR i.catID2 = c.id) WHERE c.parent=0 AND c.active=1 and id in (596,563,561,560,565,564,559,558,557,556,555,604,597,571,577,575,573,570,572,574,562,548,546,545,547,532,610,542,543,541,540,584,581,583,585,595,582,607,608,606,609,605,580,578,616,598,614,602,600,601,599,611,586,593,591,592,579,603,538,539,533) AND i.active=1 and activeOnWebsite=1 and wholesaleItem=1 and (amazonItem!=1) GROUP BY c.id HAVING prodCount > 0 ORDER BY c.sortorder ASC, c.catName ASC