Gender inflected pages to be merged in Wikidata

SQL

USE wikidatawiki_p;
SELECT CONCAT('* ', wbA.ips_site_page, ' - [[Q', wbA.ips_item_id, ']] & [[Q', GROUP_CONCAT(DISTINCT wbC.ips_item_id ORDER BY wbC.ips_item_id ASC SEPARATOR ']], [[Q'), ']]') AS result
	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 AND wbA.ips_site_id = 'cswiki')
	JOIN wb_items_per_site AS wbC
		ON (wbA.ips_site_page = CONCAT(wbC.ips_site_page, 'ová') AND NOT wbA.ips_site_id = wbC.ips_site_id)
WHERE wbB.ips_site_id IS NULL
AND wbA.ips_site_page LIKE '% %'
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'
)
AND NOT wbA.ips_item_id = wbC.ips_item_id
GROUP BY wbA.ips_item_id
ORDER BY wbA.ips_site_page, wbC.ips_site_page;
SQL

Checking query status...
