Untitled query #36947

SQL

use arwiki_p;
select p1.page_title, p2.page_title
from page p1
inner join page_props pp1
on pp1.pp_page = p1.page_id
inner join wikidatawiki_p.page wdp
on wdp.page_title = pp1.pp_value
inner join wikidatawiki_p.pagelinks wdpl
on wdpl.pl_from = wdp.page_id
inner join page_props pp2
on pp2.pp_value = wdpl.pl_title
inner join page p2
on p2.page_id = pp2.pp_page
where p1.page_namespace=0
and p1.page_is_redirect = 0
and p2.page_namespace = 100
and p2.page_is_redirect = 0
and pp1.pp_propname  = "wikibase_item"
and pp2.pp_propname  = "wikibase_item"
and wdp.page_namespace = 0
and wdp.page_is_redirect = 0
and wdpl.pl_from_namespace =0
and wdpl.pl_namespace =0
AND p1.page_id NOT IN
    (SELECT cl_from
     FROM categorylinks
     WHERE cl_to = concat("بوابة_", p2.page_title, "/مقالات_متعلقة"))
and p2.page_title not like "%/%";
SQL

Checking query status...
