Wikipedia:WikiProject Stub sorting/missing stubs
Appearance
Intro
[edit]The list below shows transclusions of missing stub templates from main-namespace articles. It was generated by TB (talk) 20:47, 8 August 2014 (UTC)
NOTE: Be sure to check the articles when replacing these stubs - several of the additions of redlinked templates seem to be vandalism (e.g., deliberate replacement of valid templates with non-existent inappropriate ones), typoes, or misunderstanding the rules for stub tag names.
List
[edit]Rebuilding
[edit]N.B. - Generating this report requires a 'pageredlinks' table:
CREATE TABLE `pageredlinks` ( `prl_from` int(8) unsigned NOT NULL DEFAULT '0', `prl_namespace` int(11) NOT NULL DEFAULT '0', `prl_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `pl_from` (`prl_from`,`prl_namespace`,`prl_title`), KEY `prl_namespace` (`prl_namespace`,`prl_title`) );
- populating this table is an expensive operation, ~6 hours on the toolserver.
Mysql transcript to aid in regenerating:
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT concat( '* {{tl|', prl_title, '}} ←', group_concat( concat( ' [[', page_title, ']]' )) ) FROM pageredlinks INNER JOIN enwiki_p.page ON page_id = prl_from WHERE prl_namespace = 10 AND prl_title LIKE '%_stub' AND page_namespace = 0 GROUP BY prl_title;