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_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (10) ) AND (((wp_posts.post_title LIKE '%実際的なDOP-C02%') OR (wp_posts.post_excerpt LIKE '%実際的なDOP-C02%') OR (wp_posts.post_content LIKE '%実際的なDOP-C02%')) AND ((wp_posts.post_title LIKE '%合格体験談試験-試験の準備方法-ユニークなDOP-C02%') OR (wp_posts.post_excerpt LIKE '%合格体験談試験-試験の準備方法-ユニークなDOP-C02%') OR (wp_posts.post_content LIKE '%合格体験談試験-試験の準備方法-ユニークなDOP-C02%')) 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 '%DOP-C02%') OR (wp_posts.post_excerpt LIKE '%DOP-C02%') OR (wp_posts.post_content LIKE '%DOP-C02%')) AND ((wp_posts.post_title LIKE '%」問題集をダウンロードDOP-C02模擬試験%') OR (wp_posts.post_excerpt LIKE '%」問題集をダウンロードDOP-C02模擬試験%') OR (wp_posts.post_content LIKE '%」問題集をダウンロードDOP-C02模擬試験%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%実際的なDOP-C02 合格体験談試験-試験の準備方法-ユニークなDOP-C02 過去問 🚃 サイト{ www.goshiken.com }で「 DOP-C02 」問題集をダウンロードDOP-C02模擬試験%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%実際的なDOP-C02 合格体験談試験-試験の準備方法-ユニークなDOP-C02 過去問 🚃 サイト{ www.goshiken.com }で「 DOP-C02 」問題集をダウンロードDOP-C02模擬試験%' THEN 4 WHEN wp_posts.post_content LIKE '%実際的なDOP-C02 合格体験談試験-試験の準備方法-ユニークなDOP-C02 過去問 🚃 サイト{ www.goshiken.com }で「 DOP-C02 」問題集をダウンロードDOP-C02模擬試験%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10