Phab:T163107 reviewLag-anon-average

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

https://phabricator.wikimedia.org/T163107

SQL

SELECT "alswiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from alswiki_p.flaggedrevs_statistics) as max, alswiki_p.flaggedrevs_statistics as frs1, alswiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "ruwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from ruwiki_p.flaggedrevs_statistics) as max, ruwiki_p.flaggedrevs_statistics as frs1, ruwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "dewiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from dewiki_p.flaggedrevs_statistics) as max, dewiki_p.flaggedrevs_statistics as frs1, dewiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "plwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from plwiki_p.flaggedrevs_statistics) as max, plwiki_p.flaggedrevs_statistics as frs1, plwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "eowiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from eowiki_p.flaggedrevs_statistics) as max, eowiki_p.flaggedrevs_statistics as frs1, eowiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "huwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from huwiki_p.flaggedrevs_statistics) as max, huwiki_p.flaggedrevs_statistics as frs1, huwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "arwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from arwiki_p.flaggedrevs_statistics) as max, arwiki_p.flaggedrevs_statistics as frs1, arwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "iawiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from iawiki_p.flaggedrevs_statistics) as max, iawiki_p.flaggedrevs_statistics as frs1, iawiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "hiwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from hiwiki_p.flaggedrevs_statistics) as max, hiwiki_p.flaggedrevs_statistics as frs1, hiwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "sqwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from sqwiki_p.flaggedrevs_statistics) as max, sqwiki_p.flaggedrevs_statistics as frs1, sqwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "idwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from idwiki_p.flaggedrevs_statistics) as max, idwiki_p.flaggedrevs_statistics as frs1, idwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "kawiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from kawiki_p.flaggedrevs_statistics) as max, kawiki_p.flaggedrevs_statistics as frs1, kawiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "fiwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from fiwiki_p.flaggedrevs_statistics) as max, fiwiki_p.flaggedrevs_statistics as frs1, fiwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "bnwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from bnwiki_p.flaggedrevs_statistics) as max, bnwiki_p.flaggedrevs_statistics as frs1, bnwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "trwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from trwiki_p.flaggedrevs_statistics) as max, trwiki_p.flaggedrevs_statistics as frs1, trwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "ukwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from ukwiki_p.flaggedrevs_statistics) as max, ukwiki_p.flaggedrevs_statistics as frs1, ukwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "vecwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from vecwiki_p.flaggedrevs_statistics) as max, vecwiki_p.flaggedrevs_statistics as frs1, vecwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "bewiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from bewiki_p.flaggedrevs_statistics) as max, bewiki_p.flaggedrevs_statistics as frs1, bewiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "enwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from enwiki_p.flaggedrevs_statistics) as max, enwiki_p.flaggedrevs_statistics as frs1, enwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "ptwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from ptwiki_p.flaggedrevs_statistics) as max, ptwiki_p.flaggedrevs_statistics as frs1, ptwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "fawiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from fawiki_p.flaggedrevs_statistics) as max, fawiki_p.flaggedrevs_statistics as frs1, fawiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "cewiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from cewiki_p.flaggedrevs_statistics) as max, cewiki_p.flaggedrevs_statistics as frs1, cewiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key 
UNION
SELECT "mkwiki_p" as wiki, frs1.frs_stat_key, frs1.frs_timestamp, MIN(frs2.frs_timestamp) as oldest_timestamp_with_this_value, frs1.frs_stat_val FROM (SELECT max(frs_timestamp) as max_timestamp from mkwiki_p.flaggedrevs_statistics) as max, mkwiki_p.flaggedrevs_statistics as frs1, mkwiki_p.flaggedrevs_statistics as frs2 WHERE max_timestamp=frs1.frs_timestamp AND frs1.frs_stat_key="reviewLag-anon-average" AND frs1.frs_stat_key=frs2.frs_stat_key AND frs1.frs_stat_val=frs2.frs_stat_val GROUP BY frs_stat_key

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...