Untitled query #87890

SQL

SELECT DISTINCT
    p.page_id,
    p.page_title,
    p.page_len,
    p.page_touched
FROM 
    page p
WHERE 
    -- Filter for main namespace (0 is the main article namespace)
    p.page_namespace = 0
    -- Exclude redirects
    AND p.page_is_redirect = 0
    -- Check that the page doesn't have content translation or section translation tags
    AND NOT EXISTS (
        SELECT 1
        FROM change_tag ct
        JOIN change_tag_def ctd ON ct.ct_tag_id = ctd.ctd_id
        JOIN revision r ON ct.ct_rev_id = r.rev_id
        WHERE 
            r.rev_page = p.page_id
            AND ctd.ctd_name IN ('contenttranslation', 'sectiontranslation')
    )
    -- Ensure the page exists (not deleted)
    AND p.page_len > 0
ORDER BY 
    p.page_len DESC
LIMIT 1000;
SQL

Checking query status...
