SQL
AخA
use wikidatawiki_p;
select CONCAT("Q",ips_item_id), CONCAT("Lar"), CONCAT('"',ips_site_page,'"')
from wb_items_per_site
where ips_site_id='arwiki'
and ips_item_id not in
(
SELECT wbit_item_id
FROM wbt_item_terms
INNER JOIN wbt_term_in_lang tt
ON wbit_term_in_lang_id = tt.wbtl_id
INNER JOIN wbt_text_in_lang dd
ON tt.wbtl_text_in_lang_id = dd.wbxl_id
INNER JOIN wbt_text yy
ON dd.wbxl_text_id = yy.wbx_id
WHERE wbit_item_id = ips_item_id
and dd.wbxl_language = "ar"
and tt.wbtl_type_id = 1
)
group by ips_item_id
limit 50
;
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.