QUERY: SELECT * FROM amphib WHERE ordr = "anura" and (submittedby like '%John Romansic%' or description_contributors like '%John Romansic%' or distribution_contributors like '%John Romansic%' or life_history_contributors like '%John Romansic%' or larva_contributors like '%John Romansic%' or trends_and_threats_contributors like '%John Romansic%' or relation_to_humans_contributors like '%John Romansic%' or comments_contributors like '%John Romansic%' or refs_contributors like '%John Romansic%') order by genus, species

Number of matches: 3

Scientific Name	Photo	Sound	IUCN Red List Status	Vernacular Name	Family	Order
Anaxyrus californicus		sounds	Endangered (EN)	Arroyo Toad	Bufonidae	Anura
Anaxyrus canorus		sounds	Endangered (EN)	Yosemite Toad	Bufonidae	Anura
Rana cascadae		sounds	Near Threatened (NT)	Cascades Frog	Ranidae	Anura