Revision 13440
Added by Aaron Marcuse-Kubitza about 10 years ago
| vegbien.sql | ||
|---|---|---|
| 9395 | 9395 |
taxon_scrub.scrubbed_family AS tnrs_accepted_name_family, |
| 9396 | 9396 |
taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name, |
| 9397 | 9397 |
taxon_scrub.scrubbed_author AS tnrs_accepted_name_author, |
| 9398 |
taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
|
|
| 9398 |
taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
|
|
| 9399 | 9399 |
FROM ((public.taxonverbatim |
| 9400 | 9400 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
| 9401 | 9401 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
Also available in: Unified diff
bugfix: schemas/public_.sql: _plots_20_tnrs_names: morphospeciesSuffix must still be called morphospecies_suffix, not taxon_morphospecies, because that column has not been updated to the taxon_morphospecies yet (fixes r13435)