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

*/
use frwiki_p;
SELECT enp.page_title, (select cla.cl_to
		from categorylinks cla
		where cla.cl_from=enp.page_id and cla.cl_type="page" and cla.cl_to like "%Jeux_olympiques_d'été%" limit 1)#enel.el_index#enp.page_title, pp_value, enel.el_index
FROM page enp, page_props, wikidatawiki_p.page wdp
#where el_to like "http://www.sports-reference.com/olympics/athletes%"
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 enel.el_index LIKE 'http://com.sports-reference.www./olympics/athletes/%'
		#AND enel.el_from = enp.page_id
AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
AND wdp.page_title = pp_value AND wdp.page_namespace = 0
AND wdpl.pl_from IS NULL# and enel.el_index not in (select wd2.el_index
						#							from wikidatawiki_p.externallinks wd2
						#							where wd2.el_index like "http://com.sports-reference.www./olympics/athletes%")
and enp.page_id in (select cla.cl_from
		from categorylinks cla
		where cla.cl_type="page" and cla.cl_to like "%Jeux_olympiques_d'été%")
#group by enp.page_title
#having count(enel.el_index)=1
limit 5000;

SQL

Checking query status...