Untitled query #5007

SQL

USE commonswiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
AND NOT page_title LIKE "%/%"
AND NOT page_id IN (
    SELECT tl_from
    FROM templatelinks
    WHERE tl_namespace=10
    AND tl_title IN ("License_template_tag","GNU-Layout","No_license","Delete","Speedydelete","Remove_this_line_and_insert_a_license_instead", "No_source_since", "No_permission_since", "No_license_since", "Copyvio", "OTRS_received")
)
AND NOT page_id IN (
    SELECT cl_from
    FROM categorylinks
    WHERE cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")
)
;
SQL

Checking query status...
