Fork of Pages, that don't have arabic label at Wikidata daily (NEW) 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",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.

Checking query status...