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
GTrang
.
Toggle Highlighting
SQL
select log_id as logid, log_title as title, log_timestamp as timestamp, page_is_redirect as redirect, rev_timestamp as last_edited from logging_userindex, page, revision where log_namespace = 0 and page_namespace = 0 and log_title = page_title and log_actor = 6483 and log_type = 'pagetriage-curation' and log_action = 'reviewed' and log_timestamp >= 20221001000000 and rev_id = page_latest order by page_is_redirect desc, log_id asc limit 1000; select count(*) from logging_userindex where log_actor = 6483 and log_type = 'pagetriage-curation' and log_action = 'reviewed' and log_timestamp >= 20221001000000
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...