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

Fork of Find all pages under Grants:Evaluation namespace 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 
    -- Find a way to get the OLDEST revision 
    -- 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 min(rev_timestamp) >= 20140802000000 -- This is the date of August 2 2014 in the format yyyymmdd 
LIMIT 10;

SQL

Checking query status...