diff options
| author | emkael <emkael@tlen.pl> | 2022-09-30 23:30:29 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2022-09-30 23:31:55 +0200 |
| commit | 7068c22a1ff56545df3a863aee074c81a536be6d (patch) | |
| tree | cbd5e9357f7782cc64831fd8bd560324ec4df099 /dumps/check-teams.sh | |
| parent | 760fcece3ce29376d4127fd668b8000c9ef49cb2 (diff) | |
Switching paid checks to both calendar years + players checks also involve players missing from DB (=not paid on either years)
Diffstat (limited to 'dumps/check-teams.sh')
| -rwxr-xr-x | dumps/check-teams.sh | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/dumps/check-teams.sh b/dumps/check-teams.sh index ecf78a5..8cd3e31 100755 --- a/dumps/check-teams.sh +++ b/dumps/check-teams.sh @@ -6,7 +6,7 @@ cat .cezar-teams-$DBNAME | while read TEAM CEZARTEAM do echo "UPDATE teams SET internet = $CEZARTEAM WHERE id = $TEAM;" done | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DBNAME -QUERY="SELECT dmppl.link, CONCAT(dmppl.gname, ' ', dmppl.sname), TRIM(t.shortname), TRIM(pl.loc2), CONCAT(lineup.rnd, '-', lineup.segment) FROM $DBNAME.players dmppl JOIN $PLAYERSDB.players pl ON dmppl.link = pl.ID JOIN $DBNAME.teams t ON t.id = dmppl.team JOIN ( +QUERY="SELECT dmppl.link, CONCAT(dmppl.gname, ' ', dmppl.sname), TRIM(t.shortname), TRIM(pl.loc2), CONCAT(lineup.rnd, '-', lineup.segment) FROM $DBNAME.players dmppl JOIN $DBNAME.teams t ON t.id = dmppl.team JOIN ( SELECT rnd, segment, openN as pl FROM $DBNAME.segments UNION SELECT rnd, segment, openS as pl FROM $DBNAME.segments @@ -22,7 +22,7 @@ UNION SELECT rnd, segment, closeE as pl FROM $DBNAME.segments UNION SELECT rnd, segment, closeW as pl FROM $DBNAME.segments -) lineup ON lineup.pl = dmppl.id -WHERE t.internet <> pl.info +) lineup ON lineup.pl = dmppl.id LEFT JOIN $PLAYERSDB.players pl ON dmppl.link = pl.ID +WHERE COALESCE(t.internet, '') <> COALESCE(pl.info, '') ORDER BY dmppl.link, lineup.rnd, lineup.segment;" echo $QUERY | mysql ${LIGA_MYSQL_CONNECTION_OPTS} -N |