WordPress データベースエラー: [Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=']SELECT d.id, d.daisha_no, d.code, d.registered_at, a.cart
FROM wp_askal_daisha d JOIN (
SELECT goq, MAX(created_at) AS rel_at, MAX(CASE WHEN detail LIKE '%(905)%' THEN '905' ELSE '901' END) AS cart
FROM wp_askal_audit_log WHERE event='除外解除' AND (detail LIKE '%(901)%' OR detail LIKE '%(905)%')
AND created_at > DATE_SUB(NOW(), INTERVAL 120 DAY)
GROUP BY goq ) a ON a.goq = d.code
WHERE d.source='manual' AND d.moved_to IS NULL AND d.daisha_no > 0 AND d.registered_at < a.rel_at
AND NOT EXISTS (SELECT 1 FROM wp_askal_satsuei s WHERE s.goq = d.code AND s.released_at IS NULL)