User:John/WikiStats

This was done by myself for information purposes as there is a surprising amount of requests going unhandled with wiki creation. The stats are interesting.

This data is collected in the capacity of a system administrator and no data being revealed is considered private or sensitive. Therefore reusing anything on this page is fair game with or without credit to myself.

First, let's see how many wiki requests there were at the time I collected the data. Date collected: 6 April 2016 MariaDB [metawiki]> SELECT COUNT(*) FROM cw_requests; +--+ +--+ +--+
 * COUNT(*) |
 * 780 |

Now let's associated user_ids with the last person who commented. This in general gives a fair estimate and is the best we have. Therefore the value can be expected to be plus or minus a few.

MariaDB [metawiki]> SELECT cw_status_comment_user, COUNT(*) from cw_requests GROUP BY cw_status_comment_user; ++--+ ++--+ ++--+
 * cw_status_comment_user | COUNT(*) |
 * 1 |      82 |
 * 2 |      80 |
 * 7 |     461 |
 * 8 |      59 |
 * 11 |      38 |
 * 367 |      60 |

Using user_id and user_names from the metawiki table the table looks like:

++--+ ++--+ ++--+
 * cw_status_comment_user | COUNT(*) |
 * John |      82 |
 * Southparkfan |      80 |
 * Reception123 |     461 |
 * Revi |      59 |
 * NDKilla |      38 |
 * Sleepymode |      60 |