ランドセル販売
岐阜県羽島市 テスト様｜試しの記事4
stg の試し（地域ページの来店記事カード）
BLOGブログ
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)