WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS sp_posts.ID FROM sp_posts WHERE 1=1 AND (((sp_posts.post_title LIKE '%👉🏻%') OR (sp_posts.post_excerpt LIKE '%👉🏻%') OR (sp_posts.post_content LIKE '%👉🏻%')) AND ((sp_posts.post_title LIKE '%acc6.top%') OR (sp_posts.post_excerpt LIKE '%acc6.top%') OR (sp_posts.post_content LIKE '%acc6.top%')) AND ((sp_posts.post_title LIKE '%👈🏻%') OR (sp_posts.post_excerpt LIKE '%👈🏻%') OR (sp_posts.post_content LIKE '%👈🏻%')) AND ((sp_posts.post_title LIKE '%アカウントの取得%') OR (sp_posts.post_excerpt LIKE '%アカウントの取得%') OR (sp_posts.post_content LIKE '%アカウントの取得%')) AND ((sp_posts.post_title LIKE '%Stripe%') OR (sp_posts.post_excerpt LIKE '%Stripe%') OR (sp_posts.post_content LIKE '%Stripe%'))) AND (sp_posts.post_password = '') AND sp_posts.post_type IN ('post', 'page', 'attachment') AND (sp_posts.post_status = 'publish') ORDER BY (CASE WHEN sp_posts.post_title LIKE '%👉🏻 acc6.top 👈🏻 アカウントの取得 Stripe%' THEN 1 WHEN sp_posts.post_title LIKE '%👉🏻%' AND sp_posts.post_title LIKE '%acc6.top%' AND sp_posts.post_title LIKE '%👈🏻%' AND sp_posts.post_title LIKE '%アカウントの取得%' AND sp_posts.post_title LIKE '%Stripe%' THEN 2 WHEN sp_posts.post_title LIKE '%👉🏻%' OR sp_posts.post_title LIKE '%acc6.top%' OR sp_posts.post_title LIKE '%👈🏻%' OR sp_posts.post_title LIKE '%アカウントの取得%' OR sp_posts.post_title LIKE '%Stripe%' THEN 3 WHEN sp_posts.post_excerpt LIKE '%👉🏻 acc6.top 👈🏻 アカウントの取得 Stripe%' THEN 4 WHEN sp_posts.post_content LIKE '%👉🏻 acc6.top 👈🏻 アカウントの取得 Stripe%' THEN 5 ELSE 6 END), sp_posts.post_date DESC LIMIT 0, 10