WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id WHERE 1=1 AND wp_posts.post_title LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' AND wp_posts.post_password = '' AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish')))OR (t.name LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' AND wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' THEN 1 WHEN wp_posts.post_title LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' THEN 4 WHEN wp_posts.post_content LIKE '%MCD-Level-1合格内容 🔟 MCD-Level-1試験概要 📗 MCD-Level-1資格難易度 🦅 “ www.goshiken.com ”サイトにて最新✔ MCD-Level-1 ️✔️問題集をダウンロードMCD-Level-1日本語練習問題%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 16