WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE '%信頼的-効率的なH19-431\\_V1.0%') OR (wp_posts.post_excerpt LIKE '%信頼的-効率的なH19-431\\_V1.0%') OR (wp_posts.post_content LIKE '%信頼的-効率的なH19-431\\_V1.0%')) AND ((wp_posts.post_title LIKE '%日本語pdf問題試験-試験の準備方法H19-431\\_V1.0%') OR (wp_posts.post_excerpt LIKE '%日本語pdf問題試験-試験の準備方法H19-431\\_V1.0%') OR (wp_posts.post_content LIKE '%日本語pdf問題試験-試験の準備方法H19-431\\_V1.0%')) AND ((wp_posts.post_title LIKE '%試験勉強過去問%') OR (wp_posts.post_excerpt LIKE '%試験勉強過去問%') OR (wp_posts.post_content LIKE '%試験勉強過去問%')) AND ((wp_posts.post_title LIKE '%🚤%') OR (wp_posts.post_excerpt LIKE '%🚤%') OR (wp_posts.post_content LIKE '%🚤%')) AND ((wp_posts.post_title LIKE '%サイト“%') OR (wp_posts.post_excerpt LIKE '%サイト“%') OR (wp_posts.post_content LIKE '%サイト“%')) AND ((wp_posts.post_title LIKE '%www.goshiken.com%') OR (wp_posts.post_excerpt LIKE '%www.goshiken.com%') OR (wp_posts.post_content LIKE '%www.goshiken.com%')) AND ((wp_posts.post_title LIKE '%”で➡%') OR (wp_posts.post_excerpt LIKE '%”で➡%') OR (wp_posts.post_content LIKE '%”で➡%')) AND ((wp_posts.post_title LIKE '%H19-431\\_V1.0%') OR (wp_posts.post_excerpt LIKE '%H19-431\\_V1.0%') OR (wp_posts.post_content LIKE '%H19-431\\_V1.0%')) AND ((wp_posts.post_title LIKE '%️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%') OR (wp_posts.post_excerpt LIKE '%️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%') OR (wp_posts.post_content LIKE '%️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment', 'slider', 'projects', 'members', 'gamgeoba', 'photo', 'video', 'lecture', 'courses', 'trainings', 'vacancies', 'ads', 'concurses', 'publications', 'gamocemema', 'kvleva', 'partners', 'representation') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','slider','projects','members','gamgeoba','photo','video','lecture','courses','trainings','vacancies','ads','concurses','publications','gamocemema','kvleva','representation' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','slider','projects','members','gamgeoba','photo','video','lecture','courses','trainings','vacancies','ads','concurses','publications','gamocemema','kvleva','representation' ) ) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%信頼的-効率的なH19-431\\_V1.0 日本語pdf問題試験-試験の準備方法H19-431\\_V1.0 試験勉強過去問 🚤 サイト“ www.goshiken.com ”で➡ H19-431\\_V1.0 ️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%信頼的-効率的なH19-431\\_V1.0 日本語pdf問題試験-試験の準備方法H19-431\\_V1.0 試験勉強過去問 🚤 サイト“ www.goshiken.com ”で➡ H19-431\\_V1.0 ️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%' THEN 4 WHEN wp_posts.post_content LIKE '%信頼的-効率的なH19-431\\_V1.0 日本語pdf問題試験-試験の準備方法H19-431\\_V1.0 試験勉強過去問 🚤 サイト“ www.goshiken.com ”で➡ H19-431\\_V1.0 ️⬅️問題集をダウンロードH19-431\\_V1.0全真問題集%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10