Revision 11505
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1367 | 1367 |
SELECT taxondetermination_id FROM taxondetermination |
| 1368 | 1368 |
WHERE taxonoccurrence_id = taxonoccurrence_id_ |
| 1369 | 1369 |
ORDER BY |
| 1370 |
COALESCE(isoriginal, false)/*false first*/ |
|
| 1370 |
COALESCE(iscurrent__verbatim, false) DESC/*true first*/ |
|
| 1371 |
, COALESCE(isoriginal, false)/*false first*/ |
|
| 1371 | 1372 |
, determinationdate DESC NULLS LAST |
| 1372 | 1373 |
LIMIT 1 |
| 1373 | 1374 |
); |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination_set_iscurrent(): include new iscurrent__verbatim, so that taxondeterminations the datasource marks as current are always considered first. this currently applies to VegBank and CVS.