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

SQL

use arwiki_p;
select p1.page_title as "التحويلة"
,(select count(*) from langlinks where ll_from = p1.page_id) as langred
,rd_title as "الهدف"
,(select count(*) from langlinks where ll_from = p2.page_id) as langtar
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
inner join page_props pp2
on pp2.pp_page = p2.page_id
where p1.page_is_redirect = 1
and p1.page_namespace = 0
and pp1.pp_propname = "wikibase_item"
and pp2.pp_propname = "wikibase_item"
and pp1.pp_value <> pp2.pp_value
and rd_namespace = 0
and p2.page_namespace = 0
and p2.page_is_redirect = 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)*/
having langtar > 0
and langred = 0;
SQL

Checking query status...
