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 DISTINCT 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) LEFT JOIN wp_postmeta espm ON (wp_posts.ID = espm.post_id) WHERE 1=1 AND wp_posts.ID NOT IN (1128) AND ( ((wp_posts.post_title LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (wp_posts.post_content LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (wp_posts.post_excerpt LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'catchcopy' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'day' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'day_end' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'free_txt' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'name' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'parking' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'parking-title' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'syozaiti' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'tel' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'time' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = 'toriatukai' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%') OR (espm.meta_key = '電話番号' AND espm.meta_value LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%')) AND ((wp_posts.post_title LIKE '%15％入金ボーナス%') OR (wp_posts.post_content LIKE '%15％入金ボーナス%') OR (wp_posts.post_excerpt LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'catchcopy' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'day' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'day_end' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'free_txt' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'name' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'parking' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'parking-title' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'syozaiti' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'tel' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'time' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = 'toriatukai' AND espm.meta_value LIKE '%15％入金ボーナス%') OR (espm.meta_key = '電話番号' AND espm.meta_value LIKE '%15％入金ボーナス%')) AND ((wp_posts.post_title LIKE '%【qc377.com】%') OR (wp_posts.post_content LIKE '%【qc377.com】%') OR (wp_posts.post_excerpt LIKE '%【qc377.com】%') OR (espm.meta_key = 'catchcopy' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'day' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'day_end' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'free_txt' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'name' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'parking' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'parking-title' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'syozaiti' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'tel' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'time' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = 'toriatukai' AND espm.meta_value LIKE '%【qc377.com】%') OR (espm.meta_key = '電話番号' AND espm.meta_value LIKE '%【qc377.com】%')) AND ((wp_posts.post_title LIKE '%銀行入金限定%') OR (wp_posts.post_content LIKE '%銀行入金限定%') OR (wp_posts.post_excerpt LIKE '%銀行入金限定%') OR (espm.meta_key = 'catchcopy' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'day' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'day_end' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'free_txt' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'name' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'parking' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'parking-title' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'syozaiti' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'tel' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'time' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = 'toriatukai' AND espm.meta_value LIKE '%銀行入金限定%') OR (espm.meta_key = '電話番号' AND espm.meta_value LIKE '%銀行入金限定%')) AND ((wp_posts.post_title LIKE '%15％入金ボーナス#NAME?%') OR (wp_posts.post_content LIKE '%15％入金ボーナス#NAME?%') OR (wp_posts.post_excerpt LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'catchcopy' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'day' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'day_end' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'free_txt' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'name' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'parking' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'parking-title' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'syozaiti' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'tel' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'time' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = 'toriatukai' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%') OR (espm.meta_key = '電話番号' AND espm.meta_value LIKE '%15％入金ボーナス#NAME?%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'shopno') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND ( ( ( wpml_translations.language_code = 'en' OR ( wpml_translations.language_code = 'ja' AND wp_posts.post_type IN ( 'post','page','shohin' ) 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_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','acf-field-group','wpcf7_contact_form','shopno','shohin' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','acf-field-group','wpcf7_contact_form','shopno','shohin' ) ) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定 15％入金ボーナス 【qc377.com】 銀行入金限定 15％入金ボーナス#NAME?%' THEN 1 WHEN wp_posts.post_title LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%' AND wp_posts.post_title LIKE '%15％入金ボーナス%' AND wp_posts.post_title LIKE '%【qc377.com】%' AND wp_posts.post_title LIKE '%銀行入金限定%' AND wp_posts.post_title LIKE '%15％入金ボーナス#NAME?%' THEN 2 WHEN wp_posts.post_title LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定%' OR wp_posts.post_title LIKE '%15％入金ボーナス%' OR wp_posts.post_title LIKE '%【qc377.com】%' OR wp_posts.post_title LIKE '%銀行入金限定%' OR wp_posts.post_title LIKE '%15％入金ボーナス#NAME?%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定 15％入金ボーナス 【qc377.com】 銀行入金限定 15％入金ボーナス#NAME?%' THEN 4 WHEN wp_posts.post_content LIKE '%#NAME?【qc377.com】👈来てください😃銀行入金限定 15％入金ボーナス 【qc377.com】 銀行入金限定 15％入金ボーナス#NAME?%' THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 10