use arwiki_p;

select p.page_title

#select CONCAT('[[',p.page_title,']]')

#select CONCAT('[[تصنيف:',p.page_title,']]')

FROM page as p, page_props as pp, wikidatawiki_p.page as wdp

WHERE p.page_namespace = 0

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P214')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P1309')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P244')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P213')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P496')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P227')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P906')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P269')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P268')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P651')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P1053')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P1015')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P245')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P902')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P886')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P434')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P549')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P409')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P349')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P1048')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P691')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P640')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P396')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P947')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P428')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P1222')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P1223')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P1157')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P950')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P271')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P1362')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P781')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (  wdpl.pl_title = 'P1248')  )

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND ( wdpl.pl_title = 'P650')  )

and p.page_id  in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="ضبط_استنادي")

​

AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0

GROUP BY p.page_title

#order by ll_from

#LIMIT 2000;