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
Chlod
.
Get a number of delete/revision actions on a certain page.
Toggle Highlighting
SQL
SELECT * FROM `logging_logindex` LEFT JOIN `actor_logging` ON `actor_id` = `log_actor` LEFT JOIN `comment_logging` ON `log_comment_id` = `comment_id` WHERE `log_type` = "delete" AND `log_action` = "revision" AND (`log_params` REGEXP "i:(?:1103344157|1076902948|1041071946|1041071907|1041071853|1041071692|1041071135|1024625643|1024625432|1023837176|1023835014|1023832025|1023827732|1023827584|1023826800|1023795690|1023756202|1023755849|1023738347|1021493684|1019908208|1019907825|1019907658|1019907565|1019905590|1019904922|1019899753|1019869221|1019700253|1019696590|1014874365|1010450402|1010449769|1005058277|1004426037|1004425272|1004370326|1002056978|988576841|977889980)[;,]") ORDER BY `log_timestamp` DESC
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...