Pages edited by a cohort

SQL

#to customize your query, follow the numbers to the instructions
#listed below the query. contact jmorgan@wikimedia.org if you need help.
SELECT DISTINCT(page_id), page_title
#1
FROM enwiki_p.page p JOIN 
#2
enwiki_p.revision r 
ON p.page_id = r.rev_page 
WHERE r.rev_user_text IN
#3
(
 "Jtmorgan", 
 "Cullen328", 
 "DESiegel", 
 "DarTar", 
 "ColinFine",
 "SuperHamster",
 "Mz7",
 "StarryGrandma"
) 
AND r.rev_timestamp BETWEEN 
#4
20141019000000 
AND 
#5
20141119000000

# CUSTOMIZING THIS QUERY
# log in to Quarry and copy/paste everything in this window into a new query
# then follow the instructions below to customize each line
#1 specify the wiki: change 'mediawikiwiki_p.page' to the alias code for whatever wiki you want data from 
# (example: 'enwiki_p.page'). See the full list of possible wikis here: http://quarry.wmflabs.org/query/1103
#2 this needs to match the first alias. So if you entereed 'enwiki_p.page' above, change this to 'enwiki_p.revision'
#3 copy/paste the usernames of the people in your cohort between the parentheses, 
# put quotation marks around each name, and separate them with a comma outside the closing quotation mark
# don't put a comma after the last name in the list
#4 date to start counting (14-digit timestamp): year-month-day-hour-minute-second 
# use four digits for year, two digits for everything else
# you can use six zeros for hour-minute-second if you don't need to be that specific
#5 date to stop counting. same instructions as #4
SQL

Checking query status...
