DB:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='

SELECT i.`image`,i.`title`,i.`price`,i.`description`,i.`description2`,i.`id`,i.`cap`,i.`avail`,i.`info` FROM ( SELECT i.`id` FROM ( SELECT `item_id` FROM `tt_filter2catalog` ) AS `fc` INNER JOIN `tt_catalog_item` AS i ON i.`id` = fc.`item_id` GROUP BY i.`id` HAVING COUNT(fc.`item_id`)>=0 ORDER BY i.`id` ) AS `f` INNER JOIN `tt_catalog_item` AS `i` ON i.`id`=f.`id` AND i.`active`=1 AND i.`group_id`=124 AND LOWER(i.`brand`)='ГАЙКИ' AND i.`avail`=1 ORDER BY i.`title` ASC