Replicas browser and optimizer
Pages edited by a cohort
This query is marked as a draft
This query has been published
...during a specified time period. Last run November 26, 2014. See comments (marked with a "#") for customization instructions
#to customize your query, follow the numbers to the instructions #listed below the query. contact email@example.com 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_user_text 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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in