use enwiki_p;

SELECT enp.page_title, cla.cl_to#enel.el_index#enp.page_title, pp_value, enel.el_index

FROM page enp, page_props#, wikidatawiki_p.page wdp

#LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P1344' AND wdpl.pl_namespace = 120

#JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'P1447' AND wdpl2.pl_namespace = 120

join categorylinks cla on cla.cl_from=enp.page_id and cla.cl_type="page" and LOCATE('Olympics', cla.cl_to)>0)

WHERE enp.page_namespace = 0

and exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id# AND wdpl.pl_from IS NULL

                     AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P1447')

​

and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id# AND wdpl.pl_from IS NULL

                     AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P27')

AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'

#AND wdp.page_title = pp_value AND wdp.page_namespace = 0

#group by enp.page_title

#having count(enel.el_index)=1

limit 50000;