| 1 |
10998
|
aaronmk
|
/* 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 |
4529
|
aaronmk
|
SELECT *
|
| 7 |
|
|
FROM taxonobservation
|
| 8 |
|
|
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
|
| 9 |
10998
|
aaronmk
|
WHERE taxoninterpretation_id IS NULL
|
| 10 |
|
|
*/
|
| 11 |
|
|
SELECT *
|
| 12 |
|
|
FROM taxoninterpretation
|
| 13 |
|
|
LEFT JOIN taxonobservation USING (taxonobservation_id)
|
| 14 |
10688
|
aaronmk
|
LEFT JOIN plantconcept_ USING (plantconcept_id)
|
| 15 |
|
|
LEFT JOIN plantname USING (plantname_id)
|
| 16 |
11223
|
aaronmk
|
; -- runtime: 20 s ("Time: 20279.441 ms") @starscream
|
