Categories about taxons in cswiki missing interwiki

SQL

USE cswiki_p; # change this to your project
SELECT sitelink.ips_site_page AS category, CONCAT("Q",items.ips_item_id) AS category_item,
	GROUP_CONCAT(DISTINCT CONCAT("Q",term_entity_id) ORDER BY epp_page_id SEPARATOR ', ') AS taxon_item,
	COUNT(items.ips_site_page) AS number_of_sitelinks
	FROM (SELECT * FROM page WHERE page_namespace = 14) AS categories
	JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type IN ("label","alias") AND term_entity_type = "item") AS terms
		ON page_title = term_text
	JOIN wikidatawiki_p.wb_entity_per_page
		ON epp_entity_id = term_entity_id
	JOIN (SELECT * FROM wikidatawiki_p.pagelinks WHERE pl_title IN ("Q16521","Q310890")) AS links
		ON links.pl_from = epp_page_id
	JOIN (SELECT * FROM wikidatawiki_p.wb_items_per_site WHERE ips_site_id = "cswiki") AS sitelink
		ON sitelink.ips_site_page = CONCAT("Kategorie:",page_title) # change this to localised prefix
	JOIN wikidatawiki_p.wb_items_per_site AS items
		ON items.ips_item_id = sitelink.ips_item_id
GROUP BY sitelink.ips_site_page HAVING COUNT(items.ips_site_page) < 4 # change this to what you consider enough
ORDER BY COUNT(items.ips_site_page) DESC, term_text;
SQL

Checking query status...
