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 , CASE WHEN r.rev_deleted == 0 then "No Deletion" WHEN r.rev_deleted == 1 then 'Text Deleted' WHEN r.rev_deleted == 2 then 'Comment Deleted' WHEN r.rev_deleted == 4 then 'User Deleted' WHEN r.rev_deleted == 6 then 'User and Comment Deleted' WHEN r.rev_deleted == 8 then 'Restricted Deletion' ElSE 'No Data' END AS Type_of_deletion, count(r.rev_page) as deletion_count from revision as r inner join page as p ON (r.page_id =r.rev_page) where r.rev_page in (27712,1605200) group by r.rev_page,r.rev_deleted ;
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...