Revision 13918
Added by Aaron Marcuse-Kubitza over 10 years ago
| public_.sql | ||
|---|---|---|
| 9579 | 9579 |
-- |
| 9580 | 9580 |
|
| 9581 | 9581 |
CREATE VIEW iucn_red_list_view AS |
| 9582 |
SELECT "ValidMatchedTaxon".accepted_family, |
|
| 9582 |
SELECT DISTINCT "ValidMatchedTaxon".accepted_family,
|
|
| 9583 | 9583 |
"ValidMatchedTaxon".accepted_species_binomial |
| 9584 | 9584 |
FROM (taxonlabel |
| 9585 | 9585 |
JOIN "TNRS"."ValidMatchedTaxon" ON (("ValidMatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))
|
| 9586 |
WHERE (taxonlabel.source_id = source_by_shortname('IUCN'::text));
|
|
| 9586 |
WHERE (((taxonlabel.source_id = source_by_shortname('IUCN'::text)) AND ("ValidMatchedTaxon".accepted_family IS NOT NULL)) AND ("ValidMatchedTaxon".accepted_species_binomial IS NOT NULL));
|
|
| 9587 | 9587 |
|
| 9588 | 9588 |
|
| 9589 | 9589 |
-- |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: iucn_red_list_view: need to include only names with an accepted name, and distinctify on the accepted names