Untitled query #86328

SQL

SELECT CONCAT('# [[Template:', templatelinks.tl_title, ']] (', COUNT(*), ' collegamenti)')
FROM templatelinks
LEFT JOIN page ON (page_namespace = templatelinks.tl_namespace AND page_title = templatelinks.tl_title)
WHERE page_title IS NULL -- Verifica che il template non esista
AND templatelinks.tl_namespace = 10 -- Namespace 10 per i template
AND templatelinks.tl_from IN (
    SELECT page_id 
    FROM page
    WHERE page_namespace IN (0, 6, 10, 12, 14, 100, 102)
)
GROUP BY templatelinks.tl_title
ORDER BY COUNT(*) DESC
LIMIT 500;
SQL

Checking query status...
