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 '%discount%') OR (tpm_posts.post_excerpt LIKE '%discount%') OR (tpm_posts.post_content LIKE '%discount%')) AND ((tpm_posts.post_title LIKE '%price%') OR (tpm_posts.post_excerpt LIKE '%price%') OR (tpm_posts.post_content LIKE '%price%')) AND ((tpm_posts.post_title LIKE '%Amaryl%') OR (tpm_posts.post_excerpt LIKE '%Amaryl%') OR (tpm_posts.post_content LIKE '%Amaryl%')) AND ((tpm_posts.post_title LIKE '%1mg%') OR (tpm_posts.post_excerpt LIKE '%1mg%') OR (tpm_posts.post_content LIKE '%1mg%'))) 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 🏺⣌ discount price Amaryl 1mg%' THEN 1 WHEN tpm_posts.post_excerpt LIKE '%⣌🏺 www.WebMD.shop 🏺⣌ discount price Amaryl 1mg%' THEN 4 WHEN tpm_posts.post_content LIKE '%⣌🏺 www.WebMD.shop 🏺⣌ discount price Amaryl 1mg%' THEN 5 ELSE 6 END), tpm_posts.post_date DESC LIMIT 0, 10