SQL
AخA
use arwiki_p;
select p1.page_title, pp_value, wikidatawiki_p.page.page_id
from page p1
inner join page_props
on pp_page = p1.page_id
inner join wikidatawiki_p.page
on wikidatawiki_p.page.page_title = pp_value
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and pp_propname = "wikibase_item"
and wikidatawiki_p.page.page_id not in ( SELECT wikidatawiki_p.wbit_item_id FROM wbt_item_terms
INNER JOIN wikidatawiki_p.wbt_term_in_lang
ON wbtl_id = wbit_term_in_lang_id
INNER JOIN wikidatawiki_p.wbt_text_in_lang
ON wbxl_id = wbtl_text_in_lang_id
WHERE wbxl_language = "ar"
AND wbtl_type_id = 1)
limit 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.