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 '%V 해선히어로 「HESUNSAFE.COM」 야간선물실시간ᇦCACィCAC이탈리아지수매매ه해외선물금차트ى녹십자홀딩스실시간ਨ에이브AAVE투자하는법🅿코인딜계좌만들기.bev%' and firstimage != '' /* and pif.eventenddate >= 20240422 */ 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 '%V 해선히어로 「HESUNSAFE.COM」 야간선물실시간ᇦCACィCAC이탈리아지수매매ه해외선물금차트ى녹십자홀딩스실시간ਨ에이브AAVE투자하는법🅿코인딜계좌만들기.bev%' 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