مقالات لا تحتوي صور

SQL

USE arwiki_p;
select concat("[[",p.page_title,"]]") as "عنوان المقالة",
from  
page p
where  p.page_id not in (
  select pp_page from page_props where pp_propname like "page_image" and pp_page = p.page_id
)
and p.page_id not in (
  select pp_page from page_props where pp_propname like "page_image_free" and pp_page = p.page_id
)
and p.page_id not in (
  select cl_from from categorylinks where cl_from = p.page_id and cl_to = "صفحات_توضيح"
)
and p.page_id not in (select il1.il_from from imagelinks il1
                   where il1.il_from = p.page_id
                   and il1.il_from_namespace = 0
                   and il1.il_to not in (select il2.il_to from imagelinks il2 where il2.il_to = il1.il_to and il2.il_from_namespace = 10))
and p.page_namespace = 0
and p.page_is_redirect = 0;
SQL

Checking query status...
