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_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'car_sold' ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%2024 C-HCADM-05 Exam Topic 100\\% Pass | Pass-Sure C-HCADM-05: SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration 100\\% Pass 🧟 Go to website （ www.pdfvce.com ） open and search for ✔ C-HCADM-05 ️✔️ to download for free 🥈C-HCADM-05 Reliable Test Tutorial%') OR (wp_posts.post_excerpt LIKE '%2024 C-HCADM-05 Exam Topic 100\\% Pass | Pass-Sure C-HCADM-05: SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration 100\\% Pass 🧟 Go to website （ www.pdfvce.com ） open and search for ✔ C-HCADM-05 ️✔️ to download for free 🥈C-HCADM-05 Reliable Test Tutorial%') OR (wp_posts.post_content LIKE '%2024 C-HCADM-05 Exam Topic 100\\% Pass | Pass-Sure C-HCADM-05: SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration 100\\% Pass 🧟 Go to website （ www.pdfvce.com ） open and search for ✔ C-HCADM-05 ️✔️ to download for free 🥈C-HCADM-05 Reliable Test Tutorial%'))) AND (wp_posts.post_password = '') AND ( ( ( wp_postmeta.meta_key = 'car_sold' AND wp_postmeta.meta_value = '2' ) OR mt1.post_id IS NULL ) ) AND wp_posts.post_type IN ('post', 'listings', 'page') AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY (CASE WHEN wp_posts.post_title LIKE '%2024 C-HCADM-05 Exam Topic 100\\% Pass | Pass-Sure C-HCADM-05: SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration 100\\% Pass 🧟 Go to website （ www.pdfvce.com ） open and search for ✔ C-HCADM-05 ️✔️ to download for free 🥈C-HCADM-05 Reliable Test Tutorial%' THEN 2 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10