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=439 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=439SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=213SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=439 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='parvus' OR junior_species='parvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ingerophrynus' AND (species='parvus' OR species='parvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ingerophrynus' AND (species='parvus' OR species='parvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='parvus' OR junior_species='parvus')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='Ingerophrynus' AND (species='parvus' OR species='parvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynoidis' AND (junior_species='aspera' OR junior_species='aspera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynoidis' AND (species='aspera' OR species='aspera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynoidis' AND (species='aspera' OR species='aspera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynoidis' AND (junior_species='aspera' OR junior_species='aspera')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='Phrynoidis' AND (species='aspera' OR species='aspera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedostibes' AND (junior_species='hosii' OR junior_species='hosi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedostibes' AND (species='hosii' OR species='hosi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedostibes' AND (species='hosii' OR species='hosi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedostibes' AND (junior_species='hosii' OR junior_species='hosi')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='Pedostibes' AND (species='hosii' OR species='hosi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fejervarya' AND (junior_species='limnocharis' OR junior_species='limnocharis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fejervarya' AND (species='limnocharis' OR species='limnocharis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fejervarya' AND (species='limnocharis' OR species='limnocharis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fejervarya' AND (junior_species='limnocharis' OR junior_species='limnocharis')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='Fejervarya' AND (species='limnocharis' OR species='limnocharis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='blythii' OR junior_species='blythi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodectes' AND (species='blythii' OR species='blythi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodectes' AND (species='blythii' OR species='blythi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='blythii' OR junior_species='blythi')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='Limnodectes' AND (species='blythii' OR species='blythi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='kuhlii' OR junior_species='kuhli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodectes' AND (species='kuhlii' OR species='kuhli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodectes' AND (species='kuhlii' OR species='kuhli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='kuhlii' OR junior_species='kuhli')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='Limnodectes' AND (species='kuhlii' OR species='kuhli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodectes' AND (species='laticeps' OR species='laticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodectes' AND (species='laticeps' OR species='laticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodectes' AND (junior_species='laticeps' OR junior_species='laticeps')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='Limnodectes' AND (species='laticeps' OR species='laticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occidozyga' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occidozyga' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='laevis' OR junior_species='laevis')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='Occidozyga' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='lima' OR junior_species='lima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occidozyga' AND (species='lima' OR species='lima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occidozyga' AND (species='lima' OR species='lima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='lima' OR junior_species='lima')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='Occidozyga' AND (species='lima' OR species='lima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amolops' AND (junior_species='larutensis' OR junior_species='larutensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amolops' AND (species='larutensis' OR species='larutensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amolops' AND (species='larutensis' OR species='larutensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amolops' AND (junior_species='larutensis' OR junior_species='larutensis')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='Amolops' AND (species='larutensis' OR species='larutensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='erythraea' OR junior_species='erythraea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='erythraea' OR species='erythraea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='erythraea' OR species='erythraea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='erythraea' OR junior_species='erythraea')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='Hylarana' AND (species='erythraea' OR species='erythraea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Hylarana' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='labialis' OR junior_species='labialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='labialis' OR species='labialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='labialis' OR species='labialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='labialis' OR junior_species='labialis')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='Hylarana' AND (species='labialis' OR species='labialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='laterimaculata' OR junior_species='laterimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='laterimaculata' OR species='laterimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='laterimaculata' OR species='laterimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='laterimaculata' OR junior_species='laterimaculata')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='Hylarana' AND (species='laterimaculata' OR species='laterimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='picturata' OR junior_species='picturata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='picturata' OR species='picturata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='picturata' OR species='picturata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='picturata' OR junior_species='picturata')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='Hylarana' AND (species='picturata' OR species='picturata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='hosii' OR junior_species='hosi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odorrana' AND (species='hosii' OR species='hosi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odorrana' AND (species='hosii' OR species='hosi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='hosii' OR junior_species='hosi')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='Odorrana' AND (species='hosii' OR species='hosi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobrachium' AND (junior_species='hendricksoni' OR junior_species='hendricksonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptobrachium' AND (species='hendricksoni' OR species='hendricksonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptobrachium' AND (species='hendricksoni' OR species='hendricksonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobrachium' AND (junior_species='hendricksoni' OR junior_species='hendricksonii')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='Leptobrachium' AND (species='hendricksoni' OR species='hendricksonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megophrys' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megophrys' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megophrys' AND (species='nasuta' OR species='nasuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megophrys' AND (junior_species='nasuta' OR junior_species='nasuta')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='Megophrys' AND (species='nasuta' OR species='nasuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaloula' AND (junior_species='pulchra' OR junior_species='pulchra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kaloula' AND (species='pulchra' OR species='pulchra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kaloula' AND (species='pulchra' OR species='pulchra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaloula' AND (junior_species='pulchra' OR junior_species='pulchra')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='Kaloula' AND (species='pulchra' OR species='pulchra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='butleri' OR junior_species='butlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='butleri' OR species='butlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='butleri' OR species='butlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='butleri' OR junior_species='butlerii')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='Microhyla' AND (species='butleri' OR species='butlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='heymonsi' OR junior_species='heymonsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='heymonsi' OR species='heymonsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='heymonsi' OR species='heymonsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='heymonsi' OR junior_species='heymonsii')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='Microhyla' AND (species='heymonsi' OR species='heymonsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')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='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='leucomystax' OR species='leucomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')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='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='macrotis' OR junior_species='macrotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='macrotis' OR species='macrotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='macrotis' OR species='macrotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='macrotis' OR junior_species='macrotis')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='Polypedates' AND (species='macrotis' OR species='macrotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caudacaecilia' AND (junior_species='nigroflava' OR junior_species='nigroflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caudacaecilia' AND (species='nigroflava' OR species='nigroflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caudacaecilia' AND (species='nigroflava' OR species='nigroflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caudacaecilia' AND (junior_species='nigroflava' OR junior_species='nigroflava')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='Caudacaecilia' AND (species='nigroflava' OR species='nigroflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bungarus' AND (junior_species='flaviceps' OR junior_species='flaviceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bungarus' AND (species='flaviceps' OR species='flaviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bungarus' AND (species='flaviceps' OR species='flaviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bungarus' AND (junior_species='flaviceps' OR junior_species='flaviceps')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='Bungarus' AND (species='flaviceps' OR species='flaviceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='kaouthia' OR junior_species='kaouthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naja' AND (species='kaouthia' OR species='kaouthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naja' AND (species='kaouthia' OR species='kaouthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naja' AND (junior_species='kaouthia' OR junior_species='kaouthia')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='Naja' AND (species='kaouthia' OR species='kaouthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimeresurus' AND (junior_species='wiroti' OR junior_species='wirotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimeresurus' AND (species='wiroti' OR species='wirotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimeresurus' AND (species='wiroti' OR species='wirotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimeresurus' AND (junior_species='wiroti' OR junior_species='wirotii')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='Trimeresurus' AND (species='wiroti' OR species='wirotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidolaemus' AND (junior_species='wagleri' OR junior_species='waglerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropidolaemus' AND (species='wagleri' OR species='waglerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropidolaemus' AND (species='wagleri' OR species='waglerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropidolaemus' AND (junior_species='wagleri' OR junior_species='waglerii')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='Tropidolaemus' AND (species='wagleri' OR species='waglerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahaetulla' AND (junior_species='mycterizans' OR junior_species='mycterizans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ahaetulla' AND (species='mycterizans' OR species='mycterizans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ahaetulla' AND (species='mycterizans' OR species='mycterizans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahaetulla' AND (junior_species='mycterizans' OR junior_species='mycterizans')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='Ahaetulla' AND (species='mycterizans' OR species='mycterizans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiga' AND (junior_species='dendrophila' OR junior_species='dendrophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boiga' AND (species='dendrophila' OR species='dendrophila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boiga' AND (species='dendrophila' OR species='dendrophila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boiga' AND (junior_species='dendrophila' OR junior_species='dendrophila')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='Boiga' AND (species='dendrophila' OR species='dendrophila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysopelea' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysopelea' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysopelea' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysopelea' AND (junior_species='ornata' OR junior_species='ornata')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='Chrysopelea' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysopelea' AND (junior_species='paradisii' OR junior_species='paradisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysopelea' AND (species='paradisii' OR species='paradisi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysopelea' AND (species='paradisii' OR species='paradisi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysopelea' AND (junior_species='paradisii' OR junior_species='paradisi')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='Chrysopelea' AND (species='paradisii' OR species='paradisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrelaphis' AND (junior_species='kopsteini' OR junior_species='kopsteinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrelaphis' AND (species='kopsteini' OR species='kopsteinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrelaphis' AND (species='kopsteini' OR species='kopsteinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrelaphis' AND (junior_species='kopsteini' OR junior_species='kopsteinii')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='Dendrelaphis' AND (species='kopsteini' OR species='kopsteinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrelaphis' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrelaphis' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrelaphis' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrelaphis' AND (junior_species='pictus' OR junior_species='pictus')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='Dendrelaphis' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropisthodon' AND (junior_species='rhodomelas' OR junior_species='rhodomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropisthodon' AND (species='rhodomelas' OR species='rhodomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropisthodon' AND (species='rhodomelas' OR species='rhodomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropisthodon' AND (junior_species='rhodomelas' OR junior_species='rhodomelas')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='Macropisthodon' AND (species='rhodomelas' OR species='rhodomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtodactylus' AND (junior_species='consobrinus' OR junior_species='consobrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrtodactylus' AND (species='consobrinus' OR species='consobrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrtodactylus' AND (species='consobrinus' OR species='consobrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtodactylus' AND (junior_species='consobrinus' OR junior_species='consobrinus')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='Cyrtodactylus' AND (species='consobrinus' OR species='consobrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='smithii' OR junior_species='smithi')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='Gekko' AND (species='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='monarchus' OR junior_species='monarchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='monarchus' OR species='monarchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='monarchus' OR species='monarchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='monarchus' OR junior_species='monarchus')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='Gekko' AND (species='monarchus' OR species='monarchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geohyra' AND (junior_species='mutilata' OR junior_species='mutilata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geohyra' AND (species='mutilata' OR species='mutilata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geohyra' AND (species='mutilata' OR species='mutilata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geohyra' AND (junior_species='mutilata' OR junior_species='mutilata')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='Geohyra' AND (species='mutilata' OR species='mutilata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='frenatus' OR species='frenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='frenatus' OR species='frenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')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='Hemidactylus' AND (species='frenatus' OR species='frenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bronchocela' AND (junior_species='cristatella' OR junior_species='cristatella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bronchocela' AND (species='cristatella' OR species='cristatella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bronchocela' AND (species='cristatella' OR species='cristatella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bronchocela' AND (junior_species='cristatella' OR junior_species='cristatella')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='Bronchocela' AND (species='cristatella' OR species='cristatella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calotes' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calotes' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calotes' AND (junior_species='versicolor' OR junior_species='versicolor')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='Calotes' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonocephalus' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonocephalus' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonocephalus' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonocephalus' AND (junior_species='grandis' OR junior_species='grandis')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='Gonocephalus' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='multifasciata' OR species='multifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')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='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='scotophilus' OR junior_species='scotophilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphenomorphus' AND (species='scotophilus' OR species='scotophilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='scotophilus' OR species='scotophilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='scotophilus' OR junior_species='scotophilus')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='Sphenomorphus' AND (species='scotophilus' OR species='scotophilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='salvator' OR junior_species='salvator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='salvator' OR species='salvator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='salvator' OR species='salvator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='salvator' OR junior_species='salvator')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='Varanus' AND (species='salvator' OR species='salvator') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=439 The Ecological Register: Kampung Peta
Kampung Peta
Basic information
Sample name: Kampung Peta

Sample aka: Endau-Rompin National Park

Reference: S. Shahriza, J. Ibrahim, M. S. Shahrul Anuar, and M. A. Abdul Muin. 2012. Herpetofauna of Peta Area of Endau-Rompin National Park, Johor, Malaysia. Journal of Tropical Agricultural Science 35(3):553-567 [ER 213]
Geography
Country: Malaysia

State: Johor


Coordinate: 2.44° N, 103.27° E
Coordinate basis: based on nearby landmark

Geography comments: coordinate is for the national park
elevation below 300 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

WMT: 27.6

CMT: 25.1

MAP: 3311.0

Habitat comments: "lowland dipterocarp forest"
climate data are based on station 48657 (Kuantan airport)

Methods
Life forms: lizards,snakes,caecilians,frogs

Sampling methods: sweep nets,hand capture

Sample size: 310 individuals

Years: 2008

Sampling comments: hand capture and sweep nets

Metadata
Sample number: 439

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-17 10:34:12

Modified: 2014-04-26 23:38:26

Abundance distribution
47 species
13 singletons
total count 310
extrapolated richness: 83.7
Fisher's α: 15.409
geometric series k: 0.9224
Hurlbert's PIE: 0.9386
Shannon's H: 3.2402
Good's u: 0.9582
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ingerophrynus parvus41
Phrynoidis aspera7
Pedostibes hosii4
Fejervarya limnocharis9
Limnodectes blythii3
Limnodectes kuhlii3
Limnodectes laticeps5
Occidozyga laevis8
Occidozyga lima2
Amolops larutensis25
Hylarana erythraea7
Hylarana glandulosa15
Hylarana labialis35
Hylarana laterimaculata2
Hylarana picturata5
Odorrana hosii6
Leptobrachium hendricksoni8
Megophrys nasuta4
Kaloula pulchra5
Microhyla butleri8
Microhyla heymonsi6
Microhyla berdmorei1
Polypedates leucomystax10
Polypedates macrotis1
Caudacaecilia nigroflava1
Bungarus flaviceps1
Naja kaouthia1
Trimeresurus wiroti1
Tropidolaemus wagleri1
Ahaetulla mycterizans2
Boiga dendrophila1
Chrysopelea ornata1
Chrysopelea paradisii1
Dendrelaphis kopsteini1
Dendrelaphis pictus2
Macropisthodon rhodomelas1
Cyrtodactylus consobrinus2
Gekko smithii7
Gekko monarchus6
Geohyra mutilata5
Hemidactylus frenatus35
Bronchocela cristatella1
Calotes versicolor4
Gonocephalus grandis3
Eutropis multifasciata5
Sphenomorphus scotophilus2
Varanus salvator6