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=276 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=276SELECT 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=276 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='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='orea' OR species='orea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='hubneri' OR species='hubnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='fornax' OR species='fornax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='fornax' OR species='fornax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT d.diet,d.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='fornax' OR species='fornax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='numilia' OR species='numilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='numilia' OR species='numilia') 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='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='pygas' OR species='pygas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='pygas' OR species='pygas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='pygas' OR species='pygas') 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='Archaeoprepona' AND (junior_species='chalciope' OR junior_species='chalciope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='chalciope' OR junior_species='chalciope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='chalciope' OR species='chalciope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='demophon' OR species='demophon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='demophon' OR species='demophon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='demophon' OR species='demophon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophoon' OR junior_species='demophoon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophoon' OR junior_species='demophoon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon') 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='Dasyophthalma' AND (junior_species='rusina' OR junior_species='rusina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyophthalma' AND (species='rusina' OR species='rusina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyophthalma' AND (species='rusina' OR species='rusina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyophthalma' AND (junior_species='rusina' OR junior_species='rusina')SELECT d.diet,d.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='rusina' OR species='rusina') 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='Morpho' AND (junior_species='aega' OR junior_species='aega')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='aega' OR species='aega') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='aega' OR species='aega')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='aega' OR junior_species='aega')SELECT d.diet,d.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='aega' OR species='aega') 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='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='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='Pharneuptychia' 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='Pharneuptychia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pharneuptychia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pharneuptychia' 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='Pharneuptychia' AND (species='sp.' OR species='sp.') 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='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='Splendeuptychia' AND (junior_species='hygina' OR junior_species='hygina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='hygina' OR species='hygina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='hygina' OR species='hygina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='hygina' OR junior_species='hygina')SELECT d.diet,d.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='hygina' OR species='hygina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='ernestina' OR junior_species='ernestina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychia' AND (species='ernestina' OR species='ernestina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychia' AND (species='ernestina' OR species='ernestina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='ernestina' OR junior_species='ernestina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euptychia' AND (species='ernestina' OR species='ernestina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=276