nlwiktionary Taxa with and without Wikispecies links

SQL

SELECT page_title, GROUP_CONCAT(iwl_title SEPARATOR '; ') AS wikispecies
FROM pagelinks, page, iwlinks
WHERE
	pl_from=1113518 AND
    pl_namespace=page_namespace AND
    pl_title=page_title AND
    page_id=iwl_from AND
    iwl_prefix='wikispecies' AND
    iwl_title REGEXP '_'
GROUP BY page_title
;
SELECT page_title
FROM pagelinks, page
WHERE
	pl_from=1113518 AND
    pl_namespace=page_namespace AND
    pl_title=page_title AND
    NOT EXISTS (SELECT * FROM iwlinks WHERE page_id=iwl_from AND iwl_prefix='wikispecies' AND iwl_title REGEXP '_')

SQL

Checking query status...