SELECT count(ss.id) AS maxpages FROM main.qk_products ss WHERE ss.active = 1 AND ss.price > 0 AND (ss.maker IN (0) OR 'NA' = 'NA') AND (ss.color IN (0) OR 'NA' = 'NA') AND ss.id != 139758 AND ( ss.catid = 80 OR ss.catid IN (SELECT id FROM main.qk_categories WHERE parentid = 80) OR ss.catid IN (SELECT id FROM main.qk_categories WHERE parentid IN (SELECT id FROM main.qk_categories WHERE parentid = 80)) ) ERROR : 1