WordPress database error: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS wp1_posts.ID FROM wp1_posts WHERE 1=1 AND (((wp1_posts.post_title LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Admission Essay Writers Site GB, September 19, 2023 - Dec 29, 2023）%') OR (wp1_posts.post_content LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Admission Essay Writers Site GB, September 19, 2023 - Dec 29, 2023）%'))) AND (wp1_posts.post_password = '') AND wp1_posts.post_type IN ('post', 'page', 'attachment') AND (wp1_posts.post_status = 'publish') ORDER BY (CASE WHEN wp1_posts.post_title LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Admission Essay Writers Site GB, September 19, 2023 - Dec 29, 2023）%' THEN 1 WHEN wp1_posts.post_title LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Admission Essay Writers Site GB, September 19, 2023 - Dec 29, 2023）%' THEN 2 WHEN wp1_posts.post_content LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:Admission Essay Writers Site GB, September 19, 2023 - Dec 29, 2023）%' THEN 4 ELSE 5 END), wp1_posts.post_date DESC LIMIT 0, 8