عناوين لقوالب غير مرتبطة ولها مقابل في ويكيبيديا الإنجليزية

SQL

use enwiki_p;
select page_title 
from page 
inner join page_props
on pp_page = page_id
where page_namespace = 10
and page_is_redirect = 0
and pp_propname like "wikibase_item"
and (select replace(replace(wikidatawiki_p.wb_items_per_site.ips_site_page, "قالب:","")," ", "_")
from wikidatawiki_p.wb_items_per_site
where wikidatawiki_p.wb_items_per_site.ips_site_id like "arwiki"
and replace(wikidatawiki_p.wb_items_per_site.ips_site_page," ", "_")
and ips_item_id = replace(pp_value,"Q","")
and wikidatawiki_p.wb_items_per_site.ips_site_page like "قالب:"
) = page_title
limit 10;

SQL

Checking query status...