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=2934 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2934SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2750SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2934 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='citrinelloides' OR junior_species='citrinelloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='citrinelloides' OR species='citrinelloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='citrinelloides' OR species='citrinelloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='citrinelloides' OR junior_species='citrinelloides')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='Serinus' AND (species='citrinelloides' OR species='citrinelloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='adusta' OR junior_species='adusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='adusta' OR species='adusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='adusta' OR species='adusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='adusta' OR junior_species='adusta')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='Muscicapa' AND (species='adusta' OR species='adusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagonosticta' AND (junior_species='rubricata' OR junior_species='rubricata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagonosticta' AND (species='rubricata' OR species='rubricata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagonosticta' AND (species='rubricata' OR species='rubricata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagonosticta' AND (junior_species='rubricata' OR junior_species='rubricata')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='Lagonosticta' AND (species='rubricata' OR species='rubricata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaplectes' AND (junior_species='rubriceps' OR junior_species='rubriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anaplectes' AND (species='rubriceps' OR species='rubriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anaplectes' AND (species='rubriceps' OR species='rubriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaplectes' AND (junior_species='rubriceps' OR junior_species='rubriceps')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='Anaplectes' AND (species='rubriceps' OR species='rubriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' AND (junior_species='calva' OR junior_species='calva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Treron' AND (species='calva' OR species='calva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Treron' AND (species='calva' OR species='calva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' AND (junior_species='calva' OR junior_species='calva')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='Treron' AND (species='calva' OR species='calva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')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='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloropeta' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloropeta' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloropeta' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloropeta' AND (junior_species='natalensis' OR junior_species='natalensis')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='Chloropeta' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='amethystina' OR junior_species='amethystina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcomitra' AND (species='amethystina' OR species='amethystina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcomitra' AND (species='amethystina' OR species='amethystina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='amethystina' OR junior_species='amethystina')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='Chalcomitra' AND (species='amethystina' OR species='amethystina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='baglafecht' OR junior_species='baglafecht')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='baglafecht' OR species='baglafecht') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='baglafecht' OR species='baglafecht')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='baglafecht' OR junior_species='baglafecht')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='Ploceus' AND (species='baglafecht' OR species='baglafecht') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' 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='Lonchura' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' 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='Lonchura' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='senegalus' OR junior_species='senegalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tchagra' AND (species='senegalus' OR species='senegalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tchagra' AND (species='senegalus' OR species='senegalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='senegalus' OR junior_species='senegalus')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='Tchagra' AND (species='senegalus' OR species='senegalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='melanocephalus' OR species='melanocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='melanocephalus' OR species='melanocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')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='Ploceus' AND (species='melanocephalus' OR species='melanocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psalidoprocne' AND (junior_species='holomelas' OR junior_species='holomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psalidoprocne' AND (species='holomelas' OR species='holomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psalidoprocne' AND (species='holomelas' OR species='holomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psalidoprocne' AND (junior_species='holomelas' OR junior_species='holomelas')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='Psalidoprocne' AND (species='holomelas' OR species='holomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='atricapilla' OR junior_species='atricapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='atricapilla' OR species='atricapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='atricapilla' OR species='atricapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='atricapilla' OR junior_species='atricapilla')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='Sylvia' AND (species='atricapilla' OR species='atricapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' 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='Serinus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='sulphuratus' OR species='sulphuratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' 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='Serinus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='cucullata' OR junior_species='cucullata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchura' AND (species='cucullata' OR species='cucullata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='cucullata' OR species='cucullata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='cucullata' OR junior_species='cucullata')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='Lonchura' AND (species='cucullata' OR species='cucullata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='kilimensis' OR junior_species='kilimensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectarinia' AND (species='kilimensis' OR species='kilimensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectarinia' AND (species='kilimensis' OR species='kilimensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='kilimensis' OR junior_species='kilimensis')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='Nectarinia' AND (species='kilimensis' OR species='kilimensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tchagra' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tchagra' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='australis' OR junior_species='australis')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='Tchagra' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parisoma' AND (junior_species='lugens' OR junior_species='lugens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parisoma' AND (species='lugens' OR species='lugens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parisoma' AND (species='lugens' OR species='lugens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parisoma' AND (junior_species='lugens' OR junior_species='lugens')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='Parisoma' AND (species='lugens' OR species='lugens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='caffra' OR junior_species='caffra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='caffra' OR species='caffra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='caffra' OR species='caffra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='caffra' OR junior_species='caffra')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='Cossypha' AND (species='caffra' OR species='caffra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='eminibey' OR junior_species='eminibey')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='eminibey' OR species='eminibey') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='eminibey' OR species='eminibey')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='eminibey' OR junior_species='eminibey')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='Passer' AND (species='eminibey' OR species='eminibey') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='molitor' OR junior_species='molitor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Batis' AND (species='molitor' OR species='molitor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Batis' AND (species='molitor' OR species='molitor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batis' AND (junior_species='molitor' OR junior_species='molitor')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='Batis' AND (species='molitor' OR species='molitor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='oreobates' OR junior_species='oreobates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='oreobates' OR species='oreobates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='oreobates' OR species='oreobates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='oreobates' OR junior_species='oreobates')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='Merops' AND (species='oreobates' OR species='oreobates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedydipna' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hedydipna' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hedydipna' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedydipna' AND (junior_species='collaris' OR junior_species='collaris')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='Hedydipna' AND (species='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnonotus' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')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='Pycnonotus' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collaris' OR junior_species='collaris')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='Lanius' AND (species='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='astrild' OR species='astrild') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='astrild' OR species='astrild')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')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='Estrilda' AND (species='astrild' OR species='astrild') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='communis' OR junior_species='communis')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='Sylvia' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='rhodopyga' OR junior_species='rhodopyga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='rhodopyga' OR species='rhodopyga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='rhodopyga' OR species='rhodopyga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='rhodopyga' OR junior_species='rhodopyga')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='Estrilda' AND (species='rhodopyga' OR species='rhodopyga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='chalcospilos' OR junior_species='chalcospilos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='chalcospilos' OR species='chalcospilos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='chalcospilos' OR species='chalcospilos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='chalcospilos' OR junior_species='chalcospilos')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='Turtur' AND (species='chalcospilos' OR species='chalcospilos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='flaviventris' OR species='flaviventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='flaviventris' OR species='flaviventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='flaviventris' OR junior_species='flaviventris')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='Emberiza' AND (species='flaviventris' OR species='flaviventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanomitra' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanomitra' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='verticalis' OR junior_species='verticalis')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='Cyanomitra' AND (species='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camaroptera' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')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='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eminia' AND (junior_species='lepida' OR junior_species='lepida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eminia' AND (species='lepida' OR species='lepida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eminia' AND (species='lepida' OR species='lepida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eminia' AND (junior_species='lepida' OR junior_species='lepida')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='Eminia' AND (species='lepida' OR species='lepida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' 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='Passer' AND (species='griseus' OR species='griseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='griseus' OR species='griseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' 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='Passer' AND (species='griseus' OR species='griseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdoides' AND (junior_species='hindei' OR junior_species='hindeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdoides' AND (species='hindei' OR species='hindeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdoides' AND (species='hindei' OR species='hindeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdoides' AND (junior_species='hindei' OR junior_species='hindeii')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='Turdoides' AND (species='hindei' OR species='hindeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='xanthops' OR junior_species='xanthops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='xanthops' OR species='xanthops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='xanthops' OR species='xanthops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='xanthops' OR junior_species='xanthops')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='Ploceus' AND (species='xanthops' OR species='xanthops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indicator' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indicator' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')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='Indicator' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='intermedius' OR species='intermedius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='intermedius' OR junior_species='intermedius')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='Ploceus' AND (species='intermedius' OR species='intermedius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='mariquensis' OR junior_species='mariquensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='mariquensis' OR species='mariquensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='mariquensis' OR species='mariquensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='mariquensis' OR junior_species='mariquensis')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='Cinnyris' AND (species='mariquensis' OR species='mariquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='palustris' OR junior_species='palustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='palustris' OR species='palustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='palustris' OR junior_species='palustris')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='Acrocephalus' AND (species='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='poliogaster' OR junior_species='poliogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='poliogaster' OR species='poliogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='poliogaster' OR species='poliogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='poliogaster' OR junior_species='poliogaster')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='Zosterops' AND (species='poliogaster' OR species='poliogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='strepitans' OR junior_species='strepitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='strepitans' OR species='strepitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='strepitans' OR species='strepitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='strepitans' OR junior_species='strepitans')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='Phyllastrephus' AND (species='strepitans' OR species='strepitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippolais' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippolais' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='pallida' OR junior_species='pallida')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='Hippolais' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivaceus' OR junior_species='olivaceus')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='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradornis' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradornis' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradornis' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradornis' AND (junior_species='pallidus' OR junior_species='pallidus')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='Bradornis' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='ianthinogaster' OR junior_species='ianthinogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uraeginthus' AND (species='ianthinogaster' OR species='ianthinogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uraeginthus' AND (species='ianthinogaster' OR species='ianthinogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='ianthinogaster' OR junior_species='ianthinogaster')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='Uraeginthus' AND (species='ianthinogaster' OR species='ianthinogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='chiniana' OR junior_species='chiniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='chiniana' OR species='chiniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='chiniana' OR species='chiniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='chiniana' OR junior_species='chiniana')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='Cisticola' AND (species='chiniana' OR species='chiniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagonosticta' AND (junior_species='senegala' OR junior_species='senegala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagonosticta' AND (species='senegala' OR species='senegala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagonosticta' AND (species='senegala' OR species='senegala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagonosticta' AND (junior_species='senegala' OR junior_species='senegala')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='Lagonosticta' AND (species='senegala' OR species='senegala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quelea' AND (junior_species='quelea' OR junior_species='quelea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quelea' AND (species='quelea' OR species='quelea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quelea' AND (species='quelea' OR species='quelea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quelea' AND (junior_species='quelea' OR junior_species='quelea')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='Quelea' AND (species='quelea' OR species='quelea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='bengalus' OR junior_species='bengalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uraeginthus' AND (species='bengalus' OR species='bengalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uraeginthus' AND (species='bengalus' OR species='bengalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='bengalus' OR junior_species='bengalus')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='Uraeginthus' AND (species='bengalus' OR species='bengalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='ardens' OR junior_species='ardens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='ardens' OR species='ardens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='ardens' OR species='ardens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='ardens' OR junior_species='ardens')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='Euplectes' AND (species='ardens' OR species='ardens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='erythrops' OR junior_species='erythrops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='erythrops' OR species='erythrops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='erythrops' OR species='erythrops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='erythrops' OR junior_species='erythrops')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='Cisticola' AND (species='erythrops' OR species='erythrops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricholaema' AND (junior_species='diademata' OR junior_species='diademata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tricholaema' AND (species='diademata' OR species='diademata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tricholaema' AND (species='diademata' OR species='diademata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricholaema' AND (junior_species='diademata' OR junior_species='diademata')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='Tricholaema' AND (species='diademata' OR species='diademata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jynx' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jynx' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='ruficollis' OR junior_species='ruficollis')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='Jynx' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdoides' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdoides' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdoides' AND (species='rubiginosus' OR species='rubiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdoides' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')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='Turdoides' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mirafra' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mirafra' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mirafra' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mirafra' AND (junior_species='africana' OR junior_species='africana')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='Mirafra' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='rufocinctus' OR junior_species='rufocinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='rufocinctus' OR species='rufocinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='rufocinctus' OR species='rufocinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='rufocinctus' OR junior_species='rufocinctus')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='Passer' AND (species='rufocinctus' OR species='rufocinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='semirufa' OR junior_species='semirufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='semirufa' OR species='semirufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='semirufa' OR species='semirufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='semirufa' OR junior_species='semirufa')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='Cossypha' AND (species='semirufa' OR species='semirufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcomitra' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcomitra' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Chalcomitra' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='brachypterus' OR junior_species='brachypterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='brachypterus' OR species='brachypterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='brachypterus' OR species='brachypterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='brachypterus' OR junior_species='brachypterus')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='Cisticola' AND (species='brachypterus' OR species='brachypterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='cantans' OR junior_species='cantans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='cantans' OR species='cantans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='cantans' OR species='cantans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='cantans' OR junior_species='cantans')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='Cisticola' AND (species='cantans' OR species='cantans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colius' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colius' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colius' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colius' AND (junior_species='striatus' OR junior_species='striatus')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='Colius' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='ocularis' OR junior_species='ocularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='ocularis' OR species='ocularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='ocularis' OR species='ocularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='ocularis' OR junior_species='ocularis')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='Ploceus' AND (species='ocularis' OR species='ocularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='spekei' OR junior_species='spekeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='spekei' OR species='spekeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='spekei' OR species='spekeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='spekei' OR junior_species='spekeii')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='Ploceus' AND (species='spekei' OR species='spekeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='striolatus' OR junior_species='striolatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='striolatus' OR species='striolatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='striolatus' OR species='striolatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='striolatus' OR junior_species='striolatus')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='Serinus' AND (species='striolatus' OR species='striolatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='tympanistria' OR species='tympanistria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')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='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')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='Prinia' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='burtoni' OR junior_species='burtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='burtoni' OR species='burtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='burtoni' OR species='burtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='burtoni' OR junior_species='burtonii')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='Serinus' AND (species='burtoni' OR species='burtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='trivialis' OR junior_species='trivialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='trivialis' OR species='trivialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='trivialis' OR species='trivialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='trivialis' OR junior_species='trivialis')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='Anthus' AND (species='trivialis' OR species='trivialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='venustus' OR junior_species='venustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='venustus' OR species='venustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='venustus' OR species='venustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='venustus' OR junior_species='venustus')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='Cinnyris' AND (species='venustus' OR species='venustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaniparus' AND (junior_species='albiventris' OR junior_species='albiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melaniparus' AND (species='albiventris' OR species='albiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melaniparus' AND (species='albiventris' OR species='albiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaniparus' AND (junior_species='albiventris' OR junior_species='albiventris')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='Melaniparus' AND (species='albiventris' OR species='albiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercotrichas' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercotrichas' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercotrichas' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercotrichas' AND (junior_species='leucophrys' OR junior_species='leucophrys')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='Cercotrichas' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaenornis' AND (junior_species='fischeri' OR junior_species='fischerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melaenornis' AND (species='fischeri' OR species='fischerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melaenornis' AND (species='fischeri' OR species='fischerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaenornis' AND (junior_species='fischeri' OR junior_species='fischerii')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='Melaenornis' AND (species='fischeri' OR species='fischerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonocichla' AND (junior_species='stellata' OR junior_species='stellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonocichla' AND (species='stellata' OR species='stellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonocichla' AND (species='stellata' OR species='stellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonocichla' AND (junior_species='stellata' OR junior_species='stellata')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='Pogonocichla' AND (species='stellata' OR species='stellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trochilus' OR junior_species='trochilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='trochilus' OR species='trochilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='trochilus' OR species='trochilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trochilus' OR junior_species='trochilus')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='Phylloscopus' AND (species='trochilus' OR species='trochilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='capensis' OR junior_species='capensis')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='Euplectes' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='flavida' OR junior_species='flavida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apalis' AND (species='flavida' OR species='flavida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalis' AND (species='flavida' OR species='flavida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='flavida' OR junior_species='flavida')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='Apalis' AND (species='flavida' OR species='flavida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='canicollis' OR junior_species='canicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='canicollis' OR species='canicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='canicollis' OR species='canicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='canicollis' OR junior_species='canicollis')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='Serinus' AND (species='canicollis' OR species='canicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='reichenowi' OR junior_species='reichenowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='reichenowi' OR species='reichenowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='reichenowi' OR species='reichenowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='reichenowi' OR junior_species='reichenowii')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='Serinus' AND (species='reichenowi' OR species='reichenowii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='bilineatus' OR junior_species='bilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogoniulus' AND (species='bilineatus' OR species='bilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogoniulus' AND (species='bilineatus' OR species='bilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='bilineatus' OR junior_species='bilineatus')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='Pogoniulus' AND (species='bilineatus' OR species='bilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='flava' OR junior_species='flava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='flava' OR species='flava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='flava' OR species='flava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='flava' OR junior_species='flava')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='Motacilla' AND (species='flava' OR species='flava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='latirostris' OR junior_species='latirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='latirostris' OR species='latirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='latirostris' OR species='latirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='latirostris' OR junior_species='latirostris')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='Andropadus' AND (species='latirostris' OR species='latirostris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2934
Reference:C. Smith, D. Barton, M. D. Johnson, C. Wendt, M. C. Milligan, P. Njoroge, and P. Gichuki. 2015. Bird communities in sun and shade coffee farms in Kenya. Global Ecology and Conservation4:479-490 [ER 2750]
Geography
Country: Kenya
Coordinate:0° 25' S, 36° 57' E
Coordinate basis: based on nearby landmark
Geography comments: "a total of 21 sites located on five individual farms"
based on satellite photos and Fig. 1, the sites are within a few km north of the city of Nyeri (basis of coordinate)
Habitat comments: "shade and sun coffee farm plantations" and specifically "11 sun sites (on four different farms) and 10 shade sites (on three separate farms)"
climate data are for the Tegu inland valley in the Nyeri District and are from Böhme et al. (2016, Physics and Chemistry of the Earth)
Methods
Life forms: birds
Sampling methods: line transect,mist nets
Sample size: 2026 individuals
Net or trap nights: 715
Sampling comments: "Each site was sampled for three consecutive days, roughly from
06:00 to 10:00, depending on weather" and there were "2861 net hours" (suggesting 715 net days)
"nets "consisted of two lanes (100 m apart) each with four (2012-2013) or six nets (2013-2015)"
Metadata
Sample number: 2934
Contributor: John Alroy
Enterer: John Alroy
Created: 2018-04-26 20:55:56
Modified: 2018-04-26 10:55:56
Abundance distribution
83 species
15 singletons
total count 2026
extrapolated richness: 119.4
Fisher's α: 17.419
geometric series k: 0.9360
Hurlbert's PIE: 0.9547
Shannon's H: 3.5237
Good's u: 0.9926
Each square represents a species. Square sizes are proportional to counts.