Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Shringa13
.
Toggle Highlighting
SQL
use enwiki_p; select r.rev_page as Page_number, p.page_title as PageTitle, r.rev_deleted, MAX(EXTRACT(YEAR FROM r.rev_timestamp)) as last_deletion_year from revision as r inner join page as p ON (p.page_id =r.rev_page) where r.rev_page in (27712,1605200) and rev_deleted =1 group by r.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...