(15.11.2013, 11:47)miniCube schrieb: OK. In den Comps auf denen ich bis jetzt war, waren immer nur 12 in Finale, deshalb wunderte es mich,
Ist vor allem dreist gelogen:
Code:
DutchOpen2013 12
FrankfurtOpen2012 12
GermanNationals2012 12
GermanOpen2012 12
HessenOpen2012 32 <---- !!!!
HessenOpen2013 12
select competitionId, finalists from
(select competitionId, count(distinct personId) finalists
from Results
where eventId='333' and roundId in ('f','c') and competitionId in
(select competitionId from Results where personId="2012WERB01")
group by competitionId) tmp