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=2363 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2363SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2266SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2363 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='Cephalotrigona' AND (junior_species='capitata' OR junior_species='capitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalotrigona' AND (species='capitata' OR species='capitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cephalotrigona' AND (species='capitata' OR species='capitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalotrigona' AND (junior_species='capitata' OR junior_species='capitata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cephalotrigona' AND (species='capitata' OR species='capitata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melipona' AND (junior_species='beecheii' OR junior_species='beechei')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melipona' AND (species='beecheii' OR species='beechei') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melipona' AND (species='beecheii' OR species='beechei')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melipona' AND (junior_species='beecheii' OR junior_species='beechei')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melipona' AND (species='beecheii' OR species='beechei') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannotrigona' AND (junior_species='testaceicornis' OR junior_species='testaceicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nannotrigona' AND (species='testaceicornis' OR species='testaceicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nannotrigona' AND (species='testaceicornis' OR species='testaceicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannotrigona' AND (junior_species='testaceicornis' OR junior_species='testaceicornis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nannotrigona' AND (species='testaceicornis' OR species='testaceicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigona' AND (junior_species='angustula' OR junior_species='angustula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trigona' AND (species='angustula' OR species='angustula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trigona' AND (species='angustula' OR species='angustula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigona' AND (junior_species='angustula' OR junior_species='angustula')SELECT d.diet,d.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='angustula' OR species='angustula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='adani' OR junior_species='adanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='adani' OR species='adanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='adani' OR species='adanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='adani' OR junior_species='adanii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='adani' OR species='adanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='aethyctera' OR junior_species='aethyctera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='aethyctera' OR species='aethyctera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='aethyctera' OR species='aethyctera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='aethyctera' OR junior_species='aethyctera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='aethyctera' OR species='aethyctera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='analis' OR junior_species='analis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='bicornuta' OR junior_species='bicornuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='bicornuta' OR species='bicornuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='bicornuta' OR species='bicornuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='bicornuta' OR junior_species='bicornuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='bicornuta' OR species='bicornuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='flavifrons' OR junior_species='flavifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='flavifrons' OR species='flavifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='flavifrons' OR species='flavifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='flavifrons' OR junior_species='flavifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='flavifrons' OR species='flavifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='heithausi' OR junior_species='heithausii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='heithausi' OR species='heithausii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='heithausi' OR species='heithausii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='heithausi' OR junior_species='heithausii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='heithausi' OR species='heithausii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' 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='Centris' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' 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='Centris' AND (species='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='trigonoides' OR junior_species='trigonoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='trigonoides' OR species='trigonoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='trigonoides' OR species='trigonoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='trigonoides' OR junior_species='trigonoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centris' AND (species='trigonoides' OR species='trigonoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exomalopsis' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exomalopsis' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Exomalopsis' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' AND (junior_species='mellipes' OR junior_species='mellipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exomalopsis' AND (species='mellipes' OR species='mellipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exomalopsis' AND (species='mellipes' OR species='mellipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' AND (junior_species='mellipes' OR junior_species='mellipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Exomalopsis' AND (species='mellipes' OR species='mellipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' 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='Exomalopsis' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exomalopsis' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exomalopsis' 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='Exomalopsis' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gaesischia' AND (junior_species='exul' OR junior_species='exul')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gaesischia' AND (species='exul' OR species='exul') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gaesischia' AND (species='exul' OR species='exul')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gaesischia' AND (junior_species='exul' OR junior_species='exul')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gaesischia' AND (species='exul' OR species='exul') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tepaneca' OR junior_species='tepaneca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='tepaneca' OR species='tepaneca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='tepaneca' OR species='tepaneca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tepaneca' OR junior_species='tepaneca')SELECT d.diet,d.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='tepaneca' OR species='tepaneca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoplia' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesoplia' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesoplia' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoplia' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesoplia' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoplia' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesoplia' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesoplia' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoplia' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesoplia' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemom' AND (junior_species='nasutus' OR junior_species='nasutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemom' AND (species='nasutus' OR species='nasutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemom' AND (species='nasutus' OR species='nasutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemom' AND (junior_species='nasutus' OR junior_species='nasutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agapostemom' AND (species='nasutus' OR species='nasutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='lutescens' OR junior_species='lutescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='lutescens' OR species='lutescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='lutescens' OR species='lutescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='lutescens' OR junior_species='lutescens')SELECT d.diet,d.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='lutescens' OR species='lutescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='hesperus' OR junior_species='hesperus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halictus' AND (species='hesperus' OR species='hesperus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halictus' AND (species='hesperus' OR species='hesperus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halictus' AND (junior_species='hesperus' OR junior_species='hesperus')SELECT d.diet,d.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='hesperus' OR species='hesperus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' 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='Coelioxys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelioxys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' 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='Coelioxys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='abacula' OR junior_species='abacula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='abacula' OR species='abacula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='abacula' OR species='abacula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='abacula' OR junior_species='abacula')SELECT d.diet,d.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='abacula' OR species='abacula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='axyx' OR junior_species='axyx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='axyx' OR species='axyx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='axyx' OR species='axyx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='axyx' OR junior_species='axyx')SELECT d.diet,d.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='axyx' OR species='axyx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='chichimeca' OR junior_species='chichimeca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='chichimeca' OR species='chichimeca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='chichimeca' OR species='chichimeca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='chichimeca' OR junior_species='chichimeca')SELECT d.diet,d.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='chichimeca' OR species='chichimeca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='exaltata' OR junior_species='exaltata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='exaltata' OR species='exaltata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='exaltata' OR species='exaltata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='exaltata' OR junior_species='exaltata')SELECT d.diet,d.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='exaltata' OR species='exaltata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='otomita' OR junior_species='otomita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='otomita' OR species='otomita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='otomita' OR species='otomita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='otomita' OR junior_species='otomita')SELECT d.diet,d.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='otomita' OR species='otomita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='toluca' OR junior_species='toluca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='toluca' OR species='toluca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='toluca' OR species='toluca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='toluca' OR junior_species='toluca')SELECT d.diet,d.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='toluca' OR species='toluca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='zexmeniae' OR junior_species='zexmeniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='zexmeniae' OR species='zexmeniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='zexmeniae' OR species='zexmeniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='zexmeniae' OR junior_species='zexmeniae')SELECT d.diet,d.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='zexmeniae' OR species='zexmeniae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2363 The Ecological Register: Liberia
Liberia
Basic information
Sample name: Liberia

Reference: G. W. Frankie, M. Rizzardi, S. B. Vinson, and T. L. Griswold. 2009. Decline in bee diversity and abundance from 1972-2004 on a flowering leguminous tree, Andira intermix in Costa Rica at the interface of disturbed dry forest and the urban environment. Journal of the Kansas Entomological Society 82(1):1-20 [ER 2266]
Geography
Country: Costa Rica

State: Guanacaste


Coordinate: 10° 38' N, 85° 26' W
Coordinate basis: based on nearby landmark

Geography comments: "along the Pan American highway within one kilometer of urban residential neighborhoods of Liberia" (coordinate based on Liberia)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

Habitat comments: "Trees of A. inermis, ranging in age from 45–75 yr in 2004, had been planted along a fence row on the east side of the highway... there was little undisturbed native habitat left around the study trees"

Methods
Life forms: bees

Sampling methods: no design,sweep nets

Sample size: 1057 individuals

Years: 2004

Sampling comments: "Twelve of the 38 [trees] flowered vigorously in late February 2004, and eight of these were sampled... Using long- handled aerial nets, a total of 96 aerial sweeps were taken in a series of steps from each tree with two collectors working together. At the upper crown level of each tree, six separate collections of eight sweeps each were taken (for total of 48). The same procedure was followed at the lower crown level of each tree for a second set of 48 sweeps"

Metadata
Sample number: 2363

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-11-19 09:07:01

Modified: 2020-01-14 05:05:32

Abundance distribution
31 species
4 singletons
total count 1057
extrapolated richness: 45.3
Fisher's α: 5.985
geometric series k: 0.8196
Hurlbert's PIE: 0.7954
Shannon's H: 2.0827
Good's u: 0.9962
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Apis mellifera scutellata205
Cephalotrigona capitata7
Melipona beecheii2
Nannotrigona testaceicornis15
Trigona angustula1
Centris adani391
Centris aethyctera32
Centris analis2
Centris bicornuta2
Centris flavifrons2
Centris heithausi3
Centris inermis28
Centris trigonoides37
Exomalopsis mexicana27
Exomalopsis mellipes1
Exomalopsis similis89
Gaesischia exul144
Melissodes tepaneca4
Mesoplia rufipes13
Mesoplia 'bicolor'1
Agapostemom nasutus14
Halictus lutescens5
Halictus hesperus2
Coelioxys sp.1
Megachile abacula3
Megachile axyx6
Megachile chichimeca3
Megachile exaltata4
Megachile otomita7
Megachile toluca4
Megachile zexmeniae2