Find all pages under Grants:Evaluation namespace created after August 2, 2014

Fork of Find all pages under Grants:Evaluation namespace created after August 2, 2014 by OShehata (WMF)

This query is marked as a draft This query has been published by OShehata (WMF).

SQL

USE metawiki_p;
SELECT * 
FROM page,revision
WHERE 
	page_namespace = 200 AND  -- 200 is the namespace of Grants:
    page_title LIKE 'Evaluation%' -- Should be under Evaluation + something 
    AND rev_parent_id = 0 -- Get the oldest revision (to find out when it was created)
    AND page_id = rev_page -- Since the revisions are stored in a different table, make sure we join correctly
    AND rev_timestamp >= 20140802000000 -- This is the date of August 2 2014 in the format yyyymmdd 
LIMIT 10;

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...