Gender inflected pages to be merged in Wikidata

SQL

USE wikidatawiki_p;
SELECT CONCAT('* ', wbA.ips_site_page, ' - [[Q', wbA.ips_item_id, ']] & ', GROUP_CONCAT(CONCAT('[[Q',wbC.ips_item_id,']]')))
	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 (CONCAT("Autor:",wbA.ips_site_page) = wbC.ips_site_page AND NOT wbA.ips_site_id = wbC.ips_site_id)
WHERE wbA.ips_site_id = 'cswiki'
AND wbC.ips_site_id = 'cswikisource'
AND wbB.ips_site_id IS NULL
AND NOT EXISTS(
	SELECT * FROM wb_items_per_site AS wbD
	WHERE wbC.ips_item_id = wbD.ips_item_id
	AND wbD.ips_site_id = 'cswiki'
)
GROUP BY wbA.ips_item_id

SQL

Checking query status...