=Total=
== App schema ==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile app edits"
FROM MobileWikiAppEdit_9003125
WHERE
event_action = "saved" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%"
GROUP BY month;
```
== Mobile web schema ==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.MobileWebEditing_8599025
WHERE
event_action = "success" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%"
GROUP BY month;
```
== Edit schema ==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.`Edit_13457736`
WHERE
event_platform = "phone" AND
event_action = "saveSuccess" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%"
GROUP BY month;
```
=Article edits only=
==Mobile web schema==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.MobileWebEditing_8599025
WHERE
event_action = "success" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
event_namespace = 0
GROUP BY month;
```
==Edit schema==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.`Edit_13457736`
WHERE
event_platform = "phone" AND
event_action = "saveSuccess" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
`event_page.ns` = 0
GROUP BY month;
```
==App schema==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile app edits"
FROM MobileWikiAppEdit_9003125
WHERE
event_action = "saved" AND
wiki LIKE "%wiki" AND
wiki NOT IN (
"commonswiki", "wikidatawiki", "metawiki", "loginwiki",
"mediawikiwiki", "sourceswiki", "specieswiki", "testwiki",
"test2wiki", "testwikidatawiki", "incubatorwiki", "advisorywiki",
"outreachwiki", "qualitywiki", "strategywiki", "usabilitywiki",
"collabwiki", "donatewiki", "execwiki", "officewiki",
"legalteamwiki", "movementroleswiki", "internalwiki",
"auditcomwiki", "boardgovcomwiki", "boardwiki", "chairwiki",
"chapcomwiki", "checkuser_wiki", "foundationwiki", "grantswiki",
"iegcomwiki", "nostalgiawiki", "ombudsmenwiki", "otrs_wikiwiki",
"searchcomwiki", "spcomwiki", "stewardwiki", "tenwiki",
"transitionteamwiki", "votewiki", "wg_enwiki", "zerowiki",
"checkuserwiki", "fdcwiki" ) AND
wiki NOT LIKE "wikimania%" AND
wiki NOT LIKE "arbcom%" AND
event_pageNS IS NULL
GROUP BY month;
```
=English Wikipedia only=
== App schema ==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile app edits"
FROM MobileWikiAppEdit_9003125
WHERE
event_action = "saved" AND
wiki = "enwiki"
GROUP BY month;
```
==Mobile web schema==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.MobileWebEditing_8599025
WHERE
event_action = "success" AND
wiki = "enwiki"
GROUP BY month;
```
== Edit schema ==
```
SELECT LEFT(timestamp, 6) as "month", COUNT(*) as "mobile web edits"
FROM log.`Edit_13457736`
WHERE
event_platform = "phone" AND
event_action = "saveSuccess" AND
wiki = "enwiki"
GROUP BY month;
```
=English Wikipedia mobile editors=
```
SELECT LEFT( rev_timestamp, 6 ), COUNT( DISTINCT( rev_user ) )
FROM change_tag
INNER JOIN revision
ON rev_id = ct_rev_id
WHERE
ct_tag = "mobile edit" AND
rev_timestamp >= "20140801000000"
GROUP BY LEFT( rev_timestamp, 6 )
```