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=1766 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1766SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1226SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1766 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Circus' AND (junior_species='pygargus' OR junior_species='pygargus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Circus' AND (species='pygargus' OR species='pygargus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Circus' AND (species='pygargus' OR species='pygargus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Circus' AND (junior_species='pygargus' OR junior_species='pygargus')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='Circus' AND (species='pygargus' OR species='pygargus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='nisus' OR junior_species='nisus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='nisus' OR species='nisus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='nisus' OR species='nisus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='nisus' OR junior_species='nisus')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='Accipiter' AND (species='nisus' OR species='nisus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falco' AND (junior_species='subbuteo' OR junior_species='subbuteo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falco' AND (species='subbuteo' OR species='subbuteo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falco' AND (species='subbuteo' OR species='subbuteo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falco' AND (junior_species='subbuteo' OR junior_species='subbuteo')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='Falco' AND (species='subbuteo' OR species='subbuteo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallus' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rallus' AND (species='aquaticus' OR species='aquaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rallus' AND (species='aquaticus' OR species='aquaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallus' AND (junior_species='aquaticus' OR junior_species='aquaticus')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='Rallus' AND (species='aquaticus' OR species='aquaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='turtur' OR junior_species='turtur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='turtur' OR species='turtur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='turtur' OR species='turtur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='turtur' OR junior_species='turtur')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='Streptopelia' AND (species='turtur' OR species='turtur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='canorus' OR junior_species='canorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuculus' AND (species='canorus' OR species='canorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuculus' AND (species='canorus' OR species='canorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='canorus' OR junior_species='canorus')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='Cuculus' AND (species='canorus' OR species='canorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='atthis' OR junior_species='atthis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcedo' AND (species='atthis' OR species='atthis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='atthis' OR species='atthis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='atthis' OR junior_species='atthis')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='Alcedo' AND (species='atthis' OR species='atthis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upupa' AND (junior_species='epops' OR junior_species='epops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Upupa' AND (species='epops' OR species='epops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Upupa' AND (species='epops' OR species='epops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upupa' AND (junior_species='epops' OR junior_species='epops')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='Upupa' AND (species='epops' OR species='epops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='torquilla' OR junior_species='torquilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jynx' AND (species='torquilla' OR species='torquilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jynx' AND (species='torquilla' OR species='torquilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='torquilla' OR junior_species='torquilla')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='torquilla' OR species='torquilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picus' AND (junior_species='canus' OR junior_species='canus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picus' AND (species='canus' OR species='canus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picus' AND (species='canus' OR species='canus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picus' AND (junior_species='canus' OR junior_species='canus')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='Picus' AND (species='canus' OR species='canus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' 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='Dendrocopos' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocopos' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' 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='Dendrocopos' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' 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='Dendrocopos' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocopos' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' 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='Dendrocopos' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')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='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delichon' AND (junior_species='urbica' OR junior_species='urbica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delichon' AND (species='urbica' OR species='urbica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delichon' AND (species='urbica' OR species='urbica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delichon' AND (junior_species='urbica' OR junior_species='urbica')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='Delichon' AND (species='urbica' OR species='urbica') 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='Motacilla' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='cinerea' OR junior_species='cinerea')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='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='troglodytes' OR junior_species='troglodytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='troglodytes' OR species='troglodytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='troglodytes' OR species='troglodytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='troglodytes' OR junior_species='troglodytes')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='troglodytes' OR species='troglodytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='modularis' OR junior_species='modularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunella' AND (species='modularis' OR species='modularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunella' AND (species='modularis' OR species='modularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='modularis' OR junior_species='modularis')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='Prunella' AND (species='modularis' OR species='modularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erithacus' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erithacus' AND (species='rubecula' OR species='rubecula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erithacus' AND (species='rubecula' OR species='rubecula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erithacus' AND (junior_species='rubecula' OR junior_species='rubecula')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='Erithacus' AND (species='rubecula' OR species='rubecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='megarhynchos' OR junior_species='megarhynchos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='megarhynchos' OR species='megarhynchos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='megarhynchos' OR species='megarhynchos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='megarhynchos' OR junior_species='megarhynchos')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='Luscinia' AND (species='megarhynchos' OR species='megarhynchos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='svecica' OR junior_species='svecica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='svecica' OR species='svecica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='svecica' OR species='svecica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='svecica' OR junior_species='svecica')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='Luscinia' AND (species='svecica' OR species='svecica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='ochruros' OR junior_species='ochruros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='ochruros' OR species='ochruros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='ochruros' OR species='ochruros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='ochruros' OR junior_species='ochruros')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='Phoenicurus' AND (species='ochruros' OR species='ochruros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='phoenicurus' OR species='phoenicurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='phoenicurus' OR species='phoenicurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')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='Phoenicurus' AND (species='phoenicurus' OR species='phoenicurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxicola' AND (junior_species='rubetra' OR junior_species='rubetra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saxicola' AND (species='rubetra' OR species='rubetra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saxicola' AND (species='rubetra' OR species='rubetra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxicola' AND (junior_species='rubetra' OR junior_species='rubetra')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='Saxicola' AND (species='rubetra' OR species='rubetra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='oenanthe' OR junior_species='oenanthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenanthe' AND (species='oenanthe' OR species='oenanthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenanthe' AND (species='oenanthe' OR species='oenanthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='oenanthe' OR junior_species='oenanthe')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='Oenanthe' AND (species='oenanthe' OR species='oenanthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='merula' OR junior_species='merula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='merula' OR species='merula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='merula' OR species='merula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='merula' OR junior_species='merula')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='merula' OR species='merula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='pilaris' OR junior_species='pilaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='pilaris' OR species='pilaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='pilaris' OR species='pilaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='pilaris' OR junior_species='pilaris')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='pilaris' OR species='pilaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='philomelos' OR junior_species='philomelos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='philomelos' OR species='philomelos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='philomelos' OR species='philomelos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='philomelos' OR junior_species='philomelos')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='philomelos' OR species='philomelos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='naevia' OR junior_species='naevia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locustella' AND (species='naevia' OR species='naevia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locustella' AND (species='naevia' OR species='naevia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='naevia' OR junior_species='naevia')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='Locustella' AND (species='naevia' OR species='naevia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='luscinioides' OR junior_species='luscinioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locustella' AND (species='luscinioides' OR species='luscinioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locustella' AND (species='luscinioides' OR species='luscinioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='luscinioides' OR junior_species='luscinioides')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='Locustella' AND (species='luscinioides' OR species='luscinioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='schoenobaenus' OR junior_species='schoenobaenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='schoenobaenus' OR species='schoenobaenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='schoenobaenus' OR species='schoenobaenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='schoenobaenus' OR junior_species='schoenobaenus')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='schoenobaenus' OR species='schoenobaenus') 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='Acrocephalus' AND (junior_species='scirpaceus' OR junior_species='scirpaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='scirpaceus' OR species='scirpaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='scirpaceus' OR species='scirpaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='scirpaceus' OR junior_species='scirpaceus')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='scirpaceus' OR species='scirpaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='arundinaceus' OR junior_species='arundinaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='arundinaceus' OR species='arundinaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='arundinaceus' OR species='arundinaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='arundinaceus' OR junior_species='arundinaceus')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='arundinaceus' OR species='arundinaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='icterina' OR junior_species='icterina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippolais' AND (species='icterina' OR species='icterina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippolais' AND (species='icterina' OR species='icterina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='icterina' OR junior_species='icterina')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='icterina' OR species='icterina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='nisoria' OR junior_species='nisoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='nisoria' OR species='nisoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='nisoria' OR species='nisoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='nisoria' OR junior_species='nisoria')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='nisoria' OR species='nisoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='curruca' OR junior_species='curruca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='curruca' OR species='curruca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='curruca' OR species='curruca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='curruca' OR junior_species='curruca')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='curruca' OR species='curruca') 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='Sylvia' AND (junior_species='borin' OR junior_species='borin')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='borin' OR species='borin') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='borin' OR species='borin')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='borin' OR junior_species='borin')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='borin' OR species='borin') 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='Phylloscopus' AND (junior_species='sibilatrix' OR junior_species='sibilatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='sibilatrix' OR species='sibilatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='sibilatrix' OR species='sibilatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='sibilatrix' OR junior_species='sibilatrix')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='sibilatrix' OR species='sibilatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='collybita' OR junior_species='collybita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='collybita' OR species='collybita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='collybita' OR species='collybita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='collybita' OR junior_species='collybita')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='collybita' OR species='collybita') 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='Regulus' AND (junior_species='regulus' OR junior_species='regulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='regulus' OR species='regulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='regulus' OR species='regulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='regulus' OR junior_species='regulus')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='Regulus' AND (species='regulus' OR species='regulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='ignicapillus' OR junior_species='ignicapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='ignicapillus' OR species='ignicapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='ignicapillus' OR species='ignicapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='ignicapillus' OR junior_species='ignicapillus')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='Regulus' AND (species='ignicapillus' OR species='ignicapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Muscicapa' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='hypoleuca' OR species='hypoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')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='Ficedula' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panurus' AND (junior_species='biarmicus' OR junior_species='biarmicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panurus' AND (species='biarmicus' OR species='biarmicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panurus' AND (species='biarmicus' OR species='biarmicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panurus' AND (junior_species='biarmicus' OR junior_species='biarmicus')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='Panurus' AND (species='biarmicus' OR species='biarmicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithalos' AND (junior_species='caudatus' OR junior_species='caudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegithalos' AND (species='caudatus' OR species='caudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegithalos' AND (species='caudatus' OR species='caudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithalos' AND (junior_species='caudatus' OR junior_species='caudatus')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='Aegithalos' AND (species='caudatus' OR species='caudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' 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='Poecile' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='palustris' OR species='palustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' 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='Poecile' AND (species='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecile' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='montanus' OR junior_species='montanus')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='Poecile' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Periparus' AND (junior_species='ater' OR junior_species='ater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Periparus' AND (species='ater' OR species='ater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Periparus' AND (species='ater' OR species='ater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Periparus' AND (junior_species='ater' OR junior_species='ater')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='Periparus' AND (species='ater' OR species='ater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanistes' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanistes' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanistes' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanistes' AND (junior_species='caeruleus' OR junior_species='caeruleus')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='Cyanistes' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' 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='Parus' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' 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='Parus' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitta' AND (junior_species='europaea' OR junior_species='europaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sitta' AND (species='europaea' OR species='europaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sitta' AND (species='europaea' OR species='europaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitta' AND (junior_species='europaea' OR junior_species='europaea')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='Sitta' AND (species='europaea' OR species='europaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Certhia' AND (junior_species='brachydactyla' OR junior_species='brachydactyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Certhia' AND (species='brachydactyla' OR species='brachydactyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Certhia' AND (species='brachydactyla' OR species='brachydactyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Certhia' AND (junior_species='brachydactyla' OR junior_species='brachydactyla')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='Certhia' AND (species='brachydactyla' OR species='brachydactyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='oriolus' OR junior_species='oriolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriolus' AND (species='oriolus' OR species='oriolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriolus' AND (species='oriolus' OR species='oriolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='oriolus' OR junior_species='oriolus')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='Oriolus' AND (species='oriolus' OR species='oriolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collurio' OR junior_species='collurio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='collurio' OR species='collurio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='collurio' OR species='collurio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collurio' OR junior_species='collurio')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='collurio' OR species='collurio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulus' AND (junior_species='glandarius' OR junior_species='glandarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulus' AND (species='glandarius' OR species='glandarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulus' AND (species='glandarius' OR species='glandarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulus' AND (junior_species='glandarius' OR junior_species='glandarius')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='Garrulus' AND (species='glandarius' OR species='glandarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='vulgaris' OR junior_species='vulgaris')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='Sturnus' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fringilla' AND (junior_species='coelebs' OR junior_species='coelebs')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fringilla' AND (species='coelebs' OR species='coelebs') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fringilla' AND (species='coelebs' OR species='coelebs')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fringilla' AND (junior_species='coelebs' OR junior_species='coelebs')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='Fringilla' AND (species='coelebs' OR species='coelebs') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='chloris' OR junior_species='chloris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='chloris' OR species='chloris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='chloris' OR species='chloris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='chloris' OR junior_species='chloris')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='Carduelis' AND (species='chloris' OR species='chloris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='carduelis' OR junior_species='carduelis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='carduelis' OR species='carduelis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='carduelis' OR species='carduelis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='carduelis' OR junior_species='carduelis')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='Carduelis' AND (species='carduelis' OR species='carduelis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='spinus' OR junior_species='spinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='spinus' OR species='spinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='spinus' OR species='spinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='spinus' OR junior_species='spinus')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='Carduelis' AND (species='spinus' OR species='spinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhula' AND (junior_species='pyrrhula' OR junior_species='pyrrhula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhula' AND (junior_species='pyrrhula' OR junior_species='pyrrhula')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='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccothraustes' AND (junior_species='coccothraustes' OR junior_species='coccothraustes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccothraustes' AND (species='coccothraustes' OR species='coccothraustes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccothraustes' AND (species='coccothraustes' OR species='coccothraustes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccothraustes' AND (junior_species='coccothraustes' OR junior_species='coccothraustes')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='Coccothraustes' AND (species='coccothraustes' OR species='coccothraustes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='citrinella' OR junior_species='citrinella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='citrinella' OR species='citrinella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='citrinella' OR species='citrinella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='citrinella' OR junior_species='citrinella')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='citrinella' OR species='citrinella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='schoeniclus' OR junior_species='schoeniclus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='schoeniclus' OR species='schoeniclus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='schoeniclus' OR species='schoeniclus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='schoeniclus' OR junior_species='schoeniclus')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='schoeniclus' OR species='schoeniclus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1766 The Ecological Register: Portalban (Wald)
Portalban (Wald)
Basic information
Sample name: Portalban (Wald)

Reference: L. Jenni and F. Widmer. 1996. Habitatnutzung von Kleinvogeln in der Herbstzugzeit am Neuenburgersee. Der Ornithologische Beobachter 93(3):221-248 [ER 1226]
Geography
Country: Switzerland


Coordinate: 46° 55' N, 6° 57' E
Coordinate basis: stated in text

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 8.0

WMT: 17.6

CMT: -3.1

MAP: 1118.0

Habitat comments: 3 nets were in a popular plantation and the others in various broadleaf forest habitats
climate data are for the Fribourg canton and are from Roger et al. (2014, Geoderma)

Methods
Life forms: birds

Sites: 1

Sampling methods: no design,mist nets

Sample size: 6732 captures or sightings

Years: 1987 - 1989

Days: 92

Seasons: summer,autumn

Nets or traps: 13

Sampling comments: sampling was continuous through August, September, and October each year
number of nets is uncertain because the table simplifies a much more complicated classification of sites

Metadata
Sample number: 1766

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-09-19 11:45:16

Modified: 2018-04-20 07:35:38

Abundance distribution
68 species
15 singletons
total count 6732
extrapolated richness: 98.5
Fisher's α: 10.522
geometric series k: 0.8922
Hurlbert's PIE: 0.8568
Shannon's H: 2.5948
Good's u: 0.9978
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Circus pygargus1261 g carnivore
Accipiter nisus2150 g carnivore
Falco subbuteo1186 g carnivore
Rallus aquaticus1125 g
Streptopelia turtur1132 g granivore
Cuculus canorus1117 g insectivore
Alcedo atthis206.0 g carnivore
Upupa epops18.6 g insectivore
Jynx torquilla136.0 g insectivore
Picus canus11137 g insectivore
Dendrocopos major144.2 g insectivore
Dendrocopos minor1419.8 g
Hirundo rustica682.1 g insectivore
Delichon urbica4 insectivore
Anthus trivialis921.7 g insectivore
Motacilla cinerea14.0 g carnivore
Troglodytes troglodytes501.6 g insectivore
Prunella modularis374.6 g insectivore-granivore
Erithacus rubecula209117.7 g insectivore-frugivore
Luscinia megarhynchos82.8 g insectivore
Luscinia svecica42.5 g insectivore
Phoenicurus ochruros716.5 g
Phoenicurus phoenicurus10414.7 g
Saxicola rubetra116.6 g insectivore
Oenanthe oenanthe15.5 g insectivore
Turdus merula2449.7 g insectivore-frugivore
Turdus pilaris4106 g
Turdus philomelos13468.9 g frugivore
Locustella naevia1313.3 g insectivore
Locustella luscinioides23.7 g
Acrocephalus schoenobaenus13.5 g insectivore
Acrocephalus palustris411.5 g insectivore
Acrocephalus scirpaceus26412.3 g insectivore
Acrocephalus arundinaceus430.0 g insectivore
Hippolais icterina113.2 g insectivore
Sylvia nisoria122.5 g
Sylvia curruca83.4 g insectivore
Sylvia communis2315.1 g insectivore
Sylvia borin35218.2 g frugivore-insectivore
Sylvia atricapilla114716.7 g frugivore-insectivore
Phylloscopus sibilatrix29.2 g insectivore
Phylloscopus collybita3408.3 g insectivore
Phylloscopus trochilus928.7 g insectivore
Regulus regulus285.6 g
Regulus ignicapillus85.6 g insectivore
Muscicapa striata10715.9 g insectivore
Ficedula hypoleuca36912.2 g insectivore-frugivore
Panurus biarmicus13.7 g
Aegithalos caudatus768.6 g insectivore
Poecile palustris593.4 g
"Parus palustris"
Poecile montanus14
"Parus montanus"
Periparus ater59.2 g insectivore
"Parus ater"
Cyanistes caeruleus3363.2 g insectivore
"Parus caeruleus"
Parus major2842.4 g insectivore-granivore
Sitta europaea232.7 g insectivore
Certhia brachydactyla338.2 g insectivore
Oriolus oriolus1 insectivore
Lanius collurio5 carnivore
Garrulus glandarius5 insectivore
Sturnus vulgaris17.9 g insectivore
Fringilla coelebs112.9 g granivore
Carduelis chloris1926.0 g granivore
Carduelis carduelis516.0 g granivore
Carduelis spinus17313.5 g
Pyrrhula pyrrhula205.2 g granivore
Coccothraustes coccothraustes258.0 g
Emberiza citrinella329.7 g
Emberiza schoeniclus4319.7 g