Flagged revs manual review counts

This query is marked as a draft This query has been published by Zache.

- log_action IN ('approve', 'approve2')
- log_timestamp > 2017

SQL

/*
This is too slow for Quarry so this is just for storing it.

Result 14.4.2017
+--------+------+--------+------------+------+
| wiki   | uc   | c      | log_action | d    |
+--------+------+--------+------------+------+
| arwiki |  272 |  16807 | approve    | 2017 |
| bewiki |   19 |   4392 | approve    | 2017 |
| cewiki |    3 |    103 | approve    | 2017 |
| dewiki | 4365 | 185697 | approve    | 2017 |
| eowiki |   62 |   2126 | approve    | 2017 |
| fiwiki |  203 |  22768 | approve    | 2017 |
| hewiki |  272 |  16807 | approve    | 2017 |
| huwiki |  128 |  15936 | approve    | 2017 |
| idwiki |   99 |  11011 | approve    | 2017 |
| plwiki | 1055 |  64502 | approve    | 2017 |
| ruwiki | 1139 | 129940 | approve    | 2017 |
| sqwiki |   33 |   1226 | approve    | 2017 |
| trwiki |  187 |  28703 | approve    | 2017 |
| ukwiki |  262 |  36999 | approve    | 2017 |
+--------+------+--------+------------+------+
14 rows in set (4 min 54.49 sec)

SELECT 'arwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM arwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'eowiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM eowiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'sqwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM sqwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'idwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM idwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'trwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM trwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'ukwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM ukwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'bewiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM bewiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'cewiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM cewiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'fiwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM fiwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'huwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM huwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'hewiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM arwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'ruwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM ruwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'dewiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM dewiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
UNION
SELECT 'plwiki' as wiki, count(distinct(log_user)) as uc, sum(1) as c, log_action,floor(log_timestamp/10000000000) as d FROM plwiki_p.logging WHERE log_action IN ('approve', 'approve2') and log_timestamp>20170000000000 group by d
ORDER BY wiki;*/

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...