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 '%4870630020%') AND categoryID<>1 AND enabled=1) OR (in_stock>0 and enabled=1 AND (((`codeOR_ru` LIKE '%48706-30020%' OR `name_ru` LIKE '%48706-30020%' OR `name_ru` LIKE 'T25670' OR `codeOR_ru` LIKE 'T25670' OR `name_ru` LIKE 'AT25670' OR `codeOR_ru` LIKE 'AT25670') AND `type_ru` LIKE '%Сайлентблок%')))