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 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.CoopPharmacy.store%') OR (wp_posts.post_excerpt LIKE '%www.CoopPharmacy.store%') OR (wp_posts.post_content LIKE '%www.CoopPharmacy.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 '%Cialis%') OR (wp_posts.post_excerpt LIKE '%Cialis%') OR (wp_posts.post_content LIKE '%Cialis%')) AND ((wp_posts.post_title LIKE '%2%') OR (wp_posts.post_excerpt LIKE '%2%') OR (wp_posts.post_content LIKE '%2%')) AND ((wp_posts.post_title LIKE '%5mg%') OR (wp_posts.post_excerpt LIKE '%5mg%') OR (wp_posts.post_content LIKE '%5mg%')) AND ((wp_posts.post_title LIKE '%prix%') OR (wp_posts.post_excerpt LIKE '%prix%') OR (wp_posts.post_content LIKE '%prix%'))) 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'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%📞🦍🧼 www.CoopPharmacy.store 🧼🦍📞 Cialis 2 5mg prix%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%📞🦍🧼 www.CoopPharmacy.store 🧼🦍📞 Cialis 2 5mg prix%' THEN 4 WHEN wp_posts.post_content LIKE '%📞🦍🧼 www.CoopPharmacy.store 🧼🦍📞 Cialis 2 5mg prix%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10