-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW threatened_taxonlabel_view AS

 SELECT DISTINCT accepted_taxonlabel_descendant.descendant_id AS taxonlabel_id

   FROM ((taxonlabel datasource_taxonlabel

   JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id)))

   JOIN taxonlabel_relationship accepted_taxonlabel_descendant ON ((accepted_taxonlabel_descendant.ancestor_id = accepted_taxonlabel.taxonlabel_id)))

  WHERE (((datasource_taxonlabel.source_id = ( SELECT source_by_shortname('IUCN'::text) AS source_by_shortname)) AND (datasource_taxonlabel.taxonomicname IS NOT NULL)) AND (accepted_taxonlabel.rank >= 'species'::taxonrank));

--

-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE threatened_taxonlabel_view FROM PUBLIC;

REVOKE ALL ON TABLE threatened_taxonlabel_view FROM bien;

GRANT ALL ON TABLE threatened_taxonlabel_view TO bien;

GRANT SELECT ON TABLE threatened_taxonlabel_view TO bien_read;

--