Untitled query #86211

SQL

-- 1. Get all module titles
WITH all_modules AS (
    SELECT
        page_title AS module_title
    FROM
        page
    WHERE
        page_namespace = 828  -- Namespace number for "Module"
),

-- 2. Get all modules that are used (transcluded in pages)
used_modules AS (
    SELECT DISTINCT
        lt_target AS module_title
    FROM
        link_target
    JOIN
        templatelinks ON lt_id = tl_target_id
    WHERE
        tl_namespace = 828  -- Namespace number for "Module"
)

-- 3. Find unused modules
SELECT
    all_modules.module_title
FROM
    all_modules
LEFT JOIN
    used_modules
ON
    all_modules.module_title = used_modules.module_title
WHERE
    used_modules.module_title IS NULL
ORDER BY
    all_modules.module_title;
SQL

Checking query status...
