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;