Portals created by TTH Apr'18-Mar'19 (no subpages)

Fork of Portals created by TTH Apr'18-Mar'19 by Cryptic

This query is marked as a draft This query has been published by Cryptic.

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.

SQL

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;

​x
 
SELECT DISTINCT CONCAT('[[Portal:', page_title, ']]') AS page,    rev_user_text,    DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,    comment_textFROM revision_userindexJOIN page    ON page_id = rev_pageJOIN comment    ON comment_id = rev_comment_idWHERE 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 = 0ORDER BY rev_timestamp ASC;​

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.

SQL

Checking query status...