AllAccessionsMissingSources.sql

SELECT 
    *
FROM
    (SELECT 
        accession.id
    FROM
        accession) AS A
        LEFT JOIN
    (SELECT DISTINCT
        accession.id
    FROM
        accession
    JOIN linked_agents_rlshp ON linked_agents_rlshp.accession_id = accession.id
    JOIN enumeration_value evrole ON linked_agents_rlshp.role_id = evrole.id
    WHERE
        evrole.value = 'source') AS B ON A.id = B.id
WHERE
    B.id IS NULL
ORDER BY A.id DESC;