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` LIKE "%i:1103344157%" OR `log_params` LIKE "%i:1076902948%" OR `log_params` LIKE "%i:1041071946%" OR `log_params` LIKE "%i:1041071907%" OR `log_params` LIKE "%i:1041071853%" OR `log_params` LIKE "%i:1041071692%" OR `log_params` LIKE "%i:1041071135%" OR `log_params` LIKE "%i:1024625643%" OR `log_params` LIKE "%i:1024625432%" OR `log_params` LIKE "%i:1023837176%" OR `log_params` LIKE "%i:1023835014%" OR `log_params` LIKE "%i:1023832025%" OR `log_params` LIKE "%i:1023827732%" OR `log_params` LIKE "%i:1023827584%" OR `log_params` LIKE "%i:1023826800%" OR `log_params` LIKE "%i:1023795690%" OR `log_params` LIKE "%i:1023756202%" OR `log_params` LIKE "%i:1023755849%" OR `log_params` LIKE "%i:1023738347%" OR `log_params` LIKE "%i:1021493684%" OR `log_params` LIKE "%i:1019908208%" OR `log_params` LIKE "%i:1019907825%" OR `log_params` LIKE "%i:1019907658%" OR `log_params` LIKE "%i:1019907565%" OR `log_params` LIKE "%i:1019905590%" OR `log_params` LIKE "%i:1019904922%" OR `log_params` LIKE "%i:1019899753%" OR `log_params` LIKE "%i:1019869221%" OR `log_params` LIKE "%i:1019700253%" OR `log_params` LIKE "%i:1019696590%" OR `log_params` LIKE "%i:1014874365%" OR `log_params` LIKE "%i:1010450402%" OR `log_params` LIKE "%i:1010449769%" OR `log_params` LIKE "%i:1005058277%" OR `log_params` LIKE "%i:1004426037%" OR `log_params` LIKE "%i:1004425272%" OR `log_params` LIKE "%i:1004370326%" OR `log_params` LIKE "%i:1002056978%" OR `log_params` LIKE "%i:988576841%" OR `log_params` LIKE "%i: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...