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=582 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=582SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=288SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=582 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaunus' AND (junior_species='marinus' OR junior_species='marinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaunus' AND (species='marinus' OR species='marinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaunus' AND (species='marinus' OR species='marinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaunus' AND (junior_species='marinus' OR junior_species='marinus')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='Chaunus' AND (species='marinus' OR species='marinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ollotis' AND (junior_species='marmorea' OR junior_species='marmorea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ollotis' AND (species='marmorea' OR species='marmorea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ollotis' AND (species='marmorea' OR species='marmorea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ollotis' AND (junior_species='marmorea' OR junior_species='marmorea')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='Ollotis' AND (species='marmorea' OR species='marmorea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exerodonta' AND (junior_species='smaragdina' OR junior_species='smaragdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exerodonta' AND (species='smaragdina' OR species='smaragdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exerodonta' AND (species='smaragdina' OR species='smaragdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exerodonta' AND (junior_species='smaragdina' OR junior_species='smaragdina')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='Exerodonta' AND (species='smaragdina' OR species='smaragdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tlalocohyla' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tlalocohyla' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tlalocohyla' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tlalocohyla' AND (junior_species='smithii' OR junior_species='smithi')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='Tlalocohyla' AND (species='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachymedusa' AND (junior_species='dacnicolor' OR junior_species='dacnicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachymedusa' AND (species='dacnicolor' OR species='dacnicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachymedusa' AND (species='dacnicolor' OR species='dacnicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachymedusa' AND (junior_species='dacnicolor' OR junior_species='dacnicolor')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='Pachymedusa' AND (species='dacnicolor' OR species='dacnicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachycephalus' AND (junior_species='venulosus' OR junior_species='venulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachycephalus' AND (species='venulosus' OR species='venulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachycephalus' AND (species='venulosus' OR species='venulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachycephalus' AND (junior_species='venulosus' OR junior_species='venulosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachycephalus' AND (species='venulosus' OR species='venulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smilisca' AND (junior_species='baudinii' OR junior_species='baudini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smilisca' AND (species='baudinii' OR species='baudini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smilisca' AND (species='baudinii' OR species='baudini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smilisca' AND (junior_species='baudinii' OR junior_species='baudini')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='Smilisca' AND (species='baudinii' OR species='baudini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craugastor' AND (junior_species='hobartsmithi' OR junior_species='hobartsmithii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Craugastor' AND (species='hobartsmithi' OR species='hobartsmithii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Craugastor' AND (species='hobartsmithi' OR species='hobartsmithii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craugastor' AND (junior_species='hobartsmithi' OR junior_species='hobartsmithii')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='Craugastor' AND (species='hobartsmithi' OR species='hobartsmithii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craugastor' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Craugastor' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Craugastor' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craugastor' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Craugastor' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='modestus' OR junior_species='modestus')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='Eleutherodactylus' AND (species='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='nitidus' OR junior_species='nitidus')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='Eleutherodactylus' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='melanonotus' OR junior_species='melanonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='melanonotus' OR species='melanonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='melanonotus' OR species='melanonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='melanonotus' OR junior_species='melanonotus')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='melanonotus' OR species='melanonotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='usta' OR junior_species='usta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastrophryne' AND (species='usta' OR species='usta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastrophryne' AND (species='usta' OR species='usta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='usta' OR junior_species='usta')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='Gastrophryne' AND (species='usta' OR species='usta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypopachus' AND (junior_species='variolosus' OR junior_species='variolosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypopachus' AND (species='variolosus' OR species='variolosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypopachus' AND (species='variolosus' OR species='variolosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypopachus' AND (junior_species='variolosus' OR junior_species='variolosus')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='Hypopachus' AND (species='variolosus' OR species='variolosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='forreri' OR junior_species='forrerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='forreri' OR species='forrerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='forreri' OR species='forrerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='forreri' OR junior_species='forrerii')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='Lithobates' AND (species='forreri' OR species='forrerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhonotus' AND (junior_species='liocephalus' OR junior_species='liocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerrhonotus' AND (species='liocephalus' OR species='liocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerrhonotus' AND (species='liocephalus' OR species='liocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhonotus' AND (junior_species='liocephalus' OR junior_species='liocephalus')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='Gerrhonotus' AND (species='liocephalus' OR species='liocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleonyx' 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='Coleonyx' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coleonyx' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleonyx' 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='Coleonyx' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodactylus' AND (junior_species='lanei' OR junior_species='laneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllodactylus' AND (species='lanei' OR species='laneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllodactylus' AND (species='lanei' OR species='laneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodactylus' AND (junior_species='lanei' OR junior_species='laneii')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='Phyllodactylus' AND (species='lanei' OR species='laneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heloderma' AND (junior_species='horridum' OR junior_species='horridum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heloderma' AND (species='horridum' OR species='horridum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heloderma' AND (species='horridum' OR species='horridum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heloderma' AND (junior_species='horridum' OR junior_species='horridum')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='Heloderma' AND (species='horridum' OR species='horridum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenosaura' AND (junior_species='pectinata' OR junior_species='pectinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenosaura' AND (species='pectinata' OR species='pectinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenosaura' AND (species='pectinata' OR species='pectinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenosaura' AND (junior_species='pectinata' OR junior_species='pectinata')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='Ctenosaura' AND (species='pectinata' OR species='pectinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='melanorhinus' OR junior_species='melanorhinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='melanorhinus' OR species='melanorhinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='melanorhinus' OR species='melanorhinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='melanorhinus' OR junior_species='melanorhinus')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='Sceloporus' AND (species='melanorhinus' OR species='melanorhinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='utiformis' OR junior_species='utiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='utiformis' OR species='utiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='utiformis' OR species='utiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='utiformis' OR junior_species='utiformis')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='Sceloporus' AND (species='utiformis' OR species='utiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urosaurus' AND (junior_species='bicarinatus' OR junior_species='bicarinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urosaurus' AND (species='bicarinatus' OR species='bicarinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urosaurus' AND (species='bicarinatus' OR species='bicarinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urosaurus' AND (junior_species='bicarinatus' OR junior_species='bicarinatus')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='Urosaurus' AND (species='bicarinatus' OR species='bicarinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='nebulosus' OR species='nebulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plestiodon' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plestiodon' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='parvulus' OR junior_species='parvulus')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='Plestiodon' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='assata' OR junior_species='assata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scincella' AND (species='assata' OR species='assata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='assata' OR species='assata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='assata' OR junior_species='assata')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='Scincella' AND (species='assata' OR species='assata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameiva' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameiva' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='undulata' OR junior_species='undulata')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='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='communis' OR junior_species='communis')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='Aspidoscelis' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='lineattissimus' OR junior_species='lineattissimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='lineattissimus' OR species='lineattissimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='lineattissimus' OR species='lineattissimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='lineattissimus' OR junior_species='lineattissimus')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='Aspidoscelis' AND (species='lineattissimus' OR species='lineattissimus') 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='Dipsas' AND (junior_species='gaigeae' OR junior_species='gaigeae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipsas' AND (species='gaigeae' OR species='gaigeae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipsas' AND (species='gaigeae' OR species='gaigeae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipsas' AND (junior_species='gaigeae' OR junior_species='gaigeae')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='gaigeae' OR species='gaigeae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryadophis' AND (junior_species='melanolomus' OR junior_species='melanolomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryadophis' AND (species='melanolomus' OR species='melanolomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryadophis' AND (species='melanolomus' OR species='melanolomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryadophis' AND (junior_species='melanolomus' OR junior_species='melanolomus')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='Dryadophis' AND (species='melanolomus' OR species='melanolomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymarchon' AND (junior_species='corais' OR junior_species='corais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymarchon' AND (species='corais' OR species='corais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymarchon' AND (species='corais' OR species='corais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymarchon' AND (junior_species='corais' OR junior_species='corais')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='Drymarchon' AND (species='corais' OR species='corais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymobius' AND (junior_species='margaritiferus' OR junior_species='margaritiferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymobius' AND (species='margaritiferus' OR species='margaritiferus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymobius' AND (species='margaritiferus' OR species='margaritiferus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymobius' AND (junior_species='margaritiferus' OR junior_species='margaritiferus')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='Drymobius' AND (species='margaritiferus' OR species='margaritiferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodeira' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodeira' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='maculata' OR junior_species='maculata')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='Leptodeira' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='diplotropis' OR junior_species='diplotropis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophis' AND (species='diplotropis' OR species='diplotropis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophis' AND (species='diplotropis' OR species='diplotropis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='diplotropis' OR junior_species='diplotropis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophis' AND (species='diplotropis' OR species='diplotropis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manolepis' AND (junior_species='putnami' OR junior_species='putnamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manolepis' AND (species='putnami' OR species='putnamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manolepis' AND (species='putnami' OR species='putnamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manolepis' AND (junior_species='putnami' OR junior_species='putnamii')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='Manolepis' AND (species='putnami' OR species='putnamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='mentovarius' OR junior_species='mentovarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Masticophis' AND (species='mentovarius' OR species='mentovarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Masticophis' AND (species='mentovarius' OR species='mentovarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='mentovarius' OR junior_species='mentovarius')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='Masticophis' AND (species='mentovarius' OR species='mentovarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxybelis' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxybelis' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='aeneus' OR junior_species='aeneus')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='Oxybelis' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleptodeira' AND (junior_species='uribei' OR junior_species='uribeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoleptodeira' AND (species='uribei' OR species='uribeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoleptodeira' AND (species='uribei' OR species='uribeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleptodeira' AND (junior_species='uribei' OR junior_species='uribeii')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='Pseudoleptodeira' AND (species='uribei' OR species='uribeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Senticolis' AND (junior_species='triaspis' OR junior_species='triaspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Senticolis' AND (species='triaspis' OR species='triaspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Senticolis' AND (species='triaspis' OR species='triaspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Senticolis' AND (junior_species='triaspis' OR junior_species='triaspis')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='Senticolis' AND (species='triaspis' OR species='triaspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulata' OR junior_species='nebulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibon' AND (species='nebulata' OR species='nebulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibon' AND (species='nebulata' OR species='nebulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulata' OR junior_species='nebulata')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='Sibon' AND (species='nebulata' OR species='nebulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='calamarina' OR junior_species='calamarina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='calamarina' OR species='calamarina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='calamarina' OR species='calamarina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='calamarina' OR junior_species='calamarina')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='calamarina' OR species='calamarina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimorphodon' AND (junior_species='biscutatus' OR junior_species='biscutatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimorphodon' AND (species='biscutatus' OR species='biscutatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimorphodon' AND (species='biscutatus' OR species='biscutatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimorphodon' AND (junior_species='biscutatus' OR junior_species='biscutatus')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='Trimorphodon' AND (species='biscutatus' OR species='biscutatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='distans' OR junior_species='distans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrurus' AND (species='distans' OR species='distans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrurus' AND (species='distans' OR species='distans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrurus' AND (junior_species='distans' OR junior_species='distans')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='distans' OR species='distans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxocemus' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxocemus' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxocemus' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxocemus' AND (junior_species='bicolor' OR junior_species='bicolor')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='Loxocemus' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='basiliscus' OR junior_species='basiliscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='basiliscus' OR species='basiliscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='basiliscus' OR species='basiliscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='basiliscus' OR junior_species='basiliscus')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='basiliscus' OR species='basiliscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kinosternon' AND (junior_species='integrum' OR junior_species='integrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kinosternon' AND (species='integrum' OR species='integrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kinosternon' AND (species='integrum' OR species='integrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kinosternon' AND (junior_species='integrum' OR junior_species='integrum')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='Kinosternon' AND (species='integrum' OR species='integrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='rubida' OR junior_species='rubida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinoclemmys' AND (species='rubida' OR species='rubida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinoclemmys' AND (species='rubida' OR species='rubida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='rubida' OR junior_species='rubida')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='Rhinoclemmys' AND (species='rubida' OR species='rubida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='pulcherrima' OR junior_species='pulcherrima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinoclemmys' AND (species='pulcherrima' OR species='pulcherrima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinoclemmys' AND (species='pulcherrima' OR species='pulcherrima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='pulcherrima' OR junior_species='pulcherrima')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='Rhinoclemmys' AND (species='pulcherrima' OR species='pulcherrima') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=582 The Ecological Register: Chamela Biosphere Reserve (conserved)
Chamela Biosphere Reserve (conserved)
Basic information
Sample name: Chamela Biosphere Reserve (conserved)

Reference: I. Suazo-Ortuño, J. Alvarado-Díaz, and M. Martínez-Ramos. 2008. Effects of conversion of dry tropical forest to agricultural mosaic on herpetofaunal assemblages. Conservation Biology 22(2):362-374 [ER 288]
Geography
Country: Mexico

State: Jalisco


Coordinate: 19° 30' N, 105° 3' W
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: biosphere reserve

Substrate: ground surface

MAT: 24.6

MAP: 788.0

Habitat comments: "tropical dry forest"

Methods
Life forms: lizards,snakes,turtles,frogs

Sites: 30

Site area: 3

Sampling methods: belt transect,hand capture

Sample size: 779 individuals

Sampling comments: ten 100 x 10 m plots each in three watersheds
all individuals were captured, marked, and released

Metadata
Sample number: 582

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-26 17:45:56

Modified: 2014-03-26 06:45:56

Abundance distribution
50 species
11 singletons
total count 779
extrapolated richness: 85.4
Fisher's α: 11.919
geometric series k: 0.9017
Hurlbert's PIE: 0.8824
Shannon's H: 2.6555
Good's u: 0.9859
Each square represents a species. Square sizes are proportional to counts.
Register