|
1
|
/* there is only 1 taxonobservation without a taxoninterpretation [1], so we can
|
|
2
|
just include one row for each taxoninterpretation. this allows us to use the
|
|
3
|
taxoninterpretation_id as the row_num.
|
|
4
|
|
|
5
|
[1]
|
|
6
|
SELECT *
|
|
7
|
FROM taxonobservation
|
|
8
|
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
|
|
9
|
WHERE taxoninterpretation_id IS NULL
|
|
10
|
*/
|
|
11
|
SELECT *
|
|
12
|
FROM taxoninterpretation
|
|
13
|
LEFT JOIN taxonobservation USING (taxonobservation_id)
|
|
14
|
LEFT JOIN plantconcept_ USING (plantconcept_id)
|
|
15
|
LEFT JOIN plantname USING (plantname_id)
|
|
16
|
; -- runtime: 20 s ("Time: 20279.441 ms") @starscream
|
