Untitled query #80833

SQL

SELECT 
    COUNT(DISTINCT p.page_title) AS count,
    REPLACE(linktarget.lt_title, "_", " ") AS template
FROM page AS p
JOIN templatelinks ON p.page_id = templatelinks.tl_from
JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
JOIN logging ON linktarget.lt_title = logging.log_title
WHERE p.page_is_redirect = 0
AND p.page_namespace = 10
AND lt_namespace = 10
AND log_namespace = 10
AND log_type = "delete"
AND linktarget.lt_title NOT IN (
SELECT page_title
FROM page
WHERE page_namespace = 10
)
GROUP BY linktarget.lt_title
ORDER BY COUNT(DISTINCT p.page_title) DESC
SQL

Checking query status...
