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=1059 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1059SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=732SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1059 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' AND (junior_species='vernans' OR junior_species='vernans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Treron' AND (species='vernans' OR species='vernans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Treron' AND (species='vernans' OR species='vernans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' AND (junior_species='vernans' OR junior_species='vernans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Treron' AND (species='vernans' OR species='vernans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='goiavier' OR junior_species='goiavier')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnonotus' AND (species='goiavier' OR species='goiavier') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='goiavier' OR species='goiavier')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='goiavier' OR junior_species='goiavier')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pycnonotus' AND (species='goiavier' OR species='goiavier') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geopelia' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geopelia' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geopelia' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geopelia' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geopelia' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Streptopelia' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acridotheres' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acridotheres' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acridotheres' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acridotheres' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acridotheres' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acridotheres' AND (junior_species='tristis' OR junior_species='tristis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acridotheres' AND (species='tristis' OR species='tristis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acridotheres' AND (species='tristis' OR species='tristis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acridotheres' AND (junior_species='tristis' OR junior_species='tristis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acridotheres' AND (species='tristis' OR species='tristis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='punctulata' OR junior_species='punctulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchura' AND (species='punctulata' OR species='punctulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='punctulata' OR species='punctulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='punctulata' OR junior_species='punctulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lonchura' AND (species='punctulata' OR species='punctulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='philippinus' OR species='philippinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='philippinus' OR species='philippinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='philippinus' OR species='philippinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaurornis' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amaurornis' AND (species='phoenicurus' OR species='phoenicurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amaurornis' AND (species='phoenicurus' OR species='phoenicurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaurornis' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amaurornis' AND (species='phoenicurus' OR species='phoenicurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='tahitica' OR junior_species='tahitica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='tahitica' OR species='tahitica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='tahitica' OR species='tahitica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='tahitica' OR junior_species='tahitica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hirundo' AND (species='tahitica' OR species='tahitica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' 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='Merops' AND (species='philippinus' OR species='philippinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='philippinus' OR species='philippinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' 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='Merops' AND (species='philippinus' OR species='philippinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='smyrnensis' OR junior_species='smyrnensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halcyon' AND (species='smyrnensis' OR species='smyrnensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='smyrnensis' OR species='smyrnensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='smyrnensis' OR junior_species='smyrnensis')SELECT d.diet,d.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='smyrnensis' OR species='smyrnensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardea' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ardea' AND (species='purpurea' OR species='purpurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ardea' AND (species='purpurea' OR species='purpurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardea' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ardea' AND (species='purpurea' OR species='purpurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' 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='Vanellus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanellus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' 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='Vanellus' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='richardi' OR junior_species='richardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='richardi' OR species='richardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='richardi' OR species='richardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='richardi' OR junior_species='richardii')SELECT d.diet,d.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='richardi' OR species='richardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='sinensis' OR junior_species='sinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixobrychus' AND (species='sinensis' OR species='sinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixobrychus' AND (species='sinensis' OR species='sinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='sinensis' OR junior_species='sinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ixobrychus' AND (species='sinensis' OR species='sinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocygna' AND (junior_species='javanica' OR junior_species='javanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocygna' AND (species='javanica' OR species='javanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocygna' AND (species='javanica' OR species='javanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocygna' AND (junior_species='javanica' OR junior_species='javanica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocygna' AND (species='javanica' OR species='javanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='malacca' OR junior_species='malacca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchura' AND (species='malacca' OR species='malacca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='malacca' OR species='malacca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='malacca' OR junior_species='malacca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lonchura' AND (species='malacca' OR species='malacca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copsychus' AND (junior_species='saularis' OR junior_species='saularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copsychus' AND (species='saularis' OR species='saularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copsychus' AND (species='saularis' OR species='saularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copsychus' AND (junior_species='saularis' OR junior_species='saularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Copsychus' AND (species='saularis' OR species='saularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplonis' 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='Aplonis' AND (species='panayensis' OR species='panayensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aplonis' AND (species='panayensis' OR species='panayensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplonis' 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='Aplonis' AND (species='panayensis' OR species='panayensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriolus' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriolus' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oriolus' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='flaviventris' OR species='flaviventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='flaviventris' OR species='flaviventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prinia' AND (species='flaviventris' OR species='flaviventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='javanica' OR junior_species='javanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='javanica' OR species='javanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='javanica' OR species='javanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='javanica' OR junior_species='javanica')SELECT d.diet,d.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='javanica' OR species='javanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithina' AND (junior_species='viridissima' OR junior_species='viridissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegithina' AND (species='viridissima' OR species='viridissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegithina' AND (species='viridissima' OR species='viridissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithina' AND (junior_species='viridissima' OR junior_species='viridissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aegithina' AND (species='viridissima' OR species='viridissima') 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='Acridotheres' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acridotheres' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acridotheres' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acridotheres' AND (junior_species='grandis' OR junior_species='grandis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acridotheres' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centropus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centropus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinula' AND (junior_species='chloropus' OR junior_species='chloropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallinula' AND (species='chloropus' OR species='chloropus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallinula' AND (species='chloropus' OR species='chloropus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinula' AND (junior_species='chloropus' OR junior_species='chloropus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallinula' AND (species='chloropus' OR species='chloropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinopium' AND (junior_species='javanense' OR junior_species='javanense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinopium' AND (species='javanense' OR species='javanense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinopium' AND (species='javanense' OR species='javanense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinopium' AND (junior_species='javanense' OR junior_species='javanense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dinopium' AND (species='javanense' OR species='javanense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithina' AND (junior_species='tiphia' OR junior_species='tiphia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegithina' AND (species='tiphia' OR species='tiphia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegithina' AND (species='tiphia' OR species='tiphia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegithina' AND (junior_species='tiphia' OR junior_species='tiphia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aegithina' AND (species='tiphia' OR species='tiphia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lalage' 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='Lalage' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lalage' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lalage' 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='Lalage' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurystomus' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurystomus' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurystomus' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurystomus' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurystomus' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' 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='Ixobrychus' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixobrychus' AND (species='cinnamomeus' OR species='cinnamomeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' 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='Ixobrychus' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='viridis' OR junior_species='viridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Merops' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT d.diet,d.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='orientalis' OR species='orientalis') 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='Porzana' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porzana' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porzana' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Porzana' AND (species='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='sutorius' OR junior_species='sutorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthotomus' AND (species='sutorius' OR species='sutorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthotomus' AND (species='sutorius' OR species='sutorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='sutorius' OR junior_species='sutorius')SELECT d.diet,d.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='sutorius' OR species='sutorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthreptes' AND (junior_species='malacensis' OR junior_species='malacensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthreptes' AND (species='malacensis' OR species='malacensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthreptes' AND (species='malacensis' OR species='malacensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthreptes' AND (junior_species='malacensis' OR junior_species='malacensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthreptes' AND (species='malacensis' OR species='malacensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='merulinus' OR junior_species='merulinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacomantis' AND (species='merulinus' OR species='merulinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacomantis' AND (species='merulinus' OR species='merulinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='merulinus' OR junior_species='merulinus')SELECT d.diet,d.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='merulinus' OR species='merulinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='ruficeps' OR junior_species='ruficeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthotomus' AND (species='ruficeps' OR species='ruficeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthotomus' AND (species='ruficeps' OR species='ruficeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='ruficeps' OR junior_species='ruficeps')SELECT d.diet,d.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='ruficeps' OR species='ruficeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Butorides' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Butorides' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Butorides' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Butorides' AND (junior_species='striatus' OR junior_species='striatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Butorides' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='jugularis' OR junior_species='jugularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectarinia' AND (species='jugularis' OR species='jugularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectarinia' AND (species='jugularis' OR species='jugularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='jugularis' OR junior_species='jugularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nectarinia' AND (species='jugularis' OR species='jugularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turnix' AND (junior_species='suscitator' OR junior_species='suscitator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turnix' AND (species='suscitator' OR species='suscitator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turnix' AND (species='suscitator' OR species='suscitator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turnix' AND (junior_species='suscitator' OR junior_species='suscitator')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turnix' AND (species='suscitator' OR species='suscitator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='dauurica' OR junior_species='dauurica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='dauurica' OR species='dauurica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='dauurica' OR species='dauurica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='dauurica' OR junior_species='dauurica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Muscicapa' AND (species='dauurica' OR species='dauurica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' 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='Porzana' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porzana' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' 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='Porzana' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='plumosus' OR junior_species='plumosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnonotus' AND (species='plumosus' OR species='plumosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='plumosus' OR species='plumosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='plumosus' OR junior_species='plumosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pycnonotus' AND (species='plumosus' OR species='plumosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='juncidis' OR junior_species='juncidis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='juncidis' OR species='juncidis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='juncidis' OR species='juncidis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='juncidis' OR junior_species='juncidis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cisticola' AND (species='juncidis' OR species='juncidis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='macrurus' OR junior_species='macrurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='macrurus' OR species='macrurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='macrurus' OR species='macrurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='macrurus' OR junior_species='macrurus')SELECT d.diet,d.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='macrurus' OR species='macrurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='affinis' OR junior_species='affinis')SELECT d.diet,d.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='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicrex' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallicrex' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallicrex' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicrex' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallicrex' AND (species='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='eurhythmus' OR junior_species='eurhythmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixobrychus' AND (species='eurhythmus' OR species='eurhythmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixobrychus' AND (species='eurhythmus' OR species='eurhythmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='eurhythmus' OR junior_species='eurhythmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ixobrychus' AND (species='eurhythmus' OR species='eurhythmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coturnix' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coturnix' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coturnix' AND (species='chinensis' OR species='chinensis') 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='Gallirallus' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallirallus' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallirallus' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallirallus' AND (junior_species='striatus' OR junior_species='striatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallirallus' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='lettia' OR junior_species='lettia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otus' AND (species='lettia' OR species='lettia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otus' AND (species='lettia' OR species='lettia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='lettia' OR junior_species='lettia')SELECT d.diet,d.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='lettia' OR species='lettia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aerodramus' AND (junior_species='fuciphagus' OR junior_species='fuciphagus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aerodramus' AND (species='fuciphagus' OR species='fuciphagus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aerodramus' AND (species='fuciphagus' OR species='fuciphagus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aerodramus' AND (junior_species='fuciphagus' OR junior_species='fuciphagus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aerodramus' AND (species='fuciphagus' OR species='fuciphagus') 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='Accipiter' AND (junior_species='gularis' OR junior_species='gularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='gularis' OR junior_species='gularis')SELECT d.diet,d.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='gularis' OR species='gularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='pileata' OR junior_species='pileata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halcyon' AND (species='pileata' OR species='pileata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='pileata' OR species='pileata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='pileata' OR junior_species='pileata')SELECT d.diet,d.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='pileata' OR species='pileata') ORDER BY year,last_namesSELECT 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='Pelargopsis' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelargopsis' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelargopsis' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelargopsis' AND (junior_species='capensis' OR junior_species='capensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pelargopsis' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pluvialis' AND (junior_species='fulva' OR junior_species='fulva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pluvialis' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pluvialis' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pluvialis' AND (junior_species='fulva' OR junior_species='fulva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pluvialis' AND (species='fulva' OR species='fulva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='sunia' OR junior_species='sunia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otus' AND (species='sunia' OR species='sunia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otus' AND (species='sunia' OR species='sunia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='sunia' OR junior_species='sunia')SELECT d.diet,d.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='sunia' OR species='sunia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='xanthorhynchus' OR junior_species='xanthorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='xanthorhynchus' OR species='xanthorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='xanthorhynchus' OR species='xanthorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='xanthorhynchus' OR junior_species='xanthorhynchus')SELECT d.diet,d.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='xanthorhynchus' OR species='xanthorhynchus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1059 The Ecological Register: Paya Indah Wetland Reserve
Paya Indah Wetland Reserve
Basic information
Sample name: Paya Indah Wetland Reserve

Reference: M. Zakaria and M. Nawaz Rajpar. 2010. Bird species composition and feeding guilds based on point count and mist netting methods at the Paya Indah Wetland Reserve, Peninsular Malaysia. Tropical Life Sciences Research 21(2):7-26 [ER 732]
Geography
Country: Malaysia

State: Selangor


Coordinate: 2° 55' N, 101° 30' E
Coordinate basis: stated in text as range

Geography comments: "adjacent to Malaysia's administrative capital Putrajaya"
coordinate based on midpoints of ranges given in text

•
Environment
Habitat: tropical/subtropical wetland

Substrate: ground surface

WMT: 26.2

CMT: 17.0

MAP: 2784.0

Habitat comments: climate data based on station 48647 (Subang Airport)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 1478 individuals

Nets or traps: 10

Net or trap nights: 105

Sampling comments: ten 14 x 4 m nets used for a total of 105 (net) days and 1260 netting hours
counts are of individuals, not captures

Metadata
Sample number: 1059

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-20 20:44:15

Modified: 2014-08-22 03:31:58

Abundance distribution
65 species
17 singletons
total count 1478
extrapolated richness: 104.3
Fisher's α: 13.901
geometric series k: 0.9114
Hurlbert's PIE: 0.9006
Shannon's H: 3.0046
Good's u: 0.9885
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Treron vernans96132 g frugivore
Pycnonotus goiavier37927.8 g insectivore-frugivore
Geopelia striata15256.6 g granivore
Streptopelia chinensis35159 g granivore
Acridotheres fuscus482.8 g omnivore
Acridotheres tristis24.8 g omnivore
Lonchura punctulata1913.6 g granivore
Ploceus philippinus14128.2 g granivore
Amaurornis phoenicurus23180 g omnivore
Hirundo tahitica517.8 g
Merops philippinus2034.0 g insectivore
Halcyon smyrnensis6691.4 g carnivore
Ardea purpurea21.1 kg carnivore
Vanellus indicus12181 g carnivore
Anthus richardi3133.5 g
Ixobrychus sinensis4994.3 g carnivore
Dendrocygna javanica2 omnivore
Lonchura malacca2112.6 g frugivore-nectarivore
Copsychus saularis4936.0 g insectivore
Aplonis panayensis256.2 g
Oriolus chinensis3 insectivore
Prinia flaviventris117.0 g insectivore-granivore
Rhipidura javanica3912.5 g insectivore
Aegithina viridissima1913.4 g insectivore
Lanius cristatus31 insectivore
Acridotheres grandis10103 g omnivore
Centropus bengalensis812.1 g insectivore
Gallinula chloropus118.4 g omnivore
Dinopium javanense1376.4 g
Aegithina tiphia512.0 g insectivore
Lalage nigra1728.4 g insectivore
Eurystomus orientalis15.5 g insectivore-carnivore
Ixobrychus cinnamomeus19128 g carnivore
Merops viridis1534.8 g insectivore
Acrocephalus orientalis2725.5 g
Gallinago stenura6113 g omnivore
Porzana cinerea152.1 g
Orthotomus sutorius67.5 g insectivore
Anthreptes malacensis712.0 g frugivore-nectarivore
Cacomantis merulinus1025.3 g insectivore
Orthotomus ruficeps1 insectivore
Butorides striatus3 carnivore
Nectarinia jugularis3
Turnix suscitator10 granivore
Muscicapa dauurica19.8 g insectivore
Porzana pusilla135.4 g
Pycnonotus plumosus636.7 g insectivore-frugivore
Cisticola juncidis17.5 g insectivore
Caprimulgus macrurus4866.2 g insectivore
Caprimulgus affinis1458.7 g
Gallicrex cinerea1503 g herbivore
Ixobrychus eurhythmus11139 g
Coturnix chinensis1
Phylloscopus borealis13.3 g insectivore
Gallirallus striatus1116 g
Otus lettia3 carnivore
Aerodramus fuciphagus310.7 g
Phylloscopus inornatus22.6 g insectivore
Accipiter gularis2104 g
Halcyon pileata184.0 g
Accipiter virgatus110.6 g carnivore
Pelargopsis capensis1155 g carnivore
Pluvialis fulva1130 g
Otus sunia18.5 g
Chrysococcyx xanthorhynchus1 insectivore