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 '%ULTRAMAGNETIC%'AND a.description1 LIKE '%MC''S%') OR (a.description2 LIKE '%ULTRAMAGNETIC%'AND a.description2 LIKE '%MC''S%') OR (a.SKU LIKE '%ULTRAMAGNETIC%'AND a.SKU LIKE '%MC''S%'))