[Stefan Pochmann]

Wäre natürlich mal interessant zwei erste Plätze im 3x3-Finale zu haben.

https://www.worldcubeassociation.org/res...teOpen2012

SQL (Click to View)

select * from
(select competitionId, eventId, roundId, best, average, pos, count(*) ctr
from Results
where best>0 and average>0 and roundId in ('f','c')
group by competitionId, eventId, roundId, best, average) tmp
where ctr > 1
order by ctr desc, pos