rowiki templates with links to disambiguations

Fork of Ukwiki templates with links to disambiguations by Base

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

SQL

SELECT	CONCAT("*[[Format:", 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 rowiki_p.pagelinks
JOIN rowiki_p.page ON page_namespace = 10 AND ukwiki_p.page.page_id = ukwiki_p.pagelinks.pl_from
WHERE pl_from_namespace = 10
AND pl_namespace = 0
AND pl_title IN (
  SELECT page_title
  FROM rowiki_p.page_props
  JOIN rowiki_p.page ON ukwiki_p.page.page_id = ukwiki_p.page_props.pp_page
  WHERE rowiki_p.page_props.pp_propname = "disambiguation"
  AND page_namespace = 0
)
GROUP BY page_title
ORDER BY number_of_links DESC, page_title ASC

SQL

Checking query status...