Untitled query #20884

SQL

use enwiki_p;
SELECT #enp.page_title
enp.page_title, pp_value , ar.term_text
FROM page enp , page_props#, wikidatawiki_p.page wdp
#where el_to like "http://www.sports-reference.com/olympics/athletes%"
#LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P1447' AND wdpl.pl_namespace = 120

LEFT JOIN wikidatawiki_p.wb_terms ar ON ar.term_entity_id = pp_value AND ar.term_type = "label"
AND ar.term_language = "ar" AND ar.term_entity_type = "item"

#LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = "label" AND term_language = "ar" AND term_entity_type = "item") AS ar
		#ON ar.term_entity_id = pp_value
WHERE enp.page_namespace = 14 
and enp.page_title like '%in_Ireland'
AND pp_page = enp.page_id 
AND pp_propname = 'wikibase_item'
and pp_value  in (select term_entity_id from wb_terms 
	where  term_type = "label" and term_language='ar' and term_entity_id= pp_value)
#AND wdp.page_title = pp_value 
#AND wdp.page_namespace = 0

/*USE enwiki_p;
SELECT page_title , p2.page_title	
FROM page
WHERE page_namespace = 14
and page_title like '%the_Republic_of_Ireland';*/
#USE enwiki_p; SELECT page_title  FROM page WHERE	page_namespace = 14	and page_title like '%in_Ireland' 
LIMIT 50;
SQL

Checking query status...
