Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- count(*)
- 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;
Add Comment
Please, Sign In to add comment