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=1508 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1508SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1016SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1508 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='bradleyi' OR junior_species='bradleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='bradleyi' OR species='bradleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='bradleyi' OR species='bradleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='bradleyi' OR junior_species='bradleyii')SELECT d.diet,d.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='bradleyi' OR species='bradleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='carlini' OR junior_species='carlinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='carlini' OR species='carlinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='carlini' OR species='carlinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='carlini' OR junior_species='carlinii')SELECT d.diet,d.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='carlini' OR species='carlinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='carolina' OR junior_species='carolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='carolina' OR species='carolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='carolina' OR species='carolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='carolina' OR junior_species='carolina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='carolina' OR species='carolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='melanochroa' OR junior_species='melanochroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='melanochroa' OR species='melanochroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='melanochroa' OR species='melanochroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='melanochroa' OR junior_species='melanochroa')SELECT d.diet,d.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='melanochroa' OR species='melanochroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='nivalis' OR species='nivalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='nivalis' OR species='nivalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andrena' AND (species='nivalis' OR species='nivalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='regularis' OR junior_species='regularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='regularis' OR species='regularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='regularis' OR species='regularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='regularis' OR junior_species='regularis')SELECT d.diet,d.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='regularis' OR species='regularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='rufosignata' OR junior_species='rufosignata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='rufosignata' OR species='rufosignata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='rufosignata' OR species='rufosignata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='rufosignata' OR junior_species='rufosignata')SELECT d.diet,d.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='rufosignata' OR species='rufosignata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='sigmundi' OR junior_species='sigmundii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='sigmundi' OR species='sigmundii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='sigmundi' OR species='sigmundii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='sigmundi' OR junior_species='sigmundii')SELECT d.diet,d.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='sigmundi' OR species='sigmundii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='vicina' OR junior_species='vicina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='vicina' OR species='vicina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='vicina' OR species='vicina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='vicina' OR junior_species='vicina')SELECT d.diet,d.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='vicina' OR species='vicina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='wheeleri' OR species='wheelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='wheeleri' OR species='wheelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT d.diet,d.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='wheeleri' OR species='wheelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andrena' AND (species='wheeleri' OR species='wheelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andrena' AND (species='wheeleri' OR species='wheelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andrena' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT d.diet,d.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='wheeleri' OR species='wheelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlorella' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Augochlorella' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Augochlorella' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Augochlorella' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Augochlorella' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='ternarius' OR junior_species='ternarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='ternarius' OR species='ternarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='ternarius' OR species='ternarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='ternarius' OR junior_species='ternarius')SELECT d.diet,d.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='ternarius' OR species='ternarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='terricola' OR junior_species='terricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='terricola' OR species='terricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='terricola' OR species='terricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='terricola' OR junior_species='terricola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='terricola' OR species='terricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='vagans' OR junior_species='vagans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombus' AND (species='vagans' OR species='vagans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombus' AND (species='vagans' OR species='vagans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombus' AND (junior_species='vagans' OR junior_species='vagans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bombus' AND (species='vagans' OR species='vagans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='inaequalis' OR species='inaequalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='inaequalis' OR species='inaequalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT d.diet,d.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='inaequalis' OR species='inaequalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' 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='Dialictus' AND (species='albipennis' OR species='albipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialictus' AND (species='albipennis' OR species='albipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' 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='Dialictus' AND (species='albipennis' OR species='albipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='cressoni' OR junior_species='cressonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialictus' AND (species='cressoni' OR species='cressonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialictus' AND (species='cressoni' OR species='cressonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='cressoni' OR junior_species='cressonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialictus' AND (species='cressoni' OR species='cressonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='imitatus' OR junior_species='imitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialictus' AND (species='imitatus' OR species='imitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialictus' AND (species='imitatus' OR species='imitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='imitatus' OR junior_species='imitatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialictus' AND (species='imitatus' OR species='imitatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='perpunctatus' OR junior_species='perpunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialictus' AND (species='perpunctatus' OR species='perpunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialictus' AND (species='perpunctatus' OR species='perpunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='perpunctatus' OR junior_species='perpunctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialictus' AND (species='perpunctatus' OR species='perpunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='pilosus' OR junior_species='pilosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialictus' AND (species='pilosus' OR species='pilosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialictus' AND (species='pilosus' OR species='pilosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialictus' AND (junior_species='pilosus' OR junior_species='pilosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialictus' AND (species='pilosus' OR species='pilosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='divergens' OR junior_species='divergens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evylaeus' AND (species='divergens' OR species='divergens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evylaeus' AND (species='divergens' OR species='divergens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='divergens' OR junior_species='divergens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Evylaeus' AND (species='divergens' OR species='divergens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='foxii' OR junior_species='foxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evylaeus' AND (species='foxii' OR species='foxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evylaeus' AND (species='foxii' OR species='foxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='foxii' OR junior_species='foxi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Evylaeus' AND (species='foxii' OR species='foxi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='quebecensis' OR junior_species='quebecensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evylaeus' AND (species='quebecensis' OR species='quebecensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evylaeus' AND (species='quebecensis' OR species='quebecensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evylaeus' AND (junior_species='quebecensis' OR junior_species='quebecensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Evylaeus' AND (species='quebecensis' OR species='quebecensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='confusus' OR junior_species='confusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='confusus' OR species='confusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='confusus' OR species='confusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='confusus' OR junior_species='confusus')SELECT d.diet,d.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='confusus' OR species='confusus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='rubicundus' OR junior_species='rubicundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='rubicundus' OR species='rubicundus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='rubicundus' OR species='rubicundus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='rubicundus' OR junior_species='rubicundus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halictus' AND (species='rubicundus' OR species='rubicundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='acuminatum' OR junior_species='acuminatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasioglossum' AND (species='acuminatum' OR species='acuminatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='acuminatum' OR species='acuminatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' AND (junior_species='acuminatum' OR junior_species='acuminatum')SELECT d.diet,d.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='acuminatum' OR species='acuminatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomada' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomada' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nomada' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='atriventris' OR junior_species='atriventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='atriventris' OR species='atriventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='atriventris' OR species='atriventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='atriventris' OR junior_species='atriventris')SELECT d.diet,d.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='atriventris' OR species='atriventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='inermis' OR junior_species='inermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='inermis' OR junior_species='inermis')SELECT d.diet,d.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='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='lignaria' OR junior_species='lignaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='lignaria' OR species='lignaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='lignaria' OR species='lignaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='lignaria' OR junior_species='lignaria')SELECT d.diet,d.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='lignaria' OR species='lignaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='virga' OR junior_species='virga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='virga' OR species='virga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='virga' OR species='virga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='virga' OR junior_species='virga')SELECT d.diet,d.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='virga' OR species='virga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphecodes' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphecodes' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphecodes' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphecodes' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sphecodes' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1508 The Ecological Register: Deblois (1989)
Deblois (1989)
Basic information
Sample name: Deblois (1989)

Reference: C. S. Stubb, H. A. Jacobson, E. A. Osgood, and F. A. Drummond. 1992. Alternative forage plants for native (wild) bees associated with lowbush blueberry, Vaccinium spp., in Maine. Maine Agricultural Experiment Station Technical Bulletin 148:1-53 [ER 1016]
Geography
Country: United States

State: Maine


Coordinate: 44° 44' N, 68° 1' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Deblois

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: "fields"

Methods
Life forms: bees

Sampling methods: line transect,sweep nets

Sample size: 190 individuals

Years: 1989

Seasons: spring

Sampling comments: "collected on blueberry bloom using a sweep net with a 15-in. n et ring and a 5-ft. handle" along a "transect"; "Each sample consisted of 50 sweeps"
there were four days of sampling in this site and another one, so sampling effort is unclear

Metadata
Sample number: 1508

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-04-26 09:04:12

Modified: 2015-04-25 23:04:12

Abundance distribution
33 species
12 singletons
total count 190
extrapolated richness: 68.8
Fisher's α: 11.537
geometric series k: 0.9021
Hurlbert's PIE: 0.9189
Shannon's H: 2.8687
Good's u: 0.9371
Each square represents a species. Square sizes are proportional to counts.
Register