Coordinate: 6° 9' N, 75° 41' W
coordinate is the midpoint of ranges stated in text
elevation 2500 to 2900 m
CMT and WMT based on station 80112 (Medellin)
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=1162 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1162SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=813SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1162 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entheus' AND (junior_species='matho' OR junior_species='matho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entheus' AND (species='matho' OR species='matho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entheus' AND (species='matho' OR species='matho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entheus' AND (junior_species='matho' OR junior_species='matho')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Entheus' AND (species='matho' OR species='matho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wahydra' 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='Wahydra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wahydra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wahydra' 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='Wahydra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wahydra' 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='Wahydra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wahydra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wahydra' 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='Wahydra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zalomes' AND (junior_species='biforis' OR junior_species='biforis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zalomes' AND (species='biforis' OR species='biforis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zalomes' AND (species='biforis' OR species='biforis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zalomes' AND (junior_species='biforis' OR junior_species='biforis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zalomes' AND (species='biforis' OR species='biforis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoralis' AND (junior_species='degener' OR junior_species='degener')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psoralis' AND (species='degener' OR species='degener') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psoralis' AND (species='degener' OR species='degener')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoralis' AND (junior_species='degener' OR junior_species='degener')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psoralis' AND (species='degener' OR species='degener') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' AND (junior_species='hesperioides' OR junior_species='hesperioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dalla' AND (species='hesperioides' OR species='hesperioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dalla' AND (species='hesperioides' OR species='hesperioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' AND (junior_species='hesperioides' OR junior_species='hesperioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dalla' AND (species='hesperioides' OR species='hesperioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' 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='Dalla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dalla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' 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='Dalla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' 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='Dalla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dalla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalla' 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='Dalla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperocharis' AND (junior_species='marchalii' OR junior_species='marchali')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperocharis' AND (species='marchalii' OR species='marchali') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperocharis' AND (species='marchalii' OR species='marchali')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperocharis' AND (junior_species='marchalii' OR junior_species='marchali')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hesperocharis' AND (species='marchalii' OR species='marchali') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leodonta' AND (junior_species='tagaste' OR junior_species='tagaste')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leodonta' AND (species='tagaste' OR species='tagaste') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leodonta' AND (species='tagaste' OR species='tagaste')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leodonta' AND (junior_species='tagaste' OR junior_species='tagaste')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leodonta' AND (species='tagaste' OR species='tagaste') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='aripa' OR junior_species='aripa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophobia' AND (species='aripa' OR species='aripa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophobia' AND (species='aripa' OR species='aripa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='aripa' OR junior_species='aripa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophobia' AND (species='aripa' OR species='aripa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='eleusis' OR junior_species='eleusis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophobia' AND (species='eleusis' OR species='eleusis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophobia' AND (species='eleusis' OR species='eleusis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='eleusis' OR junior_species='eleusis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophobia' AND (species='eleusis' OR species='eleusis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='helena' OR junior_species='helena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophobia' AND (species='helena' OR species='helena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophobia' AND (species='helena' OR species='helena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='helena' OR junior_species='helena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophobia' AND (species='helena' OR species='helena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='penthica' OR junior_species='penthica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophobia' AND (species='penthica' OR species='penthica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophobia' AND (species='penthica' OR species='penthica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='penthica' OR junior_species='penthica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophobia' AND (species='penthica' OR species='penthica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='cordillerensis' OR junior_species='cordillerensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesosemia' AND (species='cordillerensis' OR species='cordillerensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesosemia' AND (species='cordillerensis' OR species='cordillerensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='cordillerensis' OR junior_species='cordillerensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesosemia' AND (species='cordillerensis' OR species='cordillerensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='mevania' OR junior_species='mevania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesosemia' AND (species='mevania' OR species='mevania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesosemia' AND (species='mevania' OR species='mevania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='mevania' OR junior_species='mevania')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesosemia' AND (species='mevania' OR species='mevania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Johnsonita' AND (junior_species='auda' OR junior_species='auda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Johnsonita' AND (species='auda' OR species='auda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Johnsonita' AND (species='auda' OR species='auda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Johnsonita' AND (junior_species='auda' OR junior_species='auda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Johnsonita' AND (species='auda' OR species='auda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Johnsonita' AND (junior_species='pardoa' OR junior_species='pardoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Johnsonita' AND (species='pardoa' OR species='pardoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Johnsonita' AND (species='pardoa' OR species='pardoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Johnsonita' AND (junior_species='pardoa' OR junior_species='pardoa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Johnsonita' AND (species='pardoa' OR species='pardoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micandra' AND (junior_species='aegides' OR junior_species='aegides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micandra' AND (species='aegides' OR species='aegides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micandra' AND (species='aegides' OR species='aegides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micandra' AND (junior_species='aegides' OR junior_species='aegides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micandra' AND (species='aegides' OR species='aegides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penaincisalia' AND (junior_species='loxurina' OR junior_species='loxurina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penaincisalia' AND (species='loxurina' OR species='loxurina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Penaincisalia' AND (species='loxurina' OR species='loxurina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penaincisalia' AND (junior_species='loxurina' OR junior_species='loxurina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Penaincisalia' AND (species='loxurina' OR species='loxurina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='veia' OR junior_species='veia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronymia' AND (species='veia' OR species='veia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pteronymia' AND (species='veia' OR species='veia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='veia' OR junior_species='veia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pteronymia' AND (species='veia' OR species='veia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patricia' AND (junior_species='dercyllidas' OR junior_species='dercyllidas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patricia' AND (species='dercyllidas' OR species='dercyllidas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patricia' AND (species='dercyllidas' OR species='dercyllidas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patricia' AND (junior_species='dercyllidas' OR junior_species='dercyllidas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Patricia' AND (species='dercyllidas' OR species='dercyllidas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oleria' AND (junior_species='makrena' OR junior_species='makrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oleria' AND (species='makrena' OR species='makrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oleria' AND (species='makrena' OR species='makrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oleria' AND (junior_species='makrena' OR junior_species='makrena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oleria' AND (species='makrena' OR species='makrena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oleria' 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='Oleria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oleria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oleria' 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='Oleria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='eresia' OR junior_species='eresia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Altinote' AND (species='eresia' OR species='eresia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Altinote' AND (species='eresia' OR species='eresia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='eresia' OR junior_species='eresia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Altinote' AND (species='eresia' OR species='eresia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='ozomene' OR junior_species='ozomene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Altinote' AND (species='ozomene' OR species='ozomene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Altinote' AND (species='ozomene' OR species='ozomene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='ozomene' OR junior_species='ozomene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Altinote' AND (species='ozomene' OR species='ozomene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='trinacria' OR junior_species='trinacria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Altinote' AND (species='trinacria' OR species='trinacria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Altinote' AND (species='trinacria' OR species='trinacria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='trinacria' OR junior_species='trinacria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Altinote' AND (species='trinacria' OR species='trinacria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='clysonymus' OR junior_species='clysonymus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='clysonymus' OR species='clysonymus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='clysonymus' OR species='clysonymus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='clysonymus' OR junior_species='clysonymus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliconius' AND (species='clysonymus' OR species='clysonymus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='epimenes' OR junior_species='epimenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='epimenes' OR species='epimenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='epimenes' OR species='epimenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='epimenes' OR junior_species='epimenes')SELECT d.diet,d.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='epimenes' OR species='epimenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='corcyra' OR junior_species='corcyra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='corcyra' OR species='corcyra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='corcyra' OR species='corcyra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='corcyra' OR junior_species='corcyra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='corcyra' OR species='corcyra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='polina' OR junior_species='polina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='polina' OR species='polina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='polina' OR species='polina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='polina' OR junior_species='polina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eresia' AND (species='polina' OR species='polina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='kefersteini' OR junior_species='kefersteinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='kefersteini' OR species='kefersteinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='kefersteini' OR species='kefersteinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='kefersteini' OR junior_species='kefersteinii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypanartia' AND (species='kefersteini' OR species='kefersteinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT d.diet,d.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='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='sulkowskyi' OR junior_species='sulkowskyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='sulkowskyi' OR species='sulkowskyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='sulkowskyi' OR species='sulkowskyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='sulkowskyi' OR junior_species='sulkowskyii')SELECT d.diet,d.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='sulkowskyi' OR species='sulkowskyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='griphe' OR junior_species='griphe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychoides' AND (species='griphe' OR species='griphe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychoides' AND (species='griphe' OR species='griphe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychoides' AND (junior_species='griphe' OR junior_species='griphe')SELECT d.diet,d.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='griphe' OR species='griphe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='rustica' OR junior_species='rustica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='harmonia' OR junior_species='harmonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='harmonia' OR species='harmonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='harmonia' OR species='harmonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='harmonia' OR junior_species='harmonia')SELECT d.diet,d.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='harmonia' OR species='harmonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='chelonis' OR junior_species='chelonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corades' AND (species='chelonis' OR species='chelonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corades' AND (species='chelonis' OR species='chelonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='chelonis' OR junior_species='chelonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corades' AND (species='chelonis' OR species='chelonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='chirone' OR junior_species='chirone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corades' AND (species='chirone' OR species='chirone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corades' AND (species='chirone' OR species='chirone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='chirone' OR junior_species='chirone')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corades' AND (species='chirone' OR species='chirone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='cybele' OR junior_species='cybele')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corades' AND (species='cybele' OR species='cybele') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corades' AND (species='cybele' OR species='cybele')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='cybele' OR junior_species='cybele')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corades' AND (species='cybele' OR species='cybele') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='medeba' OR junior_species='medeba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corades' AND (species='medeba' OR species='medeba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corades' AND (species='medeba' OR species='medeba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corades' AND (junior_species='medeba' OR junior_species='medeba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corades' AND (species='medeba' OR species='medeba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daedalma' AND (junior_species='dinias' OR junior_species='dinias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Daedalma' AND (species='dinias' OR species='dinias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Daedalma' AND (species='dinias' OR species='dinias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daedalma' AND (junior_species='dinias' OR junior_species='dinias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Daedalma' AND (species='dinias' OR species='dinias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='apuleja' OR junior_species='apuleja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eretris' AND (species='apuleja' OR species='apuleja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eretris' AND (species='apuleja' OR species='apuleja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='apuleja' OR junior_species='apuleja')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eretris' AND (species='apuleja' OR species='apuleja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='ocellifera' OR junior_species='ocellifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eretris' AND (species='ocellifera' OR species='ocellifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eretris' AND (species='ocellifera' OR species='ocellifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='ocellifera' OR junior_species='ocellifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eretris' AND (species='ocellifera' OR species='ocellifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='porphyria' OR junior_species='porphyria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eretris' AND (species='porphyria' OR species='porphyria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eretris' AND (species='porphyria' OR species='porphyria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eretris' AND (junior_species='porphyria' OR junior_species='porphyria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eretris' AND (species='porphyria' OR species='porphyria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junea' AND (junior_species='dorinda' OR junior_species='dorinda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junea' AND (species='dorinda' OR species='dorinda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junea' AND (species='dorinda' OR species='dorinda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junea' AND (junior_species='dorinda' OR junior_species='dorinda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junea' AND (species='dorinda' OR species='dorinda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiophila' AND (junior_species='prosymna' OR junior_species='prosymna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiophila' AND (species='prosymna' OR species='prosymna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiophila' AND (species='prosymna' OR species='prosymna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiophila' AND (junior_species='prosymna' OR junior_species='prosymna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasiophila' AND (species='prosymna' OR species='prosymna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiophila' AND (junior_species='zapatoza' OR junior_species='zapatoza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiophila' AND (species='zapatoza' OR species='zapatoza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiophila' AND (species='zapatoza' OR species='zapatoza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiophila' AND (junior_species='zapatoza' OR junior_species='zapatoza')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasiophila' AND (species='zapatoza' OR species='zapatoza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='alboncincta' OR junior_species='alboncincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lymanopoda' AND (species='alboncincta' OR species='alboncincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lymanopoda' AND (species='alboncincta' OR species='alboncincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='alboncincta' OR junior_species='alboncincta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lymanopoda' AND (species='alboncincta' OR species='alboncincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='labda' OR junior_species='labda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lymanopoda' AND (species='labda' OR species='labda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lymanopoda' AND (species='labda' OR species='labda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='labda' OR junior_species='labda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lymanopoda' AND (species='labda' OR species='labda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='obsoleta' OR junior_species='obsoleta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lymanopoda' AND (species='obsoleta' OR species='obsoleta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lymanopoda' AND (species='obsoleta' OR species='obsoleta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymanopoda' AND (junior_species='obsoleta' OR junior_species='obsoleta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lymanopoda' AND (species='obsoleta' OR species='obsoleta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manerebia' AND (junior_species='germaniae' OR junior_species='germaniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manerebia' AND (species='germaniae' OR species='germaniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manerebia' AND (species='germaniae' OR species='germaniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manerebia' AND (junior_species='germaniae' OR junior_species='germaniae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manerebia' AND (species='germaniae' OR species='germaniae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manerebia' AND (junior_species='inderena' OR junior_species='inderena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manerebia' AND (species='inderena' OR species='inderena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manerebia' AND (species='inderena' OR species='inderena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manerebia' AND (junior_species='inderena' OR junior_species='inderena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manerebia' AND (species='inderena' OR species='inderena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mygona' AND (junior_species='irmina' OR junior_species='irmina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mygona' AND (species='irmina' OR species='irmina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mygona' AND (species='irmina' OR species='irmina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mygona' AND (junior_species='irmina' OR junior_species='irmina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mygona' AND (species='irmina' OR species='irmina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panyapedaliodes' AND (junior_species='drymaea' OR junior_species='drymaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panyapedaliodes' AND (species='drymaea' OR species='drymaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panyapedaliodes' AND (species='drymaea' OR species='drymaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panyapedaliodes' AND (junior_species='drymaea' OR junior_species='drymaea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panyapedaliodes' AND (species='drymaea' OR species='drymaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panyapedaliodes' AND (junior_species='jephtha' OR junior_species='jephtha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panyapedaliodes' AND (species='jephtha' OR species='jephtha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panyapedaliodes' AND (species='jephtha' OR species='jephtha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panyapedaliodes' AND (junior_species='jephtha' OR junior_species='jephtha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panyapedaliodes' AND (species='jephtha' OR species='jephtha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='baccara' OR junior_species='baccara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='baccara' OR species='baccara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='baccara' OR species='baccara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='baccara' OR junior_species='baccara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='baccara' OR species='baccara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='hebena' OR junior_species='hebena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='hebena' OR species='hebena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='hebena' OR species='hebena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='hebena' OR junior_species='hebena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='hebena' OR species='hebena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='montagna' OR junior_species='montagna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='montagna' OR species='montagna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='montagna' OR species='montagna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='montagna' OR junior_species='montagna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='montagna' OR species='montagna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='rodriguezi' OR junior_species='rodriguezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='rodriguezi' OR species='rodriguezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='rodriguezi' OR species='rodriguezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='rodriguezi' OR junior_species='rodriguezii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='rodriguezi' OR species='rodriguezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='obstructa' OR junior_species='obstructa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='obstructa' OR species='obstructa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='obstructa' OR species='obstructa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='obstructa' OR junior_species='obstructa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='obstructa' OR species='obstructa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='peucestas' OR junior_species='peucestas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='peucestas' OR species='peucestas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='peucestas' OR species='peucestas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='peucestas' OR junior_species='peucestas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='peucestas' OR species='peucestas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='phrasicla' OR junior_species='phrasicla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='phrasicla' OR species='phrasicla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='phrasicla' OR species='phrasicla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='phrasicla' OR junior_species='phrasicla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='phrasicla' OR species='phrasicla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='pisonia' OR junior_species='pisonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='pisonia' OR species='pisonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='pisonia' OR species='pisonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='pisonia' OR junior_species='pisonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='pisonia' OR species='pisonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='poesia' OR junior_species='poesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='poesia' OR species='poesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='poesia' OR species='poesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='poesia' OR junior_species='poesia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='poesia' OR species='poesia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='pollonia' OR junior_species='pollonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='pollonia' OR species='pollonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='pollonia' OR species='pollonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='pollonia' OR junior_species='pollonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='pollonia' OR species='pollonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='praemontagna' OR junior_species='praemontagna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='praemontagna' OR species='praemontagna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='praemontagna' OR species='praemontagna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='praemontagna' OR junior_species='praemontagna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='praemontagna' OR species='praemontagna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='praxithea' OR junior_species='praxithea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='praxithea' OR species='praxithea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='praxithea' OR species='praxithea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='praxithea' OR junior_species='praxithea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='praxithea' OR species='praxithea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='transmontana' OR junior_species='transmontana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='transmontana' OR species='transmontana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='transmontana' OR species='transmontana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='transmontana' OR junior_species='transmontana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='transmontana' OR species='transmontana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='simpla' OR junior_species='simpla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedaliodes' AND (species='simpla' OR species='simpla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedaliodes' AND (species='simpla' OR species='simpla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedaliodes' AND (junior_species='simpla' OR junior_species='simpla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pedaliodes' AND (species='simpla' OR species='simpla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proboscis' AND (junior_species='propylea' OR junior_species='propylea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proboscis' AND (species='propylea' OR species='propylea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proboscis' AND (species='propylea' OR species='propylea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proboscis' AND (junior_species='propylea' OR junior_species='propylea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Proboscis' AND (species='propylea' OR species='propylea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronophila' AND (junior_species='epidipnis' OR junior_species='epidipnis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pronophila' AND (species='epidipnis' OR species='epidipnis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pronophila' AND (species='epidipnis' OR species='epidipnis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronophila' AND (junior_species='epidipnis' OR junior_species='epidipnis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pronophila' AND (species='epidipnis' OR species='epidipnis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronophila' AND (junior_species='orcus' OR junior_species='orcus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pronophila' AND (species='orcus' OR species='orcus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pronophila' AND (species='orcus' OR species='orcus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronophila' AND (junior_species='orcus' OR junior_species='orcus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pronophila' AND (species='orcus' OR species='orcus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomaniola' AND (junior_species='loxo' OR junior_species='loxo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomaniola' AND (species='loxo' OR species='loxo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomaniola' AND (species='loxo' OR species='loxo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomaniola' AND (junior_species='loxo' OR junior_species='loxo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudomaniola' AND (species='loxo' OR species='loxo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steroma' AND (junior_species='bega' OR junior_species='bega')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steroma' AND (species='bega' OR species='bega') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steroma' AND (species='bega' OR species='bega')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steroma' AND (junior_species='bega' OR junior_species='bega')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Steroma' AND (species='bega' OR species='bega') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1162