SQL
AخA
USE cswiki_p;
SELECT CONCAT("Šablona:",page_title), CONCAT("Šablona:",rd_title),
CONCAT("https://cs.wikipedia.org/wiki/?redirect=no&curid=",page_id,"&action=delete") AS link
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%"
AND tl_from IS NULL
GROUP BY page_title
ORDER BY page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.