Fork of
Untitled query #43512
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by FShbib.
SQL
AخA
use wikidatawiki_p;
select CONCAT("Q",wbit_item_id), CONCAT("Lar"), CONCAT(ips_site_page)
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 wb_items_per_site
ON wbit_item_id = ips_item_id
where tt.wbtl_type_id = 1
and ips_site_id='arwiki'
and dd.wbxl_language not in ( "ar" )
group by wbit_item_id
limit 1000
;
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.