Broken courtesy vanishings

This query is marked as a draft This query has been published by Cabayi.

Edits made by users who have a courtesy vanishing username.https://quarry.wmcloud.org/fork/59203
BEWARE: The edits may have been performed before their vanishing.

SQL

SELECT DISTINCT	concat("* [[Special:Contributions/", a.actor_name, "]]")
FROM	recentchanges rc,
		actor a
WHERE	a.actor_id = rc.rc_actor
AND	(	a.actor_name LIKE 'Renamed%'
     OR	a.actor_name LIKE 'Vanished%' )
ORDER BY 1

​x
 
SELECT DISTINCT concat("* [[Special:Contributions/", a.actor_name, "]]")FROM    recentchanges rc,        actor aWHERE   a.actor_id = rc.rc_actorAND (   a.actor_name LIKE 'Renamed%'     OR a.actor_name LIKE 'Vanished%' )ORDER BY 1​

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.

SQL

Checking query status...