Revision 13120
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 9252 | 9252 |
|
| 9253 | 9253 |
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS |
| 9254 | 9254 |
SELECT count(DISTINCT taxonlabel.taxonomicname) AS taxon_names_with_author |
| 9255 |
FROM public.taxonlabel |
|
| 9256 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));
|
|
| 9255 |
FROM (public.taxonverbatim |
|
| 9256 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
|
| 9257 |
WHERE ((taxonverbatim.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonverbatim.subspecies IS NOT NULL));
|
|
| 9257 | 9258 |
|
| 9258 | 9259 |
|
| 9259 | 9260 |
-- |
| ... | ... | |
| 9262 | 9263 |
|
| 9263 | 9264 |
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS |
| 9264 | 9265 |
SELECT DISTINCT taxonlabel.taxonomicname AS taxon_name_with_author |
| 9265 |
FROM public.taxonlabel |
|
| 9266 |
WHERE ((taxonlabel.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));
|
|
| 9266 |
FROM (public.taxonverbatim |
|
| 9267 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
|
| 9268 |
WHERE ((taxonverbatim.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (taxonverbatim.subspecies IS NOT NULL));
|
|
| 9267 | 9269 |
|
| 9268 | 9270 |
|
| 9269 | 9271 |
-- |
Also available in: Unified diff
fix: schemas/vegbien.sql: specimens*_of_unique_verb_subsp_taxa_with_author: include only names with subspecies (filtering by taxonverbatim.subspecies rather than taxonlabel.taxonomicname)