تحويلات تحتوي على عنصر بيانات الحالة - 2

SQL

use arwiki_p;
select page_title
from page
inner join page_props
on pp_page = page_id
where page_is_redirect = 1
and page_namespace = 0
and pp_propname = "wikibase_item"
and pp_value in (select wikidatawiki_p.page.page_title from wikidatawiki_p.page where wikidatawiki_p.page.page_title 
    = pp_value
    and wikidatawiki_p.page.page_namespace = 0
    and wikidatawiki_p.page.page_content_model = "wikibase_item"
    and wikidatawiki_p.page.page_is_redirect = 0)
limit 1;

/*
and (select count(*) from wikidatawiki_p.page where wikidatawiki_p.page.page_title 
    =
    (select pp_value from page_props where pp_page = page_id and pp_propname = "wikibase_item")
    and wikidatawiki_p.page.page_namespace = 0
    and wikidatawiki_p.page.page_content_model = "wikibase_item"
    and wikidatawiki_p.page.page_is_redirect = 0
    ) = 1
*/

SQL

Checking query status...