Wikipedia:WikiProject Stub sorting/Stubs catted via redirects
Intro
editThis report shows categories that link to stub templates via redirects.
Generated by 14:10, 7 March 2015 (UTC)
List
edit- {{AfroAsiatic-lang-stub}} → {{Afroasiatic-lang-stub}} is linked from categories: Category:Afro-Asiatic language stubs
- {{Au-lang-stub}} → {{Austronesian-lang-stub}} is linked from categories: Category:Austronesian language stubs
- {{Australia-bcast-stub}} → {{Australia-media-stub}} is linked from categories: Category:Australian media stubs
- {{BistriţaNăsăud-geo-stub}} → {{Bistrița-Năsăud-geo-stub}} is linked from categories: Category:Bistrița-Năsăud County geography stubs
- {{Canadian-comics-creator-stub}} → {{Canada-comics-creator-stub}} is linked from categories: Category:Comics creator stubs
- {{Canadian-comics-stub}} → {{Canada-comics-stub}} is linked from categories: Category:Comics stubs
- {{CastileLaMancha-geo-stub}} → {{CastillaLaMancha-geo-stub}} is linked from categories: Category:Spain geography stubs
- {{Constanţa-geo-stub}} → {{Constanța-geo-stub}} is linked from categories: Category:Constanța County geography stubs
- {{Dr-lang-stub}} → {{Dravidian-lang-stub}} is linked from categories: Category:Dravidian language stubs
- {{Dâmboviţa-geo-stub}} → {{Dâmbovița-geo-stub}} is linked from categories: Category:Dâmbovița County geography stubs
- {{Florida-NRHP-district-stub}} → {{Florida-NRHP-stub}} is linked from categories: Category:Southern National Register of Historic Places stubs
- {{Florida-NRHP-struct-stub}} → {{Florida-NRHP-stub}} is linked from categories: Category:Southern National Register of Historic Places stubs
- {{Galaţi-geo-stub}} → {{Galați-geo-stub}} is linked from categories: Category:Galați County geography stubs
- {{Hm-lang-stub}} → {{HmongMien-lang-stub}} is linked from categories: Category:Hmong–Mien language stubs
- {{Ia-lang-stub}} → {{IndigenousAustralian-lang-stub}} is linked from categories: Category:Indigenous Australian language stubs
- {{Ialomiţa-geo-stub}} → {{Ialomița-geo-stub}} is linked from categories: Category:Ialomița County geography stubs
- {{Ie-lang-stub}} → {{IndoEuropean-lang-stub}} is linked from categories: Category:Indo-European language stubs
- {{Ja-lang-stub}} → {{Japonic-lang-stub}} is linked from categories: Category:Japonic language stubs
- {{Javanrud-geo-stub}} → {{Jawanroud-geo-stub}} is linked from categories: Category:Javanrud County geography stubs
- {{KingsCountyNY-NRHP-stub}} → {{Brooklyn-NRHP-stub}} is linked from categories: Category:Brooklyn Registered Historic Place stubs
- {{Mehedinţi-geo-stub}} → {{Mehedinți-geo-stub}} is linked from categories: Category:Mehedinți County geography stubs
- {{NEC-lang-stub}} → {{NortheastCaucasian-lang-stub}} is linked from categories: Category:Caucasian language stubs
- {{NewYorkCountyNY-NRHP-stub}} → {{Manhattan-NRHP-stub}} is linked from categories: Category:Manhattan Registered Historic Place stubs
- {{Ns-lang-stub}} → {{NiloSaharan-lang-stub}} is linked from categories: Category:Nilo-Saharan language stubs
- {{PRChina-film-director-stub}} → {{China-film-director-stub}} is linked from categories: Category:China media stubs
- {{PRChina-journalist-stub}} → {{China-journalist-stub}} is linked from categories: Category:China media stubs
- {{Pa-lang-stub}} → {{Papuan-lang-stub}} is linked from categories: Category:Papuan language stubs
- {{Peer-stub}} → {{UK-noble-stub}} is linked from categories: Category:Peer stubs
- {{SanFranciscoCountyCA-geo-stub}} → {{SanFrancisco-geo-stub}} is linked from categories: Category:California geography stubs,Category:San Francisco Bay Area geography stubs
- {{Spirochaetes-stub}} → {{Spirochaetae-stub}} is linked from categories: Category:Spirochaetes stubs
- {{St-lang-stub}} → {{SinoTibetan-lang-stub}} is linked from categories: Category:Sino-Tibetan language stubs
- {{SummitOH-school-stub}} → {{SummitCountyOH-school-stub}} is linked from categories: Category:American school stubs
- {{Transportation-stub}} → {{Transport-stub}} is linked from categories: Category:Transport stubs
- {{Windows-game-stub}} → {{Windows-videogame-stub}} is linked from categories: Category:Computer game stubs
Rebuilding
editFirst generate the Wikipedia:WikiProject Stub sorting/Uncatted stubs report (using these instructions).
Then:
DROP TABLE IF EXISTS rep3;
CREATE TABLE rep3 AS
SELECT r2.page_title as 'redir', r1.page_title as 'stub'FROM rep1 r1
INNER JOIN rep1 r2 ON r1.page_title = r2.redir
WHERE r1.page_is_redirect = 0
AND r2.page_is_redirect = 1
AND r2.cats > 0;
SELECT concat( '* {{tl|', redir, '}} → {{tl|', stub, '}} is linked from categories: ', group_concat( concat( '{{cl|', page_title, '}}' ) ) )
FROM rep2
INNER JOIN enwiki_p.pagelinks ON pl_from = page_id
INNER JOIN rep3 ON pl_namespace = 10 and pl_title = redir
GROUP BY redir, stub;