Replicas browser and optimizer
This query is marked as a draft
This query has been published
Searches en.wp for pages with the 'contenttranslation' with timestamp for datetimes 01/01/2016 00:00:00 to 27/07/2016 00:00:00
SELECT distinct page.page_title, rev_timestamp FROM revision JOIN change_tag ON ct_rev_id = rev_id JOIN page ON page_id = rev_page WHERE ct_tag = 'contenttranslation' AND rev_timestamp BETWEEN 20160101000000 AND 20160727000000 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