Replicas browser and optimizer
List of articles created by a user with no edits since
This query is marked as a draft
This query has been published
USE scowiki_p; SELECT page_title, rev_timestamp FROM revision_userindex JOIN page ON page_id = rev_page WHERE page_latest IN ( select distinct rev_id from revision_userindex where rev_actor = 294 and rev_parent_id = 0 and page_is_redirect = 0 and page_namespace = 1 ) ORDER BY rev_timestamp desc;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in