Replicas browser and optimizer
This query is marked as a draft
This query has been published
[[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?
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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in