-SELECT m.code AS code, m.mazzo_next as minus_one_is_old
- FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_tournaments as t
- WHERE t.code = m.tcode AND m.code = g.mcode
- AND t.code = %d AND g.tstamp >= '%s' AND g.tstamp < '%s'
- GROUP BY m.code, minus_one_is_old
+SELECT m.code AS code, m.ttype AS ttype, m.mazzo_next AS minus_one_is_old
+ FROM %sbin5_matches AS m, %sbin5_games AS g, %sbin5_tournaments AS t
+ WHERE t.code = m.tcode AND m.code = g.mcode
+ AND t.code = %d AND g.tstamp >= '%s' AND g.tstamp < '%s'
+ GROUP BY m.code, minus_one_is_old