Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Linked pages w/edits by specific user since date
by
Cryptic
This query is marked as a draft
This query has been published
by
Red Director
.
Pages linked from [[Wikipedia:WikiProject Academic Journals/Journals cited by Wikipedia/Sandbox]] with at least one edit by [[User:Citation bot]] on 2023 July 20 or later. For [[WP:RAQ#Articles not edited by Citation bot]] (which first asks for articles that were edited, despite the section name) circa 2023 July 8.
Toggle Highlighting
SQL
SELECT pl_namespace, pl_title, MAX(rev_timestamp) AS 'most recent edit' FROM pagelinks JOIN page AS sourcepage ON sourcepage.page_id = pl_from JOIN page AS targetpage ON targetpage.page_namespace = pl_namespace AND targetpage.page_title = pl_title JOIN revision ON rev_page = targetpage.page_id JOIN actor ON actor_id = rev_actor WHERE sourcepage.page_namespace = 0 AND sourcepage.page_title = '2024_NFL_draft' AND actor_name = 'Red Director' AND rev_timestamp >= '20230720' GROUP BY rev_page;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...