Klub Wikipedie Brno 2016-03-08

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 cswikisource_p.page p JOIN 
#2
cswiktionary_p.revision r 
ON p.page_id = r.rev_page 
WHERE r.rev_user_text IN
#3
(
'Bazi',
'Ben Skála',
'Blahma',
'Hana Kašpaříková',
'Jirr',
'Martin Kotačka',
'Nesnera',
'Ractor',
'TheWayThroughTheWoods'
) 
AND p.page_namespace = 0
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
SQL

Checking query status...
