Items with P1447, but without P27 [to fix]

SQL

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;
SQL

Checking query status...
