Skip to content

Instantly share code, notes, and snippets.

@stahnma

stahnma/gist:8206011

Last active January 1, 2016 21:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stahnma/8206011 to your computer and use it in GitHub Desktop.
Save stahnma/8206011 to your computer and use it in GitHub Desktop.
Download ZIP
Tumble ircLink submission stats (totals and for 2013)
Raw
gistfile1.txt
#All time link submissions
mysql> select count(*), user from ircLink group by user;
+----------+-----------+
| count(*) | user |
+----------+-----------+
| 14 | abotd |
| 1 | ahs |
| 2 | alisonbri |
| 183 | amanda |
| 1 | amandaz |
| 82 | andrew |
| 1 | anniesboo |
| 1211 | arafatm |
| 2 | arafatmou |
| 10 | arafatm_ |
| 1 | ashamim |
| 1 | awwww |
| 1587 | aziz |
| 1 | aziz_ |
| 2 | bacon |
| 1 | bacon_cor |
| 1 | badotd |
| 1 | balls |
| 1 | barnekr |
| 1 | beardless |
| 1 | Berringer |
| 3 | BitMinion |
| 17 | bits |
| 1 | bjotd |
| 2 | blair |
| 1 | blarkin |
| 1 | bobbycox |
| 3 | bomby |
| 312 | botd |
| 1 | botd-for- |
| 1 | botd2 |
| 3 | boty |
| 9 | brad |
| 28 | bradejr |
| 3 | bradejr%7 |
| 3 | bradejr_ |
| 1 | bradley |
| 2579 | brandon |
| 2 | brandonv |
| 1 | brandon_i |
| 2 | braveswin |
| 1 | bubyhos |
| 1 | bush |
| 2 | buttonhol |
| 11 | campbje |
| 2 | caotd |
| 1 | ccaum |
| 281 | chris |
| 60 | cluckcj |
| 5 | commander |
| 5 | cotd |
| 3 | cpotd |
| 1 | crossfito |
| 141 | crunchy |
| 30 | cupcake |
| 1435 | cwage |
| 1 | cwage%7Cf |
| 2 | cwage- |
| 6 | cwage_ |
| 4 | damocles |
| 8 | daren |
| 1 | Daren Gra |
| 10 | dippo |
| 1 | divalicio |
| 20 | doug |
| 2 | doug_ |
| 1 | driftotd |
| 1 | dvotd |
| 1 | earp |
| 15 | eeyore |
| 30 | elizabroc |
| 1 | emergency |
| 1 | epic_monk |
| 1005 | evan |
| 1 | evan%7Cmo |
| 2 | evan%7Cod |
| 4 | evan|mobi |
| 10 | evan|odin |
| 1 | evan|thor |
| 1 | ewotd |
| 1 | f7u12 |
| 3 | farfromgu |
| 6 | finfan |
| 1 | flipper |
| 2 | friday |
| 1 | gbotd |
| 1 | geoff |
| 2 | gjabla |
| 39 | gobi |
| 1 | gotd |
| 1 | gregg |
| 1 | gross |
| 109 | hassan |
| 2317 | heath |
| 10 | heathbot |
| 2 | heathjay |
| 4 | heath|her |
| 1 | helicockt |
| 1 | heroprota |
| 1 | hhotd |
| 2 | hobojames |
| 6 | homo |
| 112 | horus_ple |
| 2 | hotd |
| 6 | ian |
| 1 | iBOTD |
| 7 | ikirk |
| 1 | illicit_a |
| 2 | infidel |
| 4 | j2h |
| 3 | jackass |
| 10 | Jaime |
| 7285 | james |
| 1 | james%7Ch |
| 2 | james@web |
| 10 | jameswhit |
| 1538 | jamison |
| 3 | jamison- |
| 40 | jared |
| 7 | jared_ |
| 6 | jarvis |
| 13 | jason |
| 8 | jbennett |
| 202 | jcluff |
| 53 | jcluff_ |
| 2 | jcluff_at |
| 1 | jcluff_ho |
| 151 | jeremy |
| 1 | jeremyhol |
| 2 | jfryman |
| 2 | joe |
| 12 | johnny |
| 1 | justsayin |
| 1 | JustWalt |
| 3 | jwage |
| 1 | kaafir |
| 1 | kcotd |
| 1 | keechwd%7 |
| 1843 | kevin |
| 2 | kinda_nsf |
| 415 | kmarcum |
| 2 | kmarcum%7 |
| 1 | kpotd |
| 2 | kuotd |
| 1 | lackey |
| 106 | lara |
| 868 | larkin |
| 1 | larkin_ |
| 106 | laure |
| 1 | lcotd |
| 68 | levicole |
| 1 | levicole% |
| 1 | levicole| |
| 1 | lilkbfish |
| 2 | limey |
| 101 | lisa |
| 302 | logan |
| 1 | loganspen |
| 1 | logan_ |
| 2 | Lola |
| 1 | mailorder |
| 5 | Mandrake |
| 3 | matt |
| 19 | maxbeizer |
| 1 | maybenfsw |
| 1 | maybe_nsf |
| 1 | metslose |
| 3 | milleem1 |
| 1 | moarbacon |
| 1 | motd |
| 1 | mvotd |
| 2 | namlet |
| 1 | namlet|fr |
| 14 | nathan |
| 466 | Neil |
| 15 | nelsocs |
| 2 | newjames |
| 2 | nnorman |
| 1 | notd |
| 1 | notwhatit |
| 1 | nowaythis |
| 1 | nsfl |
| 50 | nsfw |
| 1 | NSFW! |
| 1 | nsfw-mayb |
| 1 | nsfwbutfu |
| 1 | nsfw_book |
| 1 | nsfw_cupc |
| 2 | nsfw_geek |
| 1 | nsfw_mayb |
| 1 | oaotd |
| 1 | oiotd |
| 1 | orotd |
| 1 | owotd |
| 1 | paradeotd |
| 1 | paradoja |
| 366 | phillip |
| 1 | pligbotd |
| 1 | possible- |
| 1 | potd |
| 1 | potm |
| 5 | psmith |
| 1 | psylocke |
| 1 | puppet-fa |
| 3 | queef |
| 4 | reverendj |
| 40 | revrndjim |
| 7 | rhendry |
| 507 | rick |
| 3 | rick%7Cod |
| 305 | rickbra |
| 1 | rick|away |
| 1523 | rob |
| 1 | sandbamra |
| 359 | scott |
| 2 | sealsah |
| 4 | slackey |
| 1 | slightly_ |
| 1 | smbotd |
| 1 | smotd |
| 1 | smwomotd |
| 1 | snowboard |
| 2 | sotd |
| 6 | spenclk |
| 1 | spenclk_ |
| 1 | splitotd |
| 1 | srslynsfw |
| 1467 | stahnma |
| 4 | stahnma- |
| 6 | stahnma_ |
| 14 | Stephanie |
| 323 | stephenye |
| 9 | Stephmeis |
| 461 | stephy |
| 100 | Stephy Is |
| 1 | stickyrob |
| 3 | stotd |
| 30 | swincel |
| 2 | swincel__ |
| 1 | swotd |
| 1 | syeargin% |
| 4 | terB |
| 1 | testasuar |
| 169 | teyo |
| 2 | tfotd |
| 1 | tgotd |
| 4 | tony |
| 2 | totd |
| 3 | turgidson |
| 1 | very-nsfw |
| 2 | very_nsfw |
| 1 | via_think |
| 4 | VIC-20 |
| 46 | vinbarnes |
| 1 | vnsfw |
| 1 | wh1te |
| 499 | white |
| 75 | whitejs |
| 1 | WhyBother |
| 1 | wincel |
| 3 | wtf |
| 1 | wtf_parro |
| 3 | x-heath |
| 1 | y-james |
| 74 | yermom |
| 1 | yotd |
| 1 | ypotd-nsf |
+----------+-----------+
267 rows in set (0.04 sec)
# Unique autohrs all time
mysql> select count(distinct(user)) from ircLink;
+-----------------------+
| count(distinct(user)) |
+-----------------------+
| 267 |
+-----------------------+
1 row in set (0.04 sec)
# 2013 Link submissions
mysql> select count(*) 2013_links, user from ircLink where timestamp >= '2013-01-01' and timestamp < '2014-01-01' group by user;
+------------+-----------+
| 2013_links | user |
+------------+-----------+
| 7 | abotd |
| 530 | arafatm |
| 10 | arafatm_ |
| 1 | ashamim |
| 493 | aziz |
| 1 | balls |
| 22 | botd |
| 12 | bradejr |
| 3 | bradejr%7 |
| 1112 | brandon |
| 1 | ccaum |
| 75 | chris |
| 1 | cotd |
| 141 | crunchy |
| 507 | cwage |
| 24 | elizabroc |
| 237 | evan |
| 1 | evan%7Cmo |
| 2 | evan%7Cod |
| 4 | evan|mobi |
| 1 | ewotd |
| 3 | farfromgu |
| 109 | hassan |
| 343 | heath |
| 10 | heathbot |
| 1 | helicockt |
| 1 | hhotd |
| 2 | hobojames |
| 109 | horus_ple |
| 1 | illicit_a |
| 1 | infidel |
| 1419 | james |
| 1 | james%7Ch |
| 286 | jamison |
| 3 | jamison- |
| 15 | jcluff |
| 16 | jcluff_ |
| 85 | jeremy |
| 2 | jfryman |
| 1 | justsayin |
| 1 | JustWalt |
| 1 | kaafir |
| 1 | keechwd%7 |
| 97 | kevin |
| 365 | kmarcum |
| 2 | kmarcum%7 |
| 1 | kpotd |
| 1 | lcotd |
| 52 | levicole |
| 1 | lilkbfish |
| 22 | logan |
| 17 | maxbeizer |
| 1 | maybenfsw |
| 1 | maybe_nsf |
| 48 | neil |
| 1 | nowaythis |
| 5 | nsfw |
| 1 | nsfw-mayb |
| 1 | nsfwbutfu |
| 1 | nsfw_cupc |
| 1 | nsfw_mayb |
| 52 | Phillip |
| 1 | possible- |
| 2 | psmith |
| 4 | reverendj |
| 40 | revrndjim |
| 18 | rick |
| 264 | rickbra |
| 81 | rob |
| 1 | sealsah |
| 1 | slightly_ |
| 128 | stahnma |
| 322 | stephenye |
| 1 | Stephy |
| 1 | syeargin% |
| 1 | tfotd |
| 1 | totd |
| 1 | vinbarnes |
| 14 | whitejs |
| 1 | wtf_parro |
+------------+-----------+
80 rows in set (0.03 sec)
# Link submitters in 2013
mysql> select count(distinct(user)) from ircLink where timestamp >= '2013-01-01' and timestamp < '2014-01-01';
+-----------------------+
| count(distinct(user)) |
+-----------------------+
| 80 |
+-----------------------+
1 row in set (0.04 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment