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 '%www.ZavaMed.store%') OR (wp_posts.post_excerpt LIKE '%www.ZavaMed.store%') OR (wp_posts.post_content LIKE '%www.ZavaMed.store%')) AND ((wp_posts.post_title LIKE '%🌁⡶⤄%') OR (wp_posts.post_excerpt LIKE '%🌁⡶⤄%') OR (wp_posts.post_content LIKE '%🌁⡶⤄%')) AND ((wp_posts.post_title LIKE '%Cenforce%') OR (wp_posts.post_excerpt LIKE '%Cenforce%') OR (wp_posts.post_content LIKE '%Cenforce%')) AND ((wp_posts.post_title LIKE '%50%') OR (wp_posts.post_excerpt LIKE '%50%') OR (wp_posts.post_content LIKE '%50%')) AND ((wp_posts.post_title LIKE '%online.%') OR (wp_posts.post_excerpt LIKE '%online.%') OR (wp_posts.post_content LIKE '%online.%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%⤄⡶🌁 www.ZavaMed.store 🌁⡶⤄ Cenforce 50 online.%' THEN 1 WHEN wp_posts.post_title LIKE '%⤄⡶🌁%' AND wp_posts.post_title LIKE '%www.ZavaMed.store%' AND wp_posts.post_title LIKE '%🌁⡶⤄%' AND wp_posts.post_title LIKE '%Cenforce%' AND wp_posts.post_title LIKE '%50%' AND wp_posts.post_title LIKE '%online.%' THEN 2 WHEN wp_posts.post_title LIKE '%⤄⡶🌁%' OR wp_posts.post_title LIKE '%www.ZavaMed.store%' OR wp_posts.post_title LIKE '%🌁⡶⤄%' OR wp_posts.post_title LIKE '%Cenforce%' OR wp_posts.post_title LIKE '%50%' OR wp_posts.post_title LIKE '%online.%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%⤄⡶🌁 www.ZavaMed.store 🌁⡶⤄ Cenforce 50 online.%' THEN 4 WHEN wp_posts.post_content LIKE '%⤄⡶🌁 www.ZavaMed.store 🌁⡶⤄ Cenforce 50 online.%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10