| hoo added a comment. |
cawiki had (at the time statement usage were disable again) 90,430 statement usages from just 1,118 pages. This means each of these pages had an average of about 81 statement usages (median: 90) and one page had 196 even.
Top 10 pages:
mysql:wikiadmin@db1094 [cawiki]> SELECT COUNT(*) AS No, eu_page_id FROM wbc_entity_usage WHERE eu_aspect LIKE "C.%" GROUP BY eu_page_id ORDER BY No DESC LIMIT 10; +-----+------------+ | No | eu_page_id | +-----+------------+ | 196 | 90242 | | 192 | 53024 | | 179 | 68079 | | 177 | 236868 | | 166 | 153616 | | 165 | 40888 | | 164 | 881994 | | 162 | 577523 | | 158 | 1113825 | | 157 | 114421 | +-----+------------+
On elwiki there are only 1,853,264 statement usages on 88,106 pages, thus each of these pages has an average of only 21 statement usages (median: 14).
Top 10 pages:
mysql:wikiadmin@db1072 [elwiki]> SELECT COUNT(*) AS No, eu_page_id FROM wbc_entity_usage WHERE eu_aspect LIKE "C.%" GROUP BY eu_page_id ORDER BY No DESC LIMIT 10; +-----+------------+ | No | eu_page_id | +-----+------------+ | 210 | 519024 | | 100 | 196573 | | 96 | 189235 | | 96 | 13235 | | 96 | 233523 | | 93 | 171936 | | 93 | 16531 | | 92 | 186490 | | 92 | 435266 | | 90 | 189233 | +-----+------------+On cewiki there are up to now only 99,814 statement usages on 5,865 pages, thus each of these pages has an average of only 17 statement usages (median: 14).
Top 10 pages:
mysql:wikiadmin@db1078 [cewiki]> SELECT COUNT(*) AS No, eu_page_id FROM wbc_entity_usage WHERE eu_aspect LIKE "C.%" GROUP BY eu_page_id ORDER BY No DESC LIMIT 10; +-----+------------+ | No | eu_page_id | +-----+------------+ | 187 | 2237 | | 154 | 2443 | | 125 | 9584 | | 125 | 9516 | | 122 | 2680 | | 121 | 62650 | | 121 | 2278 | | 119 | 2284 | | 118 | 2179 | | 116 | 9609 | +-----+------------+
TASK DETAIL
EMAIL PREFERENCES
To: hoo
Cc: Bawolff, eranroz, Ottomata, PokestarFan, Ladsgroup, Stashbot, gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, daniel, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Mbch331, Jay8g, Krenair
Cc: Bawolff, eranroz, Ottomata, PokestarFan, Ladsgroup, Stashbot, gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, Micru, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, daniel, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Marostegui, Lewizho99, Minhnv-2809, Maathavan, Luke081515, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
