SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=497 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=497SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=244SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=497 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplocercus' AND (junior_species='spinosus' OR junior_species='spinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplocercus' AND (species='spinosus' OR species='spinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplocercus' AND (species='spinosus' OR species='spinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplocercus' AND (junior_species='spinosus' OR junior_species='spinosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplocercus' AND (species='spinosus' OR species='spinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iguana' AND (junior_species='iguana' OR junior_species='iguana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iguana' AND (species='iguana' OR species='iguana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iguana' AND (species='iguana' OR species='iguana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iguana' AND (junior_species='iguana' OR junior_species='iguana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iguana' AND (species='iguana' OR species='iguana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidurus' AND (junior_species='oreadicus' OR junior_species='oreadicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropidurus' AND (species='oreadicus' OR species='oreadicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidurus' AND (species='oreadicus' OR species='oreadicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidurus' AND (junior_species='oreadicus' OR junior_species='oreadicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tropidurus' AND (species='oreadicus' OR species='oreadicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidurus' AND (junior_species='semitaeniatus' OR junior_species='semitaeniatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropidurus' AND (species='semitaeniatus' OR species='semitaeniatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidurus' AND (species='semitaeniatus' OR species='semitaeniatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidurus' AND (junior_species='semitaeniatus' OR junior_species='semitaeniatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tropidurus' AND (species='semitaeniatus' OR species='semitaeniatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Norops' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Norops' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Norops' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Norops' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Norops' AND (species='brasiliensis' OR species='brasiliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Norops' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polychrus' AND (junior_species='acutirostris' OR junior_species='acutirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polychrus' AND (species='acutirostris' OR species='acutirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polychrus' AND (species='acutirostris' OR species='acutirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polychrus' AND (junior_species='acutirostris' OR junior_species='acutirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polychrus' AND (species='acutirostris' OR species='acutirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllopezus' AND (junior_species='pollicaris' OR junior_species='pollicaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllopezus' AND (species='pollicaris' OR species='pollicaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllopezus' AND (species='pollicaris' OR species='pollicaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllopezus' AND (junior_species='pollicaris' OR junior_species='pollicaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllopezus' AND (species='pollicaris' OR species='pollicaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleodactylus' AND (junior_species='brachystoma' OR junior_species='brachystoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coleodactylus' AND (species='brachystoma' OR species='brachystoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coleodactylus' AND (species='brachystoma' OR species='brachystoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleodactylus' AND (junior_species='brachystoma' OR junior_species='brachystoma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coleodactylus' AND (species='brachystoma' OR species='brachystoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='brasilianus' OR junior_species='brasilianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='brasilianus' OR species='brasilianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='brasilianus' OR species='brasilianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='brasilianus' OR junior_species='brasilianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemidactylus' AND (species='brasilianus' OR species='brasilianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='mabouia' OR species='mabouia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copeoglossum' AND (junior_species='nigropunctatum' OR junior_species='nigropunctatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copeoglossum' AND (species='nigropunctatum' OR species='nigropunctatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copeoglossum' AND (species='nigropunctatum' OR species='nigropunctatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copeoglossum' AND (junior_species='nigropunctatum' OR junior_species='nigropunctatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Copeoglossum' AND (species='nigropunctatum' OR species='nigropunctatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobosaura' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobosaura' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobosaura' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobosaura' AND (junior_species='modesta' OR junior_species='modesta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobosaura' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrablepharus' AND (junior_species='maximiliani' OR junior_species='maximilianii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrablepharus' AND (species='maximiliani' OR species='maximilianii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrablepharus' AND (species='maximiliani' OR species='maximilianii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrablepharus' AND (junior_species='maximiliani' OR junior_species='maximilianii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrablepharus' AND (species='maximiliani' OR species='maximilianii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='ameiva' OR junior_species='ameiva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameiva' AND (species='ameiva' OR species='ameiva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameiva' AND (species='ameiva' OR species='ameiva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='ameiva' OR junior_species='ameiva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ameiva' AND (species='ameiva' OR species='ameiva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameivula' AND (junior_species='mumbuca' OR junior_species='mumbuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameivula' AND (species='mumbuca' OR species='mumbuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameivula' AND (species='mumbuca' OR species='mumbuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameivula' AND (junior_species='mumbuca' OR junior_species='mumbuca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ameivula' AND (species='mumbuca' OR species='mumbuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kentropyx' AND (junior_species='calcarata' OR junior_species='calcarata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kentropyx' AND (species='calcarata' OR species='calcarata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kentropyx' AND (species='calcarata' OR species='calcarata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kentropyx' AND (junior_species='calcarata' OR junior_species='calcarata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kentropyx' AND (species='calcarata' OR species='calcarata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvator' AND (junior_species='merianae' OR junior_species='merianae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salvator' AND (species='merianae' OR species='merianae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salvator' AND (species='merianae' OR species='merianae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvator' AND (junior_species='merianae' OR junior_species='merianae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salvator' AND (species='merianae' OR species='merianae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupinambis' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupinambis' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tupinambis' AND (species='quadrilineatus' OR species='quadrilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupinambis' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tupinambis' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='alba' OR junior_species='alba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphisbaena' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='polystega' OR junior_species='polystega')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='polystega' OR species='polystega') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='polystega' OR species='polystega')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='polystega' OR junior_species='polystega')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphisbaena' AND (species='polystega' OR species='polystega') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='miringoera' OR junior_species='miringoera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='miringoera' OR species='miringoera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='miringoera' OR species='miringoera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='miringoera' OR junior_species='miringoera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphisbaena' AND (species='miringoera' OR species='miringoera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='vermicularis' OR junior_species='vermicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='vermicularis' OR species='vermicularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='vermicularis' OR species='vermicularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='vermicularis' OR junior_species='vermicularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphisbaena' AND (species='vermicularis' OR species='vermicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='brongersmianus' OR junior_species='brongersmianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Typhlops' AND (species='brongersmianus' OR species='brongersmianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Typhlops' AND (species='brongersmianus' OR species='brongersmianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='brongersmianus' OR junior_species='brongersmianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Typhlops' AND (species='brongersmianus' OR species='brongersmianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricheilostoma' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tricheilostoma' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tricheilostoma' AND (species='brasiliensis' OR species='brasiliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricheilostoma' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tricheilostoma' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boa' AND (species='constrictor' OR species='constrictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boa' AND (junior_species='constrictor' OR junior_species='constrictor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Boa' AND (species='constrictor' OR species='constrictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corallus' AND (junior_species='hortulanus' OR junior_species='hortulanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corallus' AND (species='hortulanus' OR species='hortulanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corallus' AND (species='hortulanus' OR species='hortulanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corallus' AND (junior_species='hortulanus' OR junior_species='hortulanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corallus' AND (species='hortulanus' OR species='hortulanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epicrates' AND (species='assisi' OR species='assisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='assisi' OR junior_species='assisii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epicrates' AND (species='assisi' OR species='assisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunectes' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunectes' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunectes' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunectes' AND (junior_species='murinus' OR junior_species='murinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eunectes' AND (species='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='exoletus' OR junior_species='exoletus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chironius' AND (species='exoletus' OR species='exoletus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chironius' AND (species='exoletus' OR species='exoletus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='exoletus' OR junior_species='exoletus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chironius' AND (species='exoletus' OR species='exoletus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='flavolineatus' OR junior_species='flavolineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chironius' AND (species='flavolineatus' OR species='flavolineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chironius' AND (species='flavolineatus' OR species='flavolineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='flavolineatus' OR junior_species='flavolineatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chironius' AND (species='flavolineatus' OR species='flavolineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='bifossatus' OR junior_species='bifossatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mastigodryas' AND (species='bifossatus' OR species='bifossatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='boddaerti' OR junior_species='boddaertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastigodryas' AND (species='boddaerti' OR species='boddaertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastigodryas' AND (species='boddaerti' OR species='boddaertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastigodryas' AND (junior_species='boddaerti' OR junior_species='boddaertii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mastigodryas' AND (species='boddaerti' OR species='boddaertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilotes' AND (species='pullatus' OR species='pullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='melanocephala' OR junior_species='melanocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='melanocephala' OR species='melanocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='melanocephala' OR species='melanocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='melanocephala' OR junior_species='melanocephala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tantilla' AND (species='melanocephala' OR species='melanocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apostolepis' AND (species='cearensis' OR species='cearensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='cearensis' OR junior_species='cearensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apostolepis' AND (species='cearensis' OR species='cearensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='polylepis' OR junior_species='polylepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apostolepis' AND (species='polylepis' OR species='polylepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apostolepis' AND (species='polylepis' OR species='polylepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='polylepis' OR junior_species='polylepis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apostolepis' AND (species='polylepis' OR species='polylepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiruna' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boiruna' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boiruna' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiruna' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Boiruna' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicops' AND (junior_species='angulatus' OR junior_species='angulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicops' AND (species='angulatus' OR species='angulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicops' AND (species='angulatus' OR species='angulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicops' AND (junior_species='angulatus' OR junior_species='angulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicops' AND (species='angulatus' OR species='angulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrops' AND (junior_species='triangularis' OR junior_species='triangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydrops' AND (species='triangularis' OR species='triangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydrops' AND (species='triangularis' OR species='triangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrops' AND (junior_species='triangularis' OR junior_species='triangularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hydrops' AND (species='triangularis' OR species='triangularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='poecilogyrus' OR species='poecilogyrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='poecilogyrus' OR junior_species='poecilogyrus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrolamprus' AND (species='poecilogyrus' OR species='poecilogyrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='reginae' OR junior_species='reginae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='reginae' OR species='reginae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='reginae' OR species='reginae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='reginae' OR junior_species='reginae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrolamprus' AND (species='reginae' OR species='reginae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='taeniogaster' OR junior_species='taeniogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='taeniogaster' OR species='taeniogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='taeniogaster' OR species='taeniogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='taeniogaster' OR junior_species='taeniogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrolamprus' AND (species='taeniogaster' OR species='taeniogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygophis' AND (junior_species='paucidens' OR junior_species='paucidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygophis' AND (species='paucidens' OR species='paucidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygophis' AND (species='paucidens' OR species='paucidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygophis' AND (junior_species='paucidens' OR junior_species='paucidens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lygophis' AND (species='paucidens' OR species='paucidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='rhombifer' OR junior_species='rhombifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyrhopus' AND (species='rhombifer' OR species='rhombifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyrhopus' AND (species='rhombifer' OR species='rhombifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='rhombifer' OR junior_species='rhombifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxyrhopus' AND (species='rhombifer' OR species='rhombifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='trigeminus' OR junior_species='trigeminus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxyrhopus' AND (species='trigeminus' OR species='trigeminus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='nattereri' OR species='nattererii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philodryas' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='olfersii' OR junior_species='olfersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='olfersii' OR species='olfersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='olfersii' OR species='olfersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='olfersii' OR junior_species='olfersi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philodryas' AND (species='olfersii' OR species='olfersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodriguesophis' AND (junior_species='iglesiasi' OR junior_species='iglesiasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rodriguesophis' AND (species='iglesiasi' OR species='iglesiasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rodriguesophis' AND (species='iglesiasi' OR species='iglesiasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodriguesophis' AND (junior_species='iglesiasi' OR junior_species='iglesiasii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rodriguesophis' AND (species='iglesiasi' OR species='iglesiasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoboa' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoboa' AND (junior_species='nigra' OR junior_species='nigra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoboa' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psomophis' AND (species='joberti' OR species='jobertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psomophis' AND (junior_species='joberti' OR junior_species='jobertii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psomophis' AND (species='joberti' OR species='jobertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibynomorphus' AND (junior_species='mikanii' OR junior_species='mikani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibynomorphus' AND (species='mikanii' OR species='mikani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibynomorphus' AND (species='mikanii' OR species='mikani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibynomorphus' AND (junior_species='mikanii' OR junior_species='mikani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sibynomorphus' AND (species='mikanii' OR species='mikani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taeniophallus' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taeniophallus' AND (species='occipitalis' OR species='occipitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taeniophallus' AND (species='occipitalis' OR species='occipitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taeniophallus' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taeniophallus' AND (species='occipitalis' OR species='occipitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnodynastes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnodynastes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnodynastes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenodon' AND (species='merremii' OR species='merremi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='merremii' OR junior_species='merremi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xenodon' AND (species='merremii' OR species='merremi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenodon' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenodon' AND (species='nattereri' OR species='nattererii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenodon' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xenodon' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='ibiboboca' OR junior_species='ibiboboca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrurus' AND (species='ibiboboca' OR species='ibiboboca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='lutzi' OR junior_species='lutzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='lutzi' OR species='lutzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='lutzi' OR species='lutzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='lutzi' OR junior_species='lutzii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bothrops' AND (species='lutzi' OR species='lutzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='moojeni' OR junior_species='moojenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='moojeni' OR species='moojenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='moojeni' OR species='moojenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='moojeni' OR junior_species='moojenii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bothrops' AND (species='moojeni' OR species='moojenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='durissus' OR species='durissus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='durissus' OR junior_species='durissus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crotalus' AND (species='durissus' OR species='durissus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caiman' AND (junior_species='crocodilus' OR junior_species='crocodilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caiman' AND (species='crocodilus' OR species='crocodilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caiman' AND (species='crocodilus' OR species='crocodilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caiman' AND (junior_species='crocodilus' OR junior_species='crocodilus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caiman' AND (species='crocodilus' OR species='crocodilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynops' AND (junior_species='tuberosus' OR junior_species='tuberosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynops' AND (species='tuberosus' OR species='tuberosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynops' AND (species='tuberosus' OR species='tuberosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynops' AND (junior_species='tuberosus' OR junior_species='tuberosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phrynops' AND (species='tuberosus' OR species='tuberosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='minutus' OR junior_species='minutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendropsophus' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='nanus' OR junior_species='nanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='nanus' OR junior_species='nanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendropsophus' AND (species='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='rubicundulus' OR junior_species='rubicundulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='rubicundulus' OR species='rubicundulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='rubicundulus' OR species='rubicundulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='rubicundulus' OR junior_species='rubicundulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendropsophus' AND (species='rubicundulus' OR species='rubicundulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='soaresi' OR junior_species='soaresii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='soaresi' OR species='soaresii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='soaresi' OR species='soaresii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='soaresi' OR junior_species='soaresii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendropsophus' AND (species='soaresi' OR species='soaresii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='multifasciatus' OR junior_species='multifasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='multifasciatus' OR species='multifasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='multifasciatus' OR species='multifasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='multifasciatus' OR junior_species='multifasciatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypsiboas' AND (species='multifasciatus' OR species='multifasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='taurinus' OR junior_species='taurinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osteocephalus' AND (species='taurinus' OR species='taurinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteocephalus' AND (species='taurinus' OR species='taurinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='taurinus' OR junior_species='taurinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Osteocephalus' AND (species='taurinus' OR species='taurinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='azurea' OR junior_species='azurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllomedusa' AND (species='azurea' OR species='azurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllomedusa' AND (species='azurea' OR species='azurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='azurea' OR junior_species='azurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllomedusa' AND (species='azurea' OR species='azurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscomarginatus' OR junior_species='fuscomarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='fuscomarginatus' OR species='fuscomarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='fuscomarginatus' OR species='fuscomarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscomarginatus' OR junior_species='fuscomarginatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scinax' AND (species='fuscomarginatus' OR species='fuscomarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='gr.' OR junior_species='gr.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='gr.' OR species='gr.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='gr.' OR species='gr.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='gr.' OR junior_species='gr.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scinax' AND (species='gr.' OR species='gr.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='gr.' OR junior_species='gr.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='gr.' OR species='gr.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='gr.' OR species='gr.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='gr.' OR junior_species='gr.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scinax' AND (species='gr.' OR species='gr.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachycephalus' AND (junior_species='typhonius' OR junior_species='typhonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachycephalus' AND (species='typhonius' OR species='typhonius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachycephalus' AND (species='typhonius' OR species='typhonius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachycephalus' AND (junior_species='typhonius' OR junior_species='typhonius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachycephalus' AND (species='typhonius' OR species='typhonius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adenomera' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adenomera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adenomera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adenomera' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adenomera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodactylus' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='podicipinus' OR junior_species='podicipinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='podicipinus' OR species='podicipinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='podicipinus' OR species='podicipinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='podicipinus' OR junior_species='podicipinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodactylus' AND (species='podicipinus' OR species='podicipinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='troglodytes' OR junior_species='troglodytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='troglodytes' OR species='troglodytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='troglodytes' OR species='troglodytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='troglodytes' OR junior_species='troglodytes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodactylus' AND (species='troglodytes' OR species='troglodytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='vastus' OR junior_species='vastus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='vastus' OR species='vastus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='vastus' OR species='vastus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='vastus' OR junior_species='vastus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodactylus' AND (species='vastus' OR species='vastus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='centralis' OR junior_species='centralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physalaemus' AND (species='centralis' OR species='centralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physalaemus' AND (species='centralis' OR species='centralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='centralis' OR junior_species='centralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Physalaemus' AND (species='centralis' OR species='centralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='cuvieri' OR junior_species='cuvierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physalaemus' AND (species='cuvieri' OR species='cuvierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physalaemus' AND (species='cuvieri' OR species='cuvierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='cuvieri' OR junior_species='cuvierii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Physalaemus' AND (species='cuvieri' OR species='cuvierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='mystacalis' OR junior_species='mystacalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopaludicola' AND (junior_species='mystacalis' OR junior_species='mystacalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudopaludicola' AND (species='mystacalis' OR species='mystacalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaebo' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhaebo' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhaebo' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaebo' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhaebo' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='veredas' OR junior_species='veredas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='veredas' OR species='veredas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='veredas' OR species='veredas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='veredas' OR junior_species='veredas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinella' AND (species='veredas' OR species='veredas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='jimi' OR junior_species='jimii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='jimi' OR species='jimii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='jimi' OR species='jimii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='jimi' OR junior_species='jimii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinella' AND (species='jimi' OR species='jimii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='mirandaribeiroi' OR junior_species='mirandaribeiroii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='mirandaribeiroi' OR species='mirandaribeiroii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='mirandaribeiroi' OR species='mirandaribeiroii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='mirandaribeiroi' OR junior_species='mirandaribeiroii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinella' AND (species='mirandaribeiroi' OR species='mirandaribeiroii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='ocellata' OR junior_species='ocellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='ocellata' OR species='ocellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='ocellata' OR species='ocellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='ocellata' OR junior_species='ocellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinella' AND (species='ocellata' OR species='ocellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dermatonotus' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dermatonotus' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dermatonotus' AND (species='muelleri' OR species='muellerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dermatonotus' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dermatonotus' AND (species='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='carvalhoi' OR junior_species='carvalhoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elachistocleis' AND (species='carvalhoi' OR species='carvalhoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elachistocleis' AND (species='carvalhoi' OR species='carvalhoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='carvalhoi' OR junior_species='carvalhoii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elachistocleis' AND (species='carvalhoi' OR species='carvalhoii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=497 The Ecological Register: Estaçäo Ecológica de Uruçuí-Una
Estaçäo Ecológica de Uruçuí-Una
Basic information
Sample name: Estaçäo Ecológica de Uruçuí-Una

Reference: F. Dal Vechio, R. Recoder, M. Trefaut Rodrigues, and H. Zaher. 2013. The herpetofauna of the Estação Ecológica de Uruçuí-Una, state of Piauí, Brazil. Papeis Avulsos de Zoologia 53(16):225-243 [ER 244]
Geography
Country: Brazil

State: Piauí


Coordinate: 8° 50' S, 44° 10' W
Coordinate basis: stated in text

Geography comments: elevation range 380 to 620 m

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

MAT: 25.0

MAP: 900.0

Habitat comments: "wooded savanna" plus "palm marshes" in part of the area
MAP based on Santos et al. (2012, Revista Brasileira de Ornitologia) and apply to Serra Vermelha, which is about 1 degree due south

Methods
Life forms: lizards,snakes,turtles,other reptiles,frogs

Sampling methods: drift fences,pitfall traps

Sample size: 2246 individuals

Years: 2000, 2001

Sampling comments: drift fences/pitfall traps plus "active visual search"

Metadata
Sample number: 497

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-20 14:48:55

Modified: 2014-04-26 07:49:17

Abundance distribution
89 species
6 singletons
total count 2246
extrapolated richness: 111.1
Fisher's α: 18.517
geometric series k: 0.9372
Hurlbert's PIE: 0.9544
Shannon's H: 3.6587
Good's u: 0.9973
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hoplocercus spinosus13
Iguana iguana7
Tropidurus oreadicus301
Tropidurus semitaeniatus45
Norops meridionalis15
Norops brasiliensis2
Polychrus acutirostris4
Phyllopezus pollicaris25
Coleodactylus brachystoma19
Hemidactylus brasilianus15
Hemidactylus mabouia3
Copeoglossum nigropunctatum10
Colobosaura modesta44
Micrablepharus maximiliani85
Ameiva ameiva109
Ameivula cf. mumbuca162
Kentropyx calcarata5
Salvator merianae1
Tupinambis quadrilineatus12
Amphisbaena alba8
Amphisbaena polystega14
Amphisbaena miringoera5
Amphisbaena vermicularis17
Typhlops brongersmianus5
Tricheilostoma brasiliensis4
Boa constrictor6
Corallus hortulanus6
Epicrates assisi3
Eunectes murinus4
Chironius exoletus1
Chironius flavolineatus14
Leptophis ahaetulla2
Mastigodryas bifossatus6
Mastigodryas boddaerti2
Spilotes pullatus6
Tantilla melanocephala5
Apostolepis cearensis11
Apostolepis polylepis1
Boiruna sp.2
Helicops angulatus7
Hydrops triangularis8
Erythrolamprus poecilogyrus62
Erythrolamprus reginae17
Erythrolamprus taeniogaster3
Lygophis paucidens2
Oxyrhopus rhombifer14
Oxyrhopus trigeminus20
Philodryas nattereri30
Philodryas olfersii17
Rodriguesophis iglesiasi4
Pseudoboa nigra2
Psomophis joberti15
Sibynomorphus mikanii1
Taeniophallus occipitalis3
Thamnodynastes sp.17
Xenodon merremii110
Xenodon nattereri1
Micrurus ibiboboca7
Bothrops lutzi2
Bothrops moojeni104
Crotalus durissus15
Caiman crocodilus3
Phrynops cf. tuberosus4
Dendropsophus minutus3
Dendropsophus nanus20
Dendropsophus rubicundulus12
Dendropsophus soaresi42
Hypsiboas multifasciatus28
Osteocephalus taurinus7
Phyllomedusa azurea44
Scinax fuscomarginatus12
Scinax gr. ruber sp.124
Scinax gr. ruber sp.260
Trachycephalus typhonius14
Adenomera sp. nov.50
Leptodactylus fuscus12
Leptodactylus podicipinus1
Leptodactylus troglodytes33
Leptodactylus vastus23
Physalaemus centralis5
Physalaemus cuvieri191
Pseudopaludicola cf. mystacalis27
Rhaebo guttatus7
Rhinella veredas9
Rhinella jimi20
Rhinella mirandaribeiroi60
Rhinella ocellata37
Dermatonotus muelleri20
Elachistocleis carvalhoi18