Project

General

Profile

« Previous | Next » 

Revision 1254

specimens verification: Added # binomials test

View differences:

verify.specimens.sql
56 56
WHERE datasource_id =
57 57
    (SELECT party_id FROM party WHERE organizationname = :datasource)
58 58
;
59

  
60
SELECT '# binomials' AS ___;
61
SELECT count(DISTINCT plantname) AS count
62
FROM specimenreplicate
63
JOIN taxondetermination USING (taxonoccurrence_id)
64
JOIN plantconcept USING (plantconcept_id)
65
JOIN plantname
66
    ON plantname.plantname_id = plantconcept.plantname_id
67
    AND plantname.rank = 'Binomial'
68
WHERE datasource_id =
69
    (SELECT party_id FROM party WHERE organizationname = :datasource)
70
AND taxondetermination.isoriginal
71
;

Also available in: Unified diff