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=1125 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1125SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=780SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1125 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crypturellus' AND (species='parvirostris' OR species='parvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crypturellus' AND (species='parvirostris' OR species='parvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='parvirostris' OR junior_species='parvirostris')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='Crypturellus' AND (species='parvirostris' OR species='parvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porzana' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porzana' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='albicollis' OR junior_species='albicollis')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='Porzana' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='picui' OR junior_species='picuii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columbina' AND (species='picui' OR species='picuii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columbina' AND (species='picui' OR species='picuii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='picui' OR junior_species='picuii')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='Columbina' AND (species='picui' OR species='picuii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='talpacoti' OR junior_species='talpacotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columbina' AND (species='talpacoti' OR species='talpacotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columbina' AND (species='talpacoti' OR species='talpacotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='talpacoti' OR junior_species='talpacotii')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='Columbina' AND (species='talpacoti' OR species='talpacotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scardafella' AND (junior_species='squammata' OR junior_species='squammata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scardafella' AND (species='squammata' OR species='squammata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scardafella' AND (species='squammata' OR species='squammata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scardafella' AND (junior_species='squammata' OR junior_species='squammata')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='Scardafella' AND (species='squammata' OR species='squammata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brotogeris' AND (junior_species='chiriri' OR junior_species='chiririi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brotogeris' AND (species='chiriri' OR species='chiririi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brotogeris' AND (species='chiriri' OR species='chiririi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brotogeris' AND (junior_species='chiriri' OR junior_species='chiririi')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='Brotogeris' AND (species='chiriri' OR species='chiririi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')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='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='pretrei' OR species='pretreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')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='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocharis' AND (junior_species='chrysura' OR junior_species='chrysura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylocharis' AND (species='chrysura' OR species='chrysura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocharis' AND (species='chrysura' OR species='chrysura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocharis' AND (junior_species='chrysura' OR junior_species='chrysura')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='Hylocharis' AND (species='chrysura' OR species='chrysura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorostilbon' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorostilbon' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='lucidus' OR junior_species='lucidus')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='Chlorostilbon' AND (species='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctibeus' AND (junior_species='griseus' OR junior_species='griseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctibeus' AND (species='griseus' OR species='griseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctibeus' AND (species='griseus' OR species='griseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctibeus' AND (junior_species='griseus' OR junior_species='griseus')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='Nyctibeus' AND (species='griseus' OR species='griseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='parvulus' OR junior_species='parvulus')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='Caprimulgus' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydropsalis' AND (junior_species='brasilianus' OR junior_species='brasilianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydropsalis' AND (species='brasilianus' OR species='brasilianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydropsalis' AND (species='brasilianus' OR species='brasilianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydropsalis' AND (junior_species='brasilianus' OR junior_species='brasilianus')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='Hydropsalis' AND (species='brasilianus' OR species='brasilianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleothreptus' AND (junior_species='candicans' OR junior_species='candicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleothreptus' AND (species='candicans' OR species='candicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleothreptus' AND (species='candicans' OR species='candicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleothreptus' AND (junior_species='candicans' OR junior_species='candicans')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='Eleothreptus' AND (species='candicans' OR species='candicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctidromus' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctidromus' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctidromus' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctidromus' AND (junior_species='albicollis' OR junior_species='albicollis')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='Nyctidromus' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='cirratus' OR species='cirratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')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='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taraba' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taraba' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taraba' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taraba' AND (junior_species='major' OR junior_species='major')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='Taraba' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicivora' AND (junior_species='rufa' OR junior_species='rufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicivora' AND (species='rufa' OR species='rufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicivora' AND (species='rufa' OR species='rufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicivora' AND (junior_species='rufa' OR junior_species='rufa')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='Formicivora' AND (species='rufa' OR species='rufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furnarius' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furnarius' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furnarius' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furnarius' AND (junior_species='rufus' OR junior_species='rufus')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='Furnarius' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='albescens' OR junior_species='albescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='albescens' OR species='albescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='albescens' OR species='albescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='albescens' OR junior_species='albescens')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='Synallaxis' AND (species='albescens' OR species='albescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='angustirostris' OR junior_species='angustirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='angustirostris' OR junior_species='angustirostris')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='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptostoma' AND (junior_species='obsoletum' OR junior_species='obsoletum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camptostoma' AND (species='obsoletum' OR species='obsoletum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camptostoma' AND (species='obsoletum' OR species='obsoletum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptostoma' AND (junior_species='obsoletum' OR junior_species='obsoletum')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='Camptostoma' AND (species='obsoletum' OR species='obsoletum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='chiriquensis' OR species='chiriquensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='chiriquensis' OR species='chiriquensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')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='Elaenia' AND (species='chiriquensis' OR species='chiriquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='parvirostris' OR species='parvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='parvirostris' OR species='parvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')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='Elaenia' AND (species='parvirostris' OR species='parvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='flavogaster' OR species='flavogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='flavogaster' OR species='flavogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')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='Elaenia' AND (species='flavogaster' OR species='flavogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euscarthamus' AND (junior_species='meloryphus' OR junior_species='meloryphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euscarthamus' AND (species='meloryphus' OR species='meloryphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euscarthamus' AND (species='meloryphus' OR species='meloryphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euscarthamus' AND (junior_species='meloryphus' OR junior_species='meloryphus')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='Euscarthamus' AND (species='meloryphus' OR species='meloryphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='margaritaceiventer' OR junior_species='margaritaceiventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='margaritaceiventer' OR species='margaritaceiventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='margaritaceiventer' OR species='margaritaceiventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='margaritaceiventer' OR junior_species='margaritaceiventer')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='Hemitriccus' AND (species='margaritaceiventer' OR species='margaritaceiventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiophobus' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiophobus' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiophobus' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiophobus' AND (junior_species='fasciatus' OR junior_species='fasciatus')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='Myiophobus' AND (species='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')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='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casiornis' AND (junior_species='rufa' OR junior_species='rufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casiornis' AND (species='rufa' OR species='rufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casiornis' AND (species='rufa' OR species='rufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casiornis' AND (junior_species='rufa' OR junior_species='rufa')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='Casiornis' AND (species='rufa' OR species='rufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='ferox' OR junior_species='ferox')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='Myiarchus' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')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='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitangus' AND (junior_species='sulphuratus' OR junior_species='sulphuratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitangus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitangus' AND (species='sulphuratus' OR species='sulphuratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitangus' AND (junior_species='sulphuratus' OR junior_species='sulphuratus')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='Pitangus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' 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='Myiozetetes' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiozetetes' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' 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='Myiozetetes' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')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='Pipra' AND (species='fasciicauda' OR species='fasciicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrochelidon' AND (junior_species='pyrrhonata' OR junior_species='pyrrhonata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petrochelidon' AND (species='pyrrhonata' OR species='pyrrhonata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petrochelidon' AND (species='pyrrhonata' OR species='pyrrhonata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrochelidon' AND (junior_species='pyrrhonata' OR junior_species='pyrrhonata')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='Petrochelidon' AND (species='pyrrhonata' OR species='pyrrhonata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='aedon' OR species='aedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')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='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')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='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')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='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')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='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='aequinoctialis' OR junior_species='aequinoctialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geothlypis' AND (species='aequinoctialis' OR species='aequinoctialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geothlypis' AND (species='aequinoctialis' OR species='aequinoctialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='aequinoctialis' OR junior_species='aequinoctialis')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='Geothlypis' AND (species='aequinoctialis' OR species='aequinoctialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='flaveolus' OR junior_species='flaveolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='flaveolus' OR species='flaveolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='flaveolus' OR species='flaveolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='flaveolus' OR junior_species='flaveolus')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='Basileuterus' AND (species='flaveolus' OR species='flaveolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipraeidea' AND (species='melanonota' OR species='melanonota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')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='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacnis' AND (species='cayana' OR species='cayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')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='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='sayaca' OR junior_species='sayaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thraupis' AND (species='sayaca' OR species='sayaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thraupis' AND (species='sayaca' OR species='sayaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='sayaca' OR junior_species='sayaca')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='Thraupis' AND (species='sayaca' OR species='sayaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neothraupis' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neothraupis' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neothraupis' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neothraupis' AND (junior_species='fasciata' OR junior_species='fasciata')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='Neothraupis' AND (species='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cypsnagra' AND (junior_species='hirundinacea' OR junior_species='hirundinacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cypsnagra' AND (species='hirundinacea' OR species='hirundinacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cypsnagra' AND (species='hirundinacea' OR species='hirundinacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cypsnagra' AND (junior_species='hirundinacea' OR junior_species='hirundinacea')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='Cypsnagra' AND (species='hirundinacea' OR species='hirundinacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='atricollis' OR junior_species='atricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='atricollis' OR species='atricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='atricollis' OR species='atricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='atricollis' OR junior_species='atricollis')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='Saltator' AND (species='atricollis' OR species='atricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphospingus' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coryphospingus' AND (species='cucullatus' OR species='cucullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coryphospingus' AND (species='cucullatus' OR species='cucullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphospingus' AND (junior_species='cucullatus' OR junior_species='cucullatus')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='Coryphospingus' AND (species='cucullatus' OR species='cucullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryzoborus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryzoborus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' AND (junior_species='angolensis' OR junior_species='angolensis')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='Oryzoborus' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='caerulescens' OR junior_species='caerulescens')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='Sporophila' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='hypoxantha' OR junior_species='hypoxantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='hypoxantha' OR species='hypoxantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='hypoxantha' OR species='hypoxantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='hypoxantha' OR junior_species='hypoxantha')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='Sporophila' AND (species='hypoxantha' OR species='hypoxantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='leucoptera' OR junior_species='leucoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='leucoptera' OR species='leucoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='leucoptera' OR species='leucoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='leucoptera' OR junior_species='leucoptera')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='Sporophila' AND (species='leucoptera' OR species='leucoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Volatinia' AND (junior_species='jacarina' OR junior_species='jacarina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Volatinia' AND (species='jacarina' OR species='jacarina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Volatinia' AND (species='jacarina' OR species='jacarina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Volatinia' AND (junior_species='jacarina' OR junior_species='jacarina')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='Volatinia' AND (species='jacarina' OR species='jacarina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberizoides' AND (junior_species='herbicola' OR junior_species='herbicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberizoides' AND (species='herbicola' OR species='herbicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberizoides' AND (species='herbicola' OR species='herbicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberizoides' AND (junior_species='herbicola' OR junior_species='herbicola')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='Emberizoides' AND (species='herbicola' OR species='herbicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammodramus' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammodramus' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ammodramus' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammodramus' AND (junior_species='humeralis' OR junior_species='humeralis')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='Ammodramus' AND (species='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='pyrrhopterus' OR junior_species='pyrrhopterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icterus' AND (species='pyrrhopterus' OR species='pyrrhopterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icterus' AND (species='pyrrhopterus' OR species='pyrrhopterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='pyrrhopterus' OR junior_species='pyrrhopterus')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='Icterus' AND (species='pyrrhopterus' OR species='pyrrhopterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='rufoaxillaris' OR junior_species='rufoaxillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molothrus' AND (species='rufoaxillaris' OR species='rufoaxillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molothrus' AND (species='rufoaxillaris' OR species='rufoaxillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='rufoaxillaris' OR junior_species='rufoaxillaris')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='Molothrus' AND (species='rufoaxillaris' OR species='rufoaxillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnorimopsar' AND (junior_species='chopi' OR junior_species='chopii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnorimopsar' AND (species='chopi' OR species='chopii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnorimopsar' AND (species='chopi' OR species='chopii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnorimopsar' AND (junior_species='chopi' OR junior_species='chopii')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='Gnorimopsar' AND (species='chopi' OR species='chopii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='chlorotica' OR junior_species='chlorotica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='chlorotica' OR species='chlorotica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='chlorotica' OR species='chlorotica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='chlorotica' OR junior_species='chlorotica')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='Euphonia' AND (species='chlorotica' OR species='chlorotica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1125 The Ecological Register: Para La Tierra Biological Station
Para La Tierra Biological Station
Basic information
Sample name: Para La Tierra Biological Station

Sample aka: Reserva Natural de Laguna Blanca

Reference: P. Smith, D. Onley, E. Northcote-Smith, and K. Atkinson. 2012. Morphometrics of cerrado birds from the Reserva Natural Laguna Blanca (NE Paraguay). Ring 34:51-67 [ER 780]
Geography
Country: Paraguay


Coordinate: 23° 48' S, 56° 17' W
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

WMT: 27.8

CMT: 17.3

MAP: 1291.0

Habitat comments: "near pristine cerrado, a patch of degraded Atlantic forest and some transitional semideciduous humid-dry gallery forest"
climate data based on station 86134 (Concepcion)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 199 individuals

Years: 2005, 2010, 2011

Days: 87

Sampling comments: 1 to 7 mist nets "of 10 to 20 m total length" were used for "up to 9 hours a day"

Metadata
Sample number: 1125

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-29 21:29:04

Modified: 2014-08-29 11:29:04

Abundance distribution
60 species
19 singletons
total count 199
extrapolated richness: 129.9
Fisher's α: 29.169
geometric series k: 0.9563
Hurlbert's PIE: 0.9685
Shannon's H: 3.7546
Good's u: 0.9052
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Crypturellus parvirostris1180 g frugivore
Porzana albicollis1100 g
Columbina picui347.0 g frugivore
Columbina talpacoti26.8 g granivore
Scardafella squammata3
Brotogeris chiriri361.6 g frugivore
Coccyzus melacoryphus145.6 g frugivore-insectivore
Phaethornis pretrei15.6 g nectarivore
Hylocharis chrysura84.5 g nectarivore-insectivore
Chlorostilbon lucidus1 nectarivore
Nyctibeus griseus2
Caprimulgus parvulus637.0 g
Hydropsalis brasilianus3
Eleothreptus candicans6
Nyctidromus albicollis17.9 g insectivore
Picumnus cirratus110.2 g insectivore
Taraba major159.2 g insectivore
Formicivora rufa210.8 g insectivore
Furnarius rufus63.4 g insectivore
Synallaxis albescens111.2 g insectivore
Lepidocolaptes angustirostris25.6 g insectivore
Camptostoma obsoletum28.1 g frugivore-insectivore
Elaenia chiriquensis115.4 g omnivore
Elaenia parvirostris313.8 g frugivore-insectivore
Elaenia flavogaster624.8 g insectivore-frugivore
Euscarthamus meloryphus1
Hemitriccus margaritaceiventer68.4 g insectivore
Myiophobus fasciatus39.9 g insectivore
Cnemotriccus fuscatus213.6 g insectivore
Casiornis rufa324.8 g insectivore
Myiarchus ferox127.5 g insectivore
Myiarchus tyrannulus35.4 g insectivore-frugivore
Pitangus sulphuratus34.2 g frugivore-insectivore
Myiozetetes similis228.0 g insectivore-frugivore
Pipra fasciicauda115.9 g frugivore
Petrochelidon pyrrhonata1
Troglodytes aedon51.8 g insectivore
Turdus rufiventris166.8 g frugivore-insectivore
Turdus leucomelas1169.1 g frugivore-insectivore
Turdus amaurochalinus257.9 g insectivore-frugivore
Geothlypis aequinoctialis113.1 g insectivore
Basileuterus flaveolus23.6 g insectivore
Pipraeidea melanonota121.0 g frugivore-insectivore
Dacnis cayana313.0 g frugivore
Thraupis sayaca15.7 g frugivore-insectivore
Neothraupis fasciata1026.8 g
Cypsnagra hirundinacea231.4 g
Saltator atricollis253.8 g granivore
Coryphospingus cucullatus143.7 g granivore
Oryzoborus angolensis213.0 g granivore
Sporophila caerulescens1410.2 g granivore
Sporophila hypoxantha2
Sporophila leucoptera115.5 g granivore
Volatinia jacarina113.2 g granivore
Emberizoides herbicola45.0 g granivore
Ammodramus humeralis316.5 g granivore
Icterus pyrrhopterus5
Molothrus rufoaxillaris3
Gnorimopsar chopi465.9 g granivore
Euphonia chlorotica211.0 g frugivore