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 tpm_posts.ID FROM tpm_posts WHERE 1=1 AND (((tpm_posts.post_title LIKE '%📭🏤%') OR (tpm_posts.post_excerpt LIKE '%📭🏤%') OR (tpm_posts.post_content LIKE '%📭🏤%')) AND ((tpm_posts.post_title LIKE '%www.WebMD.shop%') OR (tpm_posts.post_excerpt LIKE '%www.WebMD.shop%') OR (tpm_posts.post_content LIKE '%www.WebMD.shop%')) AND ((tpm_posts.post_title LIKE '%🏤📭%') OR (tpm_posts.post_excerpt LIKE '%🏤📭%') OR (tpm_posts.post_content LIKE '%🏤📭%')) AND ((tpm_posts.post_title LIKE '%online%') OR (tpm_posts.post_excerpt LIKE '%online%') OR (tpm_posts.post_content LIKE '%online%')) AND ((tpm_posts.post_title LIKE '%apoteket%') OR (tpm_posts.post_excerpt LIKE '%apoteket%') OR (tpm_posts.post_content LIKE '%apoteket%')) AND ((tpm_posts.post_title LIKE '%viagra%') OR (tpm_posts.post_excerpt LIKE '%viagra%') OR (tpm_posts.post_content LIKE '%viagra%')) AND ((tpm_posts.post_title LIKE '%online%') OR (tpm_posts.post_excerpt LIKE '%online%') OR (tpm_posts.post_content LIKE '%online%')) AND ((tpm_posts.post_title LIKE '%kaufen%') OR (tpm_posts.post_excerpt LIKE '%kaufen%') OR (tpm_posts.post_content LIKE '%kaufen%'))) AND (tpm_posts.post_password = '') AND tpm_posts.post_type IN ('post', 'page', 'attachment', 'portfolio') AND (tpm_posts.post_status = 'publish') ORDER BY (CASE WHEN tpm_posts.post_title LIKE '%📭🏤 www.WebMD.shop 🏤📭 online apoteket viagra online kaufen%' THEN 1 WHEN tpm_posts.post_excerpt LIKE '%📭🏤 www.WebMD.shop 🏤📭 online apoteket viagra online kaufen%' THEN 4 WHEN tpm_posts.post_content LIKE '%📭🏤 www.WebMD.shop 🏤📭 online apoteket viagra online kaufen%' THEN 5 ELSE 6 END), tpm_posts.post_date DESC LIMIT 0, 10