Untitled query #12116

SQL

USE arwiki_p;
SELECT /* SLOW_OK */  concat("ملف:",page_title) , page_id
FROM page
WHERE page_namespace = 6       -- files only
AND page_is_redirect = 0       -- no redirects
AND NOT page_title LIKE "%/%"  -- no sub-pages
AND NOT exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_namespace IN (10, 2)
    AND tl_title IN ("تعليل_استعمال_غير_حر") -- find files that do not have a license and do not wait for deletion
	limit 1 
)
AND NOT exists ( -- find files that are not in "No license" categories
    SELECT *
    FROM categorylinks
    WHERE cl_from=page_id 
	AND cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")
	limit 1 
)
SQL

Checking query status...
