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=2706 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2706SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2447SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2706 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='allosticta' OR junior_species='allosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='allosticta' OR species='allosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='allosticta' OR species='allosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='allosticta' OR junior_species='allosticta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='allosticta' OR species='allosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='azureoviridis' OR junior_species='azureoviridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='azureoviridis' OR species='azureoviridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='azureoviridis' OR species='azureoviridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='azureoviridis' OR junior_species='azureoviridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='azureoviridis' OR species='azureoviridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='bursigera' OR junior_species='bursigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='bursigera' OR species='bursigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='bursigera' OR species='bursigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='bursigera' OR junior_species='bursigera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='bursigera' OR species='bursigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='championi' OR junior_species='championii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='championi' OR species='championii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='championi' OR species='championii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='championi' OR junior_species='championii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='championi' OR species='championii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cognata' OR junior_species='cognata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cognata' OR species='cognata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cognata' OR species='cognata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cognata' OR junior_species='cognata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='cognata' OR species='cognata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='crassipunctata' OR junior_species='crassipunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='crassipunctata' OR species='crassipunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='crassipunctata' OR species='crassipunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='crassipunctata' OR junior_species='crassipunctata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='crassipunctata' OR species='crassipunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cyanaspis' OR junior_species='cyanaspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cyanaspis' OR species='cyanaspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cyanaspis' OR species='cyanaspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cyanaspis' OR junior_species='cyanaspis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='cyanaspis' OR species='cyanaspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cybelia' OR junior_species='cybelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='cybelia' OR species='cybelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='cybelia' OR species='cybelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='cybelia' OR junior_species='cybelia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='cybelia' OR species='cybelia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='despecta' OR junior_species='despecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='despecta' OR species='despecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='despecta' OR species='despecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='despecta' OR junior_species='despecta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='despecta' OR species='despecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dissimula' OR junior_species='dissimula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dissimula' OR species='dissimula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dissimula' OR species='dissimula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dissimula' OR junior_species='dissimula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='dissimula' OR species='dissimula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dodsoni' OR junior_species='dodsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dodsoni' OR species='dodsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dodsoni' OR species='dodsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dodsoni' OR junior_species='dodsonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='dodsoni' OR species='dodsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dressleri' OR junior_species='dresslerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='dressleri' OR species='dresslerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='dressleri' OR species='dresslerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='dressleri' OR junior_species='dresslerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='dressleri' OR species='dresslerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='gorgonensis' OR junior_species='gorgonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='gorgonensis' OR species='gorgonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='gorgonensis' OR species='gorgonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='gorgonensis' OR junior_species='gorgonensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='gorgonensis' OR species='gorgonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hansoni' OR junior_species='hansonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='hansoni' OR species='hansonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='hansoni' OR species='hansonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='hansoni' OR junior_species='hansonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='hansoni' OR species='hansonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='heterosticta' OR junior_species='heterosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='heterosticta' OR species='heterosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='heterosticta' OR species='heterosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='heterosticta' OR junior_species='heterosticta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='heterosticta' OR species='heterosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='igniventris' OR junior_species='igniventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='igniventris' OR species='igniventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='igniventris' OR species='igniventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='igniventris' OR junior_species='igniventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='igniventris' OR species='igniventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='imperialis' OR species='imperialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='mixta' OR junior_species='mixta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='mixta' OR species='mixta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='mixta' OR species='mixta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='mixta' OR junior_species='mixta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='mixta' OR species='mixta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='purpurea' OR species='purpurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='purpurea' OR species='purpurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='purpurea' OR species='purpurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='sapphirina' OR junior_species='sapphirina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='sapphirina' OR species='sapphirina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='sapphirina' OR species='sapphirina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='sapphirina' OR junior_species='sapphirina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='sapphirina' OR species='sapphirina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='tridentata' OR junior_species='tridentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='tridentata' OR species='tridentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='tridentata' OR species='tridentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='tridentata' OR junior_species='tridentata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='tridentata' OR species='tridentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='villosiventris' OR junior_species='villosiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euglossa' AND (species='villosiventris' OR species='villosiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euglossa' AND (species='villosiventris' OR species='villosiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euglossa' AND (junior_species='villosiventris' OR junior_species='villosiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euglossa' AND (species='villosiventris' OR species='villosiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='concava' OR junior_species='concava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesia' AND (species='concava' OR species='concava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesia' AND (species='concava' OR species='concava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='concava' OR junior_species='concava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eufriesia' AND (species='concava' OR species='concava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='lucifera' OR junior_species='lucifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesia' AND (species='lucifera' OR species='lucifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesia' AND (species='lucifera' OR species='lucifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='lucifera' OR junior_species='lucifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eufriesia' AND (species='lucifera' OR species='lucifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='pulchra' OR junior_species='pulchra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eufriesia' AND (species='pulchra' OR species='pulchra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eufriesia' AND (species='pulchra' OR species='pulchra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eufriesia' AND (junior_species='pulchra' OR junior_species='pulchra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eufriesia' AND (species='pulchra' OR species='pulchra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombiformis' OR junior_species='bombiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='bombiformis' OR species='bombiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='bombiformis' OR species='bombiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='bombiformis' OR junior_species='bombiformis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaema' AND (species='bombiformis' OR species='bombiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='cingulata' OR junior_species='cingulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='cingulata' OR species='cingulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='cingulata' OR species='cingulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='cingulata' OR junior_species='cingulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaema' AND (species='cingulata' OR species='cingulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='meriana' OR junior_species='meriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='meriana' OR species='meriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='meriana' OR species='meriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='meriana' OR junior_species='meriana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaema' AND (species='meriana' OR species='meriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='nigrita' OR species='nigrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='nigrita' OR species='nigrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaema' AND (species='nigrita' OR species='nigrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='polychroma' OR junior_species='polychroma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaema' AND (species='polychroma' OR species='polychroma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaema' AND (species='polychroma' OR species='polychroma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaema' AND (junior_species='polychroma' OR junior_species='polychroma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaema' AND (species='polychroma' OR species='polychroma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exaerete' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exaerete' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Exaerete' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='smaragdina' OR junior_species='smaragdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exaerete' AND (species='smaragdina' OR species='smaragdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Exaerete' AND (species='smaragdina' OR species='smaragdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exaerete' AND (junior_species='smaragdina' OR junior_species='smaragdina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Exaerete' AND (species='smaragdina' OR species='smaragdina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2706 The Ecological Register: Tower Clearing (dry season, weeks 2-14)
Tower Clearing (dry season, weeks 2-14)
Basic information
Sample name: Tower Clearing (dry season, weeks 2-14)

Sample aka: Barro Colorado Island

Reference: J. D. Ackerman. 1983. Diversity and seasonality of male euglossine bees (Hymenoptera: Apidae) in central Panamá. Ecology 64(2):274-283 [ER 2447]
Geography
Country: Panama


Coordinate: 9° 9' N, 79° 51' W
Coordinate basis: based on nearby landmark

Geography comments: "The Tower Clearing lies at the summit and approximate geographical center of BCI" (coordinate based on Barro Colorado Island)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

Habitat comments: " semievergreen tropical forest... or tropical moist forest... a tropical monsoon climate... annual rainfall ranges from 190 to 360 cm... The climate is distinctly seasonal with a dry period of 3-4 mo beginning near mid-December"

Methods
Life forms: orchid bees

Sites: 1

Sampling methods: no design,baited,hand capture,visual

Sample size: 6887 individuals

Years: 1979

Days: 13

Seasons: dry

Sampling comments: "16 chemical baits" were used, and "most are known constituents of floral fragrance... Each chemical was applied to separate 7 x 7 cm pads of clean herbarium blotter paper... From 0830 to 1230 I presented the chemical baits... At 15-min intervals I recorded all visitors to each of the compounds... Only vouchers and taxonomically difficult species were captured... Every week from mid-February 1979 to mid-March 1980, I baited for bees at the Tower Clearing. Thereafter, I baited once every 4 wk through June 1980" but these data are for weeks 2 through 14 only

Metadata
Sample number: 2706

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-04-16 18:00:11

Modified: 2017-04-16 08:00:11

Abundance distribution
33 species
2 singletons
total count 6887
extrapolated richness: 37.8
Fisher's α: 4.500
geometric series k: 0.7889
Hurlbert's PIE: 0.8458
Shannon's H: 2.2897
Good's u: 0.9997
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Euglossa allosticta134
Euglossa azureoviridis27
Euglossa bursigera83
Euglossa championi9
Euglossa cognata55
Euglossa crassipunctata47
Euglossa cyanaspis13
Euglossa cybelia1
Euglossa despecta226
Euglossa dissimula624
Euglossa dodsoni12
Euglossa dressleri15
Euglossa gorgonensis2
Euglossa hansoni101
Euglossa heterosticta57
Euglossa igniventris13
Euglossa imperialis1405
Euglossa mixta109
Euglossa purpurea12
Euglossa sapphirina32
Euglossa tridentata1971
Euglossa variabilis254
Euglossa villosiventris1
Eufriesia concava5
Eufriesia lucifera4
Eufriesia pulchra28
Eulaema bombiformis15
Eulaema cingulata507
Eulaema meriana392
Eulaema nigrita691
Eulaema polychroma3
Exaerete frontalis31
Exaerete smaragdina8