User:Nickj/redirect-cleanup.sql

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)"; 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 %"; 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 "__"; delete from redirect_candidate where label = dest;
 * 1) delete specific redirects that sucked:
 * 1) don't link to:
 * 1) don't link from:
 * 1) double-check never suggest links to self: