Jump to content

User:Nickj/redirect-cleanup.sql

From Wikipedia, the free encyclopedia
# delete specific redirects that sucked:
delete from redirect_candidate where label = "1. Bundesliga";
delete from redirect_candidate where label = "a massive brawl";
delete from redirect_candidate where label = "area ruled";
delete from redirect_candidate where label = "1-bbl";
delete from redirect_candidate where label = "1(IA)";

# don't link to:
delete from redirect_candidate where dest = "Orders of magnitude (mass)";
delete from redirect_candidate where dest = "Daylight saving time";
delete from redirect_candidate where dest = "1 E0 m";
delete from redirect_candidate where dest like "19% NHL season";
delete from redirect_candidate where dest like "%*%";
delete from redirect_candidate where dest like "Independence Day (movie)";
delete from redirect_candidate where dest like "_";
delete from redirect_candidate where dest like "__";
delete from redirect_candidate where dest like "List of %";

# don't link from:
delete from redirect_candidate where label = "18th Government";
delete from redirect_candidate where label = "(In detail)";
delete from redirect_candidate where label = "(ISO 3166-2)";
delete from redirect_candidate where label like "1 %";
delete from redirect_candidate where label like "As of %";
delete from redirect_candidate where label like "19__-__";
delete from redirect_candidate where label like "1___ to 1___";
delete from redirect_candidate where label like "1___-1___";
delete from redirect_candidate where label like "Book _";
delete from redirect_candidate where label like "(_-_)";
delete from redirect_candidate where label like "_";
delete * from redirect_candidate where label like "__";

# double-check never suggest links to self:
delete from redirect_candidate where label = dest;