Advertisement
timbreynolds

Most common event combos

Feb 16th, 2020
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.83 KB | None | 0 0
  1. mysql> select eventSpecs, count(1) from Competitions group by 1 order by 2 desc limit 20;
  2. +------------------------------------------------------------------------------------------------------+----------+
  3. | eventSpecs | count(1) |
  4. +------------------------------------------------------------------------------------------------------+----------+
  5. | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram skewb sq1 | 316 |
  6. | 222 333 333bf 333oh 444 555 pyram | 88 |
  7. | 222 333 333bf 333oh 444 555 pyram skewb | 82 |
  8. | 222 333 333bf 333oh 444 pyram | 81 |
  9. | 222 333 333bf 333oh 444 pyram skewb | 75 |
  10. | 222 333 333oh 444 pyram skewb | 71 |
  11. | 222 333 333bf 333oh 444 555 666 777 clock minx pyram skewb sq1 | 58 |
  12. | 222 333 333bf 333oh 444 555 minx pyram skewb sq1 | 58 |
  13. | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock magic minx mmagic pyram sq1 | 56 |
  14. | 222 333 333bf 333oh 444 555 | 53 |
  15. | 333fm | 52 |
  16. | 222 333 333oh 444 pyram | 50 |
  17. | 222 333 333oh 444 555 pyram skewb | 50 |
  18. | 333 | 49 |
  19. | 222 333 333bf 333oh 444 | 48 |
  20. | 333bf 333fm 333mbf 444bf 555bf | 45 |
  21. | 222 333 333bf 333fm 333ft 333mbf 333oh 444 444bf 555 555bf 666 777 clock minx pyram sq1 | 43 |
  22. | 222 333 333bf 333ft 333oh 444 555 666 777 clock minx pyram skewb sq1 | 43 |
  23. | 222 333 333bf 333oh 444 555 minx pyram skewb | 40 |
  24. | 222 333 333bf 333oh 444 555 666 777 minx pyram skewb sq1 | 39 |
  25. +------------------------------------------------------------------------------------------------------+----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement