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
Cryptic
.
[[en:w:WP:VPT#Massdelete (nuke)]] circa 03 Feb 2019. First query is what Special:Nuke runs, give or take (and matches its current on-wiki output). Second query is all of Emoteplump's entries in the recentchanges table. Conspicuously absent is the creation of any other pages, though there should be six (for example, [[Portal:Government of Ukraine]] (namespace 100) at timestamp 20190129132140; his subsequent edit to it at timestamp 20190129132210 is missing, too). What gives?
Toggle Highlighting
SQL
SELECT rc_namespace,rc_title,rc_timestamp FROM recentchanges WHERE ((rc_new = 1) OR (rc_log_type = 'upload' AND rc_log_action = 'upload')) AND rc_user_text='Emoteplump' GROUP BY rc_namespace, rc_title, rc_timestamp ORDER BY rc_timestamp DESC; SELECT rc_namespace,rc_title,rc_timestamp,rc_new FROM recentchanges WHERE rc_user_text='Emoteplump';
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...