Untitled query #47754

SQL

USE trwiki_p;

SELECT
	/*page_en.page_title AS yonlendirme,
    wdata2.ips_site_page AS hedef,*/
    CONCAT(page_en.page_title, '::',  wdata2.ips_site_page)
FROM
	enwiki_p.page page_en
    INNER JOIN enwiki_p.redirect rd
    ON rd.rd_from = page_en.page_id
    AND rd.rd_namespace = 0
    INNER JOIN wikidatawiki_p.wb_items_per_site wdata1
	ON wdata1.ips_site_id = 'enwiki'
	AND wdata1.ips_site_page = REPLACE(rd.rd_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'
WHERE
	page_en.page_namespace = 0
    AND page_en.page_is_redirect = 1
    AND EXISTS
    (SELECT 1 FROM enwiki_p.categorylinks en_cl
    WHERE en_cl.cl_from = page_en.page_id
    AND en_cl.cl_to = 'Redirects_from_molecular_formulas')
	AND NOT EXISTS
    (SELECT 1 FROM page p
    WHERE p.page_namespace = 0
    AND p.page_title = page_en.page_title)
SQL

Checking query status...
