WordPress database error: [Illegal mix of collations (utf8mb3_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 '%わかりやすい%') OR (wp_posts.post_excerpt LIKE '%わかりやすい%') OR (wp_posts.post_content LIKE '%わかりやすい%')) AND ((wp_posts.post_title LIKE '%HP2-I68%') OR (wp_posts.post_excerpt LIKE '%HP2-I68%') OR (wp_posts.post_content LIKE '%HP2-I68%')) 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 '%HP2-I68%') OR (wp_posts.post_excerpt LIKE '%HP2-I68%') OR (wp_posts.post_content LIKE '%HP2-I68%')) 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 '%⇚で検索するだけHP2-I68資料勉強%') OR (wp_posts.post_excerpt LIKE '%⇚で検索するだけHP2-I68資料勉強%') OR (wp_posts.post_content LIKE '%⇚で検索するだけHP2-I68資料勉強%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'project' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR ( wpml_translations.language_code = 'no' AND wp_posts.post_type IN ( 'et_header_layout','et_body_layout','et_footer_layout' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'en' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'en' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','et_pb_layout','project','et_header_layout','et_body_layout','et_footer_layout' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','et_pb_layout','project','et_header_layout','et_body_layout','et_footer_layout' ) ) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%わかりやすい HP2-I68 合格教本 🐦 ➠ HP2-I68 🠰を無料でダウンロード⇛ www.goshiken.com ⇚で検索するだけHP2-I68資料勉強%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%わかりやすい HP2-I68 合格教本 🐦 ➠ HP2-I68 🠰を無料でダウンロード⇛ www.goshiken.com ⇚で検索するだけHP2-I68資料勉強%' THEN 4 WHEN wp_posts.post_content LIKE '%わかりやすい HP2-I68 合格教本 🐦 ➠ HP2-I68 🠰を無料でダウンロード⇛ www.goshiken.com ⇚で検索するだけHP2-I68資料勉強%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 5