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 '%PAT%'AND a.description1 LIKE '%GROULX%'AND a.description1 LIKE '%ET%'AND a.description1 LIKE '%LES%'AND a.description1 LIKE '%BAS%'AND a.description1 LIKE '%BLANCS%') OR (a.description2 LIKE '%PAT%'AND a.description2 LIKE '%GROULX%'AND a.description2 LIKE '%ET%'AND a.description2 LIKE '%LES%'AND a.description2 LIKE '%BAS%'AND a.description2 LIKE '%BLANCS%') OR (a.SKU LIKE '%PAT%'AND a.SKU LIKE '%GROULX%'AND a.SKU LIKE '%ET%'AND a.SKU LIKE '%LES%'AND a.SKU LIKE '%BAS%'AND a.SKU LIKE '%BLANCS%'))