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=1513 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1513SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1020SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1513 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='commoda' OR junior_species='commoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='commoda' OR species='commoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='commoda' OR species='commoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='commoda' OR junior_species='commoda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='commoda' OR species='commoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='cressonii' OR junior_species='cressoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='cressonii' OR species='cressoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='cressonii' OR species='cressoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='cressonii' OR junior_species='cressoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='cressonii' OR species='cressoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='imitatrix' OR junior_species='imitatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='imitatrix' OR species='imitatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='imitatrix' OR species='imitatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='imitatrix' OR junior_species='imitatrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='imitatrix' OR species='imitatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='robertsonii' OR junior_species='robertsoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='robertsonii' OR species='robertsoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='robertsonii' OR species='robertsoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='robertsonii' OR junior_species='robertsoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='robertsonii' OR species='robertsoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wilkella' OR junior_species='wilkella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='wilkella' OR species='wilkella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='wilkella' OR species='wilkella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wilkella' OR junior_species='wilkella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='wilkella' OR species='wilkella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protandrena' AND (junior_species='bancrofti' OR junior_species='bancroftii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protandrena' AND (species='bancrofti' OR species='bancroftii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protandrena' AND (species='bancrofti' OR species='bancroftii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protandrena' AND (junior_species='bancrofti' OR junior_species='bancroftii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protandrena' AND (species='bancrofti' OR species='bancroftii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopanurgus' AND (junior_species='albitarsis' OR junior_species='albitarsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopanurgus' AND (species='albitarsis' OR species='albitarsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopanurgus' AND (species='albitarsis' OR species='albitarsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopanurgus' AND (junior_species='albitarsis' OR junior_species='albitarsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudopanurgus' AND (species='albitarsis' OR species='albitarsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='abrupta' OR junior_species='abrupta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='abrupta' OR species='abrupta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='abrupta' OR species='abrupta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='abrupta' OR junior_species='abrupta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthophora' AND (species='abrupta' OR species='abrupta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='bomboides' OR junior_species='bomboides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='bomboides' OR species='bomboides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='bomboides' OR species='bomboides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='bomboides' OR junior_species='bomboides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthophora' AND (species='bomboides' OR species='bomboides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='terminalis' OR junior_species='terminalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='terminalis' OR species='terminalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='terminalis' OR species='terminalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='terminalis' OR junior_species='terminalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthophora' AND (species='terminalis' OR species='terminalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apis' AND (species='mellifera' OR species='mellifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='auricomus' OR junior_species='auricomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='auricomus' OR species='auricomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='auricomus' OR species='auricomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='auricomus' OR junior_species='auricomus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='auricomus' OR species='auricomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='griseocollis' OR junior_species='griseocollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='griseocollis' OR species='griseocollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='griseocollis' OR species='griseocollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='griseocollis' OR junior_species='griseocollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='griseocollis' OR species='griseocollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='impatiens' OR junior_species='impatiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='impatiens' OR species='impatiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='impatiens' OR species='impatiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='impatiens' OR junior_species='impatiens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='impatiens' OR species='impatiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' 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='Bombus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='pennsylvanicus' OR species='pennsylvanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' 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='Bombus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='vagans' OR junior_species='vagans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='vagans' OR species='vagans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='vagans' OR species='vagans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='vagans' OR junior_species='vagans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='vagans' OR species='vagans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='calcarata' OR junior_species='calcarata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratina' AND (species='calcarata' OR species='calcarata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratina' AND (species='calcarata' OR species='calcarata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='calcarata' OR junior_species='calcarata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratina' AND (species='calcarata' OR species='calcarata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='dupla' OR junior_species='dupla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratina' AND (species='dupla' OR species='dupla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratina' AND (species='dupla' OR species='dupla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='dupla' OR junior_species='dupla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratina' AND (species='dupla' OR species='dupla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='mikmaqi' OR junior_species='mikmaqii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratina' AND (species='mikmaqi' OR species='mikmaqii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratina' AND (species='mikmaqi' OR species='mikmaqii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='mikmaqi' OR junior_species='mikmaqii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratina' AND (species='mikmaqi' OR species='mikmaqii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='strenua' OR junior_species='strenua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratina' AND (species='strenua' OR species='strenua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratina' AND (species='strenua' OR species='strenua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='strenua' OR junior_species='strenua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratina' AND (species='strenua' OR species='strenua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='hamata' OR junior_species='hamata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucera' AND (species='hamata' OR species='hamata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucera' AND (species='hamata' OR species='hamata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='hamata' OR junior_species='hamata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eucera' AND (species='hamata' OR species='hamata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='agilis' OR species='agilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='agilis' OR junior_species='agilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='bimaculata' OR species='bimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='bimaculata' OR species='bimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='bimaculata' OR species='bimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='comptoides' OR junior_species='comptoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='comptoides' OR species='comptoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='comptoides' OR species='comptoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='comptoides' OR junior_species='comptoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='comptoides' OR species='comptoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='denticulata' OR junior_species='denticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='denticulata' OR species='denticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='denticulata' OR species='denticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='denticulata' OR junior_species='denticulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='denticulata' OR species='denticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='desponsa' OR junior_species='desponsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='desponsa' OR species='desponsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='desponsa' OR species='desponsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='desponsa' OR junior_species='desponsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='desponsa' OR species='desponsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='trinodis' OR junior_species='trinodis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='trinodis' OR species='trinodis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='trinodis' OR species='trinodis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='trinodis' OR junior_species='trinodis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='trinodis' OR species='trinodis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peponapis' AND (junior_species='pruinosa' OR junior_species='pruinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peponapis' AND (species='pruinosa' OR species='pruinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peponapis' AND (species='pruinosa' OR species='pruinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peponapis' AND (junior_species='pruinosa' OR junior_species='pruinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peponapis' AND (species='pruinosa' OR species='pruinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilothrix' AND (junior_species='bombiformis' OR junior_species='bombiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilothrix' AND (species='bombiformis' OR species='bombiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilothrix' AND (species='bombiformis' OR species='bombiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilothrix' AND (junior_species='bombiformis' OR junior_species='bombiformis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilothrix' AND (species='bombiformis' OR species='bombiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Svastra' AND (junior_species='obliqua' OR junior_species='obliqua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Svastra' AND (species='obliqua' OR species='obliqua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Svastra' AND (species='obliqua' OR species='obliqua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Svastra' AND (junior_species='obliqua' OR junior_species='obliqua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Svastra' AND (species='obliqua' OR species='obliqua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylocopa' AND (junior_species='virginica' OR junior_species='virginica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylocopa' AND (species='virginica' OR species='virginica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylocopa' AND (species='virginica' OR species='virginica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylocopa' AND (junior_species='virginica' OR junior_species='virginica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xylocopa' AND (species='virginica' OR species='virginica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='affinis/modestus' OR junior_species='affinis/modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeus' AND (species='affinis/modestus' OR species='affinis/modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylaeus' AND (species='affinis/modestus' OR species='affinis/modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='affinis/modestus' OR junior_species='affinis/modestus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylaeus' AND (species='affinis/modestus' OR species='affinis/modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='mesillae' OR junior_species='mesillae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeus' AND (species='mesillae' OR species='mesillae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylaeus' AND (species='mesillae' OR species='mesillae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='mesillae' OR junior_species='mesillae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylaeus' AND (species='mesillae' OR species='mesillae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeus' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylaeus' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='modestus' OR junior_species='modestus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylaeus' AND (species='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='sericeus' OR junior_species='sericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='sericeus' OR species='sericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='sericeus' OR species='sericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='sericeus' OR junior_species='sericeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agapostemon' AND (species='sericeus' OR species='sericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='virescens' OR junior_species='virescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='virescens' OR species='virescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='virescens' OR species='virescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='virescens' OR junior_species='virescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agapostemon' AND (species='virescens' OR species='virescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlora' AND (junior_species='pura' OR junior_species='pura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Augochlora' AND (species='pura' OR species='pura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Augochlora' AND (species='pura' OR species='pura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlora' AND (junior_species='pura' OR junior_species='pura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Augochlora' AND (species='pura' OR species='pura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlorella' AND (junior_species='aurata' OR junior_species='aurata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Augochlorella' AND (species='aurata' OR species='aurata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Augochlorella' AND (species='aurata' OR species='aurata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlorella' AND (junior_species='aurata' OR junior_species='aurata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Augochlorella' AND (species='aurata' OR species='aurata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochloropsis' AND (junior_species='metallica' OR junior_species='metallica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Augochloropsis' AND (species='metallica' OR species='metallica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Augochloropsis' AND (species='metallica' OR species='metallica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochloropsis' AND (junior_species='metallica' OR junior_species='metallica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Augochloropsis' AND (species='metallica' OR species='metallica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='ligatus' OR junior_species='ligatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='ligatus' OR species='ligatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='ligatus' OR species='ligatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='ligatus' OR junior_species='ligatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halictus' AND (species='ligatus' OR species='ligatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' 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='Halictus' AND (species='parallelus' OR species='parallelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='parallelus' OR species='parallelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' 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='Halictus' AND (species='parallelus' OR species='parallelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='rubicundus' OR junior_species='rubicundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='rubicundus' OR species='rubicundus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='rubicundus' OR species='rubicundus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='rubicundus' OR junior_species='rubicundus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halictus' AND (species='rubicundus' OR species='rubicundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='bruneri' OR junior_species='brunerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='bruneri' OR species='brunerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='bruneri' OR species='brunerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='bruneri' OR junior_species='brunerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='bruneri' OR species='brunerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cattellae' OR junior_species='cattellae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cattellae' OR species='cattellae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cattellae' OR species='cattellae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cattellae' OR junior_species='cattellae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='cattellae' OR species='cattellae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cinctipes' OR junior_species='cinctipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cinctipes' OR species='cinctipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cinctipes' OR species='cinctipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cinctipes' OR junior_species='cinctipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='cinctipes' OR species='cinctipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='coeruleum' OR junior_species='coeruleum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='coeruleum' OR species='coeruleum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='coeruleum' OR species='coeruleum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='coeruleum' OR junior_species='coeruleum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='coeruleum' OR species='coeruleum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='coriaceum' OR junior_species='coriaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='coriaceum' OR species='coriaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='coriaceum' OR species='coriaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='coriaceum' OR junior_species='coriaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='coriaceum' OR species='coriaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cressonii' OR junior_species='cressoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cressonii' OR species='cressoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cressonii' OR species='cressoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cressonii' OR junior_species='cressoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='cressonii' OR species='cressoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='fuscipenne' OR junior_species='fuscipenne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='fuscipenne' OR species='fuscipenne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='fuscipenne' OR species='fuscipenne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='fuscipenne' OR junior_species='fuscipenne')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='fuscipenne' OR species='fuscipenne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hitchensi' OR junior_species='hitchensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='hitchensi' OR species='hitchensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='hitchensi' OR species='hitchensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hitchensi' OR junior_species='hitchensii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='hitchensi' OR species='hitchensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='illinoense' OR junior_species='illinoense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='illinoense' OR species='illinoense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='illinoense' OR species='illinoense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='illinoense' OR junior_species='illinoense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='illinoense' OR species='illinoense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitatum' OR junior_species='imitatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='imitatum' OR species='imitatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='imitatum' OR species='imitatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitatum' OR junior_species='imitatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='imitatum' OR species='imitatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='obscurum' OR junior_species='obscurum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='obscurum' OR species='obscurum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='obscurum' OR species='obscurum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='obscurum' OR junior_species='obscurum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='obscurum' OR species='obscurum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='oceanicum' OR junior_species='oceanicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='oceanicum' OR species='oceanicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='oceanicum' OR species='oceanicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='oceanicum' OR junior_species='oceanicum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='oceanicum' OR species='oceanicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pectorale' OR junior_species='pectorale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='pectorale' OR species='pectorale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='pectorale' OR species='pectorale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pectorale' OR junior_species='pectorale')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='pectorale' OR species='pectorale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='smilacinae' OR junior_species='smilacinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='smilacinae' OR species='smilacinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='smilacinae' OR species='smilacinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='smilacinae' OR junior_species='smilacinae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='smilacinae' OR species='smilacinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='subviridatum' OR junior_species='subviridatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='subviridatum' OR species='subviridatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='subviridatum' OR species='subviridatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='subviridatum' OR junior_species='subviridatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='subviridatum' OR species='subviridatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='timothyi' OR junior_species='timothyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='timothyi' OR species='timothyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='timothyi' OR species='timothyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='timothyi' OR junior_species='timothyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='timothyi' OR species='timothyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='truncatum' OR junior_species='truncatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='truncatum' OR species='truncatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='truncatum' OR species='truncatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='truncatum' OR junior_species='truncatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='truncatum' OR species='truncatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='versatum' OR junior_species='versatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='versatum' OR species='versatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='versatum' OR species='versatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='versatum' OR junior_species='versatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='versatum' OR species='versatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='weemsi' OR junior_species='weemsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='weemsi' OR species='weemsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='weemsi' OR species='weemsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='weemsi' OR junior_species='weemsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='weemsi' OR species='weemsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='zephyrum' OR junior_species='zephyrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='zephyrum' OR species='zephyrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='zephyrum' OR species='zephyrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='zephyrum' OR junior_species='zephyrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='zephyrum' OR species='zephyrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphecodes' AND (junior_species='heraclei' OR junior_species='heracleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphecodes' AND (species='heraclei' OR species='heracleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphecodes' AND (species='heraclei' OR species='heracleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphecodes' AND (junior_species='heraclei' OR junior_species='heracleii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sphecodes' AND (species='heraclei' OR species='heracleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heriades' AND (junior_species='variolosa' OR junior_species='variolosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heriades' AND (species='variolosa' OR species='variolosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heriades' AND (species='variolosa' OR species='variolosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heriades' AND (junior_species='variolosa' OR junior_species='variolosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heriades' AND (species='variolosa' OR species='variolosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='pilosifrons' OR junior_species='pilosifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplitis' AND (species='pilosifrons' OR species='pilosifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplitis' AND (species='pilosifrons' OR species='pilosifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='pilosifrons' OR junior_species='pilosifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplitis' AND (species='pilosifrons' OR species='pilosifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='spoliata' OR junior_species='spoliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplitis' AND (species='spoliata' OR species='spoliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplitis' AND (species='spoliata' OR species='spoliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='spoliata' OR junior_species='spoliata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplitis' AND (species='spoliata' OR species='spoliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='campanulae' OR junior_species='campanulae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='campanulae' OR species='campanulae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='campanulae' OR species='campanulae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='campanulae' OR junior_species='campanulae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megachile' AND (species='campanulae' OR species='campanulae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='frugalis' OR junior_species='frugalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='frugalis' OR species='frugalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='frugalis' OR species='frugalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='frugalis' OR junior_species='frugalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megachile' AND (species='frugalis' OR species='frugalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='gemula' OR junior_species='gemula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='gemula' OR species='gemula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='gemula' OR species='gemula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='gemula' OR junior_species='gemula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megachile' AND (species='gemula' OR species='gemula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='mendica' OR junior_species='mendica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='mendica' OR species='mendica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='mendica' OR species='mendica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='mendica' OR junior_species='mendica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megachile' AND (species='mendica' OR species='mendica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1513 The Ecological Register: Alice L. Kibbe Life Science Station (elevated pan traps)
Alice L. Kibbe Life Science Station (elevated pan traps)
Basic information
Sample name: Alice L. Kibbe Life Science Station (elevated pan traps)

Reference: R. K. Geroff, J. Gibbs, and K. W. McCravy. 2014. Assessing bee (Hymenoptera: Apoidea) diversity of an Illinois restored tallgrass prairie: methodology and conservation considerations. Journal of Insect Conservation 18:951-964 [ER 1020]
Geography
Country: United States

State: Illinois


Coordinate: 40° 21' 57" N, 91° 24' 24" W
Coordinate basis: stated in text

Geography comments: "near Warsaw"

•
Environment
Habitat: temperate savanna

Altered habitat: fragment

Substrate: ground surface

Habitat comments: "a ca. 12 ha restored [tallgrass] prairie"

Methods
Life forms: bees

Sites: 5

Sampling methods: pan traps

Sample size: 753 individuals

Days: 24

Seasons: summer,autumn

Nets or traps: 15

Net or trap nights: 360

Sampling comments: "pan traps (elevated 1 m" with "3 elevated pan traps (1 blue, 1 white, and 1 yellow)" in each of five plots that "were separated by 25 m"

Metadata
Sample number: 1513

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-04-26 13:24:15

Modified: 2015-04-26 03:24:15

Abundance distribution
70 species
26 singletons
total count 753
extrapolated richness: 145.4
Fisher's α: 18.859
geometric series k: 0.9220
Hurlbert's PIE: 0.8454
Shannon's H: 2.8206
Good's u: 0.9655
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Andrena commoda1
Andrena cressonii4
Andrena imitatrix1
Andrena robertsonii2
Andrena wilkella6
Protandrena bancrofti2
Pseudopanurgus albitarsis1
Anthophora abrupta1
Anthophora bomboides1
Anthophora terminalis2
Apis mellifera8
Bombus auricomus1
Bombus griseocollis17
Bombus impatiens9
Bombus pennsylvanicus1
Bombus vagans1
Ceratina calcarata20
Ceratina dupla40
Ceratina mikmaqi7
Ceratina strenua1
Eucera hamata9
Melissodes agilis2
Melissodes bimaculata5
Melissodes comptoides4
Melissodes denticulata3
Melissodes desponsa2
Melissodes trinodis10
Peponapis pruinosa1
Ptilothrix bombiformis1
Svastra obliqua2
Xylocopa virginica1
Hylaeus affinis/modestus9
Hylaeus mesillae17
Hylaeus modestus1
Agapostemon sericeus1
Agapostemon virescens5
Augochlora pura68
Augochlorella aurata60
Augochloropsis metallica9
Halictus ligatus6
Halictus parallelus1
Halictus rubicundus1
Lasioglossum bruneri1
Lasioglossum cattellae6
Lasioglossum cinctipes1
Lasioglossum coeruleum7
Lasioglossum coriaceum30
Lasioglossum cressonii4
Lasioglossum fuscipenne2
Lasioglossum hitchensi6
Lasioglossum illinoense7
Lasioglossum imitatum2
Lasioglossum obscurum1
Lasioglossum oceanicum11
Lasioglossum pectorale2
Lasioglossum smilacinae25
Lasioglossum subviridatum2
Lasioglossum timothyi4
Lasioglossum truncatum12
Lasioglossum versatum272
Lasioglossum weemsi1
Lasioglossum zephyrum1
Sphecodes heraclei2
Heriades variolosa2
Hoplitis pilosifrons1
Hoplitis spoliata1
Megachile campanulae1
Megachile frugalis1
Megachile gemula3
Megachile mendica1