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=463 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=463SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=224SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=463 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnocnema' AND (junior_species='juipoca' OR junior_species='juipoca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnocnema' AND (species='juipoca' OR species='juipoca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnocnema' AND (species='juipoca' OR species='juipoca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnocnema' AND (junior_species='juipoca' OR junior_species='juipoca')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='Ischnocnema' AND (species='juipoca' OR species='juipoca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='pombali' OR junior_species='pombalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='pombali' OR species='pombalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='pombali' OR species='pombalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='pombali' OR junior_species='pombalii')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='pombali' OR species='pombalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='rubescens' OR junior_species='rubescens')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='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='schneideri' OR junior_species='schneiderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='schneideri' OR species='schneiderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='schneideri' OR species='schneiderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='schneideri' OR junior_species='schneiderii')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='schneideri' OR species='schneiderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haddadus' AND (junior_species='binotatus' OR junior_species='binotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haddadus' AND (species='binotatus' OR species='binotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haddadus' AND (species='binotatus' OR species='binotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haddadus' AND (junior_species='binotatus' OR junior_species='binotatus')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='Haddadus' AND (species='binotatus' OR species='binotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophrynus' AND (junior_species='cultripes' OR junior_species='cultripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontophrynus' AND (species='cultripes' OR species='cultripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontophrynus' AND (species='cultripes' OR species='cultripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophrynus' AND (junior_species='cultripes' OR junior_species='cultripes')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='Odontophrynus' AND (species='cultripes' OR species='cultripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratophrys' AND (junior_species='boiei' OR junior_species='boieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proceratophrys' AND (species='boiei' OR species='boieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proceratophrys' AND (species='boiei' OR species='boieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratophrys' AND (junior_species='boiei' OR junior_species='boieii')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='Proceratophrys' AND (species='boiei' OR species='boieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bokermannohyla' AND (junior_species='circumdata' OR junior_species='circumdata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bokermannohyla' AND (species='circumdata' OR species='circumdata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bokermannohyla' AND (species='circumdata' OR species='circumdata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bokermannohyla' AND (junior_species='circumdata' OR junior_species='circumdata')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='Bokermannohyla' AND (species='circumdata' OR species='circumdata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='elegans' OR junior_species='elegans')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='elegans' OR species='elegans') 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='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='Hypsiboas' AND (junior_species='albopunctatus' OR junior_species='albopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='albopunctatus' OR species='albopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='albopunctatus' OR species='albopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='albopunctatus' OR junior_species='albopunctatus')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='albopunctatus' OR species='albopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='faber' OR junior_species='faber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='faber' OR species='faber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='faber' OR species='faber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='faber' OR junior_species='faber')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='faber' OR species='faber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='lundii' OR junior_species='lundi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='lundii' OR species='lundi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='lundii' OR species='lundi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='lundii' OR junior_species='lundi')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='lundii' OR species='lundi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='polytaenius' OR junior_species='polytaenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='polytaenius' OR species='polytaenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='polytaenius' OR species='polytaenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='polytaenius' OR junior_species='polytaenius')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='polytaenius' OR species='polytaenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodytes' AND (junior_species='luteolus' OR junior_species='luteolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllodytes' AND (species='luteolus' OR species='luteolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllodytes' AND (species='luteolus' OR species='luteolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodytes' AND (junior_species='luteolus' OR junior_species='luteolus')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='Phyllodytes' AND (species='luteolus' OR species='luteolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='burmeisteri' OR junior_species='burmeisterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllomedusa' AND (species='burmeisteri' OR species='burmeisterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllomedusa' AND (species='burmeisteri' OR species='burmeisterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='burmeisteri' OR junior_species='burmeisterii')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='burmeisteri' OR species='burmeisterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='similis' OR junior_species='similis')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='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='cuspidatus' OR junior_species='cuspidatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='cuspidatus' OR species='cuspidatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='cuspidatus' OR species='cuspidatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='cuspidatus' OR junior_species='cuspidatus')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='cuspidatus' OR species='cuspidatus') 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='fuscovarius' OR junior_species='fuscovarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='fuscovarius' OR species='fuscovarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='fuscovarius' OR species='fuscovarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='fuscovarius' OR junior_species='fuscovarius')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='fuscovarius' OR species='fuscovarius') 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='luizotavioi' OR junior_species='luizotavioii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='luizotavioi' OR species='luizotavioii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='luizotavioi' OR species='luizotavioii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='luizotavioi' OR junior_species='luizotavioii')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='luizotavioi' OR species='luizotavioii') 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='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='labyrinthicus' OR junior_species='labyrinthicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='labyrinthicus' OR species='labyrinthicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='labyrinthicus' OR species='labyrinthicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='labyrinthicus' OR junior_species='labyrinthicus')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='labyrinthicus' OR species='labyrinthicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='latrans' OR junior_species='latrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='latrans' OR species='latrans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='latrans' OR species='latrans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='latrans' OR junior_species='latrans')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='latrans' OR species='latrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='mystaceus' OR junior_species='mystaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='mystaceus' OR species='mystaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='mystaceus' OR species='mystaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='mystaceus' OR junior_species='mystaceus')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='mystaceus' OR species='mystaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='mystacinus' OR junior_species='mystacinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='mystacinus' OR species='mystacinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='mystacinus' OR species='mystacinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='mystacinus' OR junior_species='mystacinus')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='mystacinus' OR species='mystacinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='cesarii' OR junior_species='cesari')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elachistocleis' AND (species='cesarii' OR species='cesari') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elachistocleis' AND (species='cesarii' OR species='cesari')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elachistocleis' AND (junior_species='cesarii' OR junior_species='cesari')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='cesarii' OR species='cesari') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphonops' AND (junior_species='paulensis' OR junior_species='paulensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siphonops' AND (species='paulensis' OR species='paulensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siphonops' AND (species='paulensis' OR species='paulensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphonops' AND (junior_species='paulensis' OR junior_species='paulensis')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='Siphonops' AND (species='paulensis' OR species='paulensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphonops' 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='Siphonops' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siphonops' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphonops' 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='Siphonops' AND (species='sp.' OR species='sp.') 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='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='dubia' OR junior_species='dubia')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='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiodes' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophiodes' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophiodes' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiodes' AND (junior_species='striatus' OR junior_species='striatus')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='Ophiodes' AND (species='striatus' OR species='striatus') 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='Enyalius' AND (junior_species='bilineatus' OR junior_species='bilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enyalius' AND (species='bilineatus' OR species='bilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enyalius' AND (species='bilineatus' OR species='bilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enyalius' AND (junior_species='bilineatus' OR junior_species='bilineatus')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='Enyalius' AND (species='bilineatus' OR species='bilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urostrophus' AND (junior_species='vautieri' OR junior_species='vautierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urostrophus' AND (species='vautieri' OR species='vautierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urostrophus' AND (species='vautieri' OR species='vautierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urostrophus' AND (junior_species='vautieri' OR junior_species='vautierii')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='Urostrophus' AND (species='vautieri' OR species='vautierii') 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='Notomabuya' AND (junior_species='frenata' OR junior_species='frenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notomabuya' AND (species='frenata' OR species='frenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notomabuya' AND (species='frenata' OR species='frenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notomabuya' AND (junior_species='frenata' OR junior_species='frenata')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='Notomabuya' AND (species='frenata' OR species='frenata') 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='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='Cnemidophorus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemidophorus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')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='Cnemidophorus' AND (species='lemniscatus' OR species='lemniscatus') 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='Epicrates' AND (junior_species='crassus' OR junior_species='crassus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epicrates' AND (species='crassus' OR species='crassus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epicrates' AND (species='crassus' OR species='crassus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epicrates' AND (junior_species='crassus' OR junior_species='crassus')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='crassus' OR species='crassus') 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='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='assimilis' OR junior_species='assimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apostolepis' AND (species='assimilis' OR species='assimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apostolepis' AND (species='assimilis' OR species='assimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apostolepis' AND (junior_species='assimilis' OR junior_species='assimilis')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='assimilis' OR species='assimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='aesculapii' OR junior_species='aesculapi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='aesculapii' OR species='aesculapi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='aesculapii' OR species='aesculapi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='aesculapii' OR junior_species='aesculapi')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='aesculapii' OR species='aesculapi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='almadensis' OR junior_species='almadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='almadensis' OR species='almadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='almadensis' OR species='almadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='almadensis' OR junior_species='almadensis')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='almadensis' OR species='almadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='miliaris' OR junior_species='miliaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrolamprus' AND (species='miliaris' OR species='miliaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrolamprus' AND (species='miliaris' OR species='miliaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrolamprus' AND (junior_species='miliaris' OR junior_species='miliaris')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='miliaris' OR species='miliaris') 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='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Imantodes' AND (species='cenchoa' OR species='cenchoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')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='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='guibei' OR junior_species='guibeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyrhopus' AND (species='guibei' OR species='guibeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyrhopus' AND (species='guibei' OR species='guibeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyrhopus' AND (junior_species='guibei' OR junior_species='guibeii')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='guibei' OR species='guibeii') 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='Phylodryas' 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='Phylodryas' AND (species='olfersii' OR species='olfersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylodryas' AND (species='olfersii' OR species='olfersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylodryas' 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='Phylodryas' AND (species='olfersii' OR species='olfersi') 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='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='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taeniophallus' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taeniophallus' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taeniophallus' AND (junior_species='affinis' OR junior_species='affinis')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='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='hypoconia' OR junior_species='hypoconia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnodynastes' AND (species='hypoconia' OR species='hypoconia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnodynastes' AND (species='hypoconia' OR species='hypoconia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='hypoconia' OR junior_species='hypoconia')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='hypoconia' OR species='hypoconia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='lemniscatus' OR species='lemniscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='lemniscatus' OR species='lemniscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='lemniscatus' OR junior_species='lemniscatus')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='lemniscatus' OR species='lemniscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='neuwiedi' OR junior_species='neuwiedii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='neuwiedi' OR species='neuwiedii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='neuwiedi' OR species='neuwiedii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='neuwiedi' OR junior_species='neuwiedii')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='neuwiedi' OR species='neuwiedii') 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 * FROM register WHERE sample_no=463 The Ecological Register: Inhotim Institute
Inhotim Institute
Basic information
Sample name: Inhotim Institute

Sample aka: Brumadinho

Reference: A. M. Linares and P. C. Eterovick. 2013. Herpetofaunal surveys support successful reconciliation ecology in secondary and human-modified habitats at the Inhotim Institute, southeastern Brazil. Herpetologica 69(2):237-256 [ER 224]
Geography
Country: Brazil

State: Minas Gerais


Coordinate: 20° 7' 26" S, 44° 13' 7" W
Coordinate basis: stated in text

Geography comments: coordinate stated in text
altitude 730 - 1144 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 18.0

MAP: 1250.0

Habitat comments: "Atantic Forest-Cerrado transition fragments and anthropogenic habitats" and specifically "a montane, seasonal, semi-deciduous forest" that is clearly > 100 ha in area based on satellite photos
precip 1000 to 1500 mm

Methods
Life forms: lizards,snakes,caecilians,frogs

Sampling methods: drift fences,pitfall traps,auditory,hand capture,visual

Sample size: 2292 individuals

Years: 2008, 2009

Sampling comments: plus visual and anuran auditory surveys

Metadata
Sample number: 463

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-18 14:12:58

Modified: 2015-02-24 00:25:03

Abundance distribution
65 species
12 singletons
total count 2292
extrapolated richness: 94.2
Fisher's α: 12.450
geometric series k: 0.8977
Hurlbert's PIE: 0.7971
Shannon's H: 2.6294
Good's u: 0.9948
Each square represents a species. Square sizes are proportional to counts.
Register