+----------------------------+-------------+----------+
| competitionId | competitors | attempts |
+----------------------------+-------------+----------+
| MovesN00bs2012 | 20 | 6 |
| TwenteOpen2012 | 68 | 3 |
| UAMOpen2013 | 52 | 3 |
| SpanishChampionship2012 | 51 | 3 |
| MurciaOpen2013 | 50 | 3 |
| BerlinOpen2013 | 48 | 3 |
| CampeonatoSudamericano2013 | 41 | 3 |
| GranadaOpen2012 | 36 | 3 |
| ValenciaSummerOpen2013 | 33 | 3 |
| DualGames2013 | 33 | 3 |
| AlaniaOpen2011 | 32 | 3 |
| VelbertOpen2013 | 32 | 3 |
| PuydeDomeOpen2012 | 31 | 3 |
| MolinaOpen2013 | 29 | 3 |
| DolmenOpen2012 | 26 | 3 |
| DolmenOpen2011 | 25 | 3 |
| ClermontOpen2009 | 24 | 3 |
| GernikaOpen2013 | 21 | 3 |
| ValgameOpen2012 | 21 | 3 |
| CastellonOpen2012 | 20 | 3 |
| CastellonOpen2013 | 19 | 3 |
| PKUFMC2010 | 16 | 3 |
| ChinaFM2011Xian | 15 | 3 |
| PuydeDomeOpen2011 | 15 | 3 |
| BeijingFootsteps2011 | 14 | 3 |
| ChinaFM2011Beijing | 13 | 3 |
| ChinaFM2011Shanghai | 13 | 3 |
| PKUFM2012 | 12 | 3 |
| ChinaFM2011Guangzhou | 6 | 3 |
| ChinaFM2011Shenyang | 3 | 3 |
| ChinaFM2011Zhengzhou | 3 | 3 |
| WC2013 | 580 | 2 |
| USNationals2012 | 259 | 2 |
| USNationals2010 | 227 | 2 |
| USNationals2011 | 204 | 2 |
| WC2005 | 149 | 2 |
| USNationals2009 | 135 | 2 |
| SpanishChampionship2011 | 93 | 2 |
| MITSpring2012 | 92 | 2 |
| BWOpen2013 | 76 | 2 |
| PolishOpen2007 | 76 | 2 |
| PolishOpen2006 | 72 | 2 |
| France2013 | 66 | 2 |
| Poland2009 | 63 | 2 |
| PolishNationals2010 | 62 | 2 |
| NacionalPerubik2013 | 61 | 2 |
| ZonhovenOpen2013 | 58 | 2 |
| BarcelonaSummerOpen2011 | 57 | 2 |
| GermanOpen2013 | 56 | 2 |
| BWOpen2012 | 55 | 2 |
| PoznanOpen2009 | 55 | 2 |
| Euro2004 | 53 | 2 |
| SpolsOpen2011 | 53 | 2 |
| BerkeleyWinter2012 | 53 | 2 |
| DanishOpen2011 | 52 | 2 |
| CzechOpen2012 | 50 | 2 |
| CubeCampKanazawa2012 | 47 | 2 |
| CubeCampKanazawa2011 | 45 | 2 |
| Rubikaz10thAnniversary2012 | 44 | 2 |
| LyonOpen2011 | 41 | 2 |
| MontpellierOpen2011 | 41 | 2 |
| DanishOpen2012 | 41 | 2 |
| RomanianOpen2011 | 41 | 2 |
| Altbier2012 | 38 | 2 |
| CzechOpen2013 | 37 | 2 |
| HelsinkiOpen2011 | 35 | 2 |
| CastellonOpen2011 | 34 | 2 |
| MontpellierOpen2010 | 33 | 2 |
| BasauriOpen2012 | 32 | 2 |
| MIROpen2013 | 31 | 2 |
| LaMontagneOpen2012 | 30 | 2 |
| BarcelonaWinterOpen2012 | 30 | 2 |
| WasedaBrainChallenge2012 | 28 | 2 |
| AlaniaOpen2010 | 28 | 2 |
| LyonSpringOpen2009 | 27 | 2 |
| ErfurtOpen2013 | 26 | 2 |
| DiamondBarSpring2013 | 26 | 2 |
| BlindOpen2011 | 25 | 2 |
| LyonSummerOpen2010 | 25 | 2 |
| FinnishOpen2010 | 24 | 2 |
| MagicCubeDays2012 | 24 | 2 |
| BasauriOpen2011 | 23 | 2 |
| RubikkuChamp2013 | 19 | 2 |
| ShanghaiSpring2011 | 17 | 2 |
| RenoWinter2010 | 16 | 2 |
| DanishSpecial2011 | 16 | 2 |
| GuangzhouFMC2012 | 16 | 2 |
| ZhengzhouOpen2011 | 12 | 2 |
| JavaFMCCubeDay2010 | 12 | 2 |
| WC2009 | 327 | 1 |
| WC2011 | 292 | 1 |
| Euro2012 | 285 | 1 |
| AachenOpen2011 | 230 | 1 |
| Euro2010 | 227 | 1 |
| WC2007 | 214 | 1 |
| PolishNationals2013 | 181 | 1 |
| IndianCubeChallenge2013 | 179 | 1 |
| MPEIOpen2012 | 166 | 1 |
| AachenOpen2010 | 154 | 1 |
| JakartaOpen2010 | 152 | 1 |
+----------------------------+-------------+----------+
SELECT tmp2.competitionId, count(distinct personId) competitors, attempts
FROM
(SELECT competitionId, sum(attempts) attempts
FROM
(SELECT competitionId, roundId, max((value1<>0)+(value2<>0)+(value3<>0)+(value4<>0)+(value5<>0)) attempts
FROM Results
WHERE eventId = '333fm'
GROUP BY competitionId, roundId) tmp1
GROUP BY competitionId) tmp2,
Results
WHERE Results.competitionId = tmp2.competitionId
GROUP BY competitionId
ORDER BY attempts desc, competitors desc
LIMIT 100