بحاجة لP910

SQL

use enwiki_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
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 "P360"
     and wikidatawiki_p.page.page_is_redirect = 0
     and wikidatawiki_p.page.page_namespace = 0
    ) = 0;
SQL

Checking query status...
