Rarely used template redirections on trwiki

Fork of Redirected old-named infoboxes to be deleted in cswiki by Matěj Suchánek

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

SQL

USE trwiki_p;
SELECT count(distinct tl_from) as sayi,  SUM(IF(tl_from_namespace = 0, 1, 0)) AS sayi_madde, CONCAT("Şablon:",page_title) as ad, CONCAT("Şablon:",rd_title) as yonlendirme,
	CONCAT("https://tr.wikipedia.org/wiki/?redirect=no&curid=",page_id,"") AS link,
	IF(page_title IS NULL, 0, 1) AS sayfa_var
	FROM (SELECT * FROM page WHERE page_namespace = 10 AND page_is_redirect = 1) AS boxes
    JOIN redirect
		ON rd_from = page_id
	LEFT JOIN templatelinks
    	ON tl_title = page_title AND tl_namespace = page_namespace
WHERE page_title LIKE "Infobox%"
GROUP BY page_title having sayi_madde<1
ORDER BY sayi_madde,sayi
;

SQL

Checking query status...