Coordinate: 49° 55' 8" N, 127° 40' 20" E
climate data based on station 31510 (Blagoveshchensk)
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=1146 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1146SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=799SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1146 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='gallinago' OR junior_species='gallinago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallinago' AND (species='gallinago' OR species='gallinago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallinago' AND (species='gallinago' OR species='gallinago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='gallinago' OR junior_species='gallinago')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallinago' AND (species='gallinago' OR species='gallinago') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='stenura' OR junior_species='stenura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallinago' AND (species='stenura' OR species='stenura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallinago' AND (species='stenura' OR species='stenura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='stenura' OR junior_species='stenura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallinago' AND (species='stenura' OR species='stenura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asio' AND (junior_species='otus' OR junior_species='otus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asio' AND (species='otus' OR species='otus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asio' AND (species='otus' OR species='otus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asio' AND (junior_species='otus' OR junior_species='otus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Asio' AND (species='otus' OR species='otus') 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='leucotos' OR junior_species='leucotos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocopos' AND (species='leucotos' OR species='leucotos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocopos' AND (species='leucotos' OR species='leucotos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' AND (junior_species='leucotos' OR junior_species='leucotos')SELECT d.diet,d.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='leucotos' OR species='leucotos') 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='Anthus' AND (junior_species='hodgsoni' OR junior_species='hodgsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='hodgsoni' OR species='hodgsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='hodgsoni' OR species='hodgsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='hodgsoni' OR junior_species='hodgsonii')SELECT d.diet,d.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='hodgsoni' OR species='hodgsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='cervinus' OR junior_species='cervinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='cervinus' OR species='cervinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='cervinus' OR species='cervinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='cervinus' OR junior_species='cervinus')SELECT d.diet,d.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='cervinus' OR species='cervinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT d.diet,d.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='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='montanella' OR junior_species='montanella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunella' AND (species='montanella' OR species='montanella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunella' AND (species='montanella' OR species='montanella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='montanella' OR junior_species='montanella')SELECT d.diet,d.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='montanella' OR species='montanella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='sibilans' OR junior_species='sibilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='sibilans' OR species='sibilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='sibilans' OR species='sibilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='sibilans' OR junior_species='sibilans')SELECT d.diet,d.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='sibilans' OR species='sibilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliope' AND (junior_species='calliope' OR junior_species='calliope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliope' AND (species='calliope' OR species='calliope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliope' AND (species='calliope' OR species='calliope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliope' AND (junior_species='calliope' OR junior_species='calliope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calliope' AND (species='calliope' OR species='calliope') 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='Luscinia' AND (junior_species='cyane' OR junior_species='cyane')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='cyane' OR species='cyane') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='cyane' OR species='cyane')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='cyane' OR junior_species='cyane')SELECT d.diet,d.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='cyane' OR species='cyane') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarsiger' AND (junior_species='cyanurus' OR junior_species='cyanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tarsiger' AND (species='cyanurus' OR species='cyanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tarsiger' AND (species='cyanurus' OR species='cyanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarsiger' AND (junior_species='cyanurus' OR junior_species='cyanurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tarsiger' AND (species='cyanurus' OR species='cyanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='auroreus' OR junior_species='auroreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='auroreus' OR species='auroreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='auroreus' OR species='auroreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='auroreus' OR junior_species='auroreus')SELECT d.diet,d.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='auroreus' OR species='auroreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='hortulorum' OR junior_species='hortulorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='hortulorum' OR species='hortulorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='hortulorum' OR species='hortulorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='hortulorum' OR junior_species='hortulorum')SELECT d.diet,d.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='hortulorum' OR species='hortulorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='naumanni' OR junior_species='naumannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='naumanni' OR species='naumannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='naumanni' OR species='naumannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='naumanni' OR junior_species='naumannii')SELECT d.diet,d.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='naumanni' OR species='naumannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='eunomus' OR junior_species='eunomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='eunomus' OR species='eunomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='eunomus' OR species='eunomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='eunomus' OR junior_species='eunomus')SELECT d.diet,d.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='eunomus' OR species='eunomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='thoracicus' OR junior_species='thoracicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradypterus' AND (species='thoracicus' OR species='thoracicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradypterus' AND (species='thoracicus' OR species='thoracicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradypterus' AND (junior_species='thoracicus' OR junior_species='thoracicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bradypterus' AND (species='thoracicus' OR species='thoracicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='certhiola' OR junior_species='certhiola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locustella' AND (species='certhiola' OR species='certhiola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locustella' AND (species='certhiola' OR species='certhiola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='certhiola' OR junior_species='certhiola')SELECT d.diet,d.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='certhiola' OR species='certhiola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locustella' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locustella' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locustella' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT d.diet,d.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='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='bistrigiceps' OR junior_species='bistrigiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='bistrigiceps' OR species='bistrigiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='bistrigiceps' OR species='bistrigiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='bistrigiceps' OR junior_species='bistrigiceps')SELECT d.diet,d.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='bistrigiceps' OR species='bistrigiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='aedon' OR junior_species='aedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='aedon' OR species='aedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='aedon' OR species='aedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='aedon' OR junior_species='aedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acrocephalus' AND (species='aedon' OR species='aedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='borealis' OR junior_species='borealis')SELECT d.diet,d.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='borealis' OR species='borealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='proregulus' OR junior_species='proregulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='proregulus' OR species='proregulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='proregulus' OR species='proregulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='proregulus' OR junior_species='proregulus')SELECT d.diet,d.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='proregulus' OR species='proregulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='inornatus' OR junior_species='inornatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='inornatus' OR species='inornatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='inornatus' OR species='inornatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='inornatus' OR junior_species='inornatus')SELECT d.diet,d.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='inornatus' OR species='inornatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='schwarzi' OR junior_species='schwarzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='schwarzi' OR species='schwarzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='schwarzi' OR species='schwarzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='schwarzi' OR junior_species='schwarzii')SELECT d.diet,d.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='schwarzi' OR species='schwarzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phylloscopus' AND (species='fuscatus' OR species='fuscatus') 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='Ficedula' AND (junior_species='albicilla' OR junior_species='albicilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='albicilla' OR species='albicilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='albicilla' OR species='albicilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='albicilla' OR junior_species='albicilla')SELECT d.diet,d.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='albicilla' OR species='albicilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='mugimaki' OR junior_species='mugimakii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='mugimaki' OR species='mugimakii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='mugimaki' OR species='mugimakii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='mugimaki' OR junior_species='mugimakii')SELECT d.diet,d.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='mugimaki' OR species='mugimakii') 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='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='Parus' AND (junior_species='cyanus' OR junior_species='cyanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parus' AND (species='cyanus' OR species='cyanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='cyanus' OR species='cyanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='cyanus' OR junior_species='cyanus')SELECT d.diet,d.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='cyanus' OR species='cyanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='m.' OR junior_species='m.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parus' AND (species='m.' OR species='m.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='m.' OR species='m.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='m.' OR junior_species='m.')SELECT d.diet,d.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='m.' OR species='m.') 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='Zosterops' AND (junior_species='erythropleurus' OR junior_species='erythropleurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='erythropleurus' OR species='erythropleurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='erythropleurus' OR species='erythropleurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='erythropleurus' OR junior_species='erythropleurus')SELECT d.diet,d.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='erythropleurus' OR species='erythropleurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT d.diet,d.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='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='excubitor' OR junior_species='excubitor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='excubitor' OR species='excubitor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='excubitor' OR species='excubitor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='excubitor' OR junior_species='excubitor')SELECT d.diet,d.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='excubitor' OR species='excubitor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='sphenocercus' OR junior_species='sphenocercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='sphenocercus' OR species='sphenocercus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='sphenocercus' OR species='sphenocercus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='sphenocercus' OR junior_species='sphenocercus')SELECT d.diet,d.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='sphenocercus' OR species='sphenocercus') 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='Cyanopica' AND (junior_species='cyana' OR junior_species='cyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanopica' AND (species='cyana' OR species='cyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanopica' AND (species='cyana' OR species='cyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanopica' AND (junior_species='cyana' OR junior_species='cyana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanopica' AND (species='cyana' OR species='cyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pica' AND (junior_species='pica' OR junior_species='pica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pica' AND (species='pica' OR species='pica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pica' AND (species='pica' OR species='pica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pica' AND (junior_species='pica' OR junior_species='pica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pica' AND (species='pica' OR species='pica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' 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='Passer' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' 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='Passer' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fringilla' AND (junior_species='montifringilla' OR junior_species='montifringilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fringilla' AND (species='montifringilla' OR species='montifringilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fringilla' AND (species='montifringilla' OR species='montifringilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fringilla' AND (junior_species='montifringilla' OR junior_species='montifringilla')SELECT d.diet,d.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='montifringilla' OR species='montifringilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloris' AND (junior_species='sinica' OR junior_species='sinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloris' AND (species='sinica' OR species='sinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloris' AND (species='sinica' OR species='sinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloris' AND (junior_species='sinica' OR junior_species='sinica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chloris' AND (species='sinica' OR species='sinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='erythrinus' OR junior_species='erythrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpodacus' AND (species='erythrinus' OR species='erythrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpodacus' AND (species='erythrinus' OR species='erythrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='erythrinus' OR junior_species='erythrinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpodacus' AND (species='erythrinus' OR species='erythrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='roseus' OR junior_species='roseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpodacus' AND (species='roseus' OR species='roseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpodacus' AND (species='roseus' OR species='roseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='roseus' OR junior_species='roseus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpodacus' AND (species='roseus' OR species='roseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uragus' AND (junior_species='sibiricus' OR junior_species='sibiricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uragus' AND (species='sibiricus' OR species='sibiricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uragus' AND (species='sibiricus' OR species='sibiricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uragus' AND (junior_species='sibiricus' OR junior_species='sibiricus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uragus' AND (species='sibiricus' OR species='sibiricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='spodocephala' OR junior_species='spodocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='spodocephala' OR species='spodocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='spodocephala' OR species='spodocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='spodocephala' OR junior_species='spodocephala')SELECT d.diet,d.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='spodocephala' OR species='spodocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='leucocephala' OR junior_species='leucocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='leucocephala' OR species='leucocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='leucocephala' OR species='leucocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='leucocephala' OR junior_species='leucocephala')SELECT d.diet,d.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='leucocephala' OR species='leucocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='fucata' OR junior_species='fucata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='fucata' OR species='fucata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='fucata' OR species='fucata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='fucata' OR junior_species='fucata')SELECT d.diet,d.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='fucata' OR species='fucata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='elegans' OR junior_species='elegans')SELECT d.diet,d.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='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='chrysophrys' OR junior_species='chrysophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='chrysophrys' OR species='chrysophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='chrysophrys' OR species='chrysophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='chrysophrys' OR junior_species='chrysophrys')SELECT d.diet,d.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='chrysophrys' OR species='chrysophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='tristrami' OR junior_species='tristramii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='tristrami' OR species='tristramii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='tristrami' OR species='tristramii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='tristrami' OR junior_species='tristramii')SELECT d.diet,d.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='tristrami' OR species='tristramii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' 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='Emberiza' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' 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='Emberiza' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.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='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='rutila' OR junior_species='rutila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='rutila' OR species='rutila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='rutila' OR species='rutila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='rutila' OR junior_species='rutila')SELECT d.diet,d.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='rutila' OR species='rutila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='aureola' OR junior_species='aureola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='aureola' OR species='aureola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='aureola' OR species='aureola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='aureola' OR junior_species='aureola')SELECT d.diet,d.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='aureola' OR species='aureola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='pallasi' OR junior_species='pallasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='pallasi' OR species='pallasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='pallasi' OR species='pallasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='pallasi' OR junior_species='pallasii')SELECT d.diet,d.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='pallasi' OR species='pallasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='yessoensis' OR junior_species='yessoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='yessoensis' OR species='yessoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='yessoensis' OR species='yessoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='yessoensis' OR junior_species='yessoensis')SELECT d.diet,d.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='yessoensis' OR species='yessoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rallus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rallus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallus' AND (junior_species='indicus' OR junior_species='indicus')SELECT d.diet,d.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='indicus' OR species='indicus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1146