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 '%Purchase%') OR (wp_posts.post_excerpt LIKE '%Purchase%') OR (wp_posts.post_content LIKE '%Purchase%')) AND ((wp_posts.post_title LIKE '%Celebrex%') OR (wp_posts.post_excerpt LIKE '%Celebrex%') OR (wp_posts.post_content LIKE '%Celebrex%')) 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_title LIKE '%🧣%') OR (wp_posts.post_excerpt LIKE '%🧣%') OR (wp_posts.post_content LIKE '%🧣%')) AND ((wp_posts.post_title LIKE '%WWW.IPILL.STORE%') OR (wp_posts.post_excerpt LIKE '%WWW.IPILL.STORE%') OR (wp_posts.post_content LIKE '%WWW.IPILL.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 '%Celebrex%') OR (wp_posts.post_excerpt LIKE '%Celebrex%') OR (wp_posts.post_content LIKE '%Celebrex%')) AND ((wp_posts.post_title LIKE '%Sale%') OR (wp_posts.post_excerpt LIKE '%Sale%') OR (wp_posts.post_content LIKE '%Sale%'))) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%Purchase Celebrex Online 🧣 WWW.IPILL.STORE 🧣 Celebrex For Sale%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%Purchase Celebrex Online 🧣 WWW.IPILL.STORE 🧣 Celebrex For Sale%' THEN 4 WHEN wp_posts.post_content LIKE '%Purchase Celebrex Online 🧣 WWW.IPILL.STORE 🧣 Celebrex For Sale%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10