Revision 14435
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 10168 | 10168 |
-- |
| 10169 | 10169 |
|
| 10170 | 10170 |
CREATE VIEW iucn_red_list_view AS |
| 10171 |
SELECT DISTINCT "ValidMatchedTaxon"."*Accepted_name_family" AS accepted_family,
|
|
| 10172 |
"ValidMatchedTaxon"."*Accepted_name_species" AS accepted_species_binomial
|
|
| 10171 |
SELECT DISTINCT taxon_scrub."*Accepted_name_family" AS accepted_family,
|
|
| 10172 |
taxon_scrub."*Accepted_name_species" AS accepted_species_binomial
|
|
| 10173 | 10173 |
FROM (taxonlabel |
| 10174 |
JOIN "TNRS"."ValidMatchedTaxon" ON (("ValidMatchedTaxon"."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 10175 |
WHERE (((taxonlabel.source_id = source_by_shortname('IUCN'::text)) AND ("ValidMatchedTaxon"."*Accepted_name_family" IS NOT NULL)) AND ("ValidMatchedTaxon"."*Accepted_name_species" IS NOT NULL));
|
|
| 10174 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 10175 |
WHERE (((taxonlabel.source_id = source_by_shortname('IUCN'::text)) AND (taxon_scrub."*Accepted_name_family" IS NOT NULL)) AND (taxon_scrub."*Accepted_name_species" IS NOT NULL));
|
|
| 10176 | 10176 |
|
| 10177 | 10177 |
|
| 10178 | 10178 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 10168 | 10168 |
-- |
| 10169 | 10169 |
|
| 10170 | 10170 |
CREATE VIEW iucn_red_list_view AS |
| 10171 |
SELECT DISTINCT "ValidMatchedTaxon"."*Accepted_name_family" AS accepted_family,
|
|
| 10172 |
"ValidMatchedTaxon"."*Accepted_name_species" AS accepted_species_binomial
|
|
| 10171 |
SELECT DISTINCT taxon_scrub."*Accepted_name_family" AS accepted_family,
|
|
| 10172 |
taxon_scrub."*Accepted_name_species" AS accepted_species_binomial
|
|
| 10173 | 10173 |
FROM (taxonlabel |
| 10174 |
JOIN "TNRS"."ValidMatchedTaxon" ON (("ValidMatchedTaxon"."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 10175 |
WHERE (((taxonlabel.source_id = source_by_shortname('IUCN'::text)) AND ("ValidMatchedTaxon"."*Accepted_name_family" IS NOT NULL)) AND ("ValidMatchedTaxon"."*Accepted_name_species" IS NOT NULL));
|
|
| 10174 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname)))
|
|
| 10175 |
WHERE (((taxonlabel.source_id = source_by_shortname('IUCN'::text)) AND (taxon_scrub."*Accepted_name_family" IS NOT NULL)) AND (taxon_scrub."*Accepted_name_species" IS NOT NULL));
|
|
| 10176 | 10176 |
|
| 10177 | 10177 |
|
| 10178 | 10178 |
-- |
Also available in: Unified diff
schemas/public_.sql: iucn_red_list_view: use taxon_scrub instead of ValidMatchedTaxon since they are equivalent