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 LEFT JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (((wp_posts.post_title LIKE '%CashApp%') OR (wp_posts.post_excerpt LIKE '%CashApp%') OR (wp_posts.post_content LIKE '%CashApp%')) AND ((wp_posts.post_title LIKE '%mua%') OR (wp_posts.post_excerpt LIKE '%mua%') OR (wp_posts.post_content LIKE '%mua%')) AND ((wp_posts.post_title LIKE '%sắm%') OR (wp_posts.post_excerpt LIKE '%sắm%') OR (wp_posts.post_content LIKE '%sắm%')) AND ((wp_posts.post_title LIKE '%tài%') OR (wp_posts.post_excerpt LIKE '%tài%') OR (wp_posts.post_content LIKE '%tài%')) AND ((wp_posts.post_title LIKE '%khoản%') OR (wp_posts.post_excerpt LIKE '%khoản%') OR (wp_posts.post_content LIKE '%khoản%')) AND ((wp_posts.post_title LIKE '%👉🏼%') OR (wp_posts.post_excerpt LIKE '%👉🏼%') OR (wp_posts.post_content LIKE '%👉🏼%')) AND ((wp_posts.post_title LIKE '%acc6.top%') OR (wp_posts.post_excerpt LIKE '%acc6.top%') OR (wp_posts.post_content LIKE '%acc6.top%')) AND ((wp_posts.post_title LIKE '%👈🏼%') OR (wp_posts.post_excerpt LIKE '%👈🏼%') OR (wp_posts.post_content LIKE '%👈🏼%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR ( wpml_translations.language_code = 'en' AND wp_posts.post_type IN ( 'post','page' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'en' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'en' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation' ) ) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%CashApp mua sắm tài khoản 👉🏼 acc6.top 👈🏼%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%CashApp mua sắm tài khoản 👉🏼 acc6.top 👈🏼%' THEN 4 WHEN wp_posts.post_content LIKE '%CashApp mua sắm tài khoản 👉🏼 acc6.top 👈🏼%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 16