Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p LEFT JOIN SC_tagged_objects t2 ON p.productID=t2.object_id LEFT JOIN SC_tags t1 ON t2.tag_id=t1.id AND t2.object_type="product" WHERE ( ( LOWER(t1.name) LIKE '%j41039b%') AND categoryID<>1 AND enabled=1) OR (in_stock>0 and enabled=1 AND (((`codeOR_ru` LIKE 'j41039b' OR `name_ru` LIKE 'j41039b' OR `oem_ru` LIKE 'j41039b' OR `name_ru` LIKE 'AMNI013' OR replace(LOWER(`name_ru`),'-','') LIKE 'AMNI013' OR `codeOR_ru` LIKE 'AMNI013' OR `oem_ru` LIKE 'AMNI013' OR `name_ru` LIKE '54570-50J10' OR replace(LOWER(`name_ru`),'-','') LIKE '54570-50J10' OR `codeOR_ru` LIKE '54570-50J10' OR `oem_ru` LIKE '54570-50J10' OR `name_ru` LIKE 'N24P10WB' OR replace(LOWER(`name_ru`),'-','') LIKE 'N24P10WB' OR `codeOR_ru` LIKE 'N24P10WB' OR `oem_ru` LIKE 'N24P10WB' OR `name_ru` LIKE 'AN24P10WB' OR replace(LOWER(`name_ru`),'-','') LIKE 'AN24P10WB' OR `codeOR_ru` LIKE 'AN24P10WB' OR `oem_ru` LIKE 'AN24P10WB' OR `name_ru` LIKE '54570-86J00' OR replace(LOWER(`name_ru`),'-','') LIKE '54570-86J00' OR `codeOR_ru` LIKE '54570-86J00' OR `oem_ru` LIKE '54570-86J00' OR `name_ru` LIKE '40Z1020B' OR replace(LOWER(`name_ru`),'-','') LIKE '40Z1020B' OR `codeOR_ru` LIKE '40Z1020B' OR `oem_ru` LIKE '40Z1020B' OR `name_ru` LIKE 'JJ4-139B' OR replace(LOWER(`name_ru`),'-','') LIKE 'JJ4-139B' OR `codeOR_ru` LIKE 'JJ4-139B' OR `oem_ru` LIKE 'JJ4-139B') AND `type_ru` LIKE '%Сайлентблок%')))