Gender inflected pages to be merged in Wikidata

SQL

USE wikidatawiki_p;
SELECT CONCAT('* ', wbA.ips_site_page, ' - [[Q', wbA.ips_item_id, ']] & [[Q', wbC.ips_item_id, ']]'), SUBSTRING_INDEX(wbA.ips_site_page, ':', -1)
	FROM wb_items_per_site AS wbA
	LEFT JOIN wb_items_per_site AS wbB
		ON (wbA.ips_item_id = wbB.ips_item_id AND NOT wbA.ips_site_id = wbB.ips_site_id)
	JOIN wb_items_per_site AS wbC
		ON (SUBSTRING_INDEX(wbC.ips_site_page, ':', -1) = SUBSTRING_INDEX(wbA.ips_site_page, ':', -1) AND NOT wbA.ips_site_id = wbC.ips_site_id)
WHERE wbA.ips_site_id = 'cswiki' AND wbA.ips_site_page LIKE 'Kategorie:%'
AND wbC.ips_site_page LIKE '%:%'
AND wbB.ips_site_id IS NULL
AND NOT EXISTS(
	SELECT * FROM wb_items_per_site AS wbD
	WHERE wbD.ips_item_id = wbC.ips_item_id
	AND wbD.ips_site_id = 'cswiki'
);
SQL

Checking query status...
