Ok today's quest.
Admin has furnished us with a list of numbers showing who has commented the most in the last 365 days. Top is Robben, who are the rest?
| UserID | commentCount | Name
+--------+--------------+
| 1145 | 6592 | Robben
| 6173 | 6090 |
| 10415 | 4717 |
| 11781 | 3756 |
| 19575 | 2661 |
| 1137 | 2487 |
| 1071 | 2409 |
| 2114 | 2193 |
| 3339 | 2156 |
| 1059 | 1896 |
| 3245 | 1835 |
| 6675 | 1820 |
| 1170 | 1806 |
| 12980 | 1785 |
| 6039 | 1758 |
| 1060 | 1752 |
| 2708 | 1705 |
| 13430 | 1430 |
| 12366 | 1429 |
| 9251 | 1413 |
EDIT: OK, Admin made a mistake in his production of this list. See comments for a revised list.
A year of comment
posted on 15/7/16
How many of Tyke's are 1916?
posted on 15/7/16
Is there a longer list?
posted on 15/7/16
comment by HRH King Ledley (U20095)
posted 2 minutes ago
How many of Tyke's are 1916?
----------------------------------------------------------------------
1912
Yeah, there is a top 100.... one sec
posted on 15/7/16
Top 100 in the last year
My code was wrong
+--------+--------------+
| UserID | commentCount |
+--------+--------------+
| 1145 | 58877 | Robben
| 10415 | 48527 | Galv
| 6173 | 41406 | Tyke
| 11781 | 27499 | Arab
| 1071 | 24780 | Raptor
| 1060 | 24076 | TBOK
| 6675 | 23893 | GT
| 3245 | 20586 | Pete
| 19575 | 20198 | 4za
| 18543 | 19170 | Sizzle
| 1137 | 18920 |
| 20351 | 18057 |
| 12366 | 17252 |
| 11551 | 16066 |
| 12980 | 16029 |
| 3339 | 15356 |
| 9135 | 14639 |
| 2114 | 13968 |
| 8248 | 13876 |
| 8919 | 13875 |
| 12889 | 13638 |
| 6578 | 13036 |
| 10026 | 12562 |
| 1608 | 12103 |
| 14547 | 11790 |
| 6283 | 11112 |
| 3423 | 10846 |
| 18420 | 10826 |
| 1850 | 10623 |
| 3584 | 10514 |
| 9612 | 10408 |
| 2087 | 10246 |
| 1103 | 10151 |
| 1097 | 10148 |
| 6489 | 10042 |
| 2992 | 10040 |
| 3579 | 9851 |
| 6039 | 9685 |
| 1700 | 9584 |
| 2708 | 9393 |
| 3627 | 9326 |
| 2307 | 9217 |
| 1110 | 9174 |
| 1109 | 8746 |
| 11809 | 8737 |
| 13531 | 8624 |
| 19985 | 8595 |
| 15205 | 8472 |
| 1007 | 8422 |
| 1993 | 8332 |
| 6633 | 8275 |
| 15867 | 8272 |
| 4291 | 8213 |
| 1449 | 8202 |
| 8567 | 8196 |
| 1 | 7796 |
| 1705 | 7347 |
| 10730 | 7306 |
| 20092 | 7247 |
| 9129 | 7174 |
| 19211 | 7087 |
| 6687 | 6976 |
| 4640 | 6973 |
| 3904 | 6847 |
| 1847 | 6717 |
| 3522 | 6619 |
| 4443 | 6526 |
| 10162 | 6492 |
| 9457 | 6461 |
| 20121 | 6415 |
| 17269 | 6362 |
| 5291 | 6339 |
| 5676 | 6333 |
| 6374 | 6290 |
| 1863 | 6269 |
| 20000 | 6208 |
| 8853 | 6203 |
| 20567 | 6145 |
| 1029 | 6098 |
| 1170 | 6095 |
| 8613 | 5943 |
| 20095 | 5920 | - HRH
| 1830 | 5843 |
| 9257 | 5790 |
| 18814 | 5789 |
| 1059 | 5776 |
| 1348 | 5732 |
| 19099 | 5728 |
| 1677 | 5708 |
| 16927 | 5684 |
| 10410 | 5666 |
| 6876 | 5656 |
| 6426 | 5637 |
| 1308 | 5622 |
| 20179 | 5614 |
| 3123 | 5606 |
| 1695 | 5547 |
| 4099 | 5545 |
| 5041 | 5540 |
| 3606 | 5523 |
+--------+--------------+
posted on 15/7/16
I read the initial list first.....as I thought, if it top was 6k I would be up there
posted on 15/7/16
Fack I have 10 times more comments than you
posted on 15/7/16
58877 / 365 = 161
10 comments an hour for every hour you are awake, assuming 8hrs sleep.
Do you have thumbs left?
posted on 15/7/16
We discussed this yesterday.
I'm a Monday-Friday 7:00/7:15-16:00ish poster. Works out at 1 every 2 minutes of my working day.
Thumbs? I wouldn't be able to comment this much on a phone
posted on 15/7/16
Not even 5000 comments for me this year. Probably not even 1000 because the site has become shiiiiiiiiiitttt.
posted on 15/7/16
comment by Robben: Mr JA (U1145)
posted 10 hours, 56 minutes ago
Top 100 in the last year
My code was wrong
+--------+--------------+
| UserID | commentCount |
+--------+--------------+
| 1145 | 58877 | Robben
| 10415 | 48527 | Galv
| 6173 | 41406 | Tyke
| 11781 | 27499 | Arab
| 1071 | 24780 | Raptor
| 1060 | 24076 | TBOK
| 6675 | 23893 | GT
| 3245 | 20586 | Pete
| 19575 | 20198 | 4za
| 18543 | 19170 | Sizzle
| 1137 | 18920 |
| 20351 | 18057 |
| 12366 | 17252 |
| 11551 | 16066 |
| 12980 | 16029 |
| 3339 | 15356 |
| 9135 | 14639 |
| 2114 | 13968 |
| 8248 | 13876 |
| 8919 | 13875 |
| 12889 | 13638 |
| 6578 | 13036 |
| 10026 | 12562 |
| 1608 | 12103 |
| 14547 | 11790 |
| 6283 | 11112 |
| 3423 | 10846 |
| 18420 | 10826 |
| 1850 | 10623 |
| 3584 | 10514 |
| 9612 | 10408 |
| 2087 | 10246 |
| 1103 | 10151 |
| 1097 | 10148 | RtM
| 6489 | 10042 |
| 2992 | 10040 |
| 3579 | 9851 |
| 6039 | 9685 |
| 1700 | 9584 |
| 2708 | 9393 |
| 3627 | 9326 |
| 2307 | 9217 |
| 1110 | 9174 |
| 1109 | 8746 |
| 11809 | 8737 |
| 13531 | 8624 |
| 19985 | 8595 |
| 15205 | 8472 |
| 1007 | 8422 |
| 1993 | 8332 |
| 6633 | 8275 |
| 15867 | 8272 |
| 4291 | 8213 |
| 1449 | 8202 |
| 8567 | 8196 |
| 1 | 7796 |
| 1705 | 7347 |
| 10730 | 7306 |
| 20092 | 7247 |
| 9129 | 7174 |
| 19211 | 7087 |
| 6687 | 6976 |
| 4640 | 6973 |
| 3904 | 6847 |
| 1847 | 6717 |
| 3522 | 6619 |
| 4443 | 6526 |
| 10162 | 6492 |
| 9457 | 6461 |
| 20121 | 6415 |
| 17269 | 6362 |
| 5291 | 6339 |
| 5676 | 6333 |
| 6374 | 6290 |
| 1863 | 6269 |
| 20000 | 6208 |
| 8853 | 6203 |
| 20567 | 6145 |
| 1029 | 6098 |
| 1170 | 6095 |
| 8613 | 5943 |
| 20095 | 5920 | - HRH
| 1830 | 5843 |
| 9257 | 5790 |
| 18814 | 5789 |
| 1059 | 5776 |
| 1348 | 5732 |
| 19099 | 5728 |
| 1677 | 5708 |
| 16927 | 5684 |
| 10410 | 5666 |
| 6876 | 5656 |
| 6426 | 5637 |
| 1308 | 5622 |
| 20179 | 5614 |
| 3123 | 5606 |
| 1695 | 5547 |
| 4099 | 5545 |
| 5041 | 5540 |
| 3606 | 5523 |
+--------+--------------+
----------------------------------------------------------------------