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=3520 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3520SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3209SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3520 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenotrema' AND (junior_species='hirsutum' OR junior_species='hirsutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenotrema' AND (species='hirsutum' OR species='hirsutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenotrema' AND (species='hirsutum' OR species='hirsutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenotrema' AND (junior_species='hirsutum' OR junior_species='hirsutum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenotrema' AND (species='hirsutum' OR species='hirsutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='thyroidus' OR junior_species='thyroidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodon' AND (species='thyroidus' OR species='thyroidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesodon' AND (species='thyroidus' OR species='thyroidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='thyroidus' OR junior_species='thyroidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodon' AND (species='thyroidus' OR species='thyroidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='clausus' OR junior_species='clausus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodon' AND (species='clausus' OR species='clausus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesodon' AND (species='clausus' OR species='clausus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='clausus' OR junior_species='clausus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodon' AND (species='clausus' OR species='clausus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='inflectus' OR junior_species='inflectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodon' AND (species='inflectus' OR species='inflectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesodon' AND (species='inflectus' OR species='inflectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesodon' AND (junior_species='inflectus' OR junior_species='inflectus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodon' AND (species='inflectus' OR species='inflectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triodopsis' AND (junior_species='fosteri' OR junior_species='fosterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triodopsis' AND (species='fosteri' OR species='fosterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triodopsis' AND (species='fosteri' OR species='fosterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triodopsis' AND (junior_species='fosteri' OR junior_species='fosterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triodopsis' AND (species='fosteri' OR species='fosterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triodopsis' AND (junior_species='albolabris' OR junior_species='albolabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triodopsis' AND (species='albolabris' OR species='albolabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triodopsis' AND (species='albolabris' OR species='albolabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triodopsis' AND (junior_species='albolabris' OR junior_species='albolabris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triodopsis' AND (species='albolabris' OR species='albolabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplotrema' AND (junior_species='concavum' OR junior_species='concavum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplotrema' AND (species='concavum' OR species='concavum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplotrema' AND (species='concavum' OR species='concavum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplotrema' AND (junior_species='concavum' OR junior_species='concavum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Haplotrema' AND (species='concavum' OR species='concavum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hawaiia' AND (junior_species='minuscula' OR junior_species='minuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hawaiia' AND (species='minuscula' OR species='minuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hawaiia' AND (species='minuscula' OR species='minuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hawaiia' AND (junior_species='minuscula' OR junior_species='minuscula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hawaiia' AND (species='minuscula' OR species='minuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonitoides' 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='Zonitoides' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonitoides' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonitoides' 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='Zonitoides' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguispira' AND (junior_species='alternata' OR junior_species='alternata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguispira' AND (species='alternata' OR species='alternata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguispira' AND (species='alternata' OR species='alternata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguispira' AND (junior_species='alternata' OR junior_species='alternata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anguispira' AND (species='alternata' OR species='alternata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguispira' AND (junior_species='kochi' OR junior_species='kochii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguispira' AND (species='kochi' OR species='kochii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguispira' AND (species='kochi' OR species='kochii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguispira' AND (junior_species='kochi' OR junior_species='kochii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anguispira' AND (species='kochi' OR species='kochii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='cronkhitei' OR junior_species='cronkhiteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discus' AND (species='cronkhitei' OR species='cronkhiteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discus' AND (species='cronkhitei' OR species='cronkhiteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='cronkhitei' OR junior_species='cronkhiteii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discus' AND (species='cronkhitei' OR species='cronkhiteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='patulus' OR junior_species='patulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discus' AND (species='patulus' OR species='patulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discus' AND (species='patulus' OR species='patulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='patulus' OR junior_species='patulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discus' AND (species='patulus' OR species='patulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicodiscus' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicodiscus' AND (species='parallelus' OR species='parallelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicodiscus' AND (species='parallelus' OR species='parallelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicodiscus' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicodiscus' AND (species='parallelus' OR species='parallelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physa' AND (junior_species='gyrina' OR junior_species='gyrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physa' AND (species='gyrina' OR species='gyrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physa' AND (species='gyrina' OR species='gyrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physa' AND (junior_species='gyrina' OR junior_species='gyrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Physa' AND (species='gyrina' OR species='gyrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amia' AND (junior_species='calva' OR junior_species='calva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amia' AND (species='calva' OR species='calva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amia' AND (species='calva' OR species='calva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amia' AND (junior_species='calva' OR junior_species='calva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amia' AND (species='calva' OR species='calva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisosteus' 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='Lepisosteus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepisosteus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisosteus' 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='Lepisosteus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictiobus' 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='Ictiobus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictiobus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictiobus' 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='Ictiobus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyprinidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyprinidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyprinidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictalurus' AND (junior_species='melas' OR junior_species='melas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictalurus' AND (species='melas' OR species='melas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictalurus' AND (species='melas' OR species='melas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictalurus' AND (junior_species='melas' OR junior_species='melas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ictalurus' AND (species='melas' OR species='melas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centrarchidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centrarchidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centrarchidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centrarchidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centrarchidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='texanus' OR junior_species='texanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='texanus' OR species='texanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='texanus' OR species='texanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='texanus' OR junior_species='texanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ambystoma' AND (species='texanus' OR species='texanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ambystoma' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='tigrinum' OR junior_species='tigrinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='tigrinum' OR species='tigrinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='tigrinum' OR species='tigrinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='tigrinum' OR junior_species='tigrinum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ambystoma' AND (species='tigrinum' OR species='tigrinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plethodon' AND (junior_species='glutinosus' OR junior_species='glutinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plethodon' AND (species='glutinosus' OR species='glutinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plethodon' AND (species='glutinosus' OR species='glutinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plethodon' AND (junior_species='glutinosus' OR junior_species='glutinosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plethodon' AND (species='glutinosus' OR species='glutinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycea' 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='Eurycea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurycea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycea' 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='Eurycea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siren' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siren' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siren' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siren' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Siren' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphiopus' AND (junior_species='holbrooki' OR junior_species='holbrookii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scaphiopus' AND (species='holbrooki' OR species='holbrookii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scaphiopus' AND (species='holbrooki' OR species='holbrookii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaphiopus' AND (junior_species='holbrooki' OR junior_species='holbrookii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scaphiopus' AND (species='holbrooki' OR species='holbrookii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaxyrus' 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='Anaxyrus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anaxyrus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaxyrus' 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='Anaxyrus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyla' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='catesbeianus' OR junior_species='catesbeianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='catesbeianus' OR species='catesbeianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='catesbeianus' OR species='catesbeianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='catesbeianus' OR junior_species='catesbeianus')SELECT d.diet,d.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='catesbeianus' OR species='catesbeianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='pipiens' OR junior_species='pipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='pipiens' OR species='pipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='pipiens' OR species='pipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='pipiens' OR junior_species='pipiens')SELECT d.diet,d.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='pipiens' OR species='pipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastrophryne' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastrophryne' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT d.diet,d.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='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelydra' AND (junior_species='serpentina' OR junior_species='serpentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chelydra' AND (species='serpentina' OR species='serpentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chelydra' AND (species='serpentina' OR species='serpentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelydra' AND (junior_species='serpentina' OR junior_species='serpentina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chelydra' AND (species='serpentina' OR species='serpentina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sternotherus' AND (junior_species='odoratus' OR junior_species='odoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sternotherus' AND (species='odoratus' OR species='odoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sternotherus' AND (species='odoratus' OR species='odoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sternotherus' AND (junior_species='odoratus' OR junior_species='odoratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sternotherus' AND (species='odoratus' OR species='odoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terrapene' 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='Terrapene' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terrapene' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terrapene' 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='Terrapene' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachemys' 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='Trachemys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachemys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachemys' 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='Trachemys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalone' 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='Apalone' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalone' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalone' 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='Apalone' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT d.diet,d.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='undulatus' OR species='undulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemidophorus' AND (junior_species='sexlineatus' OR junior_species='sexlineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemidophorus' AND (species='sexlineatus' OR species='sexlineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemidophorus' AND (species='sexlineatus' OR species='sexlineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemidophorus' AND (junior_species='sexlineatus' OR junior_species='sexlineatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cnemidophorus' AND (species='sexlineatus' OR species='sexlineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='laticeps' OR species='laticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='laticeps' OR species='laticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eumeces' AND (species='laticeps' OR species='laticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='platirhinos' OR junior_species='platirhinos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterodon' AND (species='platirhinos' OR species='platirhinos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterodon' AND (species='platirhinos' OR species='platirhinos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='platirhinos' OR junior_species='platirhinos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heterodon' AND (species='platirhinos' OR species='platirhinos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' 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='Coluber' AND (species='constrictor' OR species='constrictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coluber' AND (species='constrictor' OR species='constrictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' 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='Coluber' AND (species='constrictor' OR species='constrictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Masticophis' AND (species='flagellum' OR species='flagellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Masticophis' AND (species='flagellum' OR species='flagellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')SELECT d.diet,d.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='flagellum' OR species='flagellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaphe' AND (species='guttata' OR species='guttata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='obsoleta' OR junior_species='obsoleta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='obsoleta' OR species='obsoleta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='obsoleta' OR species='obsoleta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='obsoleta' OR junior_species='obsoleta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaphe' AND (species='obsoleta' OR species='obsoleta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='melanoleucus' OR junior_species='melanoleucus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pituophis' AND (species='melanoleucus' OR species='melanoleucus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pituophis' AND (species='melanoleucus' OR species='melanoleucus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pituophis' AND (junior_species='melanoleucus' OR junior_species='melanoleucus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pituophis' AND (species='melanoleucus' OR species='melanoleucus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' 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='Lampropeltis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropeltis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' 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='Lampropeltis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnophis' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='erythrogaster' OR species='erythrogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nerodia' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='rhombifer' OR junior_species='rhombifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='rhombifer' OR species='rhombifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='rhombifer' OR species='rhombifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='rhombifer' OR junior_species='rhombifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nerodia' AND (species='rhombifer' OR species='rhombifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='sipedon' OR junior_species='sipedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='sipedon' OR species='sipedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='sipedon' OR species='sipedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='sipedon' OR junior_species='sipedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nerodia' AND (species='sipedon' OR species='sipedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='contortix' OR junior_species='contortix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agkistrodon' AND (species='contortix' OR species='contortix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agkistrodon' AND (species='contortix' OR species='contortix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='contortix' OR junior_species='contortix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agkistrodon' AND (species='contortix' OR species='contortix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='horridus' OR junior_species='horridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='horridus' OR species='horridus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='horridus' OR species='horridus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='horridus' OR junior_species='horridus')SELECT d.diet,d.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='horridus' OR species='horridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botaurus' AND (junior_species='lentiginosus' OR junior_species='lentiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Botaurus' AND (species='lentiginosus' OR species='lentiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Botaurus' AND (species='lentiginosus' OR species='lentiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botaurus' AND (junior_species='lentiginosus' OR junior_species='lentiginosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Botaurus' AND (species='lentiginosus' OR species='lentiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chen' 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='Chen' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chen' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chen' 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='Chen' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' 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='Anas' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' 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='Anas' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophodytes' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophodytes' AND (species='cucullatus' OR species='cucullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophodytes' AND (species='cucullatus' OR species='cucullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophodytes' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophodytes' AND (species='cucullatus' OR species='cucullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cathartes' AND (junior_species='aura' OR junior_species='aura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cathartes' AND (species='aura' OR species='aura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cathartes' AND (species='aura' OR species='aura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cathartes' AND (junior_species='aura' OR junior_species='aura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cathartes' AND (species='aura' OR species='aura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coragyps' AND (junior_species='atratus' OR junior_species='atratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coragyps' AND (species='atratus' OR species='atratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coragyps' AND (species='atratus' OR species='atratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coragyps' AND (junior_species='atratus' OR junior_species='atratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coragyps' AND (species='atratus' OR species='atratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='jamaicensis' OR species='jamaicensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Buteo' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falco' AND (junior_species='sparverius' OR junior_species='sparverius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falco' AND (species='sparverius' OR species='sparverius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falco' AND (species='sparverius' OR species='sparverius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falco' AND (junior_species='sparverius' OR junior_species='sparverius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Falco' AND (species='sparverius' OR species='sparverius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colinus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colinus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colinus' AND (species='virginianus' OR species='virginianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colinus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colinus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meleagris' AND (species='gallopavo' OR species='gallopavo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='carolina' OR junior_species='carolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porzana' AND (species='carolina' OR species='carolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porzana' AND (species='carolina' OR species='carolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='carolina' OR junior_species='carolina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Porzana' AND (species='carolina' OR species='carolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fulica' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fulica' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fulica' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectopistes' AND (junior_species='migratorius' OR junior_species='migratorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectopistes' AND (species='migratorius' OR species='migratorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectopistes' AND (species='migratorius' OR species='migratorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectopistes' AND (junior_species='migratorius' OR junior_species='migratorius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectopistes' AND (species='migratorius' OR species='migratorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayornis' AND (junior_species='phoebe' OR junior_species='phoebe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sayornis' AND (species='phoebe' OR species='phoebe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sayornis' AND (species='phoebe' OR species='phoebe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayornis' AND (junior_species='phoebe' OR junior_species='phoebe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sayornis' AND (species='phoebe' OR species='phoebe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' 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='Empidonax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' 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='Empidonax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='crinitus' OR junior_species='crinitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='crinitus' OR species='crinitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='crinitus' OR species='crinitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='crinitus' OR junior_species='crinitus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiarchus' AND (species='crinitus' OR species='crinitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' 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='Troglodytes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' 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='Troglodytes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' 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='Hylocichla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocichla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' 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='Hylocichla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sialia' AND (junior_species='sialis' OR junior_species='sialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sialia' AND (species='sialis' OR species='sialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sialia' AND (species='sialis' OR species='sialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sialia' AND (junior_species='sialis' OR junior_species='sialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sialia' AND (species='sialis' OR species='sialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombycilla' AND (junior_species='cedrorum' OR junior_species='cedrorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombycilla' AND (species='cedrorum' OR species='cedrorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombycilla' AND (species='cedrorum' OR species='cedrorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombycilla' AND (junior_species='cedrorum' OR junior_species='cedrorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombycilla' AND (species='cedrorum' OR species='cedrorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' 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='Setophaga' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' 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='Setophaga' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quiscalus' AND (species='quiscula' OR species='quiscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quiscalus' AND (species='quiscula' OR species='quiscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quiscalus' AND (species='quiscula' OR species='quiscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='cardinalis' OR junior_species='cardinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='cardinalis' OR junior_species='cardinalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cardinalis' AND (species='cardinalis' OR species='cardinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='domesticus' OR junior_species='domesticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='domesticus' OR species='domesticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='domesticus' OR species='domesticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='domesticus' OR junior_species='domesticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passer' AND (species='domesticus' OR species='domesticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxia' 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='Loxia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxia' 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='Loxia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spiza' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spiza' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spiza' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spiza' AND (junior_species='americana' OR junior_species='americana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spiza' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='erythrophthalmus' OR junior_species='erythrophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='erythrophthalmus' OR junior_species='erythrophthalmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junco' AND (species='hyemalis' OR species='hyemalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='virginiana' OR species='virginiana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Didelphis' AND (species='virginiana' OR species='virginiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopus' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scalopus' AND (species='aquaticus' OR species='aquaticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopus' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scalopus' AND (species='aquaticus' OR species='aquaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='longirostris' OR junior_species='longirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='longirostris' OR species='longirostris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='longirostris' OR junior_species='longirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorex' AND (species='longirostris' OR species='longirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='hoyi' OR junior_species='hoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='hoyi' OR species='hoyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='hoyi' OR junior_species='hoyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorex' AND (species='hoyi' OR species='hoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptotis' AND (junior_species='parva' OR junior_species='parva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptotis' AND (species='parva' OR species='parva') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptotis' AND (junior_species='parva' OR junior_species='parva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptotis' AND (species='parva' OR species='parva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myotis' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perimyotis' AND (junior_species='subflavus' OR junior_species='subflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perimyotis' AND (species='subflavus' OR species='subflavus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perimyotis' AND (junior_species='subflavus' OR junior_species='subflavus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perimyotis' AND (species='subflavus' OR species='subflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eptesicus' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eptesicus' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plecotus' 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='Plecotus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plecotus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plecotus' 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='Plecotus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='nivalis' OR species='nivalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mustela' AND (species='nivalis' OR species='nivalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='frenata' OR junior_species='frenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neogale' AND (species='frenata' OR species='frenata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='frenata' OR junior_species='frenata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neogale' AND (species='frenata' OR species='frenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neogale' AND (species='vison' OR species='vison') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neogale' AND (species='vison' OR species='vison') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lontra' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lontra' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lontra' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lontra' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilogale' AND (junior_species='putorius' OR junior_species='putorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilogale' AND (species='putorius' OR species='putorius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilogale' AND (junior_species='putorius' OR junior_species='putorius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spilogale' AND (species='putorius' OR species='putorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitis' AND (junior_species='mephitis' OR junior_species='mephitis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mephitis' AND (species='mephitis' OR species='mephitis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitis' AND (junior_species='mephitis' OR junior_species='mephitis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mephitis' AND (species='mephitis' OR species='mephitis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taxidea' AND (junior_species='taxus' OR junior_species='taxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taxidea' AND (species='taxus' OR species='taxus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taxidea' AND (junior_species='taxus' OR junior_species='taxus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taxidea' AND (species='taxus' OR species='taxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocyon' AND (junior_species='cinereoargenteus' OR junior_species='cinereoargenteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urocyon' AND (species='cinereoargenteus' OR species='cinereoargenteus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocyon' AND (junior_species='cinereoargenteus' OR junior_species='cinereoargenteus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urocyon' AND (species='cinereoargenteus' OR species='cinereoargenteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Puma' AND (junior_species='concolor' OR junior_species='concolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Puma' AND (species='concolor' OR species='concolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Puma' AND (junior_species='concolor' OR junior_species='concolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Puma' AND (species='concolor' OR species='concolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lynx' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='monax' OR junior_species='monax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='monax' OR species='monax') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='monax' OR junior_species='monax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marmota' AND (species='monax' OR species='monax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamias' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tamias' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucomys' AND (junior_species='volans' OR junior_species='volans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucomys' AND (species='volans' OR species='volans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucomys' AND (junior_species='volans' OR junior_species='volans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glaucomys' AND (species='volans' OR species='volans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geomys' AND (junior_species='bursarius' OR junior_species='bursarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geomys' AND (species='bursarius' OR species='bursarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geomys' AND (species='bursarius' OR species='bursarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geomys' AND (junior_species='bursarius' OR junior_species='bursarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geomys' AND (species='bursarius' OR species='bursarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peromyscus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peromyscus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzomys' AND (junior_species='palustris' OR junior_species='palustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryzomys' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzomys' AND (junior_species='palustris' OR junior_species='palustris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oryzomys' AND (species='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='floridana' OR junior_species='floridana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotoma' AND (species='floridana' OR species='floridana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='floridana' OR junior_species='floridana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neotoma' AND (species='floridana' OR species='floridana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synaptomys' AND (junior_species='cooperi' OR junior_species='cooperii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synaptomys' AND (species='cooperi' OR species='cooperii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synaptomys' AND (junior_species='cooperi' OR junior_species='cooperii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synaptomys' AND (species='cooperi' OR species='cooperii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='gapperi' OR junior_species='gapperii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='gapperi' OR species='gapperii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='gapperi' OR junior_species='gapperii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myodes' AND (species='gapperi' OR species='gapperii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='xanthognathus' OR junior_species='xanthognathus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='xanthognathus' OR species='xanthognathus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='xanthognathus' OR junior_species='xanthognathus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microtus' AND (species='xanthognathus' OR species='xanthognathus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pinetorum' OR junior_species='pinetorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='pinetorum' OR species='pinetorum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pinetorum' OR junior_species='pinetorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microtus' AND (species='pinetorum' OR species='pinetorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ondatra' AND (junior_species='zibethicus' OR junior_species='zibethicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ondatra' AND (species='zibethicus' OR species='zibethicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ondatra' AND (junior_species='zibethicus' OR junior_species='zibethicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ondatra' AND (species='zibethicus' OR species='zibethicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zapus' AND (species='hudsonius' OR species='hudsonius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zapus' AND (species='hudsonius' OR species='hudsonius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3520 The Ecological Register: Meyer Cave
Meyer Cave
Basic information
Sample name: Meyer Cave

Reference: P. W. Parmalee. 1967. A recent cave bone deposit in southwestern Illinois. Bulletin of the National Speleological Society 29(4):119-147 [ER 3209]
Geography
Country: United States

State: Illinois


Coordinate: 38.40° N, -90.26° W
Coordinate basis: stated in text

Time interval: Holocene

Ma: 0.00104

Age basis: radiocarbon (uncalibrated)

Geography comments: "in the limestone bluff of the Mississippi River four miles south-southwest of Columbia... N.W. 1/4 Sec. 6, T. 2 S., R. 10 W."
there is a radiocarbon date of "1040 +/- 150 B.P." on charcoal (presumed to be uncalibrated because the error is symmetrically distributed)

Environment
Lithology: limestone

Taphonomic context: cave,pitfall trap

Archaeology: ceramics,hearths,stone tools

Habitat comments: "debris fill, composed of pieces of limestone, soil and bone... some predators probably used the small room above the lower fissure" where the fossil were found, but this is "one basic, although probably not major, source of the bone deposits. In all probability, the majority of the bone accumulated as a result of animals entering through openings from the outside and accidentally falling into the fissure"
"artifacts, as well as human (Indian?) remains" were present and artifacts include a projectile point, 30 Late Woodland sherds, flakes and small fragments of charcoal that "may have resulted from a man-made fire"

Methods
Life forms: bats,carnivores,primates,rodents,ungulates,other small mammals,birds,lizards,snakes,turtles,frogs,salamanders,fishes,snails

Sampling methods: quarry,screenwash,surface

Sample size: 78407 specimens

Years: 1959 - 1961

Sampling comments: "Surface bone was recovered during the first visit" but most bone was excavated and "washed"
beetles and other arthropods are listed but not counted

Metadata
Sample number: 3520

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-11 11:06:21

Modified: 2023-04-03 08:56:35

Abundance distribution
129 species
20 singletons
total count 78407
extrapolated richness: 174.4
Fisher's α: 15.076
geometric series k: 0.9289
Hurlbert's PIE: 0.9050
Shannon's H: 2.7340
Good's u: 0.9997
Each square represents a species. Square sizes are proportional to counts.
Register
Stenotrema hirsutum16
Mesodon thyroidus1
Mesodon clausus1
Mesodon inflectus95
Triodopsis fosteri346
Triodopsis albolabris3
Haplotrema concavum13
Hawaiia minuscula1
Zonitoides nitidus182
Anguispira alternata18
Anguispira kochi17
Discus cronkhitei anthonyi1
Discus patulus53
Helicodiscus parallelus65
Physa gyrina1
Amia calva10
Lepisosteus sp.130
Ictiobus sp.4
Cyprinidae indet.2
Ictalurus melas8
Centrarchidae indet.4
Ambystoma cf. texanus13
Ambystoma cf. maculatus73
Ambystoma tigrinum1822
Plethodon glutinosus2
Eurycea sp.3
Siren cf. intermedia29
Scaphiopus cf. holbrooki566
Anaxyrus sp.413
"Bufo sp."
Hyla cf. versicolor11
Lithobates catesbeianus973
"Rana catesbeiana"
Lithobates pipiens10272
"Rana pipiens"
Gastrophryne carolinensis2
Chelydra serpentina2
Sternotherus odoratus2
Terrapene sp.80
Trachemys sp.9
"Pseudemys sp." ("slider")
Apalone sp.5
"Trionyx sp."
Sceloporus undulatus1
Cnemidophorus sexlineatus4
Eumeces laticeps9
Heterodon cf. platirhinos10
compared to "Heterodon platyrhinos"
Coluber constrictor1804
Masticophis ? flagellum4
Elaphe cf. guttata25
Elaphe obsoleta123
Pituophis melanoleucus14
Lampropeltis sp.14
Thamnophis spp.6
Nerodia erythrogaster26
"Natrix erythrogaster"
Nerodia rhombifer1
"Natrix rhombifera"
Nerodia sipedon2
"Natrix sipedon"
Agkistrodon contortix321
Crotalus horridus3894
Botaurus lentiginosus1706 g piscivore
Chen sp.2
Anas sp.1
Lophodytes cucullatus1554 g piscivore
Cathartes aura4110.7 g carnivore
Coragyps atratus940.5 g carnivore
Buteo cf. jamaicensis330.4 g carnivore
Falco sparverius112.7 g carnivore
Colinus virginianus3912.9 g granivore
Meleagris gallopavo37.8 kg omnivore
Porzana carolina7174.8 g granivore
Fulica americana3724 g
Ectopistes migratorius3
Colaptes cf. auratus2311.3 g insectivore-frugivore
Sayornis cf. phoebe119.7 g insectivore
Empidonax sp.1
Myiarchus crinitus132.1 g frugivore-insectivore
Troglodytes sp.3
Hylocichla sp.4
Sialia sialis127.5 g insectivore
Bombycilla cedrorum230.6 g insectivore-frugivore
Vireo cf. olivaceus12.6 g insectivore-frugivore
Setophaga sp.1
"Dendroica sp."
Seiurus cf. aurocapilla118.8 g insectivore
"Seiurus cf. aurocapillus"
Quiscalus quiscula9120 g insectivore-granivore
Cardinalis cardinalis443.5 g insectivore-granivore
"Richmondena cardinalis"
Passer domesticus14.9 g granivore
Loxia sp.3
Spiza ? americana15.3 g
Pipilo erythrophthalmus1741.3 g insectivore-granivore
Junco cf. hyemalis91.6 g insectivore-granivore
Didelphis virginiana58532.2 kg insectivore-carnivore
"Didelphis marsupialis"
Scalopus aquaticus27294.9 g
Sorex cf. longirostris514.2 g
Sorex hoyi22.8 g
"Microsorex hoyi"
Blarina brevicauda104715.1 g
Cryptotis parva26094.3 g
Myotis spp.124
Perimyotis subflavus225.6 g insectivore
"Pipistrellus subflavus"
Eptesicus fuscus15317.2 g insectivore
Plecotus sp.14
Procyon lotor5205.5 kg carnivore-granivore
Mustela nivalis377.5 g carnivore
"Mustela rixosa"
Neogale cf. frenata124144 g carnivore
"Mustela frenata"
Neogale vison433950 g
"Mustela vison"
Lontra canadensis2017.1 kg piscivore
"Lutra canadensis"
Spilogale putorius306633 g carnivore-invertivore
Mephitis mephitis48491.5 kg carnivore-insectivore
Taxidea taxus207.0 kg carnivore
Vulpes vulpes125.3 kg carnivore-insectivore
"Vulpes fulva"
Urocyon cinereoargenteus814.1 kg frugivore-carnivore
Canis lupus familiaris643 kg carnivore
"Canis familiaris"
Puma concolor449 kg carnivore
"Felis concolor"
Lynx cf. rufus1459.0 kg carnivore
Marmota monax126004.5 kg
Tamias striatus1573113 g frugivore-insectivore
Sciurus carolinensis55519 g frugivore
Glaucomys volans1067.4 g
Geomys bursarius29
Peromyscus spp.11922
Oryzomys palustris3042.4 g
Neotoma floridana6053252 g
Synaptomys cooperi21029.0 g
Myodes cf. gapperi324.1 g
"Clethrionomys cf. gapperi"
Microtus pennsylvanicus2135.7 g
Microtus xanthognathus1368.5 g
Microtus pinetorum2624.0 g
"Pitymys pinetorum"
Ondatra zibethicus841.1 kg
"Ondatra zibethica"
Mus musculus217.6 g
Zapus hudsonius115.6 g
Erethizon dorsatum849.9 kg herbivore
"Erethizon dorsatus"
Sylvilagus floridanus69471.1 kg herbivore
Odocoileus virginianus9975 kg herbivore
Sus scrofa454 kg herbivore
Homo sapiens1364 kg