Untitled query #21415

Fork of Ruwiki templates with links to disambiguations by Estopedist1

This query is marked as a draft This query has been published by Estopedist1.

SQL

SELECT	CONCAT("{{tl|", page_title, "}}") as template_name,
COUNT(pl_title) as number_of_links,
CONCAT("[[", GROUP_CONCAT(pl_title ORDER BY pl_title ASC SEPARATOR "]], [["), "]]") as links
FROM etwiki_p.pagelinks
JOIN etwiki_p.page ON page_namespace = 10 AND etwiki_p.page.page_id = etwiki_p.pagelinks.pl_from
WHERE pl_from_namespace = 10
AND pl_namespace = 0

AND pl_title IN (
  SELECT page_title
  FROM page
  WHERE page_is_redirect = 1
  AND page_namespace = 0)
  
GROUP BY page_title
ORDER BY number_of_links DESC, page_title ASC
LIMIT 10;

SQL

Checking query status...