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=1511 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1511SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1019SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1511 ORDER BY register_no ASCSELECT 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='Thyreus' AND (junior_species='caeruleopunctatus' OR junior_species='caeruleopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyreus' AND (species='caeruleopunctatus' OR species='caeruleopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyreus' AND (species='caeruleopunctatus' OR species='caeruleopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyreus' AND (junior_species='caeruleopunctatus' OR junior_species='caeruleopunctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thyreus' AND (species='caeruleopunctatus' OR species='caeruleopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigona' AND (junior_species='carbonaria' OR junior_species='carbonaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trigona' AND (species='carbonaria' OR species='carbonaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trigona' AND (species='carbonaria' OR species='carbonaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigona' AND (junior_species='carbonaria' OR junior_species='carbonaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trigona' AND (species='carbonaria' OR species='carbonaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyphesma' AND (junior_species='atromicans' OR junior_species='atromicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyphesma' AND (species='atromicans' OR species='atromicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyphesma' AND (species='atromicans' OR species='atromicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyphesma' AND (junior_species='atromicans' OR junior_species='atromicans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyphesma' AND (species='atromicans' OR species='atromicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='advena' OR junior_species='advena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leioproctus' AND (species='advena' OR species='advena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leioproctus' AND (species='advena' OR species='advena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='advena' OR junior_species='advena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leioproctus' AND (species='advena' OR species='advena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='alleynae' OR junior_species='alleynae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leioproctus' AND (species='alleynae' OR species='alleynae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leioproctus' AND (species='alleynae' OR species='alleynae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='alleynae' OR junior_species='alleynae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leioproctus' AND (species='alleynae' OR species='alleynae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leioproctus' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leioproctus' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leioproctus' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' 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='Leioproctus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leioproctus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioproctus' 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='Leioproctus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='smaragdulus' OR junior_species='smaragdulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='smaragdulus' OR species='smaragdulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='smaragdulus' OR species='smaragdulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='smaragdulus' OR junior_species='smaragdulus')SELECT d.diet,d.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='smaragdulus' OR species='smaragdulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='caloundrensis' OR junior_species='caloundrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalictus' AND (species='caloundrensis' OR species='caloundrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalictus' AND (species='caloundrensis' OR species='caloundrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='caloundrensis' OR junior_species='caloundrensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalictus' AND (species='caloundrensis' OR species='caloundrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='ctenander' OR junior_species='ctenander')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalictus' AND (species='ctenander' OR species='ctenander') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalictus' AND (species='ctenander' OR species='ctenander')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='ctenander' OR junior_species='ctenander')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalictus' AND (species='ctenander' OR species='ctenander') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalictus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalictus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalictus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='sphecodoides' OR junior_species='sphecodoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalictus' AND (species='sphecodoides' OR species='sphecodoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalictus' AND (species='sphecodoides' OR species='sphecodoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='sphecodoides' OR junior_species='sphecodoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalictus' AND (species='sphecodoides' OR species='sphecodoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='urbanus' OR junior_species='urbanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalictus' AND (species='urbanus' OR species='urbanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalictus' AND (species='urbanus' OR species='urbanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalictus' AND (junior_species='urbanus' OR junior_species='urbanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalictus' AND (species='urbanus' OR species='urbanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='athrix' OR junior_species='athrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='athrix' OR species='athrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='athrix' OR species='athrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='athrix' OR junior_species='athrix')SELECT d.diet,d.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='athrix' OR species='athrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='brunnesetum' OR junior_species='brunnesetum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='brunnesetum' OR species='brunnesetum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='brunnesetum' OR species='brunnesetum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='brunnesetum' OR junior_species='brunnesetum')SELECT d.diet,d.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='brunnesetum' OR species='brunnesetum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cambagei' OR junior_species='cambageii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cambagei' OR species='cambageii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cambagei' OR species='cambageii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cambagei' OR junior_species='cambageii')SELECT d.diet,d.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='cambagei' OR species='cambageii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cephalochilum' OR junior_species='cephalochilum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cephalochilum' OR species='cephalochilum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cephalochilum' OR species='cephalochilum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cephalochilum' OR junior_species='cephalochilum')SELECT d.diet,d.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='cephalochilum' OR species='cephalochilum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='chapmani' OR junior_species='chapmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='chapmani' OR species='chapmanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='chapmani' OR species='chapmanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='chapmani' OR junior_species='chapmanii')SELECT d.diet,d.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='chapmani' OR species='chapmanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='clelandi' OR junior_species='clelandii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='clelandi' OR species='clelandii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='clelandi' OR species='clelandii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='clelandi' OR junior_species='clelandii')SELECT d.diet,d.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='clelandi' OR species='clelandii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cognatum' OR junior_species='cognatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='cognatum' OR species='cognatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='cognatum' OR species='cognatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='cognatum' OR junior_species='cognatum')SELECT d.diet,d.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='cognatum' OR species='cognatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='convexum' OR junior_species='convexum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='convexum' OR species='convexum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='convexum' OR species='convexum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='convexum' OR junior_species='convexum')SELECT d.diet,d.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='convexum' OR species='convexum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='ebeneum' OR junior_species='ebeneum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='ebeneum' OR species='ebeneum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='ebeneum' OR species='ebeneum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='ebeneum' OR junior_species='ebeneum')SELECT d.diet,d.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='ebeneum' OR species='ebeneum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='erythrurum' OR junior_species='erythrurum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='erythrurum' OR species='erythrurum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='erythrurum' OR species='erythrurum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='erythrurum' OR junior_species='erythrurum')SELECT d.diet,d.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='erythrurum' OR species='erythrurum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='expansifrons' OR junior_species='expansifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='expansifrons' OR species='expansifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='expansifrons' OR species='expansifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='expansifrons' OR junior_species='expansifrons')SELECT d.diet,d.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='expansifrons' OR species='expansifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='gilesi' OR junior_species='gilesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='gilesi' OR species='gilesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='gilesi' OR species='gilesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='gilesi' OR junior_species='gilesii')SELECT d.diet,d.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='gilesi' OR species='gilesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='globosum' OR junior_species='globosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='globosum' OR species='globosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='globosum' OR species='globosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='globosum' OR junior_species='globosum')SELECT d.diet,d.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='globosum' OR species='globosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='gynochilum' OR junior_species='gynochilum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='gynochilum' OR species='gynochilum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='gynochilum' OR species='gynochilum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='gynochilum' OR junior_species='gynochilum')SELECT d.diet,d.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='gynochilum' OR species='gynochilum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='helichrysi' OR junior_species='helichrysii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='helichrysi' OR species='helichrysii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='helichrysi' OR species='helichrysii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='helichrysi' OR junior_species='helichrysii')SELECT d.diet,d.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='helichrysi' OR species='helichrysii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hemichalceum' OR junior_species='hemichalceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='hemichalceum' OR species='hemichalceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='hemichalceum' OR species='hemichalceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='hemichalceum' OR junior_species='hemichalceum')SELECT d.diet,d.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='hemichalceum' OR species='hemichalceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitans' OR junior_species='imitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='imitans' OR species='imitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='imitans' OR species='imitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitans' OR junior_species='imitans')SELECT d.diet,d.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='imitans' OR species='imitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='instabilis' OR junior_species='instabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='instabilis' OR species='instabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='instabilis' OR species='instabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='instabilis' OR junior_species='instabilis')SELECT d.diet,d.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='instabilis' OR species='instabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='lanarium' OR junior_species='lanarium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='lanarium' OR species='lanarium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='lanarium' OR species='lanarium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='lanarium' OR junior_species='lanarium')SELECT d.diet,d.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='lanarium' OR species='lanarium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='macrops' OR junior_species='macrops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='macrops' OR species='macrops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='macrops' OR species='macrops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='macrops' OR junior_species='macrops')SELECT d.diet,d.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='macrops' OR species='macrops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='mundulum' OR junior_species='mundulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='mundulum' OR species='mundulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='mundulum' OR species='mundulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='mundulum' OR junior_species='mundulum')SELECT d.diet,d.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='mundulum' OR species='mundulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='obscurissimum' OR junior_species='obscurissimum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='obscurissimum' OR species='obscurissimum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='obscurissimum' OR species='obscurissimum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='obscurissimum' OR junior_species='obscurissimum')SELECT d.diet,d.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='obscurissimum' OR species='obscurissimum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='orbatum' OR junior_species='orbatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='orbatum' OR species='orbatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='orbatum' OR species='orbatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='orbatum' OR junior_species='orbatum')SELECT d.diet,d.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='orbatum' OR species='orbatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pachycephalum' OR junior_species='pachycephalum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='pachycephalum' OR species='pachycephalum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='pachycephalum' OR species='pachycephalum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='pachycephalum' OR junior_species='pachycephalum')SELECT d.diet,d.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='pachycephalum' OR species='pachycephalum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='repraesentans' OR junior_species='repraesentans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='repraesentans' OR species='repraesentans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='repraesentans' OR species='repraesentans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='repraesentans' OR junior_species='repraesentans')SELECT d.diet,d.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='repraesentans' OR species='repraesentans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sexsetum' OR junior_species='sexsetum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='sexsetum' OR species='sexsetum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sexsetum' OR species='sexsetum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='sexsetum' OR junior_species='sexsetum')SELECT d.diet,d.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='sexsetum' OR species='sexsetum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='tridens' OR junior_species='tridens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='tridens' OR species='tridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='tridens' OR species='tridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='tridens' OR junior_species='tridens')SELECT d.diet,d.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='tridens' OR species='tridens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='victoriellum' OR junior_species='victoriellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='victoriellum' OR species='victoriellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='victoriellum' OR species='victoriellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='victoriellum' OR junior_species='victoriellum')SELECT d.diet,d.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='victoriellum' OR species='victoriellum') 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='bryotrichum' OR junior_species='bryotrichum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='bryotrichum' OR species='bryotrichum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='bryotrichum' OR species='bryotrichum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='bryotrichum' OR junior_species='bryotrichum')SELECT d.diet,d.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='bryotrichum' OR species='bryotrichum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='tribuarium' OR junior_species='tribuarium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='tribuarium' OR species='tribuarium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='tribuarium' OR species='tribuarium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='tribuarium' OR junior_species='tribuarium')SELECT d.diet,d.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='tribuarium' OR species='tribuarium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='turneri' OR junior_species='turnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='turneri' OR species='turnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='turneri' OR species='turnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='turneri' OR junior_species='turnerii')SELECT d.diet,d.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='turneri' OR species='turnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitator' OR junior_species='imitator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='imitator' OR species='imitator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='imitator' OR species='imitator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='imitator' OR junior_species='imitator')SELECT d.diet,d.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='imitator' OR species='imitator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipotriches' AND (junior_species='flavoviridis' OR junior_species='flavoviridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lipotriches' AND (species='flavoviridis' OR species='flavoviridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lipotriches' AND (species='flavoviridis' OR species='flavoviridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipotriches' AND (junior_species='flavoviridis' OR junior_species='flavoviridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lipotriches' AND (species='flavoviridis' OR species='flavoviridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipotriches' AND (junior_species='phanerura' OR junior_species='phanerura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lipotriches' AND (species='phanerura' OR species='phanerura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lipotriches' AND (species='phanerura' OR species='phanerura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipotriches' AND (junior_species='phanerura' OR junior_species='phanerura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lipotriches' AND (species='phanerura' OR species='phanerura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='serricauda' OR junior_species='serricauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='serricauda' OR species='serricauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='serricauda' OR species='serricauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='serricauda' OR junior_species='serricauda')SELECT d.diet,d.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='serricauda' OR species='serricauda') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1511 The Ecological Register: New South Wales roadsides (yellow pan traps)
New South Wales roadsides (yellow pan traps)
Basic information
Sample name: New South Wales roadsides (yellow pan traps)

Reference: J. R. Gollan, M. B. Ashcroft, and M. Batley. 2011. Comparison of yellow and white pan traps in surveys of bee fauna in New South Wales, Australia (Hymenoptera: Apoidea: Anthophila). Australian Journal of Entomology 50:174-178 [ER 1019]
Geography
Country: Australia

State: New South Wales


Coordinate: 33° 52' S, 151° 13' E
Coordinate basis: based on nearby landmark

Geography comments: sites followed roads, were "spaced at distances of approximately 10 km", and were widely distributed in the area of Sydney (basis of coordinate)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: disturbed forest

Substrate: ground surface

Habitat comments: "open fields, riverside habitats, forests and roadside verges" that were "within 40 m of roads"

Methods
Life forms: bees

Sites: 255

Sampling methods: no design,pan traps

Sample size: 957 individuals

Years: 2008, 2009

Days: 738

Nets or traps: 2

Net or trap nights: 1476

Sampling comments: "Two yellow and two white pan traps" were placed "approximately 5 m apart at each site" and "collected after approximately 48 h"

Metadata
Sample number: 1511

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-04-26 10:58:23

Modified: 2015-04-26 01:04:30

Abundance distribution
50 species
17 singletons
total count 957
extrapolated richness: 93.4
Fisher's α: 11.215
geometric series k: 0.8904
Hurlbert's PIE: 0.8401
Shannon's H: 2.4968
Good's u: 0.9822
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Apis mellifera26
Thyreus caeruleopunctatus2
Trigona (Heterotrigona) carbonaria1
Hyphesma atromicans1
Leioproctus (Leioproctus) advena2
Leioproctus (Leioproctus) alleynae1
Leioproctus (Leioproctus) maculatus1
Leioproctus sp.11
Halictus (Seladonia) smaragdulus81
Homalictus (Homalictus) caloundrensis32
Homalictus (Homalictus) ctenander1
Homalictus (Homalictus) punctatus1
Homalictus (Homalictus) sphecodoides296
Homalictus (Homalictus) urbanus210
Lasioglossum (Chilalictus) athrix4
Lasioglossum (Chilalictus) brunnesetum3
Lasioglossum (Chilalictus) cambagei4
Lasioglossum (Chilalictus) cephalochilum4
Lasioglossum (Chilalictus) chapmani18
Lasioglossum (Chilalictus) clelandi29
Lasioglossum (Chilalictus) cognatum39
Lasioglossum (Chilalictus) convexum11
Lasioglossum (Chilalictus) ebeneum1
Lasioglossum (Chilalictus) erythrurum6
Lasioglossum (Chilalictus) expansifrons11
Lasioglossum (Chilalictus) gilesi15
Lasioglossum (Chilalictus) globosum16
Lasioglossum (Chilalictus) gynochilum1
Lasioglossum (Chilalictus) helichrysi39
Lasioglossum (Chilalictus) hemichalceum6
Lasioglossum (Chilalictus) imitans3
Lasioglossum (Chilalictus) instabilis1
Lasioglossum (Chilalictus) lanarium27
Lasioglossum (Chilalictus) macrops1
Lasioglossum (Chilalictus) mundulum1
Lasioglossum (Chilalictus) obscurissimum1
Lasioglossum (Chilalictus) orbatum3
Lasioglossum (Chilalictus) pachycephalum2
Lasioglossum (Chilalictus) repraesentans3
Lasioglossum (Chilalictus) sexsetum2
Lasioglossum (Chilalictus) tridens14
Lasioglossum (Chilalictus) victoriellum9
Lasioglossum (Ctenonomia) sp.1
Lasioglossum (Parasphecodes) bryotrichum3
Lasioglossum (Parasphecodes) tribuarium1
Lasioglossum (Parasphecodes) turneri1
Lasioglossum (Pseudochilalictus) imitator1
Lipotriches (Austronomia) flavoviridis2
Lipotriches (Austronomia) phanerura7
Megachile (Eutricharaea) serricauda1