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 wpkt_posts.ID FROM wpkt_posts WHERE 1=1 AND (((wpkt_posts.post_title LIKE '%📭📒%') OR (wpkt_posts.post_excerpt LIKE '%📭📒%') OR (wpkt_posts.post_content LIKE '%📭📒%')) AND ((wpkt_posts.post_title LIKE '%www.MayoClinic.store%') OR (wpkt_posts.post_excerpt LIKE '%www.MayoClinic.store%') OR (wpkt_posts.post_content LIKE '%www.MayoClinic.store%')) AND ((wpkt_posts.post_title LIKE '%📒📭%') OR (wpkt_posts.post_excerpt LIKE '%📒📭%') OR (wpkt_posts.post_content LIKE '%📒📭%')) AND ((wpkt_posts.post_title LIKE '%viagra%') OR (wpkt_posts.post_excerpt LIKE '%viagra%') OR (wpkt_posts.post_content LIKE '%viagra%')) AND ((wpkt_posts.post_title LIKE '%online%') OR (wpkt_posts.post_excerpt LIKE '%online%') OR (wpkt_posts.post_content LIKE '%online%')) AND ((wpkt_posts.post_title LIKE '%canada%') OR (wpkt_posts.post_excerpt LIKE '%canada%') OR (wpkt_posts.post_content LIKE '%canada%'))) AND (wpkt_posts.post_password = '') AND ((wpkt_posts.post_type = 'post' AND (wpkt_posts.post_status = 'publish'))) ORDER BY (CASE WHEN wpkt_posts.post_title LIKE '%📭📒 www.MayoClinic.store 📒📭 by viagra online canada%' THEN 1 WHEN wpkt_posts.post_title LIKE '%📭📒%' AND wpkt_posts.post_title LIKE '%www.MayoClinic.store%' AND wpkt_posts.post_title LIKE '%📒📭%' AND wpkt_posts.post_title LIKE '%viagra%' AND wpkt_posts.post_title LIKE '%online%' AND wpkt_posts.post_title LIKE '%canada%' THEN 2 WHEN wpkt_posts.post_title LIKE '%📭📒%' OR wpkt_posts.post_title LIKE '%www.MayoClinic.store%' OR wpkt_posts.post_title LIKE '%📒📭%' OR wpkt_posts.post_title LIKE '%viagra%' OR wpkt_posts.post_title LIKE '%online%' OR wpkt_posts.post_title LIKE '%canada%' THEN 3 WHEN wpkt_posts.post_excerpt LIKE '%📭📒 www.MayoClinic.store 📒📭 by viagra online canada%' THEN 4 WHEN wpkt_posts.post_content LIKE '%📭📒 www.MayoClinic.store 📒📭 by viagra online canada%' THEN 5 ELSE 6 END), wpkt_posts.post_date DESC LIMIT 0, 10