Untitled query #64880

SQL

        SELECT DISTINCT page_namespace, page_title
        FROM page
        JOIN revision ON rev_id = page_latest
        WHERE page_namespace = 118
        AND page_is_redirect = 0
        AND rev_timestamp < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
    
        UNION
        
        SELECT DISTINCT page_namespace, page_title
        FROM page
        JOIN revision ON rev_id = page_latest
        JOIN templatelinks ON tl_from = page_id 
        WHERE page_namespace = 2
        AND tl_title = "AfC_submission" 
        AND tl_namespace = 10
        AND page_is_redirect = 0
        AND rev_timestamp < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
SQL

Checking query status...
