Untitled query #43354

SQL

select now();

use wikidatawiki_p; 
select ips_item_id, ips_site_page, (select term_text from wb_terms where concat('Q',i.ips_item_id) = term_full_entity_id and term_language='en' and term_type='label' limit 1) as 'en'
from wb_items_per_site i
#join wb_terms on ips_item_id = term_entity_id and term_type = "label"
where i.ips_site_id='arwiki' and not exists
(select term_full_entity_id from wb_terms where concat('Q',i.ips_item_id) = term_full_entity_id and 
 term_type = "label" and term_language='ar' limit 1)
group by ips_item_id
limit 500;
SQL

Checking query status...
