Schema: CREATE TABLE table_name_22 (red_list VARCHAR, species_authority VARCHAR, order VARCHAR, family VARCHAR)
Question: What red list is in the artiodactyla order and the cervidae family with a Species Authority of odocoileus virginianus zimmermann, 1780?
SQL: SELECT red_list FROM table_name_22 WHERE order = "artiodactyla" AND family = "cervidae" AND species_authority = "odocoileus virginianus zimmermann, 1780"