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=1517 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1517SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1023SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1517 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='nigricula' OR junior_species='nigricula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='nigricula' OR species='nigricula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='nigricula' OR species='nigricula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='nigricula' OR junior_species='nigricula')SELECT d.diet,d.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='nigricula' OR species='nigricula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='piperi' OR junior_species='piperii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='piperi' OR species='piperii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='piperi' OR species='piperii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='piperi' OR junior_species='piperii')SELECT d.diet,d.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='piperi' OR species='piperii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='barri' OR junior_species='barrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliopsis' AND (species='barri' OR species='barrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliopsis' AND (species='barri' OR species='barrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='barri' OR junior_species='barrii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calliopsis' AND (species='barri' OR species='barrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='puellae' OR junior_species='puellae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliopsis' AND (species='puellae' OR species='puellae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliopsis' AND (species='puellae' OR species='puellae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliopsis' AND (junior_species='puellae' OR junior_species='puellae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calliopsis' AND (species='puellae' OR species='puellae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='arenaria' OR junior_species='arenaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='arenaria' OR species='arenaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='arenaria' OR species='arenaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='arenaria' OR junior_species='arenaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='arenaria' OR species='arenaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='albipennis' OR junior_species='albipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='albipennis' OR species='albipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='albipennis' OR species='albipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='albipennis' OR junior_species='albipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='albipennis' OR species='albipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='albonotata' OR junior_species='albonotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='albonotata' OR species='albonotata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='albonotata' OR species='albonotata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='albonotata' OR junior_species='albonotata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='albonotata' OR species='albonotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='aridella' OR junior_species='aridella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='aridella' OR species='aridella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='aridella' OR species='aridella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='aridella' OR junior_species='aridella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='aridella' OR species='aridella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='dilecta' OR junior_species='dilecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='dilecta' OR species='dilecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='dilecta' OR species='dilecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='dilecta' OR junior_species='dilecta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='dilecta' OR species='dilecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='dolichocephala' OR junior_species='dolichocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='dolichocephala' OR species='dolichocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='dolichocephala' OR species='dolichocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='dolichocephala' OR junior_species='dolichocephala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='dolichocephala' OR species='dolichocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='haigi' OR junior_species='haigii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='haigi' OR species='haigii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='haigi' OR species='haigii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='haigi' OR junior_species='haigii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='haigi' OR species='haigii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='idonea' OR junior_species='idonea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='idonea' OR species='idonea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='idonea' OR species='idonea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='idonea' OR junior_species='idonea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='idonea' OR species='idonea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='jucunda' OR junior_species='jucunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='jucunda' OR species='jucunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='jucunda' OR species='jucunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='jucunda' OR junior_species='jucunda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='jucunda' OR species='jucunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='lepidosparti' OR junior_species='lepidospartii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='lepidosparti' OR species='lepidospartii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='lepidosparti' OR species='lepidospartii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='lepidosparti' OR junior_species='lepidospartii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='lepidosparti' OR species='lepidospartii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='luteola' OR junior_species='luteola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='luteola' OR species='luteola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='luteola' OR species='luteola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='luteola' OR junior_species='luteola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='luteola' OR species='luteola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='nuda' OR junior_species='nuda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='nuda' OR species='nuda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='nuda' OR species='nuda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='nuda' OR junior_species='nuda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='nuda' OR species='nuda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='similis' OR junior_species='similis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='subfasciata' OR junior_species='subfasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdita' AND (species='subfasciata' OR species='subfasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='subfasciata' OR species='subfasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' AND (junior_species='subfasciata' OR junior_species='subfasciata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perdita' AND (species='subfasciata' OR species='subfasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protandrena' AND (junior_species='aurifodinae' OR junior_species='aurifodinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protandrena' AND (species='aurifodinae' OR species='aurifodinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protandrena' AND (species='aurifodinae' OR species='aurifodinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protandrena' AND (junior_species='aurifodinae' OR junior_species='aurifodinae')SELECT d.diet,d.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='aurifodinae' OR species='aurifodinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='affabilis' OR junior_species='affabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='affabilis' OR species='affabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='affabilis' OR species='affabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='affabilis' OR junior_species='affabilis')SELECT d.diet,d.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='affabilis' OR species='affabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='flexipes' OR junior_species='flexipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='flexipes' OR species='flexipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='flexipes' OR species='flexipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='flexipes' OR junior_species='flexipes')SELECT d.diet,d.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='flexipes' OR species='flexipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='maculifrons' OR junior_species='maculifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='maculifrons' OR species='maculifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='maculifrons' OR species='maculifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='maculifrons' OR junior_species='maculifrons')SELECT d.diet,d.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='maculifrons' OR species='maculifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='mortuaria' OR junior_species='mortuaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='mortuaria' OR species='mortuaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='mortuaria' OR species='mortuaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='mortuaria' OR junior_species='mortuaria')SELECT d.diet,d.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='mortuaria' OR species='mortuaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='neglecta' OR junior_species='neglecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='neglecta' OR species='neglecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='neglecta' OR species='neglecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='neglecta' OR junior_species='neglecta')SELECT d.diet,d.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='neglecta' OR species='neglecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='pachyodonta' OR junior_species='pachyodonta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='pachyodonta' OR species='pachyodonta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='pachyodonta' OR species='pachyodonta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='pachyodonta' OR junior_species='pachyodonta')SELECT d.diet,d.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='pachyodonta' OR species='pachyodonta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='petrophila' OR junior_species='petrophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='petrophila' OR species='petrophila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='petrophila' OR species='petrophila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='petrophila' OR junior_species='petrophila')SELECT d.diet,d.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='petrophila' OR species='petrophila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='porterae' OR junior_species='porterae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='porterae' OR species='porterae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='porterae' OR species='porterae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='porterae' OR junior_species='porterae')SELECT d.diet,d.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='porterae' OR species='porterae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='urbana' OR junior_species='urbana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthophora' AND (species='urbana' OR species='urbana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthophora' AND (species='urbana' OR species='urbana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthophora' AND (junior_species='urbana' OR junior_species='urbana')SELECT d.diet,d.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='urbana' OR species='urbana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='morrisoni' OR junior_species='morrisonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='morrisoni' OR species='morrisonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='morrisoni' OR species='morrisonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='morrisoni' OR junior_species='morrisonii')SELECT d.diet,d.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='morrisoni' OR species='morrisonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='pacifica' OR junior_species='pacifica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratina' AND (species='pacifica' OR species='pacifica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratina' AND (species='pacifica' OR species='pacifica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratina' AND (junior_species='pacifica' OR junior_species='pacifica')SELECT d.diet,d.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='pacifica' OR species='pacifica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diadasia' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diadasia' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='australis' OR junior_species='australis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diadasia' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='diminuta' OR junior_species='diminuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diadasia' AND (species='diminuta' OR species='diminuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diadasia' AND (species='diminuta' OR species='diminuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='diminuta' OR junior_species='diminuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diadasia' AND (species='diminuta' OR species='diminuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epeolus' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epeolus' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='minimus' OR junior_species='minimus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epeolus' AND (species='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epeolus' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epeolus' AND (species='pusillus' OR species='pusillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epeolus' AND (species='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='fulvitarsis' OR junior_species='fulvitarsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucera' AND (species='fulvitarsis' OR species='fulvitarsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucera' AND (species='fulvitarsis' OR species='fulvitarsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='fulvitarsis' OR junior_species='fulvitarsis')SELECT d.diet,d.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='fulvitarsis' OR species='fulvitarsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='lutziana' OR junior_species='lutziana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucera' AND (species='lutziana' OR species='lutziana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucera' AND (species='lutziana' OR species='lutziana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='lutziana' OR junior_species='lutziana')SELECT d.diet,d.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='lutziana' OR species='lutziana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucera' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eucera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melecta' AND (junior_species='alexanderi' OR junior_species='alexanderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melecta' AND (species='alexanderi' OR species='alexanderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melecta' AND (species='alexanderi' OR species='alexanderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melecta' AND (junior_species='alexanderi' OR junior_species='alexanderii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melecta' AND (species='alexanderi' OR species='alexanderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='utahensis' OR junior_species='utahensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='utahensis' OR species='utahensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='utahensis' OR species='utahensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='utahensis' OR junior_species='utahensis')SELECT d.diet,d.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='utahensis' OR species='utahensis') 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='bimatris' OR junior_species='bimatris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='bimatris' OR species='bimatris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='bimatris' OR species='bimatris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='bimatris' OR junior_species='bimatris')SELECT d.diet,d.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='bimatris' OR species='bimatris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='dagosa' OR junior_species='dagosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='dagosa' OR species='dagosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='dagosa' OR species='dagosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='dagosa' OR junior_species='dagosa')SELECT d.diet,d.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='dagosa' OR species='dagosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melissodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolarra' AND (junior_species='vigilans' OR junior_species='vigilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neolarra' AND (species='vigilans' OR species='vigilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neolarra' AND (species='vigilans' OR species='vigilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolarra' AND (junior_species='vigilans' OR junior_species='vigilans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neolarra' AND (species='vigilans' OR species='vigilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolarra' AND (junior_species='vigilans' OR junior_species='vigilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neolarra' AND (species='vigilans' OR species='vigilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neolarra' AND (species='vigilans' OR species='vigilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolarra' AND (junior_species='vigilans' OR junior_species='vigilans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neolarra' AND (species='vigilans' OR species='vigilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomada' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomada' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='n.' OR junior_species='n.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nomada' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomada' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomada' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='n.' OR junior_species='n.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nomada' AND (species='n.' OR species='n.') 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='Triepeolus' AND (junior_species='grindeliae' OR junior_species='grindeliae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='grindeliae' OR species='grindeliae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='grindeliae' OR species='grindeliae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='grindeliae' OR junior_species='grindeliae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='grindeliae' OR species='grindeliae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='helianthi' OR junior_species='helianthii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='helianthi' OR species='helianthii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='helianthi' OR species='helianthii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='helianthi' OR junior_species='helianthii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='helianthi' OR species='helianthii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sarothrinus' OR junior_species='sarothrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='sarothrinus' OR species='sarothrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='sarothrinus' OR species='sarothrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sarothrinus' OR junior_species='sarothrinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='sarothrinus' OR species='sarothrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='timberlakei' OR junior_species='timberlakeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triepeolus' AND (species='timberlakei' OR species='timberlakeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triepeolus' AND (species='timberlakei' OR species='timberlakeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triepeolus' AND (junior_species='timberlakei' OR junior_species='timberlakeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triepeolus' AND (species='timberlakei' OR species='timberlakeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xeromelecta' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xeromelecta' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xeromelecta' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xeromelecta' AND (junior_species='californica' OR junior_species='californica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xeromelecta' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='gypsicolens' OR junior_species='gypsicolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='gypsicolens' OR species='gypsicolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='gypsicolens' OR species='gypsicolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='gypsicolens' OR junior_species='gypsicolens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='gypsicolens' OR species='gypsicolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='louisae' OR junior_species='louisae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='louisae' OR species='louisae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='louisae' OR species='louisae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='louisae' OR junior_species='louisae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='louisae' OR species='louisae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='mandibularis' OR junior_species='mandibularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='mandibularis' OR species='mandibularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='mandibularis' OR species='mandibularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='mandibularis' OR junior_species='mandibularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='mandibularis' OR species='mandibularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='phaceliae' OR junior_species='phaceliae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='phaceliae' OR species='phaceliae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='phaceliae' OR species='phaceliae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='phaceliae' OR junior_species='phaceliae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='phaceliae' OR species='phaceliae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='simulans' OR junior_species='simulans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='simulans' OR species='simulans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='simulans' OR species='simulans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='simulans' OR junior_species='simulans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='simulans' OR species='simulans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='slevini' OR junior_species='slevinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='slevini' OR species='slevinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='slevini' OR species='slevinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='slevini' OR junior_species='slevinii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='slevini' OR species='slevinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='sphaeralceae' OR junior_species='sphaeralceae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='sphaeralceae' OR species='sphaeralceae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='sphaeralceae' OR species='sphaeralceae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='sphaeralceae' OR junior_species='sphaeralceae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colletes' AND (species='sphaeralceae' OR species='sphaeralceae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='angelicus' OR junior_species='angelicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='angelicus' OR species='angelicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='angelicus' OR species='angelicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='angelicus' OR junior_species='angelicus')SELECT d.diet,d.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='angelicus' OR species='angelicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='femoratus' OR junior_species='femoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='femoratus' OR species='femoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='femoratus' OR species='femoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='femoratus' OR junior_species='femoratus')SELECT d.diet,d.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='femoratus' OR species='femoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='texanus' OR junior_species='texanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='texanus' OR species='texanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='texanus' OR species='texanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='texanus' OR junior_species='texanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agapostemon' AND (species='texanus' OR species='texanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dieunomia' AND (junior_species='triangulifera' OR junior_species='triangulifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dieunomia' AND (species='triangulifera' OR species='triangulifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dieunomia' AND (species='triangulifera' OR species='triangulifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dieunomia' AND (junior_species='triangulifera' OR junior_species='triangulifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dieunomia' AND (species='triangulifera' OR species='triangulifera') 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='tripartitus' OR junior_species='tripartitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='tripartitus' OR species='tripartitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='tripartitus' OR species='tripartitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='tripartitus' OR junior_species='tripartitus')SELECT d.diet,d.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='tripartitus' OR species='tripartitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='pruinosum' OR species='pruinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='pruinosum' OR species='pruinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT d.diet,d.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='pruinosum' OR species='pruinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='albohirtum' OR junior_species='albohirtum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='albohirtum' OR species='albohirtum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='albohirtum' OR species='albohirtum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='albohirtum' OR junior_species='albohirtum')SELECT d.diet,d.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='albohirtum' OR species='albohirtum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hudsoniellum' OR junior_species='hudsoniellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='hudsoniellum' OR species='hudsoniellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='hudsoniellum' OR species='hudsoniellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hudsoniellum' OR junior_species='hudsoniellum')SELECT d.diet,d.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='hudsoniellum' OR species='hudsoniellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hunteri' OR junior_species='hunterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='hunteri' OR species='hunterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='hunteri' OR species='hunterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hunteri' OR junior_species='hunterii')SELECT d.diet,d.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='hunteri' OR species='hunterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hyalinum' OR junior_species='hyalinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='hyalinum' OR species='hyalinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='hyalinum' OR species='hyalinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hyalinum' OR junior_species='hyalinum')SELECT d.diet,d.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='hyalinum' OR species='hyalinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='incompletum' OR junior_species='incompletum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='incompletum' OR species='incompletum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='incompletum' OR species='incompletum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='incompletum' OR junior_species='incompletum')SELECT d.diet,d.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='incompletum' OR species='incompletum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosiforme' OR junior_species='pruinosiforme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='pruinosiforme' OR species='pruinosiforme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='pruinosiforme' OR species='pruinosiforme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosiforme' OR junior_species='pruinosiforme')SELECT d.diet,d.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='pruinosiforme' OR species='pruinosiforme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='pruinosum' OR species='pruinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='pruinosum' OR species='pruinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT d.diet,d.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='pruinosum' OR species='pruinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sisymbrii' OR junior_species='sisymbri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sisymbrii' OR species='sisymbri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sisymbrii' OR species='sisymbri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sisymbrii' OR junior_species='sisymbri')SELECT d.diet,d.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='sisymbrii' OR species='sisymbri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='emarginatum' OR junior_species='emarginatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthidium' AND (species='emarginatum' OR species='emarginatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthidium' AND (species='emarginatum' OR species='emarginatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='emarginatum' OR junior_species='emarginatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthidium' AND (species='emarginatum' OR species='emarginatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='rodecki' OR junior_species='rodeckii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthidium' AND (species='rodecki' OR species='rodeckii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthidium' AND (species='rodecki' OR species='rodeckii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='rodecki' OR junior_species='rodeckii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthidium' AND (species='rodecki' OR species='rodeckii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='aridula' OR junior_species='aridula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='aridula' OR species='aridula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='aridula' OR species='aridula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='aridula' OR junior_species='aridula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ashmeadiella' AND (species='aridula' OR species='aridula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='bucconis' OR junior_species='bucconis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='bucconis' OR species='bucconis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='bucconis' OR species='bucconis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='bucconis' OR junior_species='bucconis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ashmeadiella' AND (species='bucconis' OR species='bucconis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='foveata' OR junior_species='foveata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='foveata' OR species='foveata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='foveata' OR species='foveata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='foveata' OR junior_species='foveata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ashmeadiella' AND (species='foveata' OR species='foveata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='gillettei' OR junior_species='gilletteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='gillettei' OR species='gilletteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='gillettei' OR species='gilletteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='gillettei' OR junior_species='gilletteii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ashmeadiella' AND (species='gillettei' OR species='gilletteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='meliloti' OR junior_species='melilotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='meliloti' OR species='melilotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='meliloti' OR species='melilotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='meliloti' OR junior_species='melilotii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ashmeadiella' AND (species='meliloti' OR species='melilotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='hunteri' OR junior_species='hunterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelioxys' AND (species='hunteri' OR species='hunterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelioxys' AND (species='hunteri' OR species='hunterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='hunteri' OR junior_species='hunterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coelioxys' AND (species='hunteri' OR species='hunterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='mesae' OR junior_species='mesae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelioxys' AND (species='mesae' OR species='mesae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelioxys' AND (species='mesae' OR species='mesae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='mesae' OR junior_species='mesae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coelioxys' AND (species='mesae' OR species='mesae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dianthidium' AND (junior_species='parvum' OR junior_species='parvum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dianthidium' AND (species='parvum' OR species='parvum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dianthidium' AND (species='parvum' OR species='parvum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dianthidium' AND (junior_species='parvum' OR junior_species='parvum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dianthidium' AND (species='parvum' OR species='parvum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dianthidium' AND (junior_species='pudicum' OR junior_species='pudicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dianthidium' AND (species='pudicum' OR species='pudicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dianthidium' AND (species='pudicum' OR species='pudicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dianthidium' AND (junior_species='pudicum' OR junior_species='pudicum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dianthidium' AND (species='pudicum' OR species='pudicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dioxys' AND (junior_species='productus' OR junior_species='productus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dioxys' AND (species='productus' OR species='productus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dioxys' AND (species='productus' OR species='productus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dioxys' AND (junior_species='productus' OR junior_species='productus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dioxys' AND (species='productus' OR species='productus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='grinnelli' OR junior_species='grinnellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplitis' AND (species='grinnelli' OR species='grinnellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplitis' AND (species='grinnelli' OR species='grinnellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='grinnelli' OR junior_species='grinnellii')SELECT d.diet,d.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='grinnelli' OR species='grinnellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='hypocrita' OR junior_species='hypocrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplitis' AND (species='hypocrita' OR species='hypocrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplitis' AND (species='hypocrita' OR species='hypocrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplitis' AND (junior_species='hypocrita' OR junior_species='hypocrita')SELECT d.diet,d.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='hypocrita' OR species='hypocrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='laurita' OR junior_species='laurita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='laurita' OR species='laurita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='laurita' OR species='laurita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='laurita' OR junior_species='laurita')SELECT d.diet,d.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='laurita' OR species='laurita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='n.' OR junior_species='n.')SELECT d.diet,d.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='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='brevis' OR junior_species='brevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='brevis' OR species='brevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='brevis' OR species='brevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='brevis' OR junior_species='brevis')SELECT d.diet,d.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='brevis' OR species='brevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='inimica' OR junior_species='inimica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='inimica' OR species='inimica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='inimica' OR species='inimica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='inimica' OR junior_species='inimica')SELECT d.diet,d.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='inimica' OR species='inimica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Osmia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='gaudiosa' OR junior_species='gaudiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='gaudiosa' OR species='gaudiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='gaudiosa' OR species='gaudiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='gaudiosa' OR junior_species='gaudiosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Osmia' AND (species='gaudiosa' OR species='gaudiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='titusi' OR junior_species='titusii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='titusi' OR species='titusii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='titusi' OR species='titusii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='titusi' OR junior_species='titusii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Osmia' AND (species='titusi' OR species='titusii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperapis' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperapis' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='n.' OR junior_species='n.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hesperapis' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='carinata' OR junior_species='carinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperapis' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperapis' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='carinata' OR junior_species='carinata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hesperapis' AND (species='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='oliviae' OR junior_species='oliviae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperapis' AND (species='oliviae' OR species='oliviae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperapis' AND (species='oliviae' OR species='oliviae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperapis' AND (junior_species='oliviae' OR junior_species='oliviae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hesperapis' AND (species='oliviae' OR species='oliviae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1517 The Ecological Register: Dugway Proving Grounds
Dugway Proving Grounds
Basic information
Sample name: Dugway Proving Grounds

Reference: J. S. Wilson, T. Griswold, and O. J. Messinger. 2008. Sampling bee communities (Hymenoptera: Apiformes) in a desert landscape: are pan traps sufficient?. Journal of the Kansas Entomological Society 81(3):288-300 [ER 1023]
Geography
Country: United States

State: Utah


Coordinate: 40.2° N, -112.7° W
Coordinate basis: stated in text

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

Habitat comments: "11 one ha sites in a variety of habitats, including active sand dunes, vegetated dunes, and riparian areas"

Methods
Life forms: bees

Sites: 11

Sampling methods: no design,other nets

Sample size: 1248 individuals

Years: 2003, 2005

Seasons: spring,summer,autumn

Sampling comments: "aerial nets"

Metadata
Sample number: 1517

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-04-26 17:25:41

Modified: 2015-04-26 07:25:41

Abundance distribution
107 species
29 singletons
total count 1248
extrapolated richness: 182.3
Fisher's α: 28.021
geometric series k: 0.9592
Hurlbert's PIE: 0.9707
Shannon's H: 3.9051
Good's u: 0.9768
Each square represents a species. Square sizes are proportional to counts.
Register
Andrena nigricula26
Andrena piperi4
Calliopsis barri1
Calliopsis puellae2
Perdita aff. arenaria7
Perdita albipennis2
Perdita albonotata38
Perdita aridella50
Perdita dilecta9
Perdita dolichocephala3
Perdita haigi11
Perdita idonea81
Perdita jucunda10
Perdita lepidosparti1
Perdita luteola13
Perdita nuda42
Perdita similis3
Perdita sp.1
Perdita subfasciata9
Protandrena aurifodinae67
Anthophora affabilis28
Anthophora flexipes31
Anthophora maculifrons10
Anthophora mortuaria1
Anthophora neglecta1
Anthophora pachyodonta1
Anthophora petrophila25
Anthophora porterae4
Anthophora urbana24
Bombus morrisoni7
Ceratina pacifica1
Diadasia australis1
Diadasia diminuta3
Epeolus minimus2
Epeolus pusillus11
Eucera fulvitarsis4
Eucera lutziana9
Eucera sp.2
Melecta alexanderi3
Melissodes aff. utahensis1
Melissodes agilis12
Melissodes bimatris1
Melissodes dagosa9
Melissodes sp.16
Neolarra aff. vigilans1
Neolarra vigilans1
Nomada (Micronomada) n. sp. 13
Nomada n. sp.2
Svastra obliqua1
Triepeolus grindeliae5
Triepeolus helianthi1
Triepeolus sarothrinus1
Triepeolus sp. D71
Triepeolus sp. D82
Triepeolus timberlakei2
Xeromelecta californica1
Colletes gypsicolens46
Colletes louisae4
Colletes mandibularis1
Colletes phaceliae21
Colletes simulans32
Colletes slevini1
Colletes sphaeralceae3
Agapostemon angelicus37
Agapostemon femoratus4
Agapostemon texanus2
Dieunomia triangulifera4
Halictus ligatus7
Halictus tripartitus27
Lasioglossum aff. pruinosum2
Lasioglossum albohirtum6
Lasioglossum hudsoniellum24
Lasioglossum hunteri1
Lasioglossum hyalinum25
Lasioglossum incompletum12
Lasioglossum sp. A2
Lasioglossum pruinosiforme1
Lasioglossum pruinosum38
Lasioglossum sisymbrii7
Lasioglossum sp.55
Lasioglossum sp. 24
Lasioglossum sp. 2351
Lasioglossum sp. C1
Anthidium emarginatum3
Anthidium rodecki25
Ashmeadiella aridula3
Ashmeadiella bucconis7
Ashmeadiella foveata1
Ashmeadiella gillettei6
Ashmeadiella meliloti3
Coelioxys hunteri1
Coelioxys mesae1
Dianthidium parvum1
Dianthidium pudicum10
Dioxys productus4
Hoplitis grinnelli5
Hoplitis hypocrita2
Megachile aff. laurita1
Megachile n. sp. umatillensis5
Megachile brevis onobrychidis2
Megachile inimica3
Osmia (Melanosmia) sp.1
Osmia gaudiosa1
Osmia titusi4
Hesperapis n. sp. elegantula83
Hesperapis carinata14
Hesperapis oliviae36