SQL
AخA
SELECT DISTINCT p.page_id, p.page_title, p.page_namespace FROM wikidatawiki_p.page p WHERE p.page_id IN (
#to customize your query, follow the numbers to the instructions
#listed below the query. contact jmorgan@wikimedia.org if you need help.
SELECT r.rev_page
#1
FROM wikidatawiki_p.revision r
WHERE r.rev_user_text IN
#3
(
"Blahma",
"Dominikmatus",
"Harold",
"Martin Kotačka",
"TheWayThroughTheWoods"
)
AND r.rev_timestamp BETWEEN
#4
20160405150000
AND
#5
20160405180000
) AND page_namespace = 0
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.