Fork of Pages edited by a cohort by YjM
This query is marked as a draft This query has been published by Vojtěch Dostál.

SQL

x
 
#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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...