WordPress データベースエラー: [Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like']
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp1_posts.ID FROM wp1_posts LEFT JOIN wp1_postmeta ON wp1_posts.ID = wp1_postmeta.post_id LEFT JOIN wp1_postmeta AS pm_use_pb ON (wp1_posts.ID = pm_use_pb.post_id AND pm_use_pb.meta_key = 'use_page_builder') LEFT JOIN wp1_postmeta AS pm_pb_data ON (wp1_posts.ID = pm_pb_data.post_id AND pm_pb_data.meta_key = 'page_builder') WHERE 1=1 AND (((wp1_posts.post_title LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%') OR (wp1_postmeta.meta_value LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%') OR (wp1_posts.post_excerpt LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%') OR (wp1_posts.post_content LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%') OR (pm_use_pb.meta_value = '1' AND pm_pb_data.meta_value LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%'))) AND (wp1_posts.post_password = '') AND ((wp1_posts.post_type = 'post' AND (wp1_posts.post_status = 'publish')) OR (wp1_posts.post_type = 'page' AND (wp1_posts.post_status = 'publish')) OR (wp1_posts.post_type = 'attachment' AND (wp1_posts.post_status = 'publish')) OR (wp1_posts.post_type = 'work' AND (wp1_posts.post_status = 'publish'))) GROUP BY wp1_posts.ID ORDER BY (CASE WHEN wp1_posts.post_title LIKE '%b.link/hire\\_writer - Find a TOP Writer Here! 👌（Tag:An Essay On The Noble Science Of Self Justification Summary, Sep 29, 2023 - Dec 28, 2023）%' THEN 2 ELSE 6 END), wp1_posts.post_date DESC LIMIT 0, 10