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=1082 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1082SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=749SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1082 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megapodius' AND (junior_species='freycinet' OR junior_species='freycinet')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megapodius' AND (species='freycinet' OR species='freycinet') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megapodius' AND (species='freycinet' OR species='freycinet')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megapodius' AND (junior_species='freycinet' OR junior_species='freycinet')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megapodius' AND (species='freycinet' OR species='freycinet') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='nigrirostris' OR junior_species='nigrirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='nigrirostris' OR junior_species='nigrirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicollumba' AND (junior_species='jobiensis' OR junior_species='jobiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallicollumba' AND (species='jobiensis' OR species='jobiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallicollumba' AND (species='jobiensis' OR species='jobiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicollumba' AND (junior_species='jobiensis' OR junior_species='jobiensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallicollumba' AND (species='jobiensis' OR species='jobiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='pulchellus' OR junior_species='pulchellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilinopus' AND (species='pulchellus' OR species='pulchellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilinopus' AND (species='pulchellus' OR species='pulchellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='pulchellus' OR junior_species='pulchellus')SELECT d.diet,d.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='pulchellus' OR species='pulchellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='castaneiventris' OR junior_species='castaneiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacomantis' AND (species='castaneiventris' OR species='castaneiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacomantis' AND (species='castaneiventris' OR species='castaneiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='castaneiventris' OR junior_species='castaneiventris')SELECT d.diet,d.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='castaneiventris' OR species='castaneiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='meyerii' OR junior_species='meyeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='meyerii' OR species='meyeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='meyerii' OR species='meyeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='meyerii' OR junior_species='meyeri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysococcyx' AND (species='meyerii' OR species='meyeri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninox' AND (junior_species='theomacha' OR junior_species='theomacha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ninox' AND (species='theomacha' OR species='theomacha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ninox' AND (species='theomacha' OR species='theomacha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninox' AND (junior_species='theomacha' OR junior_species='theomacha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ninox' AND (species='theomacha' OR species='theomacha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podargus' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podargus' AND (species='ocellatus' OR species='ocellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podargus' AND (species='ocellatus' OR species='ocellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podargus' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Podargus' AND (species='ocellatus' OR species='ocellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melidora' AND (junior_species='macrorrhina' OR junior_species='macrorrhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melidora' AND (species='macrorrhina' OR species='macrorrhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melidora' AND (species='macrorrhina' OR species='macrorrhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melidora' AND (junior_species='macrorrhina' OR junior_species='macrorrhina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melidora' AND (species='macrorrhina' OR species='macrorrhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacelo' AND (junior_species='gaudichaud' OR junior_species='gaudichaud')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacelo' AND (species='gaudichaud' OR species='gaudichaud') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacelo' AND (species='gaudichaud' OR species='gaudichaud')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacelo' AND (junior_species='gaudichaud' OR junior_species='gaudichaud')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dacelo' AND (species='gaudichaud' OR species='gaudichaud') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='torotoro' OR junior_species='torotoro')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halcyon' AND (species='torotoro' OR species='torotoro') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='torotoro' OR species='torotoro')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='torotoro' OR junior_species='torotoro')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halcyon' AND (species='torotoro' OR species='torotoro') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='lepidus' OR junior_species='lepidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceyx' AND (species='lepidus' OR species='lepidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceyx' AND (species='lepidus' OR species='lepidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='lepidus' OR junior_species='lepidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceyx' AND (species='lepidus' OR species='lepidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='azurea' OR junior_species='azurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceyx' AND (species='azurea' OR species='azurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceyx' AND (species='azurea' OR species='azurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='azurea' OR junior_species='azurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceyx' AND (species='azurea' OR species='azurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='caeruleogrisea' OR junior_species='caeruleogrisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coracina' AND (species='caeruleogrisea' OR species='caeruleogrisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coracina' AND (species='caeruleogrisea' OR species='caeruleogrisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='caeruleogrisea' OR junior_species='caeruleogrisea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coracina' AND (species='caeruleogrisea' OR species='caeruleogrisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilorrhoa' AND (junior_species='castanonotus' OR junior_species='castanonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilorrhoa' AND (species='castanonotus' OR species='castanonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilorrhoa' AND (species='castanonotus' OR species='castanonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilorrhoa' AND (junior_species='castanonotus' OR junior_species='castanonotus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilorrhoa' AND (species='castanonotus' OR species='castanonotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crateroscelis' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crateroscelis' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crateroscelis' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crateroscelis' AND (junior_species='murina' OR junior_species='murina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crateroscelis' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='spilodera' OR junior_species='spilodera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='spilodera' OR species='spilodera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='spilodera' OR species='spilodera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='spilodera' OR junior_species='spilodera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='spilodera' OR species='spilodera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='arfakianus' OR junior_species='arfakianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='arfakianus' OR species='arfakianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='arfakianus' OR species='arfakianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='arfakianus' OR junior_species='arfakianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='arfakianus' OR species='arfakianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='nouhuysi' OR junior_species='nouhuysii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='nouhuysi' OR junior_species='nouhuysii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerygone' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerygone' AND (species='chrysogaster' OR species='chrysogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gerygone' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='threnothorax' OR junior_species='threnothorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='threnothorax' OR species='threnothorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='threnothorax' OR species='threnothorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='threnothorax' OR junior_species='threnothorax')SELECT d.diet,d.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='threnothorax' OR species='threnothorax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='atra' OR junior_species='atra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='atra' OR species='atra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='atra' OR species='atra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='atra' OR junior_species='atra')SELECT d.diet,d.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='atra' OR species='atra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' 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='Rhipidura' AND (species='hyperythra' OR species='hyperythra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='hyperythra' OR species='hyperythra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' 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='Rhipidura' AND (species='hyperythra' OR species='hyperythra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monarcha' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monarcha' AND (species='axillaris' OR species='axillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monarcha' AND (species='axillaris' OR species='axillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='frater' OR junior_species='frater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monarcha' AND (species='frater' OR species='frater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monarcha' AND (species='frater' OR species='frater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='frater' OR junior_species='frater')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monarcha' AND (species='frater' OR species='frater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='guttula' OR junior_species='guttula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monarcha' AND (species='guttula' OR species='guttula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monarcha' AND (species='guttula' OR species='guttula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='guttula' OR junior_species='guttula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monarcha' AND (species='guttula' OR species='guttula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arses' AND (junior_species='telescophthalmus' OR junior_species='telescophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arses' AND (species='telescophthalmus' OR species='telescophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arses' AND (species='telescophthalmus' OR species='telescophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arses' AND (junior_species='telescophthalmus' OR junior_species='telescophthalmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arses' AND (species='telescophthalmus' OR species='telescophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerirhphus' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaerirhphus' AND (species='flaviventer' OR species='flaviventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaerirhphus' AND (species='flaviventer' OR species='flaviventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerirhphus' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machaerirhphus' AND (species='flaviventer' OR species='flaviventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microeca' AND (junior_species='flavovirescens' OR junior_species='flavovirescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microeca' AND (species='flavovirescens' OR species='flavovirescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microeca' AND (species='flavovirescens' OR species='flavovirescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microeca' AND (junior_species='flavovirescens' OR junior_species='flavovirescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microeca' AND (species='flavovirescens' OR species='flavovirescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymodes' AND (junior_species='superciliaris' OR junior_species='superciliaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymodes' AND (species='superciliaris' OR species='superciliaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymodes' AND (species='superciliaris' OR species='superciliaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymodes' AND (junior_species='superciliaris' OR junior_species='superciliaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drymodes' AND (species='superciliaris' OR species='superciliaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peneothello' AND (junior_species='bimaculatus' OR junior_species='bimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peneothello' AND (species='bimaculatus' OR species='bimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peneothello' AND (species='bimaculatus' OR species='bimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peneothello' AND (junior_species='bimaculatus' OR junior_species='bimaculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peneothello' AND (species='bimaculatus' OR species='bimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephalopsis' AND (junior_species='poliosoma' OR junior_species='poliosoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephalopsis' AND (species='poliosoma' OR species='poliosoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephalopsis' AND (species='poliosoma' OR species='poliosoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephalopsis' AND (junior_species='poliosoma' OR junior_species='poliosoma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephalopsis' AND (species='poliosoma' OR species='poliosoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycare' AND (junior_species='flavogrisea' OR junior_species='flavogrisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycare' AND (species='flavogrisea' OR species='flavogrisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycare' AND (species='flavogrisea' OR species='flavogrisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycare' AND (junior_species='flavogrisea' OR junior_species='flavogrisea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycare' AND (species='flavogrisea' OR species='flavogrisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='soror' OR junior_species='soror')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='soror' OR species='soror') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='soror' OR species='soror')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='soror' OR junior_species='soror')SELECT d.diet,d.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='soror' OR species='soror') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='simplex' OR junior_species='simplex')SELECT d.diet,d.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='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' 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='Pachycephala' AND (species='hyperythra' OR species='hyperythra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='hyperythra' OR species='hyperythra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' 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='Pachycephala' AND (species='hyperythra' OR species='hyperythra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='megarhyncha' OR junior_species='megarhyncha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='megarhyncha' OR junior_species='megarhyncha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='kirhocephalus' OR junior_species='kirhocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitohui' AND (species='kirhocephalus' OR species='kirhocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitohui' AND (species='kirhocephalus' OR species='kirhocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='kirhocephalus' OR junior_species='kirhocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitohui' AND (species='kirhocephalus' OR species='kirhocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' 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='Pitohui' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitohui' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' 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='Pitohui' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocharis' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocharis' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='nigra' OR junior_species='nigra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanocharis' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='longicauda' OR junior_species='longicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocharis' AND (species='longicauda' OR species='longicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocharis' AND (species='longicauda' OR species='longicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='longicauda' OR junior_species='longicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanocharis' AND (species='longicauda' OR species='longicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='pectorale' OR junior_species='pectorale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicaeum' AND (species='pectorale' OR species='pectorale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicaeum' AND (species='pectorale' OR species='pectorale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='pectorale' OR junior_species='pectorale')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dicaeum' AND (species='pectorale' OR species='pectorale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melilestes' AND (junior_species='megarhynchus' OR junior_species='megarhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melilestes' AND (junior_species='megarhynchus' OR junior_species='megarhynchus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhamphus' AND (junior_species='poliopterus' OR junior_species='poliopterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhamphus' AND (junior_species='poliopterus' OR junior_species='poliopterus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedistoma' AND (junior_species='iliolophus' OR junior_species='iliolophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedistoma' AND (species='iliolophus' OR species='iliolophus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedistoma' AND (species='iliolophus' OR species='iliolophus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedistoma' AND (junior_species='iliolophus' OR junior_species='iliolophus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oedistoma' AND (species='iliolophus' OR species='iliolophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycichaera' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glycichaera' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glycichaera' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycichaera' AND (junior_species='fallax' OR junior_species='fallax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glycichaera' AND (species='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myzomela' AND (junior_species='eques' OR junior_species='eques')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myzomela' AND (species='eques' OR species='eques') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myzomela' AND (species='eques' OR species='eques')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myzomela' AND (junior_species='eques' OR junior_species='eques')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myzomela' AND (species='eques' OR species='eques') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='mimikae' OR junior_species='mimikae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliphaga' AND (species='mimikae' OR species='mimikae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliphaga' AND (species='mimikae' OR species='mimikae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='mimikae' OR junior_species='mimikae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meliphaga' AND (species='mimikae' OR species='mimikae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='albonotatus' OR junior_species='albonotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliphaga' AND (species='albonotatus' OR species='albonotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliphaga' AND (species='albonotatus' OR species='albonotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='albonotatus' OR junior_species='albonotatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meliphaga' AND (species='albonotatus' OR species='albonotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='analoga' OR junior_species='analoga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliphaga' AND (species='analoga' OR species='analoga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliphaga' AND (species='analoga' OR species='analoga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='analoga' OR junior_species='analoga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meliphaga' AND (species='analoga' OR species='analoga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichenostomus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lichenostomus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lichenostomus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichenostomus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lichenostomus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotis' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthotis' AND (species='flaviventer' OR species='flaviventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthotis' AND (species='flaviventer' OR species='flaviventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotis' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthotis' AND (species='flaviventer' OR species='flaviventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotis' AND (junior_species='polygramma' OR junior_species='polygramma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthotis' AND (species='polygramma' OR species='polygramma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthotis' AND (species='polygramma' OR species='polygramma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotis' AND (junior_species='polygramma' OR junior_species='polygramma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthotis' AND (species='polygramma' OR species='polygramma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnopygius' AND (junior_species='ixoides' OR junior_species='ixoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnopygius' AND (species='ixoides' OR species='ixoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnopygius' AND (species='ixoides' OR species='ixoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnopygius' AND (junior_species='ixoides' OR junior_species='ixoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pycnopygius' AND (species='ixoides' OR species='ixoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='trichroa' OR junior_species='trichroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrura' AND (species='trichroa' OR species='trichroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrura' AND (species='trichroa' OR species='trichroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='trichroa' OR junior_species='trichroa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrura' AND (species='trichroa' OR species='trichroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='papuana' OR junior_species='papuana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrura' AND (species='papuana' OR species='papuana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrura' AND (species='papuana' OR species='papuana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='papuana' OR junior_species='papuana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrura' AND (species='papuana' OR species='papuana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetorhynchus' AND (junior_species='papuensis' OR junior_species='papuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetorhynchus' AND (species='papuensis' OR species='papuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetorhynchus' AND (species='papuensis' OR species='papuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetorhynchus' AND (junior_species='papuensis' OR junior_species='papuensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chaetorhynchus' AND (species='papuensis' OR species='papuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='hottentotus' OR junior_species='hottentotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='hottentotus' OR species='hottentotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='hottentotus' OR species='hottentotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='hottentotus' OR junior_species='hottentotus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dicrurus' AND (species='hottentotus' OR species='hottentotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='bruijni' OR junior_species='bruijnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grallina' AND (species='bruijni' OR species='bruijnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grallina' AND (species='bruijni' OR species='bruijnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='bruijni' OR junior_species='bruijnii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Grallina' AND (species='bruijni' OR species='bruijnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' AND (junior_species='quoyi' OR junior_species='quoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cracticus' AND (species='quoyi' OR species='quoyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cracticus' AND (species='quoyi' OR species='quoyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' AND (junior_species='quoyi' OR junior_species='quoyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cracticus' AND (species='quoyi' OR species='quoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuroedus' AND (junior_species='buccoides' OR junior_species='buccoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ailuroedus' AND (species='buccoides' OR species='buccoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ailuroedus' AND (species='buccoides' OR species='buccoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuroedus' AND (junior_species='buccoides' OR junior_species='buccoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ailuroedus' AND (species='buccoides' OR species='buccoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloris' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptiloris' AND (species='magnificus' OR species='magnificus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptiloris' AND (species='magnificus' OR species='magnificus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloris' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptiloris' AND (species='magnificus' OR species='magnificus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicinnurus' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cicinnurus' AND (species='magnificus' OR species='magnificus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cicinnurus' AND (species='magnificus' OR species='magnificus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicinnurus' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cicinnurus' AND (species='magnificus' OR species='magnificus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1082 The Ecological Register: Crater Mountain Biological Research Station
Crater Mountain Biological Research Station
Basic information
Sample name: Crater Mountain Biological Research Station

Reference: A. L. Mack and D. D. Wright. 1996. Notes on occurrence and feeding of birds at Crater Mountain Biological Research Station, Papua New Guinea. Emu 96:89-101 [ER 749]
Geography
Country: Papua New Guinea

State: Chimbu


Coordinate: 6° 43' 24" S, 145° 5' 36" E
Coordinate basis: stated in text

Geography comments: "10 km east of Haia"
altitude 850 to 1300 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 28.0

MAP: 6400.0

Habitat comments: climate data based on Bickford (2004, Behav Ecol Sociobiol); MAT estimated from average daily range of 14 to 42

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 1375 individuals

Years: 1989 - 1993

Sampling comments: 25 "netting sessions (mean length = 26.4h)" (number of days unrecoverable and number of nets not stated)

Metadata
Sample number: 1082

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-23 21:00:55

Modified: 2015-10-04 22:13:40

Abundance distribution
64 species
15 singletons
total count 1375
extrapolated richness: 101.9
Fisher's α: 13.900
geometric series k: 0.9161
Hurlbert's PIE: 0.9205
Shannon's H: 3.0665
Good's u: 0.9891
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Megapodius freycinet1638 g omnivore
Macropygia nigrirostris190.1 g frugivore
Gallicollumba jobiensis1
Ptilinopus pulchellus170.0 g frugivore
Cacomantis castaneiventris133.2 g insectivore
Chrysococcyx meyerii117.8 g insectivore
Ninox theomacha1125 g
Podargus ocellatus15.2 g insectivore-carnivore
Melidora macrorrhina697.0 g
Dacelo gaudichaud1143 g
Halcyon torotoro1
Ceyx lepidus33.0 g invertivore-carnivore
Ceyx azurea2
Coracina caeruleogrisea1148 g invertivore-frugivore
Ptilorrhoa castanonotus8
Crateroscelis murina5315.0 g insectivore
Sericornis spilodera4811.7 g insectivore
Sericornis arfakianus238.7 g insectivore
Sericornis nouhuysi217.1 g insectivore
Gerygone chrysogaster18.0 g insectivore
Rhipidura threnothorax717.6 g insectivore
Rhipidura atra1412.2 g
Rhipidura hyperythra1911.2 g
Rhipidura rufiventris112.0 g insectivore
Monarcha axillaris815.6 g
Monarcha frater122.0 g insectivore-invertivore
Monarcha guttula22
Arses telescophthalmus63.7 g
Machaerirhphus flaviventer4
Microeca flavovirescens815.0 g insectivore
Drymodes superciliaris345.9 g insectivore
Peneothello bimaculatus1126.3 g
Pachycephalopsis poliosoma4840.5 g insectivore
Pachycare flavogrisea8 insectivore
Pachycephala soror524.8 g insectivore
Pachycephala simplex217.4 g
Pachycephala hyperythra2527.7 g insectivore
Colluricincla megarhyncha615.7 g insectivore
Pitohui kirhocephalus372.0 g
Pitohui cristatus479.0 g invertivore
Melanocharis nigra7313.2 g frugivore
Melanocharis longicauda611.0 g
Dicaeum pectorale27.6 g invertivore-frugivore
Melilestes megarhynchus74 frugivore-insectivore
Toxorhamphus poliopterus20112.4 g nectarivore-invertivore
Oedistoma iliolophus118 nectarivore-insectivore
Glycichaera fallax2
Myzomela eques2 nectarivore-insectivore
Meliphaga mimikae72
Meliphaga albonotatus3
Meliphaga analoga1
Lichenostomus obscurus20
Xanthotis flaviventer15 omnivore
Xanthotis polygramma16
Pycnopygius ixoides5
Erythrura trichroa25014.0 g
Erythrura papuana619.4 g
Chaetorhynchus papuensis36
Dicrurus hottentotus3
Grallina bruijni2
Cracticus quoyi3 omnivore
Ailuroedus buccoides18
Ptiloris magnificus3
Cicinnurus magnificus27 invertivore-frugivore