some ruwiki templates with redlinks

Fork of rowiki templates with links to disambiguations by XXN

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

https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%97%D0%B0%D0%BF%D1%80%D0%BE%D1%81%D1%8B_%D0%BA_%D0%B1%D0%BE%D1%82%D0%BE%D0%B2%D0%BE%D0%B4%D0%B0%D0%BC#.D0.A1.D0.B1.D0.BE.D1.80_.D0.BA.D1.80.D0.B0.D1.81.D0.BD.D1.8B.D1.85_.D1.81.D1.81.D1.8B.D0.BB.D0.BE.D0.BA

SQL

use ruwiki_p;
#SELECT	CONCAT("*[[Template:", page_title, "]]") as template,
COUNT(pl_title) as number_of_links,
CONCAT("[[", GROUP_CONCAT(pl_title ORDER BY pl_title ASC SEPARATOR "]], [["), "]]") as links
FROM pagelinks
JOIN page ON page_namespace = 10 AND page.page_id = pagelinks.pl_from
JOIN categorylinks ON page_id=cl_from 
WHERE pl_from_namespace = 10
AND pl_namespace = 0 AND cl_to = "Шаблоны:Таксономия"
AND pl_title not IN (
  SELECT page_title
  FROM page
  WHERE page_namespace = 0
)
GROUP BY page_title
ORDER BY number_of_links DESC, page_title ASC

SQL

Checking query status...