1267

Помилка: 1267

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' SQL=SELECT DISTINCT a.* FROM #__zoo_item AS a LEFT JOIN #__zoo_search_index AS b ON a.id = b.item_id LEFT JOIN #__zoo_tag AS c ON a.id = c.item_id WHERE ((a.name LIKE '%наÑ1адка%' OR EXISTS (SELECT value FROM #__zoo_search_index WHERE a.id = item_id AND value LIKE '%наÑ1адка%' AND 1) OR EXISTS (SELECT name FROM #__zoo_tag WHERE a.id = item_id AND name LIKE '%наÑ1адка%'))) AND a.searchable = 1 AND a.access IN (1,5) AND (a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 15:40:17') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 15:40:17')) ORDER BY a.created DESC LIMIT 0, 50