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=1079 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1079SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=746SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1079 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='virgatus' OR junior_species='virgatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='virgatus' OR species='virgatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='virgatus' OR species='virgatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='virgatus' OR junior_species='virgatus')SELECT d.diet,d.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='virgatus' OR species='virgatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhierax' AND (junior_species='erythrogonys' OR junior_species='erythrogonys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhierax' AND (species='erythrogonys' OR species='erythrogonys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhierax' AND (species='erythrogonys' OR species='erythrogonys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhierax' AND (junior_species='erythrogonys' OR junior_species='erythrogonys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microhierax' AND (species='erythrogonys' OR species='erythrogonys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcophaps' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcophaps' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chalcophaps' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phapitreron' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phapitreron' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phapitreron' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phapitreron' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phapitreron' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilinopus' AND (species='occipitalis' OR species='occipitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilinopus' AND (species='occipitalis' OR species='occipitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='occipitalis' OR junior_species='occipitalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilinopus' AND (species='occipitalis' OR species='occipitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioniturus' AND (junior_species='discurus' OR junior_species='discurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prioniturus' AND (species='discurus' OR species='discurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prioniturus' AND (species='discurus' OR species='discurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioniturus' AND (junior_species='discurus' OR junior_species='discurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prioniturus' AND (species='discurus' OR species='discurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='sepuleralis' OR junior_species='sepuleralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacomantis' AND (species='sepuleralis' OR species='sepuleralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacomantis' AND (species='sepuleralis' OR species='sepuleralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='sepuleralis' OR junior_species='sepuleralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cacomantis' AND (species='sepuleralis' OR species='sepuleralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='fugax' OR junior_species='fugax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuculus' AND (species='fugax' OR species='fugax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuculus' AND (species='fugax' OR species='fugax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='fugax' OR junior_species='fugax')SELECT d.diet,d.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='fugax' OR species='fugax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='saturatus' OR junior_species='saturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuculus' AND (species='saturatus' OR species='saturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuculus' AND (species='saturatus' OR species='saturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='saturatus' OR junior_species='saturatus')SELECT d.diet,d.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='saturatus' OR species='saturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='mirus' OR junior_species='mirus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otus' AND (species='mirus' OR species='mirus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otus' AND (species='mirus' OR species='mirus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='mirus' OR junior_species='mirus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Otus' AND (species='mirus' OR species='mirus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='manillensis' OR junior_species='manillensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='manillensis' OR species='manillensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='manillensis' OR species='manillensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='manillensis' OR junior_species='manillensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caprimulgus' AND (species='manillensis' OR species='manillensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysocolaptes' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysocolaptes' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysocolaptes' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysocolaptes' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysocolaptes' AND (species='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsipetes' AND (junior_species='philippinus' OR junior_species='philippinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsipetes' AND (species='philippinus' OR species='philippinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsipetes' AND (species='philippinus' OR species='philippinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsipetes' AND (junior_species='philippinus' OR junior_species='philippinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypsipetes' AND (species='philippinus' OR species='philippinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' 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='Parus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' 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='Parus' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitta' AND (junior_species='oenochlamys' OR junior_species='oenochlamys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sitta' AND (species='oenochlamys' OR species='oenochlamys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sitta' AND (species='oenochlamys' OR species='oenochlamys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitta' AND (junior_species='oenochlamys' OR junior_species='oenochlamys')SELECT d.diet,d.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='oenochlamys' OR species='oenochlamys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macronous' AND (junior_species='striaticeps' OR junior_species='striaticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macronous' AND (species='striaticeps' OR species='striaticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macronous' AND (species='striaticeps' OR species='striaticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macronous' AND (junior_species='striaticeps' OR junior_species='striaticeps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macronous' AND (species='striaticeps' OR species='striaticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='poliocephalus' OR junior_species='poliocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='poliocephalus' OR species='poliocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='poliocephalus' OR species='poliocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='poliocephalus' OR junior_species='poliocephalus')SELECT d.diet,d.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='poliocephalus' OR species='poliocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='heterolaemus' OR junior_species='heterolaemus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthotomus' AND (species='heterolaemus' OR species='heterolaemus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthotomus' AND (species='heterolaemus' OR species='heterolaemus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='heterolaemus' OR junior_species='heterolaemus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthotomus' AND (species='heterolaemus' OR species='heterolaemus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phylloscopus' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyias' AND (junior_species='panayensis' OR junior_species='panayensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyias' AND (species='panayensis' OR species='panayensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyias' AND (species='panayensis' OR species='panayensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyias' AND (junior_species='panayensis' OR junior_species='panayensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eumyias' AND (species='panayensis' OR species='panayensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='hyperythra' OR junior_species='hyperythra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='hyperythra' OR species='hyperythra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='hyperythra' OR species='hyperythra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='hyperythra' OR junior_species='hyperythra')SELECT d.diet,d.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='hyperythra' OR species='hyperythra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='westermanni' OR junior_species='westermannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='westermanni' OR species='westermannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='westermanni' OR species='westermannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='westermanni' OR junior_species='westermannii')SELECT d.diet,d.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='westermanni' OR species='westermannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinomyias' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinomyias' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinomyias' AND (species='goodfellowi' OR species='goodfellowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinomyias' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinomyias' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='nigrocinnamomea' OR junior_species='nigrocinnamomea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='nigrocinnamomea' OR species='nigrocinnamomea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='nigrocinnamomea' OR species='nigrocinnamomea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='nigrocinnamomea' OR junior_species='nigrocinnamomea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhipidura' AND (species='nigrocinnamomea' OR species='nigrocinnamomea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='philippinensis' OR junior_species='philippinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='philippinensis' OR species='philippinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='philippinensis' OR species='philippinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='philippinensis' OR junior_species='philippinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephala' AND (species='philippinensis' OR species='philippinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='validirostris' OR junior_species='validirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='validirostris' OR species='validirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='validirostris' OR species='validirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='validirostris' OR junior_species='validirostris')SELECT d.diet,d.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='validirostris' OR species='validirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basilornis' AND (junior_species='miranda' OR junior_species='miranda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basilornis' AND (species='miranda' OR species='miranda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basilornis' AND (species='miranda' OR species='miranda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basilornis' AND (junior_species='miranda' OR junior_species='miranda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basilornis' AND (species='miranda' OR species='miranda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='boltoni' OR junior_species='boltonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethopyga' AND (species='boltoni' OR species='boltonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethopyga' AND (species='boltoni' OR species='boltonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='boltoni' OR junior_species='boltonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aethopyga' AND (species='boltoni' OR species='boltonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethopyga' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethopyga' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aethopyga' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaceum' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaceum' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaceum' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaceum' AND (junior_species='spp.' OR junior_species='spp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaceum' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacaeum' AND (junior_species='anthonyi' OR junior_species='anthonyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diacaeum' AND (species='anthonyi' OR species='anthonyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diacaeum' AND (species='anthonyi' OR species='anthonyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacaeum' AND (junior_species='anthonyi' OR junior_species='anthonyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diacaeum' AND (species='anthonyi' OR species='anthonyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacaeum' AND (junior_species='nigrilore' OR junior_species='nigrilore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diacaeum' AND (species='nigrilore' OR species='nigrilore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diacaeum' AND (species='nigrilore' OR species='nigrilore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacaeum' AND (junior_species='nigrilore' OR junior_species='nigrilore')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diacaeum' AND (species='nigrilore' OR species='nigrilore') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocryptadius' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypocryptadius' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocryptadius' AND (species='cinnamomeus' OR species='cinnamomeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocryptadius' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypocryptadius' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophozosterops' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophozosterops' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophozosterops' AND (species='goodfellowi' OR species='goodfellowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophozosterops' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophozosterops' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1079 The Ecological Register: Mt. Kitanglad (1500 - 1800 m)
Mt. Kitanglad (1500 - 1800 m)
Basic information
Sample name: Mt. Kitanglad (1500 - 1800 m)

Reference: A. T. Peterson, T. Brooks, A. Gamauf, J. C. T. Gonzalez, N. A. D. Mallari, G. Dutson, S. E. Bush, D. H. Clayton, and R. Fernandez. 2008. The avifauna of Mt. Kitanglad, Bukidnon Province, Mindanao, Philippines. Fieldiana: Zoology 114:1-43 [ER 746]
Geography
Country: Philippines

State: Bukidnon


Coordinate: 8° 9' 30" N, 124° 45' 0" E
Coordinate basis: stated in text

Geography comments: "Mindanao, Bukidnon Province, Mt. Kitanglad Range, Mt. Imbayao Peak, 15 km S, 7 km E Baungon
camps were at 1600 and 1800 m and were respectively at 8 10 N 124 45 E and 8 9 N 124 45 E

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 23.6

MAP: 2736.0

Habitat comments: respectively "primary midmontane forest" and "primary transitional montane/mossy rain forest"
there is no nearby climate station; climate data are for Malaybalay and are from Karatson et al. (1999, Bull Volcanol)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 235 individuals

Net or trap nights: 365

Sampling comments: net days stated (respectively 297 and 68), but number of nets is unclear

Metadata
Sample number: 1079

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-23 10:58:29

Modified: 2014-08-23 00:58:29

Abundance distribution
34 species
8 singletons
total count 235
extrapolated richness: 56.5
Fisher's α: 10.916
geometric series k: 0.9060
Hurlbert's PIE: 0.9397
Shannon's H: 3.0761
Good's u: 0.9661
Each square represents a species. Square sizes are proportional to counts.
Register