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=1538 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1538SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1037SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1538 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='koikei' OR junior_species='koikeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='koikei' OR species='koikeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='koikei' OR species='koikeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='koikei' OR junior_species='koikeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bembidion' AND (species='koikei' OR species='koikeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='pseudolucillum' OR junior_species='pseudolucillum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='pseudolucillum' OR species='pseudolucillum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='pseudolucillum' OR species='pseudolucillum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='pseudolucillum' OR junior_species='pseudolucillum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bembidion' AND (species='pseudolucillum' OR species='pseudolucillum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='exarata' OR junior_species='exarata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyura' AND (species='exarata' OR species='exarata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyura' AND (species='exarata' OR species='exarata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='exarata' OR junior_species='exarata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyura' AND (species='exarata' OR species='exarata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyura' AND (species='fuscicauda' OR species='fuscicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyura' AND (species='fuscicauda' OR species='fuscicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyura' AND (species='fuscicauda' OR species='fuscicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='nana' OR junior_species='nana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyura' AND (species='nana' OR species='nana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyura' AND (species='nana' OR species='nana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='nana' OR junior_species='nana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyura' AND (species='nana' OR species='nana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='tosta' OR junior_species='tosta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyura' AND (species='tosta' OR species='tosta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyura' AND (species='tosta' OR species='tosta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyura' AND (junior_species='tosta' OR junior_species='tosta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyura' AND (species='tosta' OR species='tosta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheropsophus' AND (junior_species='jessoensis' OR junior_species='jessoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheropsophus' AND (species='jessoensis' OR species='jessoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheropsophus' AND (species='jessoensis' OR species='jessoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheropsophus' AND (junior_species='jessoensis' OR junior_species='jessoensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheropsophus' AND (species='jessoensis' OR species='jessoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='dehaanii' OR junior_species='dehaani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='dehaanii' OR species='dehaani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='dehaanii' OR species='dehaani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='dehaanii' OR junior_species='dehaani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='dehaanii' OR species='dehaani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='maiyasanus' OR junior_species='maiyasanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='maiyasanus' OR species='maiyasanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='maiyasanus' OR species='maiyasanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='maiyasanus' OR junior_species='maiyasanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='maiyasanus' OR species='maiyasanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptocarabus' AND (junior_species='procerulus' OR junior_species='procerulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptocarabus' AND (species='procerulus' OR species='procerulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptocarabus' AND (species='procerulus' OR species='procerulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptocarabus' AND (junior_species='procerulus' OR junior_species='procerulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptocarabus' AND (species='procerulus' OR species='procerulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='japana' OR junior_species='japana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cicindela' AND (species='japana' OR species='japana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cicindela' AND (species='japana' OR species='japana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='japana' OR junior_species='japana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cicindela' AND (species='japana' OR species='japana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='ovipennis' OR junior_species='ovipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cicindela' AND (species='ovipennis' OR species='ovipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cicindela' AND (species='ovipennis' OR species='ovipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicindela' AND (junior_species='ovipennis' OR junior_species='ovipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cicindela' AND (species='ovipennis' OR species='ovipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='eous' OR junior_species='eous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='eous' OR species='eous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='eous' OR species='eous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='eous' OR junior_species='eous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpalus' AND (species='eous' OR species='eous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='jureceki' OR junior_species='jurecekii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='jureceki' OR species='jurecekii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='jureceki' OR species='jurecekii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='jureceki' OR junior_species='jurecekii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpalus' AND (species='jureceki' OR species='jurecekii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='sinicus' OR junior_species='sinicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='sinicus' OR species='sinicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='sinicus' OR species='sinicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='sinicus' OR junior_species='sinicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpalus' AND (species='sinicus' OR species='sinicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxycentrus' AND (junior_species='argutoroides' OR junior_species='argutoroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxycentrus' AND (species='argutoroides' OR species='argutoroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxycentrus' AND (species='argutoroides' OR species='argutoroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxycentrus' AND (junior_species='argutoroides' OR junior_species='argutoroides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxycentrus' AND (species='argutoroides' OR species='argutoroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichotichnus' AND (junior_species='longitarsis' OR junior_species='longitarsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichotichnus' AND (species='longitarsis' OR species='longitarsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichotichnus' AND (species='longitarsis' OR species='longitarsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichotichnus' AND (junior_species='longitarsis' OR junior_species='longitarsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichotichnus' AND (species='longitarsis' OR species='longitarsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='congrius' OR junior_species='congrius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenolophus' AND (species='congrius' OR species='congrius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenolophus' AND (species='congrius' OR species='congrius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='congrius' OR junior_species='congrius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenolophus' AND (species='congrius' OR species='congrius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='punctatipennis' OR junior_species='punctatipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='punctatipennis' OR junior_species='punctatipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='sadoensis' OR junior_species='sadoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisodactylus' AND (species='sadoensis' OR species='sadoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisodactylus' AND (species='sadoensis' OR species='sadoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='sadoensis' OR junior_species='sadoensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisodactylus' AND (species='sadoensis' OR species='sadoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='congrua' OR junior_species='congrua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='congrua' OR species='congrua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='congrua' OR species='congrua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='congrua' OR junior_species='congrua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amara' AND (species='congrua' OR species='congrua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='(Morawitz)' OR junior_species='(Morawitz)')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='(Morawitz)' OR species='(Morawitz)') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='(Morawitz)' OR species='(Morawitz)')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='(Morawitz)' OR junior_species='(Morawitz)')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amara' AND (species='(Morawitz)' OR species='(Morawitz)') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='bipustulatus' OR junior_species='bipustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Badister' AND (species='bipustulatus' OR species='bipustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Badister' AND (species='bipustulatus' OR species='bipustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='bipustulatus' OR junior_species='bipustulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Badister' AND (species='bipustulatus' OR species='bipustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parabroscus' AND (junior_species='crassipalpis' OR junior_species='crassipalpis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parabroscus' AND (species='crassipalpis' OR species='crassipalpis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parabroscus' AND (species='crassipalpis' OR species='crassipalpis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parabroscus' AND (junior_species='crassipalpis' OR junior_species='crassipalpis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parabroscus' AND (species='crassipalpis' OR species='crassipalpis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='hasegawai' OR junior_species='hasegawaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platynus' AND (species='hasegawai' OR species='hasegawaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platynus' AND (species='hasegawai' OR species='hasegawaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='hasegawai' OR junior_species='hasegawaii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platynus' AND (species='hasegawai' OR species='hasegawaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='takabai' OR junior_species='takabaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platynus' AND (species='takabai' OR species='takabaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platynus' AND (species='takabai' OR species='takabaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='takabai' OR junior_species='takabaii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platynus' AND (species='takabai' OR species='takabaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='thoreyii' OR junior_species='thoreyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platynus' AND (species='thoreyii' OR species='thoreyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platynus' AND (species='thoreyii' OR species='thoreyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='thoreyii' OR junior_species='thoreyi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platynus' AND (species='thoreyii' OR species='thoreyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='arcuaticollis' OR junior_species='arcuaticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='arcuaticollis' OR junior_species='arcuaticollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='crocatus' OR junior_species='crocatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='crocatus' OR species='crocatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='crocatus' OR species='crocatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='crocatus' OR junior_species='crocatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='crocatus' OR species='crocatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='cycloderus' OR junior_species='cycloderus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='cycloderus' OR species='cycloderus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='cycloderus' OR species='cycloderus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='cycloderus' OR junior_species='cycloderus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='cycloderus' OR species='cycloderus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='difficilis' OR junior_species='difficilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='difficilis' OR species='difficilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='difficilis' OR species='difficilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='difficilis' OR junior_species='difficilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='difficilis' OR species='difficilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='dulcigradus' OR junior_species='dulcigradus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='dulcigradus' OR species='dulcigradus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='dulcigradus' OR species='dulcigradus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='dulcigradus' OR junior_species='dulcigradus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='dulcigradus' OR species='dulcigradus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='melantho' OR junior_species='melantho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='melantho' OR species='melantho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='melantho' OR species='melantho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='melantho' OR junior_species='melantho')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synuchus' AND (species='melantho' OR species='melantho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' 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='Synuchus' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' 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='Synuchus' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestichus' AND (junior_species='magnus' OR junior_species='magnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestichus' AND (species='magnus' OR species='magnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestichus' AND (species='magnus' OR species='magnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestichus' AND (junior_species='magnus' OR junior_species='magnus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lestichus' AND (species='magnus' OR species='magnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='haptoroides' OR junior_species='haptoroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='haptoroides' OR species='haptoroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='haptoroides' OR species='haptoroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='haptoroides' OR junior_species='haptoroides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='haptoroides' OR species='haptoroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='microcephalus' OR junior_species='microcephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='microcephalus' OR species='microcephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='microcephalus' OR species='microcephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='microcephalus' OR junior_species='microcephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='microcephalus' OR species='microcephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='noguchii' OR junior_species='noguchi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='noguchii' OR species='noguchi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='noguchii' OR species='noguchi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='noguchii' OR junior_species='noguchi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='noguchii' OR species='noguchi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='polygenus' OR junior_species='polygenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='polygenus' OR species='polygenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='polygenus' OR species='polygenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='polygenus' OR junior_species='polygenus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='polygenus' OR species='polygenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='sulcitarsis' OR junior_species='sulcitarsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='sulcitarsis' OR species='sulcitarsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='sulcitarsis' OR species='sulcitarsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='sulcitarsis' OR junior_species='sulcitarsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='sulcitarsis' OR species='sulcitarsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='yoritomus' OR junior_species='yoritomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='yoritomus' OR species='yoritomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='yoritomus' OR species='yoritomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='yoritomus' OR junior_species='yoritomus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='yoritomus' OR species='yoritomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonognatha' AND (junior_species='aurescense' OR junior_species='aurescense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trigonognatha' AND (species='aurescense' OR species='aurescense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trigonognatha' AND (species='aurescense' OR species='aurescense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonognatha' AND (junior_species='aurescense' OR junior_species='aurescense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trigonognatha' AND (species='aurescense' OR species='aurescense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonognatha' AND (junior_species='cuprescens' OR junior_species='cuprescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trigonognatha' AND (species='cuprescens' OR species='cuprescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trigonognatha' AND (species='cuprescens' OR species='cuprescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonognatha' AND (junior_species='cuprescens' OR junior_species='cuprescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trigonognatha' AND (species='cuprescens' OR species='cuprescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='terricola' OR junior_species='terricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarites' AND (species='terricola' OR species='terricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarites' AND (species='terricola' OR species='terricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='terricola' OR junior_species='terricola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scarites' AND (species='terricola' OR species='terricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiotrechus' AND (junior_species='discuss' OR junior_species='discuss')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiotrechus' AND (species='discuss' OR species='discuss') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiotrechus' AND (species='discuss' OR species='discuss')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiotrechus' AND (junior_species='discuss' OR junior_species='discuss')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasiotrechus' AND (species='discuss' OR species='discuss') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplochlaenius' AND (junior_species='costiger' OR junior_species='costiger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplochlaenius' AND (species='costiger' OR species='costiger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplochlaenius' AND (species='costiger' OR species='costiger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplochlaenius' AND (junior_species='costiger' OR junior_species='costiger')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Haplochlaenius' AND (species='costiger' OR species='costiger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemichlaenius' AND (junior_species='noguchii' OR junior_species='noguchi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemichlaenius' AND (species='noguchii' OR species='noguchi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemichlaenius' AND (species='noguchii' OR species='noguchi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemichlaenius' AND (junior_species='noguchii' OR junior_species='noguchi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemichlaenius' AND (species='noguchii' OR species='noguchi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='bioculatus' OR junior_species='bioculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='bioculatus' OR species='bioculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='bioculatus' OR species='bioculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='bioculatus' OR junior_species='bioculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='bioculatus' OR species='bioculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='circumdatus' OR junior_species='circumdatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='circumdatus' OR species='circumdatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='circumdatus' OR species='circumdatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='circumdatus' OR junior_species='circumdatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='circumdatus' OR species='circumdatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='costiger' OR junior_species='costiger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='costiger' OR species='costiger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='costiger' OR species='costiger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='costiger' OR junior_species='costiger')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='costiger' OR species='costiger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='ocreatus' OR junior_species='ocreatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='ocreatus' OR species='ocreatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='ocreatus' OR species='ocreatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='ocreatus' OR junior_species='ocreatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='ocreatus' OR species='ocreatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='pallipes' OR junior_species='pallipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='pallipes' OR species='pallipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='pallipes' OR species='pallipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='pallipes' OR junior_species='pallipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='pallipes' OR species='pallipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='posticalis' OR junior_species='posticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='posticalis' OR species='posticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='posticalis' OR species='posticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='posticalis' OR junior_species='posticalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='posticalis' OR species='posticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='tetragonoderus' OR junior_species='tetragonoderus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='tetragonoderus' OR species='tetragonoderus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='tetragonoderus' OR species='tetragonoderus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='tetragonoderus' OR junior_species='tetragonoderus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='tetragonoderus' OR species='tetragonoderus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='virgulifer' OR junior_species='virgulifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='virgulifer' OR species='virgulifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='virgulifer' OR species='virgulifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='virgulifer' OR junior_species='virgulifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlaenius' AND (species='virgulifer' OR species='virgulifer') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1538 The Ecological Register: Kitadan Valley
Kitadan Valley
Basic information
Sample name: Kitadan Valley

Reference: W. M. El Sayed and K. Nakamura. 2010. Abundance, diversity and distribution of the ground beetles (Coleoptera: Carabidae) in a satoyama valley in Kanazawa, Japan, with special reference to the body size and feeding categories. Far Eastern Entomologist 205:1-19 [ER 1037]
Geography
Country: Japan


Coordinate: 36° 32' N, 136° 42' E
Coordinate basis: stated in text

Geography comments: "within Kanazawa University's Kakuma Campus, Kanazawa"
elevation 60 to 150 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

MAT: 14.8

WMT: 26.8

CMT: 3.5

MAP: 2545.0

Habitat comments: the original vegetation was "deciduous broad leaved trees predominated by two oak species, Quercus serrata and Q. variabilis, patches of plantations of Japanese cedar, Cryptomeria japonica, and moso bamboo, Phyllosta- chys sp." and sites were located "on the banks of the terraced paddies (coded as PF), at the edges of oak forests (two sites, Fe A and Fe B) in wetland among artificial ponds (W) and in open grassland (OG), in an area of abandoned crop land where millet was cultivated in 2004 and 2005"

Methods
Life forms: ground beetles

Sites: 5

Sampling methods: line transect,pitfall traps

Sample size: 1961 individuals

Years: 2007, 2008

Nets or traps: 75

Sampling comments: "At each sampling site, 15 unbaited pitfall traps were installed as trapping tools and spaced about 1 m apart along a transect" and sampled "early May till late November"

Metadata
Sample number: 1538

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-14 20:36:12

Modified: 2015-05-14 10:36:12

Abundance distribution
55 species
3 singletons
total count 1961
extrapolated richness: 74.1
Fisher's α: 10.507
geometric series k: 0.9065
Hurlbert's PIE: 0.9404
Shannon's H: 3.0602
Good's u: 0.9985
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bembidion koikei3
Bembidion pseudolucillum2
Tachyura exarata3
Tachyura fuscicauda2
Tachyura nana3
Tachyura tosta2
Pheropsophus jessoensis3
Carabus dehaanii punctatostriatus130
Carabus maiyasanus maiyasanus154
Leptocarabus procerulus122
Cicindela japana67
Cicindela ovipennis10
Harpalus eous1
Harpalus jureceki2
Harpalus sinicus8
Oxycentrus argutoroides3
Trichotichnus longitarsis2
Stenolophus congrius2
Anisodactylus punctatipennis109
Anisodactylus sadoensis107
Amara congrua58
Amara (congrua) (Morawitz) Amara macros50
Badister bipustulatus4
Parabroscus crassipalpis4
Platynus hasegawai1
Platynus takabai2
Platynus thoreyii nipponicus5
Synuchus (Synuchus) arcuaticollis3
Synuchus (Synuchus) crocatus200
Synuchus (Synuchus) cycloderus105
Synuchus (Synuchus) difficilis9
Synuchus (Synuchus) dulcigradus64
Synuchus (Synuchus) melantho72
Synuchus (Crepidactyla) nitidus13
Lestichus magnus4
Pterostichus haptoroides japonensis4
Pterostichus microcephalus3
Pterostichus noguchii2
Pterostichus polygenus128
Pterostichus sulcitarsis12
Pterostichus yoritomus144
Trigonognatha aurescense4
Trigonognatha cuprescens5
Scarites (Paralleblomorphus) terricola5
Lasiotrechus discuss2
Haplochlaenius costiger107
Hemichlaenius noguchii1
Chlaenius bioculatus3
Chlaenius circumdatus5
Chlaenius costiger15
Chlaenius ocreatus11
Chlaenius pallipes173
Chlaenius posticalis3
Chlaenius tetragonoderus2
Chlaenius virgulifer3