Untitled query #20884

SQL

use enwiki_p;
SELECT #enp.page_title
enp.page_title, pp_value
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

WHERE enp.page_namespace = 14 and enp.page_title like '%in_Ireland'
AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
AND wdp.page_title = pp_value AND wdp.page_namespace = 0
#AND wdpl.pl_from IS NULL

#and enp.page_id in (select cla.cl_from
#		from categorylinks cla
#		where cla.cl_type="page" and cla.cl_to like "%olimpijczycy")
#group by enp.page_title

/*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...
