Revision 1254
Added by Aaron Marcuse-Kubitza almost 13 years ago
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
specimens verification: Added # binomials test