Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mile.Horizon
.
Toggle Highlighting
SQL
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
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
.
Checking query status...