blob: 0bd2df73002510f124f5c9a51242ed2fc7cbc505 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
MATCH_RESULTS = '''
SELECT t1.fullname, t2.fullname, matches.carry, matches.vph, matches.vpv, matches.corrh, matches.corrv
FROM #db#.matches matches
JOIN #db#.teams t1
ON t1.id = #db#.matches.homet
JOIN #db#.teams t2
ON t2.id = #db#.matches.visit
WHERE matches.tabl = %s AND matches.rnd = %s
'''
BOARD_COUNT = '''
SELECT segmentsperround*boardspersegment, SUM(sc1.contract IS NOT NULL AND sc2.contract IS NOT NULL)
FROM #db#.scores sc1
JOIN #db#.scores sc2
ON sc1.rnd = sc2.rnd
AND sc1.segment = sc2.segment
AND sc1.tabl = sc2.tabl
AND sc1.board = sc2.board
AND sc1.room = 1
AND sc2.room = 2
JOIN #db#.admin
WHERE sc1.tabl = %s AND sc1.rnd = %s
'''
|
