File pages without files and links

SQL

use arwiki_p;
select DISTINCT concat ("ملف:",page_title) from page
where page_namespace = 6
and not page.page_title in (select img_name from image)
And Not page.page_title in (select il_to from imagelinks)
And Not page.page_id in (select tl_from from templatelinks  where tl_title = 'استعمال_مقيد')
And Not page.page_id in (select tl_from from templatelinks  where tl_title = 'صورة_مختارة')
and page_title not in (select commonswiki_p.page_title from commonswiki_p
                       where commonswiki_p.page_title = page_title
                       and commonswiki_p.page_namespace = 6);
SQL

Checking query status...
