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.