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 WHERE 1=1 AND (((wp_posts.post_title LIKE '%試験の準備方法-最高のGCX-ARC%') OR (wp_posts.post_excerpt LIKE '%試験の準備方法-最高のGCX-ARC%') OR (wp_posts.post_content LIKE '%試験の準備方法-最高のGCX-ARC%')) AND ((wp_posts.post_title LIKE '%過去問無料試験-一番優秀なGCX-ARC%') OR (wp_posts.post_excerpt LIKE '%過去問無料試験-一番優秀なGCX-ARC%') OR (wp_posts.post_content LIKE '%過去問無料試験-一番優秀なGCX-ARC%')) 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 '%GCX-ARC%') OR (wp_posts.post_excerpt LIKE '%GCX-ARC%') OR (wp_posts.post_content LIKE '%GCX-ARC%')) AND ((wp_posts.post_title LIKE '%⮘問題集がありますGCX-ARC最新試験%') OR (wp_posts.post_excerpt LIKE '%⮘問題集がありますGCX-ARC最新試験%') OR (wp_posts.post_content LIKE '%⮘問題集がありますGCX-ARC最新試験%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'agency' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'agent' AND (wp_posts.post_status = 'publish')) OR (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 = 'property' AND (wp_posts.post_status = 'publish'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%試験の準備方法-最高のGCX-ARC 過去問無料試験-一番優秀なGCX-ARC 日本語学習内容 💘 （ www.goshiken.com ）には無料の➤ GCX-ARC ⮘問題集がありますGCX-ARC最新試験%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%試験の準備方法-最高のGCX-ARC 過去問無料試験-一番優秀なGCX-ARC 日本語学習内容 💘 （ www.goshiken.com ）には無料の➤ GCX-ARC ⮘問題集がありますGCX-ARC最新試験%' THEN 4 WHEN wp_posts.post_content LIKE '%試験の準備方法-最高のGCX-ARC 過去問無料試験-一番優秀なGCX-ARC 日本語学習内容 💘 （ www.goshiken.com ）には無料の➤ GCX-ARC ⮘問題集がありますGCX-ARC最新試験%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10