Untitled query #38371

SQL

USE trwiki_p;

SELECT
	en_page.page_title en_baslik,
    tr_page.page_title tr_baslik,
    (CASE WHEN tr_cl.cl_to IS NULL THEN '-' ELSE 'Mevcut' END) tr_kategori
FROM
	enwiki_p.page en_page
	INNER JOIN enwiki_p.categorylinks en_cl
	ON en_cl.cl_from = en_page.page_id
	AND en_cl.cl_to = 'Medalists_at_the_2018_Winter_Olympics'
	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, '_', ' ')
	INNER JOIN wikidatawiki_p.wb_items_per_site wdata2
	ON wdata1.ips_item_id = wdata2.ips_item_id
	AND wdata2.ips_site_id = 'trwiki'
	INNER 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 = '2018_Kış_Olimpiyatları_nda_madalya_kazanan_sporcular'
	AND tr_cl.cl_from = tr_page.page_id
WHERE
	en_page.page_namespace = 0
	AND en_page.page_is_redirect = 0
ORDER BY
	en_page.page_title
SQL

Checking query status...
