Research talk:Editor month dataset
Non-content wikis covered[edit]
I was wondering which non-content wikis are included in the dataset; leaving the result here in case anyone else has the same question:
- wikimediafoundation.org
- mediawiki.org
- meta.wikimedia.org
- incubator.wikimedia.org
(via:
SELECT DISTINCT wiki FROM staging.editor_month
WHERE wiki NOT RLIKE '^...?wiki' # Wikipedias with 2- or 3-letter language code
AND wiki NOT RLIKE '^.*_.*wiki' # wikis with a "-" in their language code (e.g. zh-min-nan.wikipedia.org )
AND wiki NOT LIKE '%wiktionary'
AND wiki NOT LIKE '%wikisource'
AND wiki NOT LIKE '%wikibooks'
AND wiki NOT LIKE '%wikinews'
AND wiki NOT LIKE '%wikiquote'
AND wiki NOT LIKE '%wikivoyage'
AND wiki NOT LIKE '%wikiversity'
ORDER BY wiki;
+----------------+
| wiki |
+----------------+
| commonswiki |
| foundationwiki |
| incubatorwiki |
| mediawikiwiki |
| metawiki |
| simplewiki |
| sourceswiki |
| specieswiki |
| wikidatawiki |
+----------------+
9 rows in set (0.01 sec)
Regards, Tbayer (WMF) (talk) 06:47, 10 March 2018 (UTC)