SELECT Count(*) AS prodCount FROM products AS a INNER JOIN productTypes_Products b ON a.idProduct = b.idProduct INNER JOIN productTypes c ON b.idProdType = c.idProdType WHERE a.active = -1 AND c.idParentProdType = 6 AND ((a.description1 LIKE '%OAK%'AND a.description1 LIKE '%RIDGE%'AND a.description1 LIKE '%BOYS%') OR (a.description2 LIKE '%OAK%'AND a.description2 LIKE '%RIDGE%'AND a.description2 LIKE '%BOYS%') OR (a.SKU LIKE '%OAK%'AND a.SKU LIKE '%RIDGE%'AND a.SKU LIKE '%BOYS%'))