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 '%ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ ï¿½ï¿½ ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ zafer tekstil%') AND categoryID<>1 AND enabled=1)