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

SELECT DISTINCT(page_id), page_title, page_namespace

#1

FROM cswiktionary_p.page p JOIN 

#2

cswiktionary_p.revision r 

ON p.page_id = r.rev_page 

WHERE r.rev_user_text IN

#3

(

'Ben Skála',

'Blahma',

'Hana Kašpaříková',

'Jirr',

'Martin Kotačka'

) 

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

​