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 '%제주시비즈니스010.7513.0304 제주공항비즈니스 신제주비즈니스☭제원비즈니스㈒제주제원비즈니스 nOo%' and firstimage != '' /* and pif.eventenddate >= 20240329 */ 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 '%제주시비즈니스010.7513.0304 제주공항비즈니스 신제주비즈니스☭제원비즈니스㈒제주제원비즈니스 nOo%' 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