Untitled query #86330

SQL

SELECT 
    CONCAT('# [[Template:', tl_title, ']] (', COUNT(*), ' collegamenti)') AS template_info
FROM 
    templatelinks
LEFT JOIN 
    page ON page.page_namespace = templatelinks.tl_namespace 
           AND page.page_title = templatelinks.tl_title
WHERE 
    page.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 = 0 -- Namespace 0 per le pagine principali
    )
GROUP BY 
    templatelinks.tl_title
ORDER BY 
    COUNT(*) DESC
LIMIT 500;
SQL

Checking query status...
