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=1181 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1181SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=832SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1181 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='aganice' OR junior_species='aganice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='aganice' OR species='aganice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='aganice' OR species='aganice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='aganice' OR junior_species='aganice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='aganice' OR species='aganice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='alicia' OR junior_species='alicia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='alicia' OR species='alicia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='alicia' OR species='alicia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='alicia' OR junior_species='alicia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='alicia' OR species='alicia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='encedon' OR junior_species='encedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='encedon' OR species='encedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='encedon' OR species='encedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='encedon' OR junior_species='encedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='encedon' OR species='encedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='esebria' OR junior_species='esebria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='esebria' OR species='esebria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='esebria' OR species='esebria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='esebria' OR junior_species='esebria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='esebria' OR species='esebria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='rahira' OR junior_species='rahira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='rahira' OR species='rahira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='rahira' OR species='rahira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='rahira' OR junior_species='rahira')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='rahira' OR species='rahira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='campus' OR junior_species='campus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='campus' OR species='campus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='campus' OR species='campus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='campus' OR junior_species='campus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='campus' OR species='campus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='safitza' OR junior_species='safitza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='safitza' OR species='safitza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='safitza' OR species='safitza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='safitza' OR junior_species='safitza')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='safitza' OR species='safitza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byblia' AND (junior_species='anvatara' OR junior_species='anvatara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Byblia' AND (species='anvatara' OR species='anvatara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Byblia' AND (species='anvatara' OR species='anvatara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byblia' AND (junior_species='anvatara' OR junior_species='anvatara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Byblia' AND (species='anvatara' OR species='anvatara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catacroptera' AND (junior_species='cloanthe' OR junior_species='cloanthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catacroptera' AND (species='cloanthe' OR species='cloanthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catacroptera' AND (species='cloanthe' OR species='cloanthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catacroptera' AND (junior_species='cloanthe' OR junior_species='cloanthe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catacroptera' AND (species='cloanthe' OR species='cloanthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='brutus' OR junior_species='brutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='brutus' OR species='brutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='brutus' OR species='brutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='brutus' OR junior_species='brutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='brutus' OR species='brutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='candiope' OR junior_species='candiope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='candiope' OR species='candiope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='candiope' OR species='candiope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='candiope' OR junior_species='candiope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='candiope' OR species='candiope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='ethalion' OR junior_species='ethalion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='ethalion' OR species='ethalion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='ethalion' OR species='ethalion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='ethalion' OR junior_species='ethalion')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='ethalion' OR species='ethalion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='zoolina' OR junior_species='zoolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='zoolina' OR species='zoolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='zoolina' OR species='zoolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='zoolina' OR junior_species='zoolina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='zoolina' OR species='zoolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='chrysippus' OR junior_species='chrysippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='chrysippus' OR species='chrysippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='chrysippus' OR species='chrysippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='chrysippus' OR junior_species='chrysippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='chrysippus' OR species='chrysippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='dryope' OR junior_species='dryope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurytela' AND (species='dryope' OR species='dryope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurytela' AND (species='dryope' OR species='dryope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='dryope' OR junior_species='dryope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurytela' AND (species='dryope' OR species='dryope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='hiarbas' OR junior_species='hiarbas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurytela' AND (species='hiarbas' OR species='hiarbas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurytela' AND (species='hiarbas' OR species='hiarbas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='hiarbas' OR junior_species='hiarbas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurytela' AND (species='hiarbas' OR species='hiarbas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamanumida' AND (junior_species='daedalus' OR junior_species='daedalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamanumida' AND (species='daedalus' OR species='daedalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamanumida' AND (species='daedalus' OR species='daedalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamanumida' AND (junior_species='daedalus' OR junior_species='daedalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamanumida' AND (species='daedalus' OR species='daedalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henotesia' AND (junior_species='perspicua' OR junior_species='perspicua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Henotesia' AND (species='perspicua' OR species='perspicua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Henotesia' AND (species='perspicua' OR species='perspicua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henotesia' AND (junior_species='perspicua' OR junior_species='perspicua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Henotesia' AND (species='perspicua' OR species='perspicua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='oenone' OR junior_species='oenone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='oenone' OR species='oenone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='oenone' OR species='oenone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='oenone' OR junior_species='oenone')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='oenone' OR species='oenone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hierta' OR junior_species='hierta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='hierta' OR species='hierta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='hierta' OR species='hierta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hierta' OR junior_species='hierta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='hierta' OR species='hierta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='natalica' OR junior_species='natalica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='natalica' OR species='natalica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='natalica' OR species='natalica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='natalica' OR junior_species='natalica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='natalica' OR species='natalica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='orithya' OR junior_species='orithya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='orithya' OR species='orithya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='orithya' OR species='orithya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='orithya' OR junior_species='orithya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='orithya' OR species='orithya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='terea' OR junior_species='terea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='terea' OR species='terea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='terea' OR species='terea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='terea' OR junior_species='terea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='terea' OR species='terea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocoenyra' AND (junior_species='gregorii' OR junior_species='gregori')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocoenyra' AND (species='gregorii' OR species='gregori') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocoenyra' AND (species='gregorii' OR species='gregori')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocoenyra' AND (junior_species='gregorii' OR junior_species='gregori')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neocoenyra' AND (species='gregorii' OR species='gregori') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='saclava' OR junior_species='saclava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='saclava' OR species='saclava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='saclava' OR species='saclava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='saclava' OR junior_species='saclava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptis' AND (species='saclava' OR species='saclava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Precis' AND (junior_species='limnoria' OR junior_species='limnoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Precis' AND (species='limnoria' OR species='limnoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Precis' AND (species='limnoria' OR species='limnoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Precis' AND (junior_species='limnoria' OR junior_species='limnoria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Precis' AND (species='limnoria' OR species='limnoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Precis' AND (junior_species='tugela' OR junior_species='tugela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Precis' AND (species='tugela' OR species='tugela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Precis' AND (species='tugela' OR species='tugela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Precis' AND (junior_species='tugela' OR junior_species='tugela')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Precis' AND (species='tugela' OR species='tugela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salamis' AND (junior_species='parhassus' OR junior_species='parhassus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salamis' AND (species='parhassus' OR species='parhassus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salamis' AND (species='parhassus' OR species='parhassus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salamis' AND (junior_species='parhassus' OR junior_species='parhassus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salamis' AND (species='parhassus' OR species='parhassus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sallya' AND (junior_species='morantii' OR junior_species='moranti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sallya' AND (species='morantii' OR species='moranti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sallya' AND (species='morantii' OR species='moranti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sallya' AND (junior_species='morantii' OR junior_species='moranti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sallya' AND (species='morantii' OR species='moranti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='jodutta' OR junior_species='jodutta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='jodutta' OR species='jodutta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='jodutta' OR species='jodutta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='jodutta' OR junior_species='jodutta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='jodutta' OR species='jodutta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='acerata' OR junior_species='acerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acraea' AND (species='acerata' OR species='acerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acraea' AND (species='acerata' OR species='acerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acraea' AND (junior_species='acerata' OR junior_species='acerata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acraea' AND (species='acerata' OR species='acerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actizera' AND (junior_species='stellata' OR junior_species='stellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actizera' AND (species='stellata' OR species='stellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actizera' AND (species='stellata' OR species='stellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actizera' AND (junior_species='stellata' OR junior_species='stellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actizera' AND (species='stellata' OR species='stellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alaena' AND (junior_species='picata' OR junior_species='picata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alaena' AND (species='picata' OR species='picata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alaena' AND (species='picata' OR species='picata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alaena' AND (junior_species='picata' OR junior_species='picata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alaena' AND (species='picata' OR species='picata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axiocerses' AND (junior_species='harpax' OR junior_species='harpax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axiocerses' AND (species='harpax' OR species='harpax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Axiocerses' AND (species='harpax' OR species='harpax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axiocerses' AND (junior_species='harpax' OR junior_species='harpax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Axiocerses' AND (species='harpax' OR species='harpax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='jesous' OR junior_species='jesous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azanus' AND (species='jesous' OR species='jesous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azanus' AND (species='jesous' OR species='jesous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='jesous' OR junior_species='jesous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Azanus' AND (species='jesous' OR species='jesous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azanus' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azanus' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Azanus' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='ubaldus' OR junior_species='ubaldus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azanus' AND (species='ubaldus' OR species='ubaldus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azanus' AND (species='ubaldus' OR species='ubaldus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azanus' AND (junior_species='ubaldus' OR junior_species='ubaldus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Azanus' AND (species='ubaldus' OR species='ubaldus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacyreus' AND (junior_species='virilis' OR junior_species='virilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacyreus' AND (species='virilis' OR species='virilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacyreus' AND (species='virilis' OR species='virilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacyreus' AND (junior_species='virilis' OR junior_species='virilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cacyreus' AND (species='virilis' OR species='virilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deudorix' AND (junior_species='antalus' OR junior_species='antalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deudorix' AND (species='antalus' OR species='antalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deudorix' AND (species='antalus' OR species='antalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deudorix' AND (junior_species='antalus' OR junior_species='antalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Deudorix' AND (species='antalus' OR species='antalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eicochrysops' AND (junior_species='nandianus' OR junior_species='nandianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eicochrysops' AND (species='nandianus' OR species='nandianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eicochrysops' AND (species='nandianus' OR species='nandianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eicochrysops' AND (junior_species='nandianus' OR junior_species='nandianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eicochrysops' AND (species='nandianus' OR species='nandianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='subpallida' OR junior_species='subpallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchrysops' AND (species='subpallida' OR species='subpallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchrysops' AND (species='subpallida' OR species='subpallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='subpallida' OR junior_species='subpallida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euchrysops' AND (species='subpallida' OR species='subpallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Freyeria' AND (junior_species='trochylus' OR junior_species='trochylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Freyeria' AND (species='trochylus' OR species='trochylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Freyeria' AND (species='trochylus' OR species='trochylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Freyeria' AND (junior_species='trochylus' OR junior_species='trochylus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Freyeria' AND (species='trochylus' OR species='trochylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidochrysops' AND (junior_species='neonegus' OR junior_species='neonegus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidochrysops' AND (species='neonegus' OR species='neonegus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidochrysops' AND (species='neonegus' OR species='neonegus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidochrysops' AND (junior_species='neonegus' OR junior_species='neonegus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepidochrysops' AND (species='neonegus' OR species='neonegus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidochrysops' AND (junior_species='pterou' OR junior_species='pterou')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidochrysops' AND (species='pterou' OR species='pterou') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidochrysops' AND (species='pterou' OR species='pterou')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidochrysops' AND (junior_species='pterou' OR junior_species='pterou')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepidochrysops' AND (species='pterou' OR species='pterou') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='pirithous' OR junior_species='pirithous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotes' AND (species='pirithous' OR species='pirithous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotes' AND (species='pirithous' OR species='pirithous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='pirithous' OR junior_species='pirithous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotes' AND (species='pirithous' OR species='pirithous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='antanossa' OR junior_species='antanossa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizina' AND (species='antanossa' OR species='antanossa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizina' AND (species='antanossa' OR species='antanossa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='antanossa' OR junior_species='antanossa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zizina' AND (species='antanossa' OR species='antanossa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizula' AND (species='hylax' OR species='hylax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizula' AND (species='hylax' OR species='hylax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zizula' AND (species='hylax' OR species='hylax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='malathana' OR junior_species='malathana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchrysops' AND (species='malathana' OR species='malathana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchrysops' AND (species='malathana' OR species='malathana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='malathana' OR junior_species='malathana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euchrysops' AND (species='malathana' OR species='malathana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='osiris' OR junior_species='osiris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchrysops' AND (species='osiris' OR species='osiris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchrysops' AND (species='osiris' OR species='osiris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchrysops' AND (junior_species='osiris' OR junior_species='osiris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euchrysops' AND (species='osiris' OR species='osiris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='butleri' OR junior_species='butlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthene' AND (species='butleri' OR species='butlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthene' AND (species='butleri' OR species='butlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='butleri' OR junior_species='butlerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthene' AND (species='butleri' OR species='butlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacyreus' AND (junior_species='palemon' OR junior_species='palemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacyreus' AND (species='palemon' OR species='palemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacyreus' AND (species='palemon' OR species='palemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacyreus' AND (junior_species='palemon' OR junior_species='palemon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cacyreus' AND (species='palemon' OR species='palemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baliochila' AND (junior_species='lipara' OR junior_species='lipara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baliochila' AND (species='lipara' OR species='lipara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baliochila' AND (species='lipara' OR species='lipara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baliochila' AND (junior_species='lipara' OR junior_species='lipara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Baliochila' AND (species='lipara' OR species='lipara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='aurota' OR junior_species='aurota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='aurota' OR species='aurota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='aurota' OR species='aurota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='aurota' OR junior_species='aurota')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='aurota' OR species='aurota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='crawshayi' OR junior_species='crawshayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='crawshayi' OR species='crawshayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='crawshayi' OR species='crawshayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='crawshayi' OR junior_species='crawshayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='crawshayi' OR species='crawshayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='creona' OR junior_species='creona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='creona' OR species='creona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='creona' OR species='creona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='creona' OR junior_species='creona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='creona' OR species='creona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='subeida' OR junior_species='subeida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='subeida' OR species='subeida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='subeida' OR species='subeida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='subeida' OR junior_species='subeida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='subeida' OR species='subeida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='thysa' OR junior_species='thysa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='thysa' OR species='thysa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='thysa' OR species='thysa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='thysa' OR junior_species='thysa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='thysa' OR species='thysa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='zochalia' OR junior_species='zochalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Belenois' AND (species='zochalia' OR species='zochalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Belenois' AND (species='zochalia' OR species='zochalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Belenois' AND (junior_species='zochalia' OR junior_species='zochalia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Belenois' AND (species='zochalia' OR species='zochalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='florella' OR species='florella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='florella' OR species='florella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsilia' AND (species='florella' OR species='florella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='electo' OR junior_species='electo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='electo' OR species='electo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='electo' OR species='electo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='electo' OR junior_species='electo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colias' AND (species='electo' OR species='electo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='antevippe' OR junior_species='antevippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='antevippe' OR species='antevippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='antevippe' OR species='antevippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='antevippe' OR junior_species='antevippe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='antevippe' OR species='antevippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='aurigineus' OR junior_species='aurigineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='aurigineus' OR species='aurigineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='aurigineus' OR species='aurigineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='aurigineus' OR junior_species='aurigineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='aurigineus' OR species='aurigineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='daira' OR junior_species='daira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='daira' OR species='daira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='daira' OR species='daira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='daira' OR junior_species='daira')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='daira' OR species='daira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='danae' OR junior_species='danae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='danae' OR species='danae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='danae' OR species='danae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='danae' OR junior_species='danae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='danae' OR species='danae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='euippe' OR junior_species='euippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='euippe' OR species='euippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='euippe' OR species='euippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='euippe' OR junior_species='euippe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='euippe' OR species='euippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='evagore' OR junior_species='evagore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='evagore' OR species='evagore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='evagore' OR species='evagore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='evagore' OR junior_species='evagore')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='evagore' OR species='evagore') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='hetaera' OR junior_species='hetaera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='hetaera' OR species='hetaera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='hetaera' OR species='hetaera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='hetaera' OR junior_species='hetaera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='hetaera' OR species='hetaera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='rogersi' OR junior_species='rogersii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotis' AND (species='rogersi' OR species='rogersii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotis' AND (species='rogersi' OR species='rogersii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotis' AND (junior_species='rogersi' OR junior_species='rogersii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotis' AND (species='rogersi' OR species='rogersii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dixeia' AND (junior_species='orbona' OR junior_species='orbona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dixeia' AND (species='orbona' OR species='orbona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dixeia' AND (species='orbona' OR species='orbona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dixeia' AND (junior_species='orbona' OR junior_species='orbona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dixeia' AND (species='orbona' OR species='orbona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='brigitta' OR junior_species='brigitta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='brigitta' OR species='brigitta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='brigitta' OR species='brigitta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='brigitta' OR junior_species='brigitta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='brigitta' OR species='brigitta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='desjardinsi' OR junior_species='desjardinsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='desjardinsi' OR species='desjardinsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='desjardinsi' OR species='desjardinsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='desjardinsi' OR junior_species='desjardinsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='desjardinsi' OR species='desjardinsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='alcesta' OR junior_species='alcesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='alcesta' OR species='alcesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='alcesta' OR species='alcesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='alcesta' OR junior_species='alcesta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptosia' AND (species='alcesta' OR species='alcesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylothris' AND (junior_species='agathina' OR junior_species='agathina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mylothris' AND (species='agathina' OR species='agathina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mylothris' AND (species='agathina' OR species='agathina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylothris' AND (junior_species='agathina' OR junior_species='agathina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mylothris' AND (species='agathina' OR species='agathina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinacopteryx' AND (junior_species='eriphia' OR junior_species='eriphia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinacopteryx' AND (species='eriphia' OR species='eriphia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pinacopteryx' AND (species='eriphia' OR species='eriphia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinacopteryx' AND (junior_species='eriphia' OR junior_species='eriphia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pinacopteryx' AND (species='eriphia' OR species='eriphia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='helice' OR junior_species='helice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pontia' AND (species='helice' OR species='helice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pontia' AND (species='helice' OR species='helice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='helice' OR junior_species='helice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pontia' AND (species='helice' OR species='helice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borbo' AND (species='borbonica' OR species='borbonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borbo' AND (species='borbonica' OR species='borbonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borbo' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Borbo' AND (species='borbonica' OR species='borbonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='anchises' OR junior_species='anchises')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliades' AND (species='anchises' OR species='anchises') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliades' AND (species='anchises' OR species='anchises')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliades' AND (junior_species='anchises' OR junior_species='anchises')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coeliades' AND (species='anchises' OR species='anchises') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coliades' AND (junior_species='pisistratus' OR junior_species='pisistratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coliades' AND (species='pisistratus' OR species='pisistratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coliades' AND (species='pisistratus' OR species='pisistratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coliades' AND (junior_species='pisistratus' OR junior_species='pisistratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coliades' AND (species='pisistratus' OR species='pisistratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erestis' AND (junior_species='umbra' OR junior_species='umbra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erestis' AND (species='umbra' OR species='umbra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erestis' AND (species='umbra' OR species='umbra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erestis' AND (junior_species='umbra' OR junior_species='umbra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erestis' AND (species='umbra' OR species='umbra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gegenes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gegenes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gegenes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gegenes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gegenes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metisella' 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='Metisella' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metisella' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metisella' 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='Metisella' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metisella' AND (junior_species='quadrisignatus' OR junior_species='quadrisignatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metisella' AND (species='quadrisignatus' OR species='quadrisignatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metisella' AND (species='quadrisignatus' OR species='quadrisignatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metisella' AND (junior_species='quadrisignatus' OR junior_species='quadrisignatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Metisella' AND (species='quadrisignatus' OR species='quadrisignatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarangesa' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarangesa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarangesa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarangesa' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sarangesa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='colotes' OR junior_species='colotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spialia' AND (species='colotes' OR species='colotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spialia' AND (species='colotes' OR species='colotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='colotes' OR junior_species='colotes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spialia' AND (species='colotes' OR species='colotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='dromus' OR junior_species='dromus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spialia' AND (species='dromus' OR species='dromus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spialia' AND (species='dromus' OR species='dromus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='dromus' OR junior_species='dromus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spialia' AND (species='dromus' OR species='dromus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='spio' OR junior_species='spio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spialia' AND (species='spio' OR species='spio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spialia' AND (species='spio' OR species='spio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='spio' OR junior_species='spio')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spialia' AND (species='spio' OR species='spio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='wrefordi' OR junior_species='wrefordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spialia' AND (species='wrefordi' OR species='wrefordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spialia' AND (species='wrefordi' OR species='wrefordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='wrefordi' OR junior_species='wrefordii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spialia' AND (species='wrefordi' OR species='wrefordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zezonia' AND (junior_species='zeno' OR junior_species='zeno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zezonia' AND (species='zeno' OR species='zeno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zezonia' AND (species='zeno' OR species='zeno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zezonia' AND (junior_species='zeno' OR junior_species='zeno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zezonia' AND (species='zeno' OR species='zeno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='diomus' OR junior_species='diomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spialia' AND (species='diomus' OR species='diomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spialia' AND (species='diomus' OR species='diomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spialia' AND (junior_species='diomus' OR junior_species='diomus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spialia' AND (species='diomus' OR species='diomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bromius' OR junior_species='bromius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='bromius' OR species='bromius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='bromius' OR species='bromius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='bromius' OR junior_species='bromius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='bromius' OR species='bromius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demodocus' OR junior_species='demodocus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='demodocus' OR species='demodocus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='demodocus' OR species='demodocus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demodocus' OR junior_species='demodocus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='demodocus' OR species='demodocus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='dardanus' OR junior_species='dardanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='dardanus' OR species='dardanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='dardanus' OR species='dardanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='dardanus' OR junior_species='dardanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='dardanus' OR species='dardanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='jacksoni' OR junior_species='jacksonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='jacksoni' OR species='jacksonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='jacksoni' OR species='jacksonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='jacksoni' OR junior_species='jacksonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='jacksoni' OR species='jacksonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='phorcas' OR junior_species='phorcas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='phorcas' OR species='phorcas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='phorcas' OR species='phorcas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='phorcas' OR junior_species='phorcas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='phorcas' OR species='phorcas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='echerioides' OR junior_species='echerioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='echerioides' OR species='echerioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='echerioides' OR species='echerioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='echerioides' OR junior_species='echerioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='echerioides' OR species='echerioides') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1181 The Ecological Register: Mkogodo Forests
Mkogodo Forests
Basic information
Sample name: Mkogodo Forests

Reference: C. N. Lange and J. Mugambi. 2006. The butterflies of Mkogodo forests, Kenya. African Journal of Ecology 44:286-289 [ER 832]
Geography
Country: Kenya


Coordinate: 0° 5' N, 36° 40' E
Coordinate basis: based on political unit

Geography comments: "Laikipia district" (coordinate based on Laikipia County)

Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

MAT: 24.0

MAP: 637.0

Habitat comments: "dry land" habitat with many "savannah" butterflies
climate data are for Laikipia East District and are based on Huho et al. (2012)

Methods
Life forms: butterflies

Sites: 3

Site area: 30

Sampling methods: sweep nets

Sample size: 888 individuals

Years: 2004

Sampling comments: "sweep-netting" in "10 blocks of 100 x 100 m" in each of three forest fragments; number of netting days is not indicated

Metadata
Sample number: 1181

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-10-01 16:02:40

Modified: 2014-10-01 06:02:40

Abundance distribution
97 species
24 singletons
total count 888
extrapolated richness: 160.6
Fisher's α: 27.739
geometric series k: 0.9611
Hurlbert's PIE: 0.9766
Shannon's H: 4.0275
Good's u: 0.9730
Each square represents a species. Square sizes are proportional to counts.
Register
Acraea aganice1
Acraea alicia1
Acraea encedon2
Acraea esebria23
Acraea rahira1
Bicyclus campus1
Bicyclus safitza12
Byblia anvatara2
Catacroptera cloanthe1
Charaxes brutus1
Charaxes candiope31
Charaxes ethalion kikuyuensis1
Charaxes zoolina12
Danaus chrysippus11
Eurytela dryope7
Eurytela hiarbas lita3
Hamanumida daedalus1
Henotesia perspicua7
Junonia oenone7
Junonia hierta19
Junonia natalica1
Junonia orithya14
Junonia terea13
Melanitis leda18
Neocoenyra gregorii4
Neptis saclava marpessa20
Precis limnoria taveta1
Precis tugela15
Salamis parhassus4
Sallya morantii1
Acraea jodutta6
Acraea acerata3
Actizera stellata29
Alaena picata2
Axiocerses harpax ugandana2
Azanus jesous2
Azanus natalensis1
Azanus ubaldus1
Cacyreus virilis2
Deudorix antalus39
Eicochrysops nandianus6
Euchrysops subpallida6
Freyeria trochylus19
Lepidochrysops neonegus4
Lepidochrysops pterou2
Leptotes pirithous14
Zizina antanossa26
Zizula hylax9
Euchrysops malathana5
Euchrysops osiris4
Anthene butleri4
Cacyreus palemon2
Baliochila lipara10
Belenois aurota30
Belenois crawshayi2
Belenois creona severina24
Belenois subeida30
Belenois thysa5
Belenois zochalia agrippinides8
Catopsilia florella35
Colias electo pseudohecate29
Colotis antevippe6
Colotis aurigineus45
Colotis daira2
Colotis danae1
Colotis euippe3
Colotis evagore2
Colotis hetaera10
Colotis rogersi1
Dixeia orbona9
Eurema brigitta25
Eurema desjardinsi1
Eurema hecabe28
Leptosia alcesta13
Mylothris agathina7
Pinacopteryx eriphia2
Pontia helice1
Borbo borbonica2
Coeliades anchises4
Coliades pisistratus9
Erestis umbra2
Gegenes sp.4
Metisella orientalis3
Metisella quadrisignatus18
Sarangesa sp.1
Spialia colotes8
Spialia dromus1
Spialia spio1
Spialia wrefordi1
Zezonia zeno25
Spialia diomus3
Papilio bromius1
Papilio demodocus11
Papilio dardanus polytropus29
Papilio jacksoni jacksoni1
Papilio phorcas11
Papilio echerioides1