Top ten combined match scores:
Columns are:
Event, "Complevel", match number, red alliance, blue alliance, red score, blue score.
Complevels are:
Quals - 10
Quarters - 30
Semis - 40
Finals - 50
Matchnumbers for Elims are ((10 * set number) + match number)
Code:
Wash DC Regional 30 11 234 45 620 1111 122 768 126 100
Newton Division 40 12 768 1625 234 1507 177 121 92 133
Archimedes Division 10 67 1302 3062 2056 176 107 503 129 94
Galileo Division 40 11 111 971 67 1332 1902 40 126 97
Michigan State Cmp 10 37 2337 216 226 469 2834 70 86 133
Curie Division....... 40 11 79 70 27 329 188 399 119 99
Curie Division....... 50 13 399 188 329 68 247 217 98 118
Galileo Division 30 12 67 111 971 1208 207 56 124 88
Chesapeake Regional 10 57 2234 449 229 40 2079 2199 68 142
Chesapeake Regional 30 32 2199 40 134 888 2534 166 130 80
Brought to you by:
Code:
SELECT events.name, matches.complevel, matches.matchnumber, matches.red1, matches.red2, matches.red3, matches.blue1, matches.blue2, matches.blue3, matches.redscore, matches.bluescore
FROM `matches` ,
EVENTS WHERE matches.event = events.eventid
AND events.year = "2009"
ORDER BY (
redscore + bluescore
) DESC