SELECT p.page_id, p.page_title, cla.cl_to, pp_value

FROM page as p

JOIN page_props as pp ON pp.pp_page = p.page_id AND pp.pp_propname = 'wikibase_item'

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

JOIN wikidatawiki_p.page as wdp ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0

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

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

WHERE p.page_namespace = 0 AND wdpl.pl_from IS NULL

limit 50000;