Jump to content

Wikipedia:WikiProject Stub sorting/missing stubs

Add links
From Wikipedia, the free encyclopedia
< Wikipedia:WikiProject Stub sorting
This is an old revision of this page, as edited by Od Mishehu (talk | contribs) at 03:39, 10 August 2014 (rm more handled). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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;
Retrieved from "https://en.wikipedia.org/w/index.php?title=Wikipedia:WikiProject_Stub_sorting/missing_stubs&oldid=620590927"