Guest User

Untitled

a guest
Nov 12th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT
  2. count(*)
  3. FROM
  4. (SELECT
  5. accession.id
  6. FROM
  7. accession) AS A
  8. LEFT JOIN
  9. (SELECT DISTINCT
  10. accession.id
  11. FROM
  12. accession
  13. JOIN linked_agents_rlshp ON linked_agents_rlshp.accession_id = accession.id
  14. JOIN enumeration_value evrole ON linked_agents_rlshp.role_id = evrole.id
  15. WHERE
  16. evrole.value = 'source') AS B ON A.id = B.id
  17. WHERE
  18. B.id IS NULL;
Add Comment
Please, Sign In to add comment