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_site_item = ips2.ips_site_item
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "skwiki" AND ips_site_page LIKE "Kategória:%") AS ips4
	#	ON ips4.ips
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "skwiki" AND ips_site_page LIKE "Kategória:%") AS ips5
LIMIT 50;
SQL

Checking query status...
