Untitled query #54339

SQL

SELECT concat('File:', p.page_title) AS fqp
    FROM page p
LEFT JOIN templatelinks
    ON tl_title IN ('Uncategorized', 'Uncategorized-Geograph', 'Check_categories', 'Uncategorized-PIB', 'Uncategorized-Polona')
    AND tl_namespace = 10
    AND page_id = tl_from
LEFT JOIN categorylinks
    ON page_id = cl_from
    AND (
        SELECT page_id AS id
        FROM page ppp
        WHERE ppp.page_namespace = 14
            AND ppp.page_title = cl_to
    ) NOT IN (
        SELECT DISTINCT pp_page
        FROM page_props
        WHERE pp_propname IN ('hiddencat')
    )
WHERE p.page_namespace = 6
    AND cl_from IS NULL
    AND tl_from IS NULL
    AND page_is_redirect = 0
    -- group by p.page_id
    -- order by p.page_latest asc
LIMIT 4000
SQL

Checking query status...
