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=10 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=10SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=10 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='madagascariense' OR junior_species='madagascariense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='madagascariense' OR species='madagascariense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='madagascariense' OR species='madagascariense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='madagascariense' OR junior_species='madagascariense')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='Antidesma' AND (species='madagascariense' OR species='madagascariense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antirrhoea' AND (junior_species='verticillata' OR junior_species='verticillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antirrhoea' AND (species='verticillata' OR species='verticillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antirrhoea' AND (species='verticillata' OR species='verticillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antirrhoea' AND (junior_species='verticillata' OR junior_species='verticillata')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='Antirrhoea' AND (species='verticillata' OR species='verticillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphloia' AND (junior_species='theiformis' OR junior_species='theiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphloia' AND (species='theiformis' OR species='theiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphloia' AND (species='theiformis' OR species='theiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphloia' AND (junior_species='theiformis' OR junior_species='theiformis')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='Aphloia' AND (species='theiformis' OR species='theiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tree' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')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='Tree' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calvaria' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calvaria' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calvaria' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calvaria' AND (junior_species='major' OR junior_species='major')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='Calvaria' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='mauritianum' OR junior_species='mauritianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='mauritianum' OR species='mauritianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='mauritianum' OR species='mauritianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='mauritianum' OR junior_species='mauritianum')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='Canarium' AND (species='mauritianum' OR species='mauritianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasalia' AND (junior_species='capitata' OR junior_species='capitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chasalia' AND (species='capitata' OR species='capitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chasalia' AND (species='capitata' OR species='capitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasalia' AND (junior_species='capitata' OR junior_species='capitata')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='Chasalia' AND (species='capitata' OR species='capitata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopharyngia' AND (junior_species='mauritiana' OR junior_species='mauritiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conopharyngia' AND (species='mauritiana' OR species='mauritiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conopharyngia' AND (species='mauritiana' OR species='mauritiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopharyngia' AND (junior_species='mauritiana' OR junior_species='mauritiana')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='Conopharyngia' AND (species='mauritiana' OR species='mauritiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' 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='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' 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='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='spp.' OR junior_species='spp.')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='Diospyros' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeodendron' AND (junior_species='orientale' OR junior_species='orientale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeodendron' AND (species='orientale' OR species='orientale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeodendron' AND (species='orientale' OR species='orientale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeodendron' AND (junior_species='orientale' OR junior_species='orientale')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='Elaeodendron' AND (species='orientale' OR species='orientale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrospermum' AND (junior_species='mauritianum' OR junior_species='mauritianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrospermum' AND (species='mauritianum' OR species='mauritianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrospermum' AND (species='mauritianum' OR species='mauritianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrospermum' AND (junior_species='mauritianum' OR junior_species='mauritianum')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='Erythrospermum' AND (species='mauritianum' OR species='mauritianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='laurifolium' OR junior_species='laurifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='laurifolium' OR species='laurifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='laurifolium' OR species='laurifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='laurifolium' OR junior_species='laurifolium')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='Erythroxylum' AND (species='laurifolium' OR species='laurifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='glomerata' OR junior_species='glomerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='glomerata' OR species='glomerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='glomerata' OR species='glomerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='glomerata' OR junior_species='glomerata')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='Eugenia' AND (species='glomerata' OR species='glomerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='orbiculata' OR junior_species='orbiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='orbiculata' OR species='orbiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='orbiculata' OR species='orbiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='orbiculata' OR junior_species='orbiculata')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='Eugenia' AND (species='orbiculata' OR species='orbiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evodia' 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='Evodia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evodia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evodia' 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='Evodia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fernelia' AND (junior_species='buxifolia' OR junior_species='buxifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fernelia' AND (species='buxifolia' OR species='buxifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fernelia' AND (species='buxifolia' OR species='buxifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fernelia' AND (junior_species='buxifolia' OR junior_species='buxifolia')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='Fernelia' AND (species='buxifolia' OR species='buxifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gaertnera' AND (junior_species='psychotrioides' OR junior_species='psychotrioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gaertnera' AND (species='psychotrioides' OR species='psychotrioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gaertnera' AND (species='psychotrioides' OR species='psychotrioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gaertnera' AND (junior_species='psychotrioides' OR junior_species='psychotrioides')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='Gaertnera' AND (species='psychotrioides' OR species='psychotrioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labourdonnaisia' 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='Labourdonnaisia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Labourdonnaisia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labourdonnaisia' 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='Labourdonnaisia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='integrifolius' OR junior_species='integrifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='integrifolius' OR species='integrifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='integrifolius' OR species='integrifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='integrifolius' OR junior_species='integrifolius')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='Mallotus' AND (species='integrifolius' OR species='integrifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='maxima' OR junior_species='maxima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimusops' AND (species='maxima' OR species='maxima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimusops' AND (species='maxima' OR species='maxima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='maxima' OR junior_species='maxima')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='Mimusops' AND (species='maxima' OR species='maxima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='petiolaris' OR junior_species='petiolaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimusops' AND (species='petiolaris' OR species='petiolaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimusops' AND (species='petiolaris' OR species='petiolaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='petiolaris' OR junior_species='petiolaris')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='Mimusops' AND (species='petiolaris' OR species='petiolaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molinaea' AND (junior_species='cupanioides' OR junior_species='cupanioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molinaea' AND (species='cupanioides' OR species='cupanioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molinaea' AND (species='cupanioides' OR species='cupanioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molinaea' AND (junior_species='cupanioides' OR junior_species='cupanioides')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='Molinaea' AND (species='cupanioides' OR species='cupanioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mussaenda' AND (junior_species='landia' OR junior_species='landia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mussaenda' AND (species='landia' OR species='landia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mussaenda' AND (species='landia' OR species='landia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mussaenda' AND (junior_species='landia' OR junior_species='landia')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='Mussaenda' AND (species='landia' OR species='landia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuxia' AND (junior_species='verticillata' OR junior_species='verticillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nuxia' AND (species='verticillata' OR species='verticillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nuxia' AND (species='verticillata' OR species='verticillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuxia' AND (junior_species='verticillata' OR junior_species='verticillata')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='Nuxia' AND (species='verticillata' OR species='verticillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='cupularis' OR junior_species='cupularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='cupularis' OR species='cupularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='cupularis' OR species='cupularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='cupularis' OR junior_species='cupularis')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='Ocotea' AND (species='cupularis' OR species='cupularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psiloxylon' AND (junior_species='mauritianum' OR junior_species='mauritianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psiloxylon' AND (species='mauritianum' OR species='mauritianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psiloxylon' AND (species='mauritianum' OR species='mauritianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psiloxylon' AND (junior_species='mauritianum' OR junior_species='mauritianum')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='Psiloxylon' AND (species='mauritianum' OR species='mauritianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quivisia' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quivisia' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quivisia' AND (species='oppositifolia' OR species='oppositifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quivisia' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')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='Quivisia' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tambourissa' AND (junior_species='sieberi' OR junior_species='sieberii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tambourissa' AND (species='sieberi' OR species='sieberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tambourissa' AND (species='sieberi' OR species='sieberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tambourissa' AND (junior_species='sieberi' OR junior_species='sieberii')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='Tambourissa' AND (species='sieberi' OR species='sieberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='richardi' OR junior_species='richardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='richardi' OR species='richardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='richardi' OR species='richardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='richardi' OR junior_species='richardii')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='Xylopia' AND (species='richardi' OR species='richardii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=10 The Ecological Register: Crown Land Macabé Sample Plot 1
Crown Land Macabé Sample Plot 1
Basic information
Sample name: Crown Land Macabé Sample Plot 1

Reference: R. E. Vaughan and P. O. Wiehe. 1941. Studies on the vegetation of Mauritius: III. The structure and development of the upland climax forest. Journal of Ecology 29(1):127-160 [ER 3]
Geography
Country: Mauritius


Coordinate: 20° 25' S, 57° 25' E
Geography comments: coordinate based on Black River Gorges National Park

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 20.0

WMT: 26.0

CMT: 14.0

MAP: 3125.0

Methods
Life forms: trees

Sites: 1

Site length: 50

Site width: 20

Sampling methods: quadrat

Sample size: 126 individuals

Size min: 10

Sampling comments: see table 1 (p. 132)

Metadata
Sample number: 10

Contributor: John Alroy

Enterer: John Alroy

Modifier no: Benjamin Carter

Created: 2013-01-23 14:23:53

Modified: 2014-07-17 05:17:50

Abundance distribution
30 species
14 singletons
total count 126
extrapolated richness: 78.2
Fisher's α: 12.457
geometric series k: 0.8989
Hurlbert's PIE: 0.9092
Shannon's H: 2.7975
Good's u: 0.8896
Each square represents a species. Square sizes are proportional to counts.
Register