#!/usr/bin/env bash
# 旧サーバ（133）で実行: surface または distance が NULL のレース一覧を TSV で出力
# scp で新本番 tmp/ へ送る
set -euo pipefail
OUT="${1:-/tmp/races_null_surface_133.tsv}"
mysql -uroot keiba_ai -N -e "
SELECT r.race_date, t.code, r.race_number, IFNULL(r.surface,''), IFNULL(r.distance_m,'')
FROM races r
JOIN tracks t ON t.id = r.track_id
WHERE r.circuit = 'JRA'
  AND (r.surface IS NULL OR r.surface = '' OR r.distance_m IS NULL OR r.distance_m = 0)
ORDER BY r.race_date, t.code, r.race_number
" | awk -F'\t' 'BEGIN{print "race_date\ttrack_code\trace_number\tsurface\tdistance_m"} {print}' > "$OUT"
echo "wrote $OUT ($(wc -l < "$OUT") lines)"