Jump to content

User:Narutolovehinata5/featured article langlinks

From Wikipedia, the free encyclopedia

Overview

[edit]

This report lists featured articles in the main namespace of the English-language Wikipedia in order of ascending number of interwiki links. Onle the first 100 entries are shown. It was generated on the toolserver by TB (talk) 19:04, 8 February 2013 (UTC)

Report

[edit]

Regenerating

[edit]
SELECT concat('*[[', page_title, ']] (', if( ll_from IS NULL, 0, count(*)), ' interwiki links)')
FROM enwiki_p.templatelinks
INNER JOIN enwiki_p.page ON tl_from = page_id
LEFT OUTER JOIN enwiki_p.langlinks ON ll_from = page_id
WHERE tl_namespace = 10
AND   tl_title = 'Featured_article'
AND   page_namespace = 0
GROUP BY page_id
ORDER BY if( ll_from IS NULL, 0, count(*)) ASC
LIMIT 250;