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 '%YEGOR%'AND a.description1 LIKE '%DYACHKOV%'AND a.description1 LIKE '%/%'AND a.description1 LIKE '%JEAN%'AND a.description1 LIKE '%SAULNIER%') OR (a.description2 LIKE '%YEGOR%'AND a.description2 LIKE '%DYACHKOV%'AND a.description2 LIKE '%/%'AND a.description2 LIKE '%JEAN%'AND a.description2 LIKE '%SAULNIER%') OR (a.SKU LIKE '%YEGOR%'AND a.SKU LIKE '%DYACHKOV%'AND a.SKU LIKE '%/%'AND a.SKU LIKE '%JEAN%'AND a.SKU LIKE '%SAULNIER%'))