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=1336 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1336SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=891SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1336 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='macar' OR junior_species='macar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rohana' AND (species='macar' OR species='macar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rohana' AND (species='macar' OR species='macar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='macar' OR junior_species='macar')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rohana' AND (species='macar' OR species='macar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='affinis' OR junior_species='affinis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='nitebis' OR junior_species='nitebis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='nitebis' OR species='nitebis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='nitebis' OR species='nitebis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='nitebis' OR junior_species='nitebis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='nitebis' OR species='nitebis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='libnites' OR junior_species='libnites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='libnites' OR species='libnites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='libnites' OR species='libnites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='libnites' OR junior_species='libnites')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Athyma' AND (species='libnites' OR species='libnites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='rahria' OR junior_species='rahria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersonesia' AND (species='rahria' OR species='rahria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersonesia' AND (species='rahria' OR species='rahria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='rahria' OR junior_species='rahria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chersonesia' AND (species='rahria' OR species='rahria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamasia' AND (junior_species='lyncides' OR junior_species='lyncides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamasia' AND (species='lyncides' OR species='lyncides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamasia' AND (species='lyncides' OR species='lyncides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamasia' AND (junior_species='lyncides' OR junior_species='lyncides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lamasia' AND (species='lyncides' OR species='lyncides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='neriphus' OR junior_species='neriphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasippa' AND (species='neriphus' OR species='neriphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasippa' AND (species='neriphus' OR species='neriphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='neriphus' OR junior_species='neriphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasippa' AND (species='neriphus' OR species='neriphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='aeetes' OR junior_species='aeetes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lexias' AND (species='aeetes' OR species='aeetes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lexias' AND (species='aeetes' OR species='aeetes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='aeetes' OR junior_species='aeetes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lexias' AND (species='aeetes' OR species='aeetes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dophla' AND (species='evelina' OR species='evelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tacola' AND (junior_species='eulimene' OR junior_species='eulimene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tacola' AND (species='eulimene' OR species='eulimene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tacola' AND (species='eulimene' OR species='eulimene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tacola' AND (junior_species='eulimene' OR junior_species='eulimene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tacola' AND (species='eulimene' OR species='eulimene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarattia' AND (junior_species='lysanias' OR junior_species='lysanias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tarattia' AND (species='lysanias' OR species='lysanias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tarattia' AND (species='lysanias' OR species='lysanias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarattia' AND (junior_species='lysanias' OR junior_species='lysanias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tarattia' AND (species='lysanias' OR species='lysanias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='virgata' OR junior_species='virgata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amathusia' AND (species='virgata' OR species='virgata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amathusia' AND (species='virgata' OR species='virgata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='virgata' OR junior_species='virgata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amathusia' AND (species='virgata' OR species='virgata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathuxidia' AND (junior_species='plateni' OR junior_species='platenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amathuxidia' AND (species='plateni' OR species='platenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amathuxidia' AND (species='plateni' OR species='platenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathuxidia' AND (junior_species='plateni' OR junior_species='platenii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amathuxidia' AND (species='plateni' OR species='platenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hippalus' OR junior_species='hippalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symbrenthia' AND (species='hippalus' OR species='hippalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symbrenthia' AND (species='hippalus' OR species='hippalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hippalus' OR junior_species='hippalus')SELECT d.diet,d.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='hippalus' OR species='hippalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bletogona' AND (junior_species='mycalesis' OR junior_species='mycalesis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bletogona' AND (species='mycalesis' OR species='mycalesis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bletogona' AND (species='mycalesis' OR species='mycalesis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bletogona' AND (junior_species='mycalesis' OR junior_species='mycalesis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bletogona' AND (species='mycalesis' OR species='mycalesis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='cumaea' OR junior_species='cumaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='cumaea' OR species='cumaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='cumaea' OR species='cumaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='cumaea' OR junior_species='cumaea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymnias' AND (species='cumaea' OR species='cumaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='hicetas' OR junior_species='hicetas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='hicetas' OR species='hicetas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='hicetas' OR species='hicetas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='hicetas' OR junior_species='hicetas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymnias' AND (species='hicetas' OR species='hicetas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='anna' OR junior_species='anna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lohora' AND (species='anna' OR species='anna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lohora' AND (species='anna' OR species='anna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='anna' OR junior_species='anna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lohora' AND (species='anna' OR species='anna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='deianira' OR junior_species='deianira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lohora' AND (species='deianira' OR species='deianira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lohora' AND (species='deianira' OR species='deianira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='deianira' OR junior_species='deianira')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lohora' AND (species='deianira' OR species='deianira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='transiens' OR junior_species='transiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lohora' AND (species='transiens' OR species='transiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lohora' AND (species='transiens' OR species='transiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lohora' AND (junior_species='transiens' OR junior_species='transiens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lohora' AND (species='transiens' OR species='transiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='phedima' OR species='phedima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='pyrrha' OR junior_species='pyrrha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='pyrrha' OR species='pyrrha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='pyrrha' OR species='pyrrha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='pyrrha' OR junior_species='pyrrha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='pyrrha' OR species='pyrrha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='velutina' OR junior_species='velutina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='itys' OR junior_species='itys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='itys' OR species='itys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='itys' OR species='itys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='itys' OR junior_species='itys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='itys' OR species='itys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='janardana' OR junior_species='janardana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='janardana' OR species='janardana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='janardana' OR species='janardana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='janardana' OR junior_species='janardana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='janardana' OR species='janardana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='jopas' OR junior_species='jopas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orsotriaena' AND (species='jopas' OR species='jopas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orsotriaena' AND (species='jopas' OR species='jopas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='jopas' OR junior_species='jopas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orsotriaena' AND (species='jopas' OR species='jopas') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1336 The Ecological Register: Lore Lindu National Park (disturbed forest, 0-1 m)
Lore Lindu National Park (disturbed forest, 0-1 m)
Basic information
Sample name: Lore Lindu National Park (disturbed forest, 0-1 m)

Reference: H. Fermon, M. Waltert, R. I. Vane-Wright, and M. Mühlenberg. 2005. Forest use and vertical stratification in fruit-feeding butterflies of Sulawesi, Indonesia: impacts for conservation. Biodiversity and Conservation 14(2):333-350 [ER 891]
Geography
Country: Indonesia

State: Central Sulawesi


Coordinate: 1° 12' S, 120° 8' E
Coordinate basis: stated in text

Geography comments: "right at the forest margin near Kamarora Field Station"; elevation stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Protection: national/state park

Substrate: ground surface

Disturbance: agriculture

MAT: 24.5

MAP: 970.0

Habitat comments: MAP supposedly "between 2500 and 3500 mm"; climate data based on sample 610
the site was "a mosaic of older small-scale subsistence farms, recently abandoned farms and regenerating secondary forest". Upper and middle forest layers were largely intact... The major crop was coffee, additionally bananas"

Methods
Life forms: butterflies

Sites: 6

Sampling methods: baited

Sample size: 226 individuals

Years: 2001

Days: 44

Nets or traps: 6

Net or trap nights: 264

Sampling comments: traps were "cylindrical gauze-traps (as in DeVries 1987, 1988; cf. Rydon 1964)" and "baited with a standardised mixture of mashed, fermenting bananas" and were installed 0-1 m above ground level; there were two traps per site and they were checked on 44 days

Metadata
Sample number: 1336

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-22 14:34:09

Modified: 2015-07-07 07:05:41

Abundance distribution
28 species
9 singletons
total count 226
extrapolated richness: 55.0
Fisher's α: 8.416
geometric series k: 0.8479
Hurlbert's PIE: 0.8236
Shannon's H: 2.4003
Good's u: 0.9604
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Rohana macar16
Charaxes affinis2
Charaxes nitebis6
Athyma libnites3
Chersonesia rahria2
Lamasia lyncides1
Lasippa neriphus1
Lexias aeetes15
Dophla evelina9
Tacola eulimene8
Tarattia lysanias2
Amathusia virgata1
Amathuxidia plateni1
Symbrenthia hippalus1
Bletogona mycalesis2
Elymnias cumaea1
Elymnias hicetas2
Lohora anna1
Lohora deianira1
Lohora transiens86
Melanitis leda21
Melanitis phedima2
Melanitis pyrrha9
Melanitis velutina7
Mycalesis horsfieldi16
Mycalesis itys3
Mycalesis janardana1
Orsotriaena jopas6