Východočeská softballová liga mužů 2012
rok
typ
tým
soupeř
zápas
vše
2008
2007
2006
5 nej
tým
hráči
SELECT DISTINCT domaci AS team FROM terminovka,stat_bat WHERE zapas_num=zap_num AND terminovka.soutez=10 AND SUBSTRING(zap_num,7,4)='2012' UNION SELECT DISTINCT hoste AS team FROM terminovka,stat_bat WHERE zapas_num=zap_num AND terminovka.soutez=10 AND SUBSTRING(zap_num,7,4)='2012' ORDER BY team
všechny
SELECT DISTINCT domaci AS team FROM terminovka,stat_bat,teams WHERE zapas_num=zap_num AND terminovka.soutez=10 AND domaci<>'' AND SUBSTRING(zap_num,7,4)='2012' UNION SELECT DISTINCT hoste AS team FROM terminovka,stat_bat,teams WHERE zapas_num=zap_num AND terminovka.soutez=10 AND hoste<>'' AND SUBSTRING(zap_num,7,4)='2012'ORDER BY team
všechny
všechny
Nadhoz
Zadák
Pálka
Pole