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=426 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=426SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=203SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=426 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allobates' 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='Allobates' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allobates' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allobates' 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='Allobates' AND (species='sp.' OR species='sp.') 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='margaritifera' OR junior_species='margaritifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='margaritifera' OR species='margaritifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='margaritifera' OR species='margaritifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='margaritifera' OR junior_species='margaritifera')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='margaritifera' OR species='margaritifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='marina' OR junior_species='marina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='marina' OR species='marina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='marina' OR species='marina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='marina' OR junior_species='marina')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='marina' OR species='marina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophrys' AND (junior_species='cornuta' OR junior_species='cornuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratophrys' AND (species='cornuta' OR species='cornuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratophrys' AND (species='cornuta' OR species='cornuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratophrys' AND (junior_species='cornuta' OR junior_species='cornuta')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='Ceratophrys' AND (species='cornuta' OR species='cornuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='hahneli' OR junior_species='hahnelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameerega' AND (species='hahneli' OR species='hahnelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameerega' AND (species='hahneli' OR species='hahnelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='hahneli' OR junior_species='hahnelii')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='Ameerega' AND (species='hahneli' OR species='hahnelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='trivittata' OR junior_species='trivittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameerega' AND (species='trivittata' OR species='trivittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameerega' AND (species='trivittata' OR species='trivittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='trivittata' OR junior_species='trivittata')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='Ameerega' AND (species='trivittata' OR species='trivittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='brevifrons' OR junior_species='brevifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='brevifrons' OR species='brevifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='brevifrons' OR species='brevifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='brevifrons' OR junior_species='brevifrons')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='brevifrons' OR species='brevifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='leucophyllatus' OR junior_species='leucophyllatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='leucophyllatus' OR species='leucophyllatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='leucophyllatus' OR species='leucophyllatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='leucophyllatus' OR junior_species='leucophyllatus')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='leucophyllatus' OR species='leucophyllatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='parviceps' OR junior_species='parviceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropsophus' AND (species='parviceps' OR species='parviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropsophus' AND (species='parviceps' OR species='parviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropsophus' AND (junior_species='parviceps' OR junior_species='parviceps')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='parviceps' OR species='parviceps') 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='Hypsiboas' AND (junior_species='boans' OR junior_species='boans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='boans' OR species='boans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='boans' OR species='boans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='boans' OR junior_species='boans')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='boans' OR species='boans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='calcaratus' OR junior_species='calcaratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='calcaratus' OR species='calcaratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='calcaratus' OR species='calcaratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='calcaratus' OR junior_species='calcaratus')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='calcaratus' OR species='calcaratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='fasciatus' OR junior_species='fasciatus')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='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='geographicus' OR junior_species='geographicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='geographicus' OR species='geographicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='geographicus' OR species='geographicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='geographicus' OR junior_species='geographicus')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='geographicus' OR species='geographicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='lanciformis' OR junior_species='lanciformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='lanciformis' OR species='lanciformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='lanciformis' OR species='lanciformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='lanciformis' OR junior_species='lanciformis')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='lanciformis' OR species='lanciformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='punctatus' OR junior_species='punctatus')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='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='wavrini' OR junior_species='wavrinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='wavrini' OR species='wavrinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='wavrini' OR species='wavrinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='wavrini' OR junior_species='wavrinii')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='wavrini' OR species='wavrinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='castaneicola' OR junior_species='castaneicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osteocephalus' AND (species='castaneicola' OR species='castaneicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteocephalus' AND (species='castaneicola' OR species='castaneicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='castaneicola' OR junior_species='castaneicola')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='castaneicola' OR species='castaneicola') 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='palliata' OR junior_species='palliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllomedusa' AND (species='palliata' OR species='palliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllomedusa' AND (species='palliata' OR species='palliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomedusa' AND (junior_species='palliata' OR junior_species='palliata')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='palliata' OR species='palliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarthyla' AND (junior_species='goinorum' OR junior_species='goinorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarthyla' AND (species='goinorum' OR species='goinorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarthyla' AND (species='goinorum' OR species='goinorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarthyla' AND (junior_species='goinorum' OR junior_species='goinorum')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='Scarthyla' AND (species='goinorum' OR species='goinorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='boesemani' OR junior_species='boesemanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='boesemani' OR species='boesemanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='boesemani' OR species='boesemanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='boesemani' OR junior_species='boesemanii')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='boesemani' OR species='boesemanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='garbei' OR junior_species='garbeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='garbei' OR species='garbeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='garbei' OR species='garbeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='garbei' OR junior_species='garbeii')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='garbei' OR species='garbeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='nebulosus' OR junior_species='nebulosus')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='nebulosus' OR species='nebulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='ruber' OR junior_species='ruber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scinax' AND (species='ruber' OR species='ruber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scinax' AND (species='ruber' OR species='ruber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scinax' AND (junior_species='ruber' OR junior_species='ruber')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='ruber' OR species='ruber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Edalorhina' AND (junior_species='perezi' OR junior_species='perezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Edalorhina' AND (species='perezi' OR species='perezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Edalorhina' AND (species='perezi' OR species='perezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Edalorhina' AND (junior_species='perezi' OR junior_species='perezii')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='Edalorhina' AND (species='perezi' OR species='perezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engystomops' AND (junior_species='freibergi' OR junior_species='freibergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Engystomops' AND (species='freibergi' OR species='freibergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Engystomops' AND (species='freibergi' OR species='freibergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engystomops' AND (junior_species='freibergi' OR junior_species='freibergii')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='Engystomops' AND (species='freibergi' OR species='freibergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='andreae' OR junior_species='andreae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='andreae' OR species='andreae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='andreae' OR species='andreae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='andreae' OR junior_species='andreae')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='andreae' OR species='andreae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='hylaedactylus' OR junior_species='hylaedactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='hylaedactylus' OR species='hylaedactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='hylaedactylus' OR species='hylaedactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='hylaedactylus' OR junior_species='hylaedactylus')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='hylaedactylus' OR species='hylaedactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='pentadactylus' OR junior_species='pentadactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='pentadactylus' OR species='pentadactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='pentadactylus' OR species='pentadactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='pentadactylus' OR junior_species='pentadactylus')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='pentadactylus' OR species='pentadactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='petersii' OR junior_species='petersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='petersii' OR species='petersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='petersii' OR species='petersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='petersii' OR junior_species='petersi')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='petersii' OR species='petersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='rhodomystax' OR junior_species='rhodomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='rhodomystax' OR species='rhodomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='rhodomystax' OR species='rhodomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='rhodomystax' OR junior_species='rhodomystax')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='rhodomystax' OR species='rhodomystax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='bassleri' OR junior_species='basslerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiasmocleis' AND (species='bassleri' OR species='basslerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiasmocleis' AND (species='bassleri' OR species='basslerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='bassleri' OR junior_species='basslerii')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='Chiasmocleis' AND (species='bassleri' OR species='basslerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='ventrimaculata' OR junior_species='ventrimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiasmocleis' AND (junior_species='ventrimaculata' OR junior_species='ventrimaculata')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='Chiasmocleis' AND (species='ventrimaculata' OR species='ventrimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamptophryne' AND (species='boliviana' OR species='boliviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')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='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipa' AND (junior_species='pipa' OR junior_species='pipa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipa' AND (species='pipa' OR species='pipa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipa' AND (species='pipa' OR species='pipa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipa' AND (junior_species='pipa' OR junior_species='pipa')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='Pipa' AND (species='pipa' OR species='pipa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreobates' AND (junior_species='quixensis' OR junior_species='quixensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreobates' AND (species='quixensis' OR species='quixensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreobates' AND (species='quixensis' OR species='quixensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreobates' AND (junior_species='quixensis' OR junior_species='quixensis')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='Oreobates' AND (species='quixensis' OR species='quixensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='fenestratus' OR junior_species='fenestratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='fenestratus' OR species='fenestratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='fenestratus' OR species='fenestratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='fenestratus' OR junior_species='fenestratus')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='Pristimantis' AND (species='fenestratus' OR species='fenestratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='ockendeni' OR junior_species='ockendenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='ockendeni' OR species='ockendenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='ockendeni' OR species='ockendenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='ockendeni' OR junior_species='ockendenii')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='Pristimantis' AND (species='ockendeni' OR species='ockendenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caecilia' 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='Caecilia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caecilia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caecilia' 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='Caecilia' 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='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphisbaena' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphisbaena' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphisbaena' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')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='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopoglossus' 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='Alopoglossus' AND (species='angulatus' OR species='angulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alopoglossus' AND (species='angulatus' OR species='angulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopoglossus' 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='Alopoglossus' AND (species='angulatus' OR species='angulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthrosaura' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arthrosaura' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arthrosaura' AND (species='reticulata' OR species='reticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthrosaura' AND (junior_species='reticulata' OR junior_species='reticulata')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='Arthrosaura' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bachia' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bachia' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='flavescens' OR junior_species='flavescens')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='Bachia' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='peruana' OR junior_species='peruana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bachia' AND (species='peruana' OR species='peruana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bachia' AND (species='peruana' OR species='peruana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bachia' AND (junior_species='peruana' OR junior_species='peruana')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='Bachia' AND (species='peruana' OR species='peruana') 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='Anolis' AND (junior_species='fuscoauratus' OR junior_species='fuscoauratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='fuscoauratus' OR junior_species='fuscoauratus')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='Anolis' AND (species='fuscoauratus' OR species='fuscoauratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')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='Anolis' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')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='Anolis' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='trachyderma' OR junior_species='trachyderma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='trachyderma' OR species='trachyderma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='trachyderma' OR species='trachyderma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='trachyderma' OR junior_species='trachyderma')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='Anolis' AND (species='trachyderma' OR species='trachyderma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plica' AND (junior_species='umbra' OR junior_species='umbra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plica' AND (species='umbra' OR species='umbra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plica' AND (species='umbra' OR species='umbra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plica' AND (junior_species='umbra' OR junior_species='umbra')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='Plica' AND (species='umbra' OR species='umbra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonatodes' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonatodes' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='humeralis' OR junior_species='humeralis')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='Gonatodes' AND (species='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='hasemani' OR junior_species='hasemanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonatodes' AND (species='hasemani' OR species='hasemanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonatodes' AND (species='hasemani' OR species='hasemanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatodes' AND (junior_species='hasemani' OR junior_species='hasemanii')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='Gonatodes' AND (species='hasemani' OR species='hasemanii') 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='Kentropyx' AND (junior_species='altamazonica' OR junior_species='altamazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kentropyx' AND (species='altamazonica' OR species='altamazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kentropyx' AND (species='altamazonica' OR species='altamazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kentropyx' AND (junior_species='altamazonica' OR junior_species='altamazonica')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='altamazonica' OR species='altamazonica') 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='Chironius' AND (junior_species='multiventris' OR junior_species='multiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chironius' AND (species='multiventris' OR species='multiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chironius' AND (species='multiventris' OR species='multiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='multiventris' OR junior_species='multiventris')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='multiventris' OR species='multiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymoluber' AND (junior_species='dichrous' OR junior_species='dichrous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymoluber' AND (species='dichrous' OR species='dichrous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymoluber' AND (species='dichrous' OR species='dichrous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymoluber' AND (junior_species='dichrous' OR junior_species='dichrous')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='Drymoluber' AND (species='dichrous' OR species='dichrous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipsas' AND (junior_species='catesbyi' OR junior_species='catesbyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipsas' AND (species='catesbyi' OR species='catesbyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipsas' AND (species='catesbyi' OR species='catesbyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipsas' AND (junior_species='catesbyi' OR junior_species='catesbyii')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='Dipsas' AND (species='catesbyi' OR species='catesbyii') 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='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='Liophis' AND (junior_species='dorsocorallinus' OR junior_species='dorsocorallinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='dorsocorallinus' OR species='dorsocorallinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='dorsocorallinus' OR species='dorsocorallinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='dorsocorallinus' OR junior_species='dorsocorallinus')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='Liophis' AND (species='dorsocorallinus' OR species='dorsocorallinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='argentea' OR junior_species='argentea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodryas' AND (species='argentea' OR species='argentea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodryas' AND (species='argentea' OR species='argentea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodryas' AND (junior_species='argentea' OR junior_species='argentea')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='argentea' OR species='argentea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphlophis' AND (junior_species='compressus' OR junior_species='compressus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siphlophis' AND (species='compressus' OR species='compressus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siphlophis' AND (species='compressus' OR species='compressus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siphlophis' AND (junior_species='compressus' OR junior_species='compressus')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='Siphlophis' AND (species='compressus' OR species='compressus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnodynastes' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnodynastes' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnodynastes' AND (junior_species='pallidus' OR junior_species='pallidus')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='pallidus' OR species='pallidus') 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='Micrurus' AND (junior_species='spixii' OR junior_species='spixi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='spixii' OR species='spixi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='spixii' OR species='spixi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='spixii' OR junior_species='spixi')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='spixii' OR species='spixi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='surinamensis' OR junior_species='surinamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='surinamensis' OR species='surinamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='surinamensis' OR species='surinamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='surinamensis' OR junior_species='surinamensis')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='surinamensis' OR species='surinamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothriopsis' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothriopsis' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothriopsis' AND (species='bilineata' OR species='bilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothriopsis' AND (junior_species='bilineata' OR junior_species='bilineata')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='Bothriopsis' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='atrox' OR junior_species='atrox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='atrox' OR species='atrox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='atrox' OR species='atrox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='atrox' OR junior_species='atrox')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='atrox' OR species='atrox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachesis' AND (junior_species='muta' OR junior_species='muta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachesis' AND (species='muta' OR species='muta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachesis' AND (species='muta' OR species='muta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachesis' AND (junior_species='muta' OR junior_species='muta')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='Lachesis' AND (species='muta' OR species='muta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=426 The Ecological Register: Reserva Extrativista do Rio Gregório
Reserva Extrativista do Rio Gregório
Basic information
Sample name: Reserva Extrativista do Rio Gregório

Reference: D. L. Pantoja and R. de Fraga. 2012. Herpetofauna of the Reserva Extraivista do Rio Gregório, Juruá Basin, southwest Amazonia, Brazil. Check List 8(3):360-374 [ER 203]
Geography
Country: Brazil

State: Amazonas


Coordinate: 7° 24' S, 71° 10' W
Coordinate basis: estimated from map

Geography comments: coordinate estimated from map in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 26.0

CMT: 24.0

MAP: 2500.0

Habitat comments: "open lowland rainforest"
temperature 24 to 26 and precip 2250 to 2750 mm

Methods
Life forms: lizards,snakes,caecilians,frogs

Sampling methods: timed,drift fences,pitfall traps,hand capture

Sample size: 222 individuals

Years: 2009

Sampling comments: pitfall traps with drift fences, time constrained searches, opportunistic captures

Metadata
Sample number: 426

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-16 10:11:07

Modified: 2014-03-19 23:25:54

Abundance distribution
75 species
30 singletons
total count 222
extrapolated richness: 186.6
Fisher's α: 39.827
geometric series k: 0.9535
Hurlbert's PIE: 0.9617
Shannon's H: 3.8805
Good's u: 0.8655
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Allobates sp.6
Rhaebo guttatus1
Rhinella margaritifera34
Rhinella marina4
Ceratophrys cornuta3
Ameerega hahneli5
Ameerega trivittata1
Dendropsophus brevifrons2
Dendropsophus leucophyllatus2
Dendropsophus parviceps2
Dendropsophus minutus5
Hypsiboas boans2
Hypsiboas calcaratus2
Hypsiboas fasciatus4
Hypsiboas geographicus6
Hypsiboas lanciformis4
Hypsiboas punctatus1
Hypsiboas wavrini4
Osteocephalus castaneicola1
Osteocephalus taurinus2
Phyllomedusa palliata1
Scarthyla goinorum3
Scinax boesemani1
Scinax garbei2
Scinax cf. nebulosus1
Scinax ruber4
Edalorhina perezi3
Engystomops freibergi4
Leptodactylus andreae3
Leptodactylus hylaedactylus1
Leptodactylus pentadactylus1
Leptodactylus petersii8
Leptodactylus rhodomystax7
Chiasmocleis bassleri6
Chiasmocleis ventrimaculata1
Hamptophryne boliviana2
Pipa pipa1
Oreobates quixensis4
Pristimantis fenestratus5
Pristimantis ockendeni3
Pristimantis sp. 12
Pristimantis sp. 21
Caecilia sp.1
Amphisbaena fuliginosa1
Alopoglossus angulatus6
Arthrosaura reticulata2
Bachia flavescens1
Bachia peruana2
Iguana iguana2
Anolis fuscoauratus1
Anolis nitens nitens1
Anolis nitens tandai1
Anolis trachyderma8
Plica umbra1
Gonatodes humeralis4
Gonatodes hasemani3
Ameiva ameiva4
Kentropyx altamazonica4
Boa constrictor1
Corallus hortulanus3
Chironius multiventris2
Drymoluber dichrous1
Dipsas catesbyi1
Helicops angulatus1
Imantodes cenchoa2
Liophis dorsocorallinus2
Philodryas argentea1
Siphlophis compressus1
Thamnodynastes pallidus1
Micrurus lemniscatus2
Micrurus spixii1
Micrurus surinamensis1
Bothriopsis bilineata1
Bothrops atrox3
Lachesis muta1