Replicas browser and optimizer
Portals created by TTH Apr'18-Mar'19
This query is marked as a draft
This query has been published
Non-redirect pages in the Portal: namespace created by User:The Transhumanist between April 2018 and March 2019. Compared to the previous query, this omits subpages. For [[WT:CSD#X3]] circa 12 Mar 2019.
SELECT DISTINCT CONCAT('[[Portal:', page_title, ']]') AS page, rev_user_text, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp, comment_text FROM revision_userindex JOIN page ON page_id = rev_page JOIN comment ON comment_id = rev_comment_id WHERE page_namespace = 100 AND rev_user = 1754504 AND rev_timestamp >= '201804' AND rev_timestamp < '201903' AND page_is_redirect = 0 AND page_title NOT LIKE '%/%' AND rev_parent_id = 0 ORDER BY rev_timestamp ASC;
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