Pages, that don't have arabic label at Wikidata daily (NEW)

Fork of Pages, that don't have arabic label at Wikidata daily by Mr. Ibrahem

This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

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_type oo
    #ON tt.wbtl_type_id = oo.wby_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 100
;

SQL

Checking query status...