WordPress database error: [Illegal mix of collations (latin1_swedish_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 '%👉🏻%') OR (wp_posts.post_excerpt LIKE '%👉🏻%') OR (wp_posts.post_content LIKE '%👉🏻%')) AND ((wp_posts.post_title LIKE '%acc6.top%') OR (wp_posts.post_excerpt LIKE '%acc6.top%') OR (wp_posts.post_content LIKE '%acc6.top%')) AND ((wp_posts.post_title LIKE '%👈🏻%') OR (wp_posts.post_excerpt LIKE '%👈🏻%') OR (wp_posts.post_content LIKE '%👈🏻%')) AND ((wp_posts.post_title LIKE '%GoogleVoice%') OR (wp_posts.post_excerpt LIKE '%GoogleVoice%') OR (wp_posts.post_content LIKE '%GoogleVoice%')) 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_password = '') AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'r3d' AND (wp_posts.post_status = 'publish'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%👉🏻 acc6.top 👈🏻 GoogleVoice تدارکات حساب%' THEN 1 WHEN wp_posts.post_title LIKE '%👉🏻%' AND wp_posts.post_title LIKE '%acc6.top%' AND wp_posts.post_title LIKE '%👈🏻%' AND wp_posts.post_title LIKE '%GoogleVoice%' AND wp_posts.post_title LIKE '%تدارکات%' AND wp_posts.post_title LIKE '%حساب%' THEN 2 WHEN wp_posts.post_title LIKE '%👉🏻%' OR wp_posts.post_title LIKE '%acc6.top%' OR wp_posts.post_title LIKE '%👈🏻%' OR wp_posts.post_title LIKE '%GoogleVoice%' OR wp_posts.post_title LIKE '%تدارکات%' OR wp_posts.post_title LIKE '%حساب%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%👉🏻 acc6.top 👈🏻 GoogleVoice تدارکات حساب%' THEN 4 WHEN wp_posts.post_content LIKE '%👉🏻 acc6.top 👈🏻 GoogleVoice تدارکات حساب%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 8