Replicas browser and optimizer
This query is marked as a draft
This query has been published
How many Wikipedia Android app users have made 5 or more (vs. fewer than 5 but at least 1) Wikidata description edits since the launch of the feature in September 2016.
USE wikidatawiki_p; SELECT IF(n_edits >= 5, '5 or more', 'fewer than 5') AS wikidata_description_edits, COUNT(1) AS n_android_app_users FROM ( SELECT rev_user, SUM( CASE WHEN (rev_timestamp < '20180710' AND ct_tag_id = 13) THEN 1 -- ^ wikidata description edits tagged generically as 'mobile app edit' -- can be safely assumed to come from android WHEN (rev_timestamp >= '20180710' AND ct_tag_id = 14) THEN 1 -- ^ wikidata description edits made on android as of 10 July 2018 are -- explicitly tagged as 'android app edit' ELSE 0 END -- ^ 'mobile app edit'-tagged wikidata description edits made later may -- come from iOS since Fall 2018 ) AS n_edits FROM ( SELECT rev_id, rev_user, rev_timestamp FROM revision WHERE rev_timestamp >= '20160901' -- wikidata description editing on android app started in September 2016 AND INSTR(rev_comment, 'wbsetdescription') > 0 ) AS description_edits INNER JOIN ( SELECT ct_rev_id, ct_tag_id FROM change_tag WHERE ct_tag_id IN(13, 14) -- 'mobile app edit' is 13, 'android app edit' is 14 ) AS android_edits ON description_edits.rev_id = android_edits.ct_rev_id GROUP BY rev_user ) AS android_app_users_wd_desc_edit_counts GROUP BY wikidata_description_edits;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in