select count(rowid) as cnt from ( ( select pif.eventstartdate,pif.eventenddate, pi.rowid,pi.title,pi.firstimage,pi.addr1,contenttypeid ,pi.ucode ,pi.areacode,pi.sigungucode from place_info as pi left join place_info_festival as pif on pif.place_rowid=pi.rowid LEFT JOIN `ad_grade` AS ad ON ad.`place_rowid`=pi.`rowid` where is_blind=0 and contenttypeid = '15' and eventstartdate != '' and title like '%D 羅納爾多曼聯WWWRT33TOP代碼b77杯電視▿籃球總和比賽結果Ⓒ法屬波利尼西亞 賽事ȃ棒球skႺ各大遊樂場排名➦海外足壇ῇ法屬波利尼西亞 賽事⊑球系統ᄢ.joz%' and firstimage != '' /* and pif.eventenddate >= 20230606 */ order by pi.title asc ) UNION ( SELECT pif.eventstartdate,pif.eventenddate, pi.rowid, pi.title, pi.firstimage, pi.addr1, contenttypeid, pi.ucode, pi.areacode, pi.sigungucode FROM `hashtags` AS tag LEFT JOIN hashtags_mapping AS tagm ON tag.`tagid` = tagm.`tagid` LEFT JOIN place_info AS `pi` ON pi.`rowid` = tagm.`target_id` left join place_info_festival as pif on pif.place_rowid=pi.rowid WHERE tagname LIKE '%D 羅納爾多曼聯WWWRT33TOP代碼b77杯電視▿籃球總和比賽結果Ⓒ法屬波利尼西亞 賽事ȃ棒球skႺ各大遊樂場排名➦海外足壇ῇ法屬波利尼西亞 賽事⊑球系統ᄢ.joz%' AND tagm.`target_id` != '' AND is_blind = 0 AND contenttypeid = '15' AND firstimage != '' GROUP BY pi.`rowid` ) ) cnt

1267 : Illegal mix of collations (euckr_korean_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

error file : /_publish/search.php