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")

)

;