SELECT page_title

FROM categorylinks

INNER JOIN page

ON page_namespace = 6

AND page_id = cl_from

WHERE cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")

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

);