Coordinate: 31° 5' N, 79° 5' E
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=1675 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1675SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1149SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1675 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choaspes' AND (junior_species='benjaminii' OR junior_species='benjamini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choaspes' AND (species='benjaminii' OR species='benjamini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Choaspes' AND (species='benjaminii' OR species='benjamini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choaspes' AND (junior_species='benjaminii' OR junior_species='benjamini')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Choaspes' AND (species='benjaminii' OR species='benjamini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='litigiosa' OR junior_species='litigiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tagiades' AND (species='litigiosa' OR species='litigiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tagiades' AND (species='litigiosa' OR species='litigiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tagiades' AND (junior_species='litigiosa' OR junior_species='litigiosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tagiades' AND (species='litigiosa' OR species='litigiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='hardwickii' OR junior_species='hardwicki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnassius' AND (species='hardwickii' OR species='hardwicki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnassius' AND (species='hardwickii' OR species='hardwicki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='hardwickii' OR junior_species='hardwicki')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parnassius' AND (species='hardwickii' OR species='hardwicki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnassius' AND (species='epaphus' OR species='epaphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnassius' AND (species='epaphus' OR species='epaphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parnassius' AND (species='epaphus' OR species='epaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='machaon' OR junior_species='machaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='machaon' OR species='machaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='machaon' OR species='machaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='machaon' OR junior_species='machaon')SELECT d.diet,d.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='machaon' OR species='machaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonopteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonopteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonopteryx' AND (species='rhamni' OR species='rhamnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonopteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gonopteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pomona' OR junior_species='pomona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsila' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsila' AND (species='pomona' OR species='pomona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsila' AND (junior_species='pomona' OR junior_species='pomona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsila' AND (species='pomona' OR species='pomona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='fieldii' OR junior_species='fieldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='fieldii' OR species='fieldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='fieldii' OR species='fieldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='fieldii' OR junior_species='fieldi')SELECT d.diet,d.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='fieldii' OR species='fieldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='brassicae' OR species='brassicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='canidia' OR species='canidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='canidia' OR species='canidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pieris' AND (species='canidia' OR species='canidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='daplidice' OR junior_species='daplidice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pontia' AND (species='daplidice' OR species='daplidice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pontia' AND (species='daplidice' OR species='daplidice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='daplidice' OR junior_species='daplidice')SELECT d.diet,d.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='daplidice' OR species='daplidice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belladonna' OR junior_species='belladonna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='belladonna' OR species='belladonna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='belladonna' OR species='belladonna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belladonna' OR junior_species='belladonna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='belladonna' OR species='belladonna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Esakiozephyrus' AND (junior_species='mandara' OR junior_species='mandara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Esakiozephyrus' AND (species='mandara' OR species='mandara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Esakiozephyrus' AND (species='mandara' OR species='mandara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Esakiozephyrus' AND (junior_species='mandara' OR junior_species='mandara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Esakiozephyrus' AND (species='mandara' OR species='mandara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spindasis' AND (junior_species='vulcanus' OR junior_species='vulcanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spindasis' AND (species='vulcanus' OR species='vulcanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spindasis' AND (species='vulcanus' OR species='vulcanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spindasis' AND (junior_species='vulcanus' OR junior_species='vulcanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spindasis' AND (species='vulcanus' OR species='vulcanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='phlaeas' OR species='phlaeas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='tamu' OR junior_species='tamu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliophorus' AND (species='tamu' OR species='tamu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliophorus' AND (species='tamu' OR species='tamu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='tamu' OR junior_species='tamu')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliophorus' AND (species='tamu' OR species='tamu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='sena' OR junior_species='sena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliophorus' AND (species='sena' OR species='sena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliophorus' AND (species='sena' OR species='sena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='sena' OR junior_species='sena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliophorus' AND (species='sena' OR species='sena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actyolepis' AND (junior_species='puspa' OR junior_species='puspa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actyolepis' AND (species='puspa' OR species='puspa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actyolepis' AND (species='puspa' OR species='puspa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actyolepis' AND (junior_species='puspa' OR junior_species='puspa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actyolepis' AND (species='puspa' OR species='puspa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='eros' OR junior_species='eros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='eros' OR species='eros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='eros' OR species='eros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='eros' OR junior_species='eros')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyommatus' AND (species='eros' OR species='eros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libythea' AND (species='lepita' OR species='lepita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libythea' AND (species='lepita' OR species='lepita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Libythea' AND (species='lepita' OR species='lepita') 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='Lasiaommata' AND (junior_species='schakra' OR junior_species='schakra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiaommata' AND (species='schakra' OR species='schakra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiaommata' AND (species='schakra' OR species='schakra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiaommata' AND (junior_species='schakra' OR junior_species='schakra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasiaommata' AND (species='schakra' OR species='schakra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocera' AND (junior_species='swaha' OR junior_species='swaha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulocera' AND (species='swaha' OR species='swaha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulocera' AND (species='swaha' OR species='swaha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocera' AND (junior_species='swaha' OR junior_species='swaha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aulocera' AND (species='swaha' OR species='swaha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paralasa' AND (junior_species='mani' OR junior_species='manii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paralasa' AND (species='mani' OR species='manii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paralasa' AND (species='mani' OR species='manii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paralasa' AND (junior_species='mani' OR junior_species='manii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paralasa' AND (species='mani' OR species='manii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fabriciana' AND (junior_species='adippe' OR junior_species='adippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fabriciana' AND (species='adippe' OR species='adippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fabriciana' AND (species='adippe' OR species='adippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fabriciana' AND (junior_species='adippe' OR junior_species='adippe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fabriciana' AND (species='adippe' OR species='adippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Issoria' AND (species='lathonia' OR species='lathonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Issoria' AND (species='lathonia' OR species='lathonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Issoria' AND (species='lathonia' OR species='lathonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='hylas' OR species='hylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT d.diet,d.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='hylas' OR species='hylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='mahendra' OR junior_species='mahendra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='mahendra' OR species='mahendra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='mahendra' OR species='mahendra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='mahendra' OR junior_species='mahendra')SELECT d.diet,d.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='mahendra' OR species='mahendra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hypselis' OR junior_species='hypselis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symbrenthia' AND (species='hypselis' OR species='hypselis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symbrenthia' AND (species='hypselis' OR species='hypselis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hypselis' OR junior_species='hypselis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Symbrenthia' AND (species='hypselis' OR species='hypselis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanessa' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='cashmiriensis' OR junior_species='cashmiriensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglais' AND (species='cashmiriensis' OR species='cashmiriensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglais' AND (species='cashmiriensis' OR species='cashmiriensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='cashmiriensis' OR junior_species='cashmiriensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aglais' AND (species='cashmiriensis' OR species='cashmiriensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='egea' OR junior_species='egea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonia' AND (species='egea' OR species='egea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='egea' OR species='egea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='egea' OR junior_species='egea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polygonia' AND (species='egea' OR species='egea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaniska' AND (junior_species='canace' OR junior_species='canace')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kaniska' AND (species='canace' OR species='canace') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kaniska' AND (species='canace' OR species='canace')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaniska' AND (junior_species='canace' OR junior_species='canace')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kaniska' AND (species='canace' OR species='canace') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1675