SELECT COUNT(*) AS cnt FROM ( SELECT a.wr_id FROM lms_B01 a LEFT JOIN teacher b ON FIND_IN_SET(b.id, a.wr_8) > 0 WHERE a.wr_is_comment = 0 AND a.ca_name2 = 'y' AND a.ca_name = 'refu' AND a.wr_1 LIKE 'a%' AND a.wr_41 = '1' and wr_6 = 1 and (a.wr_subject like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%' or b.name like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%' or a.wr_keyword like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%' or a.wr_2 like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%' or a.wr_3 like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%' or a.wr_4 like '%确定 冷空气将变劳模,我国持续偏冷,权威预报 冷冬还需观察%') GROUP BY a.wr_id ) AS x

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

error file : /lecture_list.html