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 commonswiki_p.page p JOIN 
#2
commonswiki_p.revision r 
ON p.page_id = r.rev_page 
WHERE r.rev_actor IN
#3
(
 "Jan Macura (lektor)", 
 "Alikvota", 
 "Novakova Milada", 
 "Jana Hajkova", 
 "Dsvatka",
 "Verunaplzen",
 "Klokan1988",
 "Slafra",
 "Kaskova"
) 
AND r.rev_timestamp BETWEEN 
#4
20170301000000 
AND 
#5
20170420000000

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