Fork of
Transclusions of deleted templates
by Frietjes
This query is marked as a draft
This query has been published
by Plastikspork.
SQL
AخA
SELECT
CONVERT(tl_title USING utf8),
COUNT(DISTINCT tl_from)
FROM templatelinks
LEFT JOIN page AS p1
ON p1.page_namespace = tl_namespace
AND p1.page_title = tl_title
JOIN logging
ON tl_namespace = log_namespace
AND tl_title = log_title
AND log_type = 'delete'
JOIN page AS p2
ON tl_from = p2.page_id
WHERE p1.page_id IS NULL
AND tl_namespace = 10
GROUP BY tl_title
ORDER BY COUNT(DISTINCT tl_from) DESC
LIMIT 5000;
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.