Items with P1447, but without P27 [to fix]

SQL

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('Olympics', 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 = 'P106' AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0 AND wdpl.pl_from IS NULL
limit 50000;

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

Checking query status...
