Authority control template without any data local at arwiki or Properties

This query is marked as a draft This query has been published by Mr. Ibrahem.

http://quarry.wmflabs.org/query/8132    (Authority control Properties but no local template at arwiki)

قالب ضبط استنادي دون أي معرفات محلية أو في ويكي بيانات.

SQL

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 p.page_is_redirect = 0 
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;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...