use lvwiki_p;

SELECT #enp.page_title, enel.el_index

enp.page_title, pp.pp_value, enel.el_index

FROM page enp

JOIN externallinks as enel on enel.el_from = enp.page_id

LEFT JOIN page_props pp ON pp.pp_page = enp.page_id

WHERE enp.page_namespace = 0 AND pp.pp_propname = 'wikibase_item'

        AND enel.el_index LIKE 'http://com.sports-reference.www./olympics/athletes/%'

AND pp.pp_value IS NULL and enp.page_title ="Jevgeņijs_Kafeļņikovs"

order by enp.page_title desc