enwiki-trwiki category populator

SQL

USE trwiki;

SELECT
	en_page.page_title en_title,
	tr_page.page_title tr_title
FROM
	enwiki_p.page en_page
	INNER JOIN wikidatawiki_p.wb_items_per_site wdata3
	ON wdata3.ips_site_id = 'trwiki'
	AND wdata3.ips_site_page = 'Kategori:1984 Yaz Olimpiyatları voleybolcuları'
	INNER JOIN wikidatawiki_p.wb_items_per_site wdata4
	ON wdata3.ips_item_id = wdata4.ips_item_id
	AND wdata4.ips_site_id = 'enwiki'
	INNER JOIN enwiki_p.categorylinks en_cl
	ON en_cl.cl_from = en_page.page_id
	AND en_cl.cl_to = REPLACE(REPLACE(wdata4.ips_site_page, 'Category:', ''), ' ', '_')
	INNER JOIN wikidatawiki_p.wb_items_per_site wdata1
	ON wdata1.ips_site_id = 'enwiki'
	AND wdata1.ips_site_page = REPLACE(en_page.page_title, '_', ' ')
	LEFT JOIN wikidatawiki_p.wb_items_per_site wdata2
	ON wdata1.ips_item_id = wdata2.ips_item_id
	AND wdata2.ips_site_id = 'trwiki'
	LEFT JOIN page tr_page
	ON tr_page.page_namespace = 0
	AND tr_page.page_title = REPLACE(wdata2.ips_site_page, ' ', '_')
	LEFT JOIN categorylinks tr_cl
	ON tr_cl.cl_to = REPLACE(REPLACE(wdata3.ips_site_page, 'Kategori:', ''), ' ', '_')
	AND tr_cl.cl_from = tr_page.page_id
WHERE
	en_page.page_namespace = 0
	AND en_page.page_is_redirect = 0
	AND tr_cl.cl_to IS NULL
	AND tr_page.page_title IS NOT NULL
ORDER BY
	en_page.page_title
SQL

Checking query status...
