Wikipedia:WikiProject Stub sorting/Uncatted stubs
Intro
Templates that are not redirects and that have titles ending in '-stub' that are not linked to from any category page that transcludes {{tl|stub category}}, {{tl|regional stub category}} or {{tl|parent-only stub category}}. Links from redirects to the template are counted also. Only those templates with more than 50 transclusions (directly or via redirect) are listed.
Generated by TB (talk) 14:08, 7 March 2015 (UTC)
Note: Manual update completed February 24, 2022
List
- {{tl|1950s-horror-film-stub}} - 27 transclusions
- {{tl|1950s-Malayalam-film-stub}} - 44 transclusions
- {{tl|Agonidium-stub}} - 50 transclusions
- {{tl|AlbDonau-geo-stub}} - 37 transclusions
- {{tl|Algeria-airport-stub}} - 57 transclusions
- {{tl|AlleganyCountyMD-NRHP-stub}} - 39 transclusions
- {{tl|AlleghanyCountyVA-geo-stub}} - 32 transclusions
- {{tl|AmeliaCountyVA-geo-stub}} - 10 transclusions
- {{tl|Ansbachdistrict-geo-stub}} - 49 transclusions
- {{tl|ArmstrongCountyPA-geo-stub}} - 51 transclusions
- {{tl|BakerCountyOR-geo-stub}} - 43 transclusions
- {{tl|BanjaLuka-geo-stub}} - 56 transclusions
- {{tl|BarryCountyMO-geo-stub}} - 57 transclusions
- {{tl|BentonCountyWA-geo-stub}} - 21 transclusions
- {{tl|BerkeleyCountyWV-geo-stub}} - 48 transclusions
- {{tl|Beylagan-geo-stub}} - 48 transclusions
- {{tl|Bileća-geo-stub}} - 50 transclusions
- {{tl|Bistonini-stub}} - 52 transclusions
- {{tl|Boeny-geo-stub}} - 50 transclusions
- {{tl|BolivarCO-geo-stub}} - 40 transclusions
- {{tl|BraxtonCountyWV-geo-stub}} - 49 transclusions
- {{tl|BrčkoDistrict-geo-stub}} - 52 transclusions
- {{tl|BroomeCountyNY-NRHP-stub}} - 57 transclusions
- {{tl|Bucharest-metro-stub}} - 43 transclusions
- {{tl|BucksCountyPA-geo-stub}} - 44 transclusions
- {{tl|ButlerCountyOH-NRHP-stub}} - 51 transclusions
- {{tl|Callidulidae-stub}} - 49 transclusions
- {{tl|Canada-hotel-stub}} - 26 transclusions
- {{tl|CarrollCountyMD-NRHP-stub}} - 57 transclusions
- {{tl|CattaraugusCountyNY-NRHP-stub}} - 33 transclusions
- {{tl|CecilCountyMD-NRHP-stub}} - 39 transclusions
- {{tl|Cham-geo-stub}} - 33 transclusions
- {{tl|CharlesCityCountyVA-geo-stub}} - 26 transclusions
- {{tl|ChautauquaCountyNY-NRHP-stub}} - 38 transclusions
- {{tl|ChelanCountyWA-geo-stub}} - 56 transclusions
- {{tl|ChemungCountyNY-NRHP-stub}} - 34 transclusions
- {{tl|Cherkasy-geo-stub}} - 9 transclusions
- {{tl|ClatsopCountyOR-geo-stub}} - 33 transclusions
- {{tl|ClayCountyIN-geo-stub}} - 43 transclusions
- {{tl|ClayCountyWV-geo-stub}} - 53 transclusions
- {{tl|CoosCountyOR-geo-stub}} - 46 transclusions
- {{tl|CórdobaCO-geo-stub}} - 29 transclusions
- {{tl|CowlitzCountyWA-geo-stub}} - 36 transclusions
- {{tl|CravenCountyNC-NRHP-stub}} - 49 transclusions
- {{tl|CurryCountyOR-geo-stub}} - 35 transclusions
- {{tl|CuyahogaCountyOH-NRHP-stub}} - 42 transclusions
- {{tl|DavidsonCountyNC-NRHP-stub}} - 56 transclusions
- {{tl|DavisCoast-geo-stub}} - 56 transclusions
- {{tl|Derventa-geo-stub}} - 54 transclusions
- {{tl|Dichelopa-stub}} - 51 transclusions
- {{tl|Diepholz-geo-stub}} - 51 transclusions
- {{tl|Dnipropetrovsk-geo-stub}} - 17 transclusions
- {{tl|DoddridgeCountyWV-geo-stub}} - 30 transclusions
- {{tl|DouglasCountyOR-geo-stub}} - 54 transclusions
- {{tl|DouglasCountyWI-geo-stub}} - 53 transclusions
- {{tl|Dzierżoniów-geo-stub}} - 53 transclusions
- {{tl|Eichstätt-geo-stub}} - 31 transclusions
- {{tl|ElkhartCountyIN-geo-stub}} - 29 transclusions
- {{tl|ElOued-geo-stub}} - 51 transclusions
- {{tl|Erzgebirgskreis-geo-stub}} - 54 transclusions
- {{tl|Euzophera-stub}} - 54 transclusions
- {{tl|FayetteCountyTX-geo-stub}} - 29 transclusions
- {{tl|Finland-airport-stub}} - 54 transclusions
- {{tl|Florești-geo-stub}} - 39 transclusions
- {{tl|FluvannaCountyVA-geo-stub}} - 27 transclusions
- {{tl|FondduLacCountyWI-geo-stub}} - 57 transclusions
- {{tl|Forchheim-geo-stub}} - 23 transclusions
- {{tl|Germany-musicologist-stub}} - 52 transclusions
- {{tl|GilmerCountyWV-geo-stub}} - 27 transclusions
- {{tl|Glarus-geo-stub}} - 54 transclusions
- {{tl|GrantCountyIN-geo-stub}} - 33 transclusions
- {{tl|GrantCountyWV-geo-stub}} - 38 transclusions
- {{tl|GranvilleCountyNC-NRHP-stub}} - 53 transclusions
- {{tl|Günzburg-geo-stub}} - 29 transclusions
- {{tl|Harburg-geo-stub}} - 49 transclusions
- {{tl|HarrisCountyTX-geo-stub}} - 42 transclusions
- {{tl|HerkimerCountyNY-NRHP-stub}} - 59 transclusions
- {{tl|Hyōgo-university-stub}} - 49 transclusions
- {{tl|Hypotia-stub}} - 54 transclusions
- {{tl|Ica-geo-stub}} - 52 transclusions
- {{tl|IlmKreis-geo-stub}} - 49 transclusions
- {{tl|Iran-road-stub}} - 57 transclusions
- {{tl|Italy-footy-midfielder-1930s-stub}} - 59 transclusions
- {{tl|IvoryCoast-airport-stub}} - 26 transclusions
- {{tl|IvoryCoast-footyclub-stub}} - 30 transclusions
- {{tl|JacksonCountyIN-geo-stub}} - 32 transclusions
- {{tl|Jacksonville-NRHP-stub}} - 27 transclusions
- {{tl|Japan-spacecraft-stub}} - 42 transclusions
- {{tl|JeffersonCountyWA-geo-stub}} - 39 transclusions
- {{tl|Kenya-footyclub-stub}} - 55 transclusions
- {{tl|Khizi-geo-stub}} - 54 transclusions
- {{tl|Khojaly-geo-stub}} - 32 transclusions
- {{tl|KingWilliamCountyVA-geo-stub}} - 37 transclusions
- {{tl|Kitzingen-geo-stub}} - 27 transclusions
- {{tl|KlamathCountyOR-geo-stub}} - 52 transclusions
- {{tl|Kostel-geo-stub}} - 54 transclusions
- {{tl|KozarskaDubica-geo-stub}} - 54 transclusions
- {{tl|Kranj-geo-stub}} - 50 transclusions
- {{tl|Kyffhäuserkreis-geo-stub}} - 56 transclusions
- {{tl|Kyrgyzstan-footyclub-stub}} - 56 transclusions
- {{tl|Landsberg-geo-stub}} - 29 transclusions
- {{tl|LeeCountyVA-geo-stub}} - 43 transclusions
- {{tl|LehighCountyPA-geo-stub}} - 41 transclusions
- {{tl|LewisCountyWA-geo-stub}} - 49 transclusions
- {{tl|LewisCountyWV-geo-stub}} - 49 transclusions
- {{tl|LinnCountyOR-geo-stub}} - 39 transclusions
- {{tl|LuzerneCountyPA-geo-stub}} - 41 transclusions
- {{tl|Maglaj-geo-stub}} - 17 transclusions
- {{tl|MalheurCountyOR-geo-stub}} - 33 transclusions
- {{tl|ManitowocCountyWI-geo-stub}} - 49 transclusions
- {{tl|MarinetteCountyWI-geo-stub}} - 34 transclusions
- {{tl|MarionCountyOR-geo-stub}} - 37 transclusions
- {{tl|MarionCountyWV-geo-stub}} - 43 transclusions
- {{tl|MasonCountyWV-geo-stub}} - 42 transclusions
- {{tl|Massachusetts-university-stub}} - 46 transclusions
- {{tl|MathewsCountyVA-geo-stub}} - 47 transclusions
- {{tl|McLeanCountyIL-geo-stub}} - 51 transclusions
- {{tl|Metlika-geo-stub}} - 53 transclusions
- {{tl|MonroeCountyWV-geo-stub}} - 48 transclusions
- {{tl|Montana-geologic-formation-stub}} - 57 transclusions
- {{tl|MontgomeryCountyMD-NRHP-stub}} - 58 transclusions
- {{tl|MorganCountyIN-geo-stub}} - 54 transclusions
- {{tl|Mühldorf-geo-stub}} - 29 transclusions
- {{tl|NewKentCountyVA-geo-stub}} - 25 transclusions
- {{tl|NewSouthWales-airport-stub}} - 54 transclusions
- {{tl|NicholasCountyWV-geo-stub}} - 54 transclusions
- {{tl|Norway-footy-competition-stub}} - 40 transclusions
- {{tl|Norway-politician-1810s-stub}} - 54 transclusions
- {{tl|NoviGrad-geo-stub}} - 46 transclusions
- {{tl|NovoGoražde-geo-stub}} - 57 transclusions
- {{tl|Oceania-hotel-stub}} - 28 transclusions
- {{tl|OcontoCountyWI-geo-stub}} - 32 transclusions
- {{tl|OgleCountyIL-geo-stub}} - 40 transclusions
- {{tl|OkanoganCountyWA-geo-stub}} - 37 transclusions
- {{tl|Ontario-road-stub}} - 30 transclusions
- {{tl|Ophidiidae-stub}} - 76 transclusions
- {{tl|Ormož-geo-stub}} - 59 transclusions
- {{tl|OumelBouaghi-geo-stub}} - 40 transclusions
- {{tl|Pakistan-road-stub}} - 56 transclusions
- {{tl|PendletonCountyWV-geo-stub}} - 44 transclusions
- {{tl|Peru-sports-venue-stub}} - 53 transclusions
- {{tl|Phasianellidae-stub}} - 49 transclusions
- {{tl|PinellasCountyFL-NRHP-stub}} - 55 transclusions
- {{tl|PleasantsCountyWV-geo-stub}} - 34 transclusions
- {{tl|PodunavljeRS-geo-stub}} - 51 transclusions
- {{tl|Poland-sculptor-stub}} - 56 transclusions
- {{tl|Polyceridae-stub}} - 44 transclusions
- {{tl|Pomatiidae-stub}} - 55 transclusions
- {{tl|PRChina-prison-stub}} - 32 transclusions
- {{tl|PulaskiCountyVA-geo-stub}} - 30 transclusions
- {{tl|PutnamCountyWV-geo-stub}} - 26 transclusions
- {{tl|RamabaiNagar-geo-stub}} - 26 transclusions
- {{tl|RandolphCountyIL-geo-stub}} - 51 transclusions
- {{tl|Relizane-geo-stub}} - 52 transclusions
- {{tl|RitchieCountyWV-geo-stub}} - 46 transclusions
- {{tl|RoaneCountyWV-geo-stub}} - 57 transclusions
- {{tl|Rogatica-geo-stub}} - 55 transclusions
- {{tl|Russia-conductor-stub}} - 54 transclusions
- {{tl|SaalfeldRudolstadt-geo-stub}} - 54 transclusions
- {{tl|SaintPetersburg-metro-stub}} - 55 transclusions
- {{tl|SaintThomasVI-geo-stub}} - 57 transclusions
- {{tl|Schwandorf-geo-stub}} - 31 transclusions
- {{tl|Scotland-newspaper-stub}} - 52 transclusions
- {{tl|Senegal-party-stub}} - 56 transclusions
- {{tl|Šentjernej-geo-stub}} - 57 transclusions
- {{tl|ShawanoCountyWI-geo-stub}} - 33 transclusions
- {{tl|Siazan-geo-stub}} - 47 transclusions
- {{tl|Skikda-geo-stub}} - 52 transclusions
- {{tl|SlovenskeKonjice-geo-stub}} - 57 transclusions
- {{tl|ŠmartnopriLitiji-geo-stub}} - 54 transclusions
- {{tl|Spain-palace-stub}} - 43 transclusions
- {{tl|Staphylococcaceae-stub}} - 52 transclusions
- {{tl|Star-system-stub}} - 15 transclusions
- {{tl|StarkCountyOH-school-stub}} - 27 transclusions
- {{tl|StatenIsland-NRHP-stub}} - 32 transclusions
- {{tl|Tampa-stub}} - 51 transclusions
- {{tl|TazewellCountyVA-geo-stub}} - 29 transclusions
- {{tl|Tiaret-geo-stub}} - 56 transclusions
- {{tl|TillamookCountyOR-geo-stub}} - 37 transclusions
- {{tl|Traunstein-geo-stub}} - 28 transclusions
- {{tl|TuckerCountyWV-geo-stub}} - 35 transclusions
- {{tl|TylerCountyWV-geo-stub}} - 42 transclusions
- {{tl|Ukraine-sports-venue-stub}} - 57 transclusions
- {{tl|UmatillaCountyOR-geo-stub}} - 30 transclusions
- {{tl|UnstrutHainich-geo-stub}} - 55 transclusions
- {{tl|Unterallgäu-geo-stub}} - 49 transclusions
- {{tl|Uruguay-church-stub}} - 56 transclusions
- {{tl|US-baseball-catcher-1850s-stub}} - 48 transclusions
- {{tl|US-baseball-catcher-1920s-stub}} - 45 transclusions
- {{tl|US-baseball-catcher-1950s-stub}} - 39 transclusions
- {{tl|US-business-bio-1810s-stub}} - 32 transclusions
- {{tl|US-business-bio-1860s-stub}} - 53 transclusions
- {{tl|US-business-bio-1870s-stub}} - 49 transclusions
- {{tl|US-business-bio-1880s-stub}} - 48 transclusions
- {{tl|US-screen-actor-1900s-stub}} - 28 transclusions
- {{tl|Varna-geo-stub}} - 55 transclusions
- {{tl|Virginia-geologic-formation-stub}} - 51 transclusions
- {{tl|Virginia-railstation-stub}} - 47 transclusions
- {{tl|Vojnik-geo-stub}} - 55 transclusions
- {{tl|WallisFutuna-geo-stub}} - 52 transclusions
- {{tl|WalworthCountyWI-geo-stub}} - 37 transclusions
- {{tl|Washington-sport-bio-stub}} - 20 transclusions
- {{tl|WashingtonCountyOR-geo-stub}} - 33 transclusions
- {{tl|WaukeshaCountyWI-geo-stub}} - 28 transclusions
- {{tl|WaupacaCountyWI-geo-stub}} - 36 transclusions
- {{tl|WayneCountyWV-geo-stub}} - 47 transclusions
- {{tl|WestmorelandCountyPA-geo-stub}} - 47 transclusions
- {{tl|WetzelCountyWV-geo-stub}} - 53 transclusions
- {{tl|WinnebagoCountyWI-geo-stub}} - 48 transclusions
- {{tl|WiseCountyVA-geo-stub}} - 34 transclusions
- {{tl|Wyoming-geologic-formation-stub}} - 45 transclusions
- {{tl|YakimaCountyWA-geo-stub}} - 51 transclusions
Rebuilding
Mysql transcript to aid in regenerating:
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
DROP TABLE IF EXISTS rep1;
DROP TABLE IF EXISTS rep2;
-- First, capture all potentially interesting stub templates
CREATE TABLE rep1 AS
SELECT page_title, page_is_redirect
FROM enwiki_p.page
WHERE page_namespace = 10
AND page_title LIKE '%-stub'
AND page_is_redirect = 0;
-- Add in any templates that redirect to one of these.
ALTER TABLE rep1 ADD COLUMN redir varbinary(255);
INSERT INTO rep1
SELECT p.page_title, p.page_is_redirect, r.page_title
FROM enwiki_p.page p
INNER JOIN enwiki_p.redirect ON rd_from = p.page_id
INNER JOIN rep1 r ON rd_namespace = 10 AND rd_title = r.page_title
WHERE p.page_namespace = 10
AND p.page_is_redirect = 1
AND r.page_is_redirect = 0;
-- Now count how many times each is transcluded
alter table rep1 add column trans int(8);
-- Process in chunks - repeat as necessary
UPDATE rep1
SET trans = (
SELECT count(*)
FROM enwiki_p.templatelinks
WHERE tl_namespace = 10
AND tl_title = page_title )
WHERE trans IS NULL
LIMIT 5000;
alter table rep1 add index( redir );
-- Now we need to credit transclusions of redirects to
-- the targets of those redirects
UPDATE rep1 r1
INNER JOIN rep1 r2 ON r1.page_title = r2.redir
SET r1.trans = r1.trans + r2.trans
WHERE r1.page_is_redirect = 0
AND r2.page_is_redirect = 1;
-- Now find categories of interest
CREATE table rep2 AS
SELECT page_id, page_title
FROM enwiki_p.page
INNER JOIN enwiki_p.templatelinks ON tl_from = page_id
WHERE tl_namespace = 10
AND tl_title = "Stub_category"
AND page_namespace = 14;
REPLACE INTO rep2
SELECT page_id, page_title
FROM enwiki_p.page
INNER JOIN enwiki_p.templatelinks ON tl_from = page_id
WHERE tl_namespace = 10
AND tl_title = "Parent-only_stub_category"
AND page_namespace = 14;
REPLACE INTO rep2
SELECT page_id, page_title
FROM enwiki_p.page
INNER JOIN enwiki_p.templatelinks ON tl_from = page_id
WHERE tl_namespace = 10
AND tl_title = "Regional_stub_category"
AND page_namespace = 14;
-- Index these
ALTER TABLE rep2 ADD INDEX( page_id );
ALTER TABLE rep1 ADD INDEX ( page_title );
-- Now count how many time each interesting template is linked from an interesting category
ALTER TABLE rep1 ADD COLUMN cats int(8);
-- Process in chunks - repeat as necessary
UPDATE rep1 r1
SET cats = (
SELECT count(*)
FROM enwiki_p.pagelinks l
INNER JOIN rep2 r2 ON l.pl_from = r2.page_id
WHERE l.pl_namespace = 10
AND l.pl_title = r1.page_title )
WHERE Cats IS NULL
LIMIT 5000;
-- Now we need to credit any category links to redirects to
-- the targets of those redirects
UPDATE rep1 r1
INNER JOIN rep1 r2 ON r1.page_title = r2.redir
SET r1.cats = r1.cats + r2.cats
WHERE r1.page_is_redirect = 0
AND r2.page_is_redirect = 1;
-- Test the results
SELECT count(*) FROM rep1 WHERE page_is_redirect = 0 AND cats = 0 AND trans >= 60;
-- Generate some output
SELECT CONCAT( '*{{tl|', rep1.page_title, '}} - ', trans, ' transclusions' )
FROM rep1
WHERE page_is_redirect = 0
AND cats = 0
AND trans >= 50;