Olympics-related category export to Wikidata

use euwiki_p;
SELECT #concat('* [[',p.page_title,']]')
#concat('* [[:Kategorija:',p.page_title,']]')
ll_lang, ll.ll_title, p.page_title
from page p
join langlinks ll on p.page_id=ll.ll_from
where p.page_namespace=0
and p.page_title not like "%/%"
and p.page_is_redirect=0
#and ll_lang<>"en"
and p.page_id not in (SELECT  eu_page_id
					from wbc_entity_usage wb
					GROUP BY eu_page_id)
                    
and p.page_id in (select cl_from
																from categorylinks
																where cl_to="Ko_udalerriak")
order by p.page_title asc

SQL

use enwiki_p;
SELECT enp.page_title, pp_value, concat('S143')#, cla.cl_to
FROM page_props as pp, wikidatawiki_p.page as wdp, page enp
JOIN categorylinks cl ON cl.cl_type="page" AND cl.cl_from = enp.page_id
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
WHERE enp.page_namespace = 0
AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
AND wdp.page_title = pp_value AND wdp.page_namespace = 0 and cl.cl_to like "%Olympics"
AND wdpl.pl_from IS NULL
#group by enp.page_title
#having count(enel.el_index)=1;
limit 50;

SQL

Checking query status...