|
1
|
SELECT '# specimen replicates' AS ___;
|
|
2
|
SELECT count(*) AS count
|
|
3
|
FROM specimenreplicate
|
|
4
|
JOIN party ON party_id = datasource_id AND organizationname = :datasource
|
|
5
|
;
|
|
6
|
|
|
7
|
SELECT '# families' AS ___;
|
|
8
|
SELECT count(DISTINCT plantname) AS count
|
|
9
|
FROM specimenreplicate
|
|
10
|
JOIN party ON party_id = datasource_id AND organizationname = :datasource
|
|
11
|
JOIN taxondetermination USING (taxonoccurrence_id)
|
|
12
|
JOIN plantconcept USING (plantconcept_id)
|
|
13
|
JOIN plantname USING (plantname_id)
|
|
14
|
WHERE rank = 'Family'
|
|
15
|
;
|
