Revision 7135
Added by Aaron Marcuse-Kubitza about 12 years ago
| schema.sql | ||
|---|---|---|
| 117 | 117 |
, tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid" |
| 118 | 118 |
FROM tnrs |
| 119 | 119 |
LEFT JOIN tnrs tnrs_accepted ON |
| 120 |
tnrs_accepted."Name_submitted" = NULLIF(array_to_string(ARRAY[ |
|
| 121 |
NULLIF(tnrs."Accepted_name_family", 'Unknown') |
|
| 122 |
, tnrs."Accepted_name" |
|
| 123 |
, tnrs."Accepted_name_author" |
|
| 124 |
], ' '), '') |
|
| 120 |
tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name" |
|
| 125 | 121 |
; |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs+accepted: Use new Accepted_scientific_name to join to tnrs_accepted.Name_submitted