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

SQL

use arwiki_p;
select p1.page_title as "التحويلة", rd_title as "الهدف"
,(select count(*) from langlinks where ll_from = p1.page_id) as "عدد وصلات التحويلة"
,(select count(*) from langlinks where ll_from = p2.page_id) as "عدد وصلات الهدف"
,pp1.pp_value
from page p1
inner join page_props pp1
on pp1.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 pp1.pp_propname = "wikibase_item"
and rd_namespace = 0
and pp1.pp_value in (select wikidatawiki_p.page.page_title from wikidatawiki_p.page where wikidatawiki_p.page.page_title 
    = pp1.pp_value
    and wikidatawiki_p.page.page_namespace = 0
    and wikidatawiki_p.page.page_is_redirect = 0) 
limit 10;

SQL

Checking query status...