Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select eventSpecs, count(1) from Competitions group by 1 order by 2 desc limit 20;
- +------------------------------------------------------------------------------------------------------+----------+
- | eventSpecs | count(1) |
- +------------------------------------------------------------------------------------------------------+----------+
- | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram skewb sq1 | 316 |
- | 222 333 333bf 333oh 444 555 pyram | 88 |
- | 222 333 333bf 333oh 444 555 pyram skewb | 82 |
- | 222 333 333bf 333oh 444 pyram | 81 |
- | 222 333 333bf 333oh 444 pyram skewb | 75 |
- | 222 333 333oh 444 pyram skewb | 71 |
- | 222 333 333bf 333oh 444 555 666 777 clock minx pyram skewb sq1 | 58 |
- | 222 333 333bf 333oh 444 555 minx pyram skewb sq1 | 58 |
- | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock magic minx mmagic pyram sq1 | 56 |
- | 222 333 333bf 333oh 444 555 | 53 |
- | 333fm | 52 |
- | 222 333 333oh 444 pyram | 50 |
- | 222 333 333oh 444 555 pyram skewb | 50 |
- | 333 | 49 |
- | 222 333 333bf 333oh 444 | 48 |
- | 333bf 333fm 333mbf 444bf 555bf | 45 |
- | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram sq1 | 43 |
- | 222 333 333bf 333ft 333oh 444 555 666 777 clock minx pyram skewb sq1 | 43 |
- | 222 333 333bf 333oh 444 555 minx pyram skewb | 40 |
- | 222 333 333bf 333oh 444 555 666 777 minx pyram skewb sq1 | 39 |
- +------------------------------------------------------------------------------------------------------+----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement