User:John/WikiStats

This was done by myself (with the help of Southparkfan for tuning the SQL query) for information purposes as there is a surprising amount of requests going unhandled with wiki creation. The stats are interesting.

Updated information (and new information on approved requests) collected by NDKilla and Reception123

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.

Please note that the number of requests is nowhere near the actual number of wikis due to deletion, denied requests and spam. (Reception123)

First, let's see how many wiki requests there were at the time I collected the data. Date collected: 8 October 2020 (Reception123) MariaDB [metawiki]> SELECT COUNT(*) FROM cw_requests;

+--+ +--+ +--+
 * COUNT(*) |
 * 14614 |

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.

For all wiki requests MariaDB [metawiki]> SELECT user.user_name, COUNT(*) as COUNT FROM cw_requests JOIN user ON cw_requests.cw_status_comment_user = user.user_id GROUP BY cw_requests.cw_status_comment_user ORDER BY COUNT DESC; Last updated: 24 August 2018 (OUTDATED!)

+---+---+ +---+---+ +---+---+
 * user_name        | COUNT |
 * Reception123     |  1773 |
 * Void             |   656 |
 * AlvaroMolina     |   533 |
 * MacFan4000       |   487 |
 * TriX             |   431 |
 * John             |   224 |
 * Southparkfan     |   120 |
 * CnocBride        |   102 |
 * Revi             |    93 |
 * NDKilla          |    79 |
 * Wiki1776         |    70 |
 * SleepyMode       |    60 |
 * Videojeux4       |    54 |
 * Sau226           |    42 |
 * Zppix            |    38 |
 * ItsPugle         |    35 |
 * Lawrence-Prairies |   33 |
 * GOTILON          |    29 |
 * Samuel           |    17 |
 * XOF              |    12 |
 * Corey            |    11 |
 * Sammy            |     9 |
 * Paladox          |     6 |
 * There'sNoTime    |     6 |
 * Labster          |     2 |
 * Guy vandegrift   |     1 |

For approved wiki requests MariaDB [metawiki]> SELECT user.user_name, COUNT(*) as COUNT FROM cw_requests JOIN user ON cw_requests.cw_status_comment_user = user.user_id WHERE cw_requests.cw_status="approved" GROUP BY cw_requests.cw_status_comment_user ORDER BY COUNT DESC; Last updated: 24 August 2018 (OUTDATED!)

+---+---+ +---+---+ +---+---+
 * user_name        | COUNT |
 * Reception123     |  1548 |
 * AlvaroMolina     |   443 |
 * Void             |   425 |
 * TriX             |   412 |
 * MacFan4000       |   409 |
 * John             |   177 |
 * Southparkfan     |   105 |
 * Revi             |    80 |
 * CnocBride        |    74 |
 * NDKilla          |    70 |
 * Wiki1776         |    60 |
 * Videojeux4       |    40 |
 * Sau226           |    35 |
 * Zppix            |    28 |
 * SleepyMode       |    26 |
 * Lawrence-Prairies |   25 |
 * ItsPugle         |    25 |
 * GOTILON          |    24 |
 * Samuel           |    17 |
 * XOF              |    12 |
 * Corey            |    11 |
 * Sammy            |     9 |
 * There'sNoTime    |     6 |
 * Paladox          |     3 |
 * Labster          |     1 |

For wikis created MariaDB [metawiki]> select actor_name, count(*) as count from logging join actor on actor_id = log_actor where log_type = 'farmer' and log_action = 'createwiki' group by log_actor order by count desc; +-+---+ +-+---+ +-+---+ 56 rows in set (0.296 sec)
 * actor_name                             | count |
 * Reception123                           |  1986 |
 * Void                                   |  1598 |
 * é–‹æ‹“è€…                              |  1411 |
 * Examknow                               |   517 |
 * Dmehus                                 |   499 |
 * AlvaroMolina                           |   478 |
 * Amanda Catherine                       |   447 |
 * RhinosF1                               |   429 |
 * MacFan4000                             |   424 |
 * TriX                                   |   389 |
 * Zppix                                  |   299 |
 * MrJaroslavik                           |   275 |
 * Hispano76                              |   260 |
 * SA 13 Bro                              |   234 |
 * John                                   |   229 |
 * Paladox                                |   204 |
 * CnocBride                              |   193 |
 * Southparkfan                           |   158 |
 * GOTILON                                |   109 |
 * FireBarrier101                         |   108 |
 * Guy vandegrift                         |   104 |
 * Revi                                   |   103 |
 * Universal Omega                        |   103 |
 * HispanoBOT                             |    93 |
 * HeartsDo                               |    85 |
 * NDKilla                                |    84 |
 * Msnhinet8                              |    75 |
 * Bonnedav                               |    72 |
 * Cmg                                    |    69 |
 * Sau226                                 |    63 |
 * Centrist16                             |    52 |
 * Hypercane                              |    49 |
 * Cy                                     |    44 |
 * Lawrence-Prairies                      |    27 |
 * LegoMaster                             |    26 |
 * SleepyMode                             |    24 |
 * Sario528                               |    24 |
 * Gustave London                         |    22 |
 * Fungster                               |    17 |
 * Samuel                                 |    17 |
 * CircleyDoesExtracter                   |    16 |
 * Furricane                              |    15 |
 * Corey                                  |    14 |
 * Pkbwcgs                                |    14 |
 * XOF                                    |    12 |
 * ã‚·ãƒ¥ãƒ´ã‚¡ãƒ«ãƒ„                     |    11 |
 * CoolieCoolster                         |    11 |
 * Sammy                                  |    11 |
 * Wolf                                   |    11 |
 * OlegCinema                             |    10 |
 * Eduaddad                               |     7 |
 * There'sNoTime                          |     6 |
 * ã��ã‚‰ã�Ÿã�“                        |     5 |
 * Example4                               |     1 |
 * Labster                                |     1 |

For wikis created between 2019-2020

MariaDB [metawiki]> select actor_name, count(*) as count from logging join actor on actor_id = log_actor where log_type = 'farmer' and log_action = 'createwiki'    and (log_timestamp like '2020%' or log_timestamp like '2019%' or log_timestamp like '2019%') group by log_actor order by count desc; +-+---+ +-+---+ +-+---+ 38 rows in set (0.016 sec)
 * actor_name                             | count |
 * é–‹æ‹“è€…                              |  1144 |
 * Void                                   |   768 |
 * Examknow                               |   517 |
 * Dmehus                                 |   499 |
 * Amanda Catherine                       |   447 |
 * RhinosF1                               |   429 |
 * Reception123                           |   336 |
 * MrJaroslavik                           |   275 |
 * Zppix                                  |   249 |
 * SA 13 Bro                              |   234 |
 * Hispano76                              |   230 |
 * FireBarrier101                         |   108 |
 * Universal Omega                        |   103 |
 * Paladox                                |    86 |
 * Bonnedav                               |    72 |
 * Cmg                                    |    69 |
 * Hypercane                              |    49 |
 * Msnhinet8                              |    44 |
 * John                                   |    35 |
 * LegoMaster                             |    26 |
 * Sario528                               |    24 |
 * Gustave London                         |    22 |
 * HeartsDo                               |    17 |
 * Fungster                               |    17 |
 * CnocBride                              |    16 |
 * CircleyDoesExtracter                   |    16 |
 * Furricane                              |    15 |
 * Southparkfan                           |    12 |
 * ã‚·ãƒ¥ãƒ´ã‚¡ãƒ«ãƒ„                     |    11 |
 * Wolf                                   |    11 |
 * Eduaddad                               |     7 |
 * Revi                                   |     6 |
 * AlvaroMolina                           |     5 |
 * ã��ã‚‰ã�Ÿã�“                        |     5 |
 * MacFan4000                             |     4 |
 * Cy                                     |     3 |
 * Pkbwcgs                                |     1 |
 * NDKilla                                |     1 |

Wikis by languages MariaDB [mhglobal]> SELECT wiki_language, COUNT(*) as COUNT FROM cw_wikis GROUP BY wiki_language ORDER BY COUNT DESC;

+---+---+ +---+---+ +---+---+ 72 rows in set (0.003 sec)
 * wiki_language | COUNT |
 * en           |  3042 |
 * fr           |   134 |
 * ja           |   109 |
 * ko           |    99 |
 * es           |    97 |
 * de           |    82 |
 * pt-br        |    82 |
 * ru           |    73 |
 * zh-cn        |    55 |
 * pl           |    45 |
 * it           |    44 |
 * zh           |    39 |
 * nl           |    27 |
 * zh-hans      |    26 |
 * en-gb        |    24 |
 * zh-tw        |    22 |
 * cs           |    19 |
 * id           |    19 |
 * fi           |    12 |
 * tr           |    12 |
 * zh-hant      |    11 |
 * hu           |    10 |
 * es-419       |    10 |
 * ar           |    10 |
 * sv           |     9 |
 * pt           |     8 |
 * he           |     7 |
 * bn           |     6 |
 * nb           |     6 |
 * en-ca        |     5 |
 * el           |     5 |
 * es-formal    |     5 |
 * de-ch        |     4 |
 * hr           |     4 |
 * th           |     4 |
 * lt           |     4 |
 * uk           |     3 |
 * sk           |     3 |
 * de-formal    |     3 |
 * ro           |     3 |
 * fa           |     3 |
 * de-at        |     2 |
 * vi           |     2 |
 * no           |     2 |
 * zh-sg        |     2 |
 * sr-el        |     2 |
 * ca           |     2 |
 * sr           |     2 |
 * frc          |     2 |
 * zh-yue       |     1 |
 * et           |     1 |
 * bar          |     1 |
 * fy           |     1 |
 * mr           |     1 |
 * uz           |     1 |
 * zh-hk        |     1 |
 * eo           |     1 |
 * isv          |     1 |
 * yue          |     1 |
 * nl-informal  |     1 |
 * ta           |     1 |
 * bg           |     1 |
 * tl           |     1 |
 * kk           |     1 |
 * ee           |     1 |
 * ak           |     1 |
 * hi           |     1 |
 * gsw          |     1 |
 * sr-ec        |     1 |
 * bs           |     1 |
 * pa           |     1 |
 * eu           |     1 |

Wikis by categories MariaDB [mhglobal]> SELECT wiki_category, COUNT(*) as COUNT FROM cw_wikis GROUP BY wiki_category ORDER BY COUNT DESC;

+---+---+ +---+---+ +---+---+ 25 rows in set (0.004 sec)
 * wiki_category | COUNT |
 * uncategorised | 1102 |
 * gaming       |   588 |
 * community    |   484 |
 * education    |   448 |
 * fantasy      |   273 |
 * private      |   251 |
 * fandom       |   234 |
 * software     |   194 |
 * literature   |   193 |
 * music        |   134 |
 * sport        |    47 |
 * electronics  |    43 |
 * leisure      |    39 |
 * religion     |    37 |
 * medical      |    33 |
 * geography    |    33 |
 * politics     |    27 |
 * entertainment |   25 |
 * military     |    15 |
 * podcast      |     9 |
 * langling     |     7 |
 * automotive   |     3 |
 * history      |     2 |
 * media        |     2 |
 * humour       |     1 |