Portals created by TTH Apr'18-Mar'19

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.

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 rev_parent_id = 0
ORDER 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...