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 wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%百家樂%') OR (wp_posts.post_excerpt LIKE '%百家樂%') OR (wp_posts.post_content LIKE '%百家樂%')) AND ((wp_posts.post_title LIKE '%論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂%') OR (wp_posts.post_excerpt LIKE '%論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂%') OR (wp_posts.post_content LIKE '%論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂%')) AND ((wp_posts.post_title LIKE '%論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂%') OR (wp_posts.post_excerpt LIKE '%論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂%') OR (wp_posts.post_content LIKE '%論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂%')) AND ((wp_posts.post_title LIKE '%論壇eju7g-新加坡金沙酒店泳池khtu%') OR (wp_posts.post_excerpt LIKE '%論壇eju7g-新加坡金沙酒店泳池khtu%') OR (wp_posts.post_content LIKE '%論壇eju7g-新加坡金沙酒店泳池khtu%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish') ORDER BY (CASE WHEN wp_posts.post_title LIKE '%百家樂 論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂 論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂 論壇eju7g-新加坡金沙酒店泳池khtu%' THEN 1 WHEN wp_posts.post_title LIKE '%百家樂%' AND wp_posts.post_title LIKE '%論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂%' AND wp_posts.post_title LIKE '%論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂%' AND wp_posts.post_title LIKE '%論壇eju7g-新加坡金沙酒店泳池khtu%' THEN 2 WHEN wp_posts.post_title LIKE '%百家樂%' OR wp_posts.post_title LIKE '%論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂%' OR wp_posts.post_title LIKE '%論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂%' OR wp_posts.post_title LIKE '%論壇eju7g-新加坡金沙酒店泳池khtu%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%百家樂 論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂 論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂 論壇eju7g-新加坡金沙酒店泳池khtu%' THEN 4 WHEN wp_posts.post_content LIKE '%百家樂 論壇-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池-百家樂 論壇2mge9-【✔️官網DD86·CC✔️】-新加坡金沙酒店泳池6fns-百家樂 論壇eju7g-新加坡金沙酒店泳池khtu%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 8