Coordinate: 26° 13' S, 28° 6' E
counts are of individuals ringed as adults or juveniles (as opposed to nestlings, which are also inventoried and apparently were sampled in an ad hoc way)
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=2952 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2952SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2761SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2952 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elanus' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elanus' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elanus' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elanus' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elanus' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='coqui' OR junior_species='coquii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='coqui' OR species='coquii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='coqui' OR species='coquii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='coqui' OR junior_species='coquii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Francolinus' AND (species='coqui' OR species='coquii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='swainsoni' OR junior_species='swainsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='swainsoni' OR species='swainsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='swainsoni' OR species='swainsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='swainsoni' OR junior_species='swainsonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Francolinus' AND (species='swainsoni' OR species='swainsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Numida' AND (junior_species='meleagris' OR junior_species='meleagris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Numida' AND (species='meleagris' OR species='meleagris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Numida' AND (species='meleagris' OR species='meleagris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Numida' AND (junior_species='meleagris' OR junior_species='meleagris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Numida' AND (species='meleagris' OR species='meleagris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crex' AND (junior_species='crex' OR junior_species='crex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crex' AND (species='crex' OR species='crex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crex' AND (species='crex' OR species='crex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crex' AND (junior_species='crex' OR junior_species='crex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crex' AND (species='crex' OR species='crex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='tricollaris' OR junior_species='tricollaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charadrius' AND (species='tricollaris' OR species='tricollaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charadrius' AND (species='tricollaris' OR species='tricollaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='tricollaris' OR junior_species='tricollaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charadrius' AND (species='tricollaris' OR species='tricollaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanellus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanellus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT d.diet,d.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='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' 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='Burhinus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Burhinus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' 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='Burhinus' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='capicola' OR junior_species='capicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='capicola' OR species='capicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='capicola' OR species='capicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='capicola' OR junior_species='capicola')SELECT d.diet,d.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='capicola' OR species='capicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilopelia' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilopelia' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilopelia' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilopelia' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spilopelia' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oena' 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='Oena' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oena' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oena' 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='Oena' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='solitarius' OR junior_species='solitarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuculus' AND (species='solitarius' OR species='solitarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuculus' AND (species='solitarius' OR species='solitarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='solitarius' OR junior_species='solitarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cuculus' AND (species='solitarius' OR species='solitarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='caprius' OR junior_species='caprius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='caprius' OR species='caprius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='caprius' OR species='caprius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='caprius' OR junior_species='caprius')SELECT d.diet,d.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='caprius' OR species='caprius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centropus' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT d.diet,d.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='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubo' AND (junior_species='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bubo' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubo' AND (species='africanus' OR species='africanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubo' AND (junior_species='africanus' OR junior_species='africanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bubo' AND (species='africanus' OR species='africanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyto' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyto' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' AND (junior_species='alba' OR junior_species='alba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tyto' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='rufigena' OR junior_species='rufigena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='rufigena' OR species='rufigena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='rufigena' OR species='rufigena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='rufigena' OR junior_species='rufigena')SELECT d.diet,d.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='rufigena' OR species='rufigena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apus' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apus' AND (species='caffer' OR species='caffer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' AND (junior_species='caffer' OR junior_species='caffer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apus' AND (species='caffer' OR species='caffer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' 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='Apus' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apus' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' 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='Apus' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocolius' 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='Urocolius' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urocolius' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocolius' 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='Urocolius' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythornis' 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='Corythornis' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corythornis' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythornis' 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='Corythornis' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='albiventris' OR junior_species='albiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halcyon' AND (species='albiventris' OR species='albiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='albiventris' OR species='albiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='albiventris' OR junior_species='albiventris')SELECT d.diet,d.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='albiventris' OR species='albiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='apiaster' OR junior_species='apiaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='apiaster' OR species='apiaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='apiaster' OR species='apiaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='apiaster' OR junior_species='apiaster')SELECT d.diet,d.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='apiaster' OR species='apiaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upupa' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Upupa' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Upupa' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upupa' AND (junior_species='africana' OR junior_species='africana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Upupa' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lybius' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lybius' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lybius' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lybius' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lybius' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricholaema' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tricholaema' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tricholaema' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricholaema' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tricholaema' AND (species='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyphonus' AND (junior_species='vaillanti' OR junior_species='vaillantii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyphonus' AND (species='vaillanti' OR species='vaillantii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyphonus' AND (species='vaillanti' OR species='vaillantii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyphonus' AND (junior_species='vaillanti' OR junior_species='vaillantii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachyphonus' AND (species='vaillanti' OR species='vaillantii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='indicator' OR junior_species='indicator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indicator' AND (species='indicator' OR species='indicator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indicator' AND (species='indicator' OR species='indicator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='indicator' OR junior_species='indicator')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Indicator' AND (species='indicator' OR species='indicator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indicator' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indicator' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Indicator' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jynx' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jynx' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jynx' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jynx' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='albigularis' OR junior_species='albigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='albigularis' OR species='albigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='albigularis' OR species='albigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='albigularis' OR junior_species='albigularis')SELECT d.diet,d.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='albigularis' OR species='albigularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='cucullata' OR junior_species='cucullata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='cucullata' OR species='cucullata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='cucullata' OR species='cucullata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='cucullata' OR junior_species='cucullata')SELECT d.diet,d.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='cucullata' OR species='cucullata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropis' AND (junior_species='abyssinica' OR junior_species='abyssinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropis' AND (species='abyssinica' OR species='abyssinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropis' AND (species='abyssinica' OR species='abyssinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropis' AND (junior_species='abyssinica' OR junior_species='abyssinica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cecropis' AND (species='abyssinica' OR species='abyssinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Riparia' AND (junior_species='paludicola' OR junior_species='paludicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Riparia' AND (species='paludicola' OR species='paludicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Riparia' AND (species='paludicola' OR species='paludicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Riparia' AND (junior_species='paludicola' OR junior_species='paludicola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Riparia' AND (species='paludicola' OR species='paludicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Riparia' AND (junior_species='cincta' OR junior_species='cincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Riparia' AND (species='cincta' OR species='cincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Riparia' AND (species='cincta' OR species='cincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Riparia' AND (junior_species='cincta' OR junior_species='cincta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Riparia' AND (species='cincta' OR species='cincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='adsimilis' OR junior_species='adsimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='adsimilis' OR species='adsimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='adsimilis' OR species='adsimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='adsimilis' OR junior_species='adsimilis')SELECT d.diet,d.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='adsimilis' OR species='adsimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='oriolus' OR junior_species='oriolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriolus' AND (species='oriolus' OR species='oriolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriolus' AND (species='oriolus' OR species='oriolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='oriolus' OR junior_species='oriolus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oriolus' AND (species='oriolus' OR species='oriolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnonotus' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT d.diet,d.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='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turdus' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophocichla' AND (junior_species='litsitsirupa' OR junior_species='litsitsirupa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psophocichla' AND (species='litsitsirupa' OR species='litsitsirupa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psophocichla' AND (species='litsitsirupa' OR species='litsitsirupa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophocichla' AND (junior_species='litsitsirupa' OR junior_species='litsitsirupa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psophocichla' AND (species='litsitsirupa' OR species='litsitsirupa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxicola' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saxicola' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saxicola' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxicola' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saxicola' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='caffra' OR junior_species='caffra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='caffra' OR species='caffra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='caffra' OR species='caffra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='caffra' OR junior_species='caffra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cossypha' AND (species='caffra' OR species='caffra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='borin' OR junior_species='borin')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvia' AND (species='borin' OR species='borin') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvia' AND (species='borin' OR species='borin')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvia' AND (junior_species='borin' OR junior_species='borin')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sylvia' AND (species='borin' OR species='borin') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='icterina' OR junior_species='icterina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippolais' AND (species='icterina' OR species='icterina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippolais' AND (species='icterina' OR species='icterina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippolais' AND (junior_species='icterina' OR junior_species='icterina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hippolais' AND (species='icterina' OR species='icterina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trochilus' OR junior_species='trochilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='trochilus' OR species='trochilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='trochilus' OR species='trochilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trochilus' OR junior_species='trochilus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phylloscopus' AND (species='trochilus' OR species='trochilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='arundinaceus' OR junior_species='arundinaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='arundinaceus' OR species='arundinaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='arundinaceus' OR species='arundinaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='arundinaceus' OR junior_species='arundinaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acrocephalus' AND (species='arundinaceus' OR species='arundinaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenoeacus' AND (junior_species='afer' OR junior_species='afer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphenoeacus' AND (species='afer' OR species='afer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenoeacus' AND (species='afer' OR species='afer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenoeacus' AND (junior_species='afer' OR junior_species='afer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sphenoeacus' AND (species='afer' OR species='afer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='fulvicapilla' OR junior_species='fulvicapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='fulvicapilla' OR species='fulvicapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='fulvicapilla' OR species='fulvicapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='fulvicapilla' OR junior_species='fulvicapilla')SELECT d.diet,d.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='fulvicapilla' OR species='fulvicapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='tinniens' OR junior_species='tinniens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='tinniens' OR species='tinniens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='tinniens' OR species='tinniens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='tinniens' OR junior_species='tinniens')SELECT d.diet,d.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='tinniens' OR species='tinniens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')SELECT d.diet,d.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='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='flavicans' OR junior_species='flavicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='flavicans' OR species='flavicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='flavicans' OR species='flavicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='flavicans' OR junior_species='flavicans')SELECT d.diet,d.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='flavicans' OR species='flavicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Muscicapa' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parisoma' AND (junior_species='subcaeruleum' OR junior_species='subcaeruleum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parisoma' AND (species='subcaeruleum' OR species='subcaeruleum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parisoma' AND (species='subcaeruleum' OR species='subcaeruleum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parisoma' AND (junior_species='subcaeruleum' OR junior_species='subcaeruleum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parisoma' AND (species='subcaeruleum' OR species='subcaeruleum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaenornis' AND (junior_species='silens' OR junior_species='silens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melaenornis' AND (species='silens' OR species='silens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melaenornis' AND (species='silens' OR species='silens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaenornis' AND (junior_species='silens' OR junior_species='silens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melaenornis' AND (species='silens' OR species='silens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' 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='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' 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='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' 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='Motacilla' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' 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='Motacilla' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collurio' OR junior_species='collurio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='collurio' OR species='collurio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='collurio' OR species='collurio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collurio' OR junior_species='collurio')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lanius' AND (species='collurio' OR species='collurio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='collaris' OR junior_species='collaris')SELECT d.diet,d.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='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telophorus' AND (junior_species='zeylonus' OR junior_species='zeylonus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telophorus' AND (species='zeylonus' OR species='zeylonus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telophorus' AND (species='zeylonus' OR species='zeylonus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telophorus' AND (junior_species='zeylonus' OR junior_species='zeylonus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Telophorus' AND (species='zeylonus' OR species='zeylonus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamprotornis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamprotornis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lamprotornis' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyricinclus' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyricinclus' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyricinclus' AND (species='leucogaster' OR species='leucogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyricinclus' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cinnyricinclus' AND (species='leucogaster' OR species='leucogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='amethystina' OR junior_species='amethystina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcomitra' AND (species='amethystina' OR species='amethystina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcomitra' AND (species='amethystina' OR species='amethystina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='amethystina' OR junior_species='amethystina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chalcomitra' AND (species='amethystina' OR species='amethystina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zosterops' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='domesticus' OR junior_species='domesticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='domesticus' OR species='domesticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='domesticus' OR species='domesticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='domesticus' OR junior_species='domesticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passer' AND (species='domesticus' OR species='domesticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='melanurus' OR species='melanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='melanurus' OR species='melanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passer' AND (species='melanurus' OR species='melanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='diffusus' OR junior_species='diffusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='diffusus' OR species='diffusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='diffusus' OR species='diffusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='diffusus' OR junior_species='diffusus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passer' AND (species='diffusus' OR species='diffusus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='ocularis' OR junior_species='ocularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='ocularis' OR species='ocularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='ocularis' OR species='ocularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='ocularis' OR junior_species='ocularis')SELECT d.diet,d.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='ocularis' OR species='ocularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='cucullatus' OR species='cucullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='cucullatus' OR species='cucullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='cucullatus' OR junior_species='cucullatus')SELECT d.diet,d.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='cucullatus' OR species='cucullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='velatus' OR junior_species='velatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='velatus' OR species='velatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='velatus' OR species='velatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='velatus' OR junior_species='velatus')SELECT d.diet,d.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='velatus' OR species='velatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='xanthops' OR junior_species='xanthops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='xanthops' OR species='xanthops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='xanthops' OR species='xanthops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='xanthops' OR junior_species='xanthops')SELECT d.diet,d.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='xanthops' OR species='xanthops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quelea' AND (junior_species='quelea' OR junior_species='quelea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quelea' AND (species='quelea' OR species='quelea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quelea' AND (species='quelea' OR species='quelea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quelea' AND (junior_species='quelea' OR junior_species='quelea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quelea' AND (species='quelea' OR species='quelea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='orix' OR junior_species='orix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='orix' OR species='orix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='orix' OR species='orix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='orix' OR junior_species='orix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='orix' OR species='orix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='afer' OR junior_species='afer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='afer' OR species='afer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='afer' OR species='afer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='afer' OR junior_species='afer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='afer' OR species='afer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='progne' OR junior_species='progne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='progne' OR species='progne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='progne' OR species='progne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='progne' OR junior_species='progne')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='progne' OR species='progne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amandava' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amandava' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amandava' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amandava' AND (junior_species='subflava' OR junior_species='subflava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amandava' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='astrild' OR species='astrild') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='astrild' OR species='astrild')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Estrilda' AND (species='astrild' OR species='astrild') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='granatinus' OR junior_species='granatinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uraeginthus' AND (species='granatinus' OR species='granatinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uraeginthus' AND (species='granatinus' OR species='granatinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uraeginthus' AND (junior_species='granatinus' OR junior_species='granatinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uraeginthus' AND (species='granatinus' OR species='granatinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vidua' AND (junior_species='macroura' OR junior_species='macroura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vidua' AND (species='macroura' OR species='macroura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vidua' AND (species='macroura' OR species='macroura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vidua' AND (junior_species='macroura' OR junior_species='macroura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vidua' AND (species='macroura' OR species='macroura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='mozambicus' OR junior_species='mozambicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='mozambicus' OR species='mozambicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='mozambicus' OR species='mozambicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='mozambicus' OR junior_species='mozambicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Serinus' AND (species='mozambicus' OR species='mozambicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='atrogularis' OR junior_species='atrogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='atrogularis' OR species='atrogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='atrogularis' OR species='atrogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='atrogularis' OR junior_species='atrogularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Serinus' AND (species='atrogularis' OR species='atrogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' 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='Serinus' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' 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='Serinus' AND (species='gularis' OR species='gularis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2952