SQL
AخA
use arwiki_p;
select page_title, pp_value from page
inner join page_props
on pp_page= page_id
where page_is_redirect = 0
and page_namespace = 0
and page_title in (select cl_to from categorylinks where cl_to = page_title)
and pp_propname = "wikibase_item"
and (select count(wikidatawiki_p.pagelinks.pl_from) from wikidatawiki_p.pagelinks
inner join wikidatawiki_p.page
on wikidatawiki_p.page.page_id = wikidatawiki_p.pagelinks.pl_from
where wikidatawiki_p.page.page_title = pp_value
and pl_title like "P910"
and wikidatawiki_p.page.page_is_redirect = 0
and wikidatawiki_p.page.page_namespace = 0
) = 0
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.