Wikipedia:WikiProject Stub sorting/missing stubs

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Intro

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)[reply]

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

Rebuilding

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;