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

SQL

use arwiki_p;
select p1.page_title as "التحويلة", rd_title as "الهدف", (select count(*) from langlinks where ll_from = p1.page_id)
from page p1
inner join page_props p1
on p1.pp_page = p1.page_id
inner join redirect
on rd_from = p1.page_id
inner join page p2
on p2.page_title = rd_title
where p1.page_is_redirect = 1
and p1.page_namespace = 0
and p1.pp_propname = "wikibase_item"
and rd_namespace = 0
and p1.pp_value in (select wikidatawiki_p.page.page_title from wikidatawiki_p.page where wikidatawiki_p.page.page_title 
    = p1.pp_value
    and wikidatawiki_p.page.page_namespace = 0
    and wikidatawiki_p.page.page_is_redirect = 0) 
limit 10;

SQL

Checking query status...