Untitled query #20884

SQL

use wikidatawiki_p; 
select ips_item_id
	, ips_site_page
	#, (select term_text from wb_terms where i.ips_item_id = term_entity_id and term_language='ar' and term_type='label' limit 1) as 'ar'
	,  s.term_text
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='enwiki' 
and  i.ips_site_page like '%in_Ireland'
and exists (select term_text #as text 
            from wb_terms s where i.ips_item_id = s.term_entity_id and s.term_language='ar' and s.term_type='label' limit 1)
group by ips_item_id
limit 50;
SQL

Checking query status...
