Untitled query #26708

SQL

SELECT d.ips_site_page, CONCAT('Q', d.ips_item_id),page_namespace
										   FROM ruwiki_p.categorylinks c
										  INNER JOIN ruwiki_p.page p ON c.cl_from = p.page_id
										  INNER JOIN wikidatawiki_p.wb_items_per_site d ON d.ips_site_page = CONCAT(CASE page_namespace WHEN 10 THEN 'Шаблон:' ELSE '' END, REPLACE(p.page_title, '_', ' ')) AND d.ips_site_id = 'ruwiki'
										  INNER JOIN wikidatawiki_p.wb_items_per_site s ON c.cl_to = REPLACE(REPLACE(s.ips_site_page, ' ', '_'), 'Категория:', '') 
										  WHERE s.ips_site_id = 'ruwiki' AND s.ips_item_id = 93506334
			                              ORDER BY p.page_title
SQL

Checking query status...
