Coordinate: -23.1° S, -45.2° W
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=279 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=279SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=119SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=279 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='epinome' OR species='epinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myscelia' AND (species='orsis' OR species='orsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='februa' OR species='februa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='feronia' OR species='feronia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectima' AND (species='thecla' OR species='thecla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temenis' AND (species='laothoe' OR species='laothoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='candrena' OR species='candrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='appias' OR junior_species='appias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='appias' OR species='appias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='appias' OR species='appias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='appias' OR junior_species='appias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='appias' OR species='appias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fountainea' AND (species='ryphea' OR species='ryphea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fountainea' AND (species='ryphea' OR species='ryphea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fountainea' AND (species='ryphea' OR species='ryphea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='otrere' OR junior_species='otrere')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='otrere' OR species='otrere') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='otrere' OR species='otrere')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='otrere' OR junior_species='otrere')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='otrere' OR species='otrere') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zaretis' AND (species='isidora' OR species='isidora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='moruus' OR species='moruus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobura' AND (species='dirce' OR species='dirce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='syme' OR junior_species='syme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opoptera' AND (species='syme' OR species='syme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opoptera' AND (species='syme' OR species='syme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='syme' OR junior_species='syme')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opoptera' AND (species='syme' OR species='syme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eryphanis' AND (species='reevesi' OR species='reevesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eryphanis' AND (species='reevesi' OR species='reevesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryphanis' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eryphanis' AND (species='reevesi' OR species='reevesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyophthalma' AND (junior_species='creusa' OR junior_species='creusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyophthalma' AND (species='creusa' OR species='creusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyophthalma' AND (species='creusa' OR species='creusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyophthalma' AND (junior_species='creusa' OR junior_species='creusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dasyophthalma' AND (species='creusa' OR species='creusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='arisbe' OR junior_species='arisbe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='arisbe' OR species='arisbe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='arisbe' OR species='arisbe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='arisbe' OR junior_species='arisbe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caligo' AND (species='arisbe' OR species='arisbe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narope' AND (junior_species='cyllene' OR junior_species='cyllene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Narope' AND (species='cyllene' OR species='cyllene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Narope' AND (species='cyllene' OR species='cyllene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narope' AND (junior_species='cyllene' OR junior_species='cyllene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Narope' AND (species='cyllene' OR species='cyllene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='aorsa' OR junior_species='aorsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opoptera' AND (species='aorsa' OR species='aorsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opoptera' AND (species='aorsa' OR species='aorsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opoptera' AND (junior_species='aorsa' OR junior_species='aorsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opoptera' AND (species='aorsa' OR species='aorsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='helenor' OR species='helenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Godartiana' AND (species='muscosa' OR species='muscosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='soter' OR junior_species='soter')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='soter' OR species='soter') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='soter' OR species='soter')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='soter' OR junior_species='soter')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='soter' OR species='soter') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='quantius' OR species='quantius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='hermes' OR species='hermes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='doxes' OR junior_species='doxes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='doxes' OR species='doxes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='doxes' OR species='doxes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='doxes' OR junior_species='doxes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Splendeuptychia' AND (species='doxes' OR species='doxes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='castrensis' OR junior_species='castrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychoides' AND (species='castrensis' OR species='castrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychoides' AND (species='castrensis' OR species='castrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='castrensis' OR junior_species='castrensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euptychoides' AND (species='castrensis' OR species='castrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='phronius' OR species='phronius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='necys' OR species='necys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='ochracea' OR species='ochracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='ochracea' OR species='ochracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='griseldis' OR species='griseldis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='paeon' OR species='paeon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='paeon' OR junior_species='paeon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='paeon' OR species='paeon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='ypthima' OR species='ypthima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='borasta' OR junior_species='borasta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='borasta' OR species='borasta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='borasta' OR species='borasta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='borasta' OR junior_species='borasta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='borasta' OR species='borasta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='grimon' OR species='grimon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='acuta' OR junior_species='acuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='acuta' OR species='acuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='acuta' OR species='acuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='acuta' OR junior_species='acuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='acuta' OR species='acuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='laches' OR junior_species='laches')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='laches' OR species='laches') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='laches' OR species='laches')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='laches' OR junior_species='laches')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='laches' OR species='laches') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eteona' AND (species='tisiphone' OR species='tisiphone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praepedaliodes' AND (species='phanias' OR species='phanias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zischkaia' AND (junior_species='pacarus' OR junior_species='pacarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zischkaia' AND (species='pacarus' OR species='pacarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zischkaia' AND (species='pacarus' OR species='pacarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zischkaia' AND (junior_species='pacarus' OR junior_species='pacarus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zischkaia' AND (species='pacarus' OR species='pacarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=279