Untitled query #4740

SQL

USE wikidatawiki_p;
SELECT *
	FROM (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cswiki" AND ips_site_page LIKE "Kategorie:%") AS ips1
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cswiki" AND ips_site_page LIKE "Kategorie:%") AS ips2
		ON SUBSTRING_INDEX(ips2.ips_site_page, " ", -1) = SUBSTRING_INDEX(ips1.ips_site_page, " ", -1)
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "skwiki") AS ips3
		ON ips3.ips_item_id = ips2.ips_item_id
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "skwiki" AND ips_site_page LIKE "Kategória:%") AS ips4
		ON SUBSTRING_INDEX(ips4.ips_site_page, " ", -1) = SUBSTRING_INDEX(ips3.ips_site_page, " ", -1)
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "skwiki" AND ips_site_page LIKE "Kategória:%") AS ips5
		ON SUBSTRING_INDEX(SUBSTRING_INDEX(ips5.ips_site_page, ":", -1), " ", 1)
			= SUBSTRING_INDEX(SUBSTRING_INDEX(ips4.ips_site_page, ":", -1), " ", 1)
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cswiki") AS ips6
		ON ips6.ips_item_id = ips5.ips_item_page
		AND SUBSTRING_INDEX(SUBSTRING_INDEX(ips6.ips_site_page, ":", -1), " ", 1)
		= SUBSTRING_INDEX(SUBSTRING_INDEX(ips1.ips_site_page, ":", -1), " ", 1)
LIMIT 50;
SQL

Checking query status...
