SQL
AخA
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 page
JOIN redirect ON rd_from = page_id
WHERE page_title LIKE "Infobox%"
AND page_namespace = 10
AND page_is_redirect = 1
AND NOT EXISTS (
SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id
WHERE lt_namespace = page_namespace AND lt_title = page_title
)
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.