Untitled query #9703

SQL

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

Checking query status...
