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=2322 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2322SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2256SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2322 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cophyla' AND (junior_species='phyllodactyla' OR junior_species='phyllodactyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cophyla' AND (species='phyllodactyla' OR species='phyllodactyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cophyla' AND (species='phyllodactyla' OR species='phyllodactyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cophyla' AND (junior_species='phyllodactyla' OR junior_species='phyllodactyla')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='Cophyla' AND (species='phyllodactyla' OR species='phyllodactyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blommersia' AND (junior_species='wittei' OR junior_species='witteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blommersia' AND (species='wittei' OR species='witteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blommersia' AND (species='wittei' OR species='witteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blommersia' AND (junior_species='wittei' OR junior_species='witteii')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='Blommersia' AND (species='wittei' OR species='witteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantella' AND (junior_species='ebenaui' OR junior_species='ebenauii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantella' AND (species='ebenaui' OR species='ebenauii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantella' AND (species='ebenaui' OR species='ebenauii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantella' AND (junior_species='ebenaui' OR junior_species='ebenauii')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='Mantella' AND (species='ebenaui' OR species='ebenauii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='ulcerosus' OR junior_species='ulcerosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='ulcerosus' OR species='ulcerosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='ulcerosus' OR species='ulcerosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='ulcerosus' OR junior_species='ulcerosus')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='Mantidactylus' AND (species='ulcerosus' OR species='ulcerosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brookesia' AND (junior_species='stumpffi' OR junior_species='stumpffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brookesia' AND (species='stumpffi' OR species='stumpffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brookesia' AND (species='stumpffi' OR species='stumpffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brookesia' AND (junior_species='stumpffi' OR junior_species='stumpffii')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='Brookesia' AND (species='stumpffi' OR species='stumpffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calumma' AND (junior_species='boettgeri' OR junior_species='boettgerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calumma' AND (species='boettgeri' OR species='boettgerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calumma' AND (species='boettgeri' OR species='boettgerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calumma' AND (junior_species='boettgeri' OR junior_species='boettgerii')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='Calumma' AND (species='boettgeri' OR species='boettgerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calumma' AND (junior_species='nasutum' OR junior_species='nasutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calumma' AND (species='nasutum' OR species='nasutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calumma' AND (species='nasutum' OR species='nasutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calumma' AND (junior_species='nasutum' OR junior_species='nasutum')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='Calumma' AND (species='nasutum' OR species='nasutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furcifer' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furcifer' AND (species='pardalis' OR species='pardalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcifer' AND (junior_species='pardalis' OR junior_species='pardalis')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='Furcifer' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonosaurus' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonosaurus' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonosaurus' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonosaurus' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Zonosaurus' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonosaurus' AND (junior_species='subunicolor' OR junior_species='subunicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonosaurus' AND (species='subunicolor' OR species='subunicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonosaurus' AND (species='subunicolor' OR species='subunicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonosaurus' AND (junior_species='subunicolor' OR junior_species='subunicolor')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='Zonosaurus' AND (species='subunicolor' OR species='subunicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='gravenhorstii' OR junior_species='gravenhorsti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='gravenhorstii' OR species='gravenhorsti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='gravenhorstii' OR species='gravenhorsti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='gravenhorstii' OR junior_species='gravenhorsti')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='Trachylepis' AND (species='gravenhorstii' OR species='gravenhorsti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ebenavia' AND (junior_species='inunguis' OR junior_species='inunguis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ebenavia' AND (species='inunguis' OR species='inunguis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ebenavia' AND (species='inunguis' OR species='inunguis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ebenavia' AND (junior_species='inunguis' OR junior_species='inunguis')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='Ebenavia' AND (species='inunguis' OR species='inunguis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geckolepis' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geckolepis' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geckolepis' AND (junior_species='maculata' OR junior_species='maculata')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='Geckolepis' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platycephalus' OR junior_species='platycephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='platycephalus' OR species='platycephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='platycephalus' OR species='platycephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platycephalus' OR junior_species='platycephalus')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='platycephalus' OR species='platycephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Lygodactylus' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='abbotti' OR junior_species='abbottii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='abbotti' OR species='abbottii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='abbotti' OR species='abbottii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='abbotti' OR junior_species='abbottii')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='Phelsuma' AND (species='abbotti' OR species='abbottii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='dubia' OR junior_species='dubia')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='Phelsuma' AND (species='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' 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='Phelsuma' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' 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='Phelsuma' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='laticauda' OR junior_species='laticauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='laticauda' OR species='laticauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='laticauda' OR species='laticauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='laticauda' OR junior_species='laticauda')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='Phelsuma' AND (species='laticauda' OR species='laticauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='oviceps' OR junior_species='oviceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paroedura' AND (species='oviceps' OR species='oviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paroedura' AND (species='oviceps' OR species='oviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='oviceps' OR junior_species='oviceps')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='Paroedura' AND (species='oviceps' OR species='oviceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='quadriocellata' OR junior_species='quadriocellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='quadriocellata' OR junior_species='quadriocellata')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='Phelsuma' AND (species='quadriocellata' OR species='quadriocellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='seippi' OR junior_species='seippii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelsuma' AND (species='seippi' OR species='seippii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelsuma' AND (species='seippi' OR species='seippii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelsuma' AND (junior_species='seippi' OR junior_species='seippii')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='Phelsuma' AND (species='seippi' OR species='seippii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='stumpffi' OR junior_species='stumpffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paroedura' AND (species='stumpffi' OR species='stumpffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paroedura' AND (species='stumpffi' OR species='stumpffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroedura' AND (junior_species='stumpffi' OR junior_species='stumpffii')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='Paroedura' AND (species='stumpffi' OR species='stumpffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroplatus' AND (junior_species='ebenaui' OR junior_species='ebenauii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroplatus' AND (species='ebenaui' OR species='ebenauii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroplatus' AND (species='ebenaui' OR species='ebenauii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroplatus' AND (junior_species='ebenaui' OR junior_species='ebenauii')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='Uroplatus' AND (species='ebenaui' OR species='ebenauii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroplatus' AND (junior_species='henkeli' OR junior_species='henkelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroplatus' AND (species='henkeli' OR species='henkelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uroplatus' AND (species='henkeli' OR species='henkelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroplatus' AND (junior_species='henkeli' OR junior_species='henkelii')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='Uroplatus' AND (species='henkeli' OR species='henkelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromicodryas' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromicodryas' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dromicodryas' AND (species='quadrilineatus' OR species='quadrilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromicodryas' AND (junior_species='quadrilineatus' OR junior_species='quadrilineatus')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='Dromicodryas' AND (species='quadrilineatus' OR species='quadrilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioheterodon' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leioheterodon' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leioheterodon' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leioheterodon' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Leioheterodon' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madagascarophis' AND (junior_species='colubrinus' OR junior_species='colubrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Madagascarophis' AND (species='colubrinus' OR species='colubrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Madagascarophis' AND (species='colubrinus' OR species='colubrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madagascarophis' AND (junior_species='colubrinus' OR junior_species='colubrinus')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='Madagascarophis' AND (species='colubrinus' OR species='colubrinus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2322 The Ecological Register: Nosy Komba (degraded habitat)
Nosy Komba (degraded habitat)
Basic information
Sample name: Nosy Komba (degraded habitat)

Reference: S. Hyde Roberts and . Daly. 2014. A rapid herpetofaunal assessment of Nosy Komba Island, northwestern Madagascar, with new locality records for seventeen species. Salamandra 50(1):18-26 [ER 2256]
Geography
Country: Madagascar


Coordinate: -13.47° S, 48.35° E
Coordinate basis: based on nearby landmark

Geography comments: no details given (coordinate based on Nosy Komba)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: disturbed forest

Substrate: ground surface

Habitat comments: "degraded habitats consisted of plantation- or agricultural-type lands, bamboo forest, village environs, and areas of secondary forest that regularly experience human disturbance" (moist forest based on location)

Methods
Life forms: lizards,snakes,frogs

Sampling methods: no design,visual

Sample size: 191 captures or sightings

Years: 2013

Sampling comments: "Three separate trips were made... during the Austral winter of 2013... Each rapid biodiversity assessment (RBA) period took place on the island for a period of three days... Each survey lasted approximately two hours" (amount of sampling effort in this habitat category is unclear); counts are based on visual identifications with apparently no specimens retained

Metadata
Sample number: 2322

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-22 14:19:49

Modified: 2016-10-22 03:19:49

Abundance distribution
28 species
6 singletons
total count 191
extrapolated richness: 49.3
Fisher's α: 9.042
geometric series k: 0.8568
Hurlbert's PIE: 0.8508
Shannon's H: 2.5492
Good's u: 0.9689
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cophyla phyllodactyla2
Blommersia wittei3
Mantella ebenaui2
Mantidactylus ulcerosus3
Brookesia stumpffi17
Calumma boettgeri65
Calumma nasutum1
Furcifer pardalis5
Zonosaurus madagascariensis3
Zonosaurus subunicolor11
Trachylepis gravenhorstii11
Ebenavia inunguis1
Geckolepis maculata3
Hemidactylus platycephalus4
Lygodactylus madagascariensis4
Phelsuma abbotti1
Phelsuma dubia2
Phelsuma grandis9
Phelsuma laticauda3
Paroedura oviceps1
Phelsuma quadriocellata2
Phelsuma seippi2
Paroedura stumpffi6
Uroplatus ebenaui19
Uroplatus henkeli7
Dromicodryas quadrilineatus1
Leioheterodon madagascariensis1
Madagascarophis colubrinus2