#to customize your query, follow the numbers to the instructions

#listed below the query. contact jmorgan@wikimedia.org if you need help.

SELECT DISTINCT(rev_page)

#1

#2

FROM enwiki_p.revision r 

WHERE r.rev_user_text IN

#3

(

'Bazi',

'Ben Skála',

'Blahma',

'Hana Kašpaříková',

'Jirr',

'Martin Kotačka',

'Nesnera',

'Ractor',

'TheWayThroughTheWoods'

) 

AND r.rev_timestamp BETWEEN 

#4

20160308160000 

AND 

#5

20160308185959 

​

# 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

​