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=239 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=239SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=98SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=239 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnacranthera' AND (junior_species='farquhariana' OR junior_species='farquhariana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnacranthera' AND (species='farquhariana' OR species='farquhariana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnacranthera' AND (species='farquhariana' OR species='farquhariana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnacranthera' AND (junior_species='farquhariana' OR junior_species='farquhariana')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='Gymnacranthera' AND (species='farquhariana' OR species='farquhariana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='fatua' OR junior_species='fatua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='fatua' OR species='fatua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='fatua' OR species='fatua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='fatua' OR junior_species='fatua')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='Myristica' AND (species='fatua' OR species='fatua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastixia' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastixia' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastixia' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastixia' AND (junior_species='arborea' OR junior_species='arborea')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='Mastixia' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinanga' AND (junior_species='dicksonii' OR junior_species='dicksoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pinanga' AND (species='dicksonii' OR species='dicksoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pinanga' AND (species='dicksonii' OR species='dicksoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pinanga' AND (junior_species='dicksonii' OR junior_species='dicksoni')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='Pinanga' AND (species='dicksonii' OR species='dicksoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='ponga' OR junior_species='ponga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hopea' AND (species='ponga' OR species='ponga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hopea' AND (species='ponga' OR species='ponga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='ponga' OR junior_species='ponga')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='Hopea' AND (species='ponga' OR species='ponga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipterocarpus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipterocarpus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='indicus' OR junior_species='indicus')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='Dipterocarpus' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandanus' AND (junior_species='unipapillatus' OR junior_species='unipapillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pandanus' AND (species='unipapillatus' OR species='unipapillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pandanus' AND (species='unipapillatus' OR species='unipapillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandanus' AND (junior_species='unipapillatus' OR junior_species='unipapillatus')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='Pandanus' AND (species='unipapillatus' OR species='unipapillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophopetalum' AND (junior_species='wightianum' OR junior_species='wightianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophopetalum' AND (species='wightianum' OR species='wightianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophopetalum' AND (species='wightianum' OR species='wightianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophopetalum' AND (junior_species='wightianum' OR junior_species='wightianum')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='Lophopetalum' AND (species='wightianum' OR species='wightianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrostistachys' AND (junior_species='meeboldii' OR junior_species='meeboldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrostistachys' AND (species='meeboldii' OR species='meeboldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrostistachys' AND (species='meeboldii' OR species='meeboldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrostistachys' AND (junior_species='meeboldii' OR junior_species='meeboldi')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='Agrostistachys' AND (species='meeboldii' OR species='meeboldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='malabarica' OR junior_species='malabarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='malabarica' OR species='malabarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='malabarica' OR species='malabarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='malabarica' OR junior_species='malabarica')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='Myristica' AND (species='malabarica' OR species='malabarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meiogyne' AND (junior_species='pannosa' OR junior_species='pannosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meiogyne' AND (species='pannosa' OR species='pannosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meiogyne' AND (species='pannosa' OR species='pannosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meiogyne' AND (junior_species='pannosa' OR junior_species='pannosa')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='Meiogyne' AND (species='pannosa' OR species='pannosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimocarpus' AND (junior_species='longan' OR junior_species='longan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dimocarpus' AND (species='longan' OR species='longan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimocarpus' AND (species='longan' OR species='longan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimocarpus' AND (junior_species='longan' OR junior_species='longan')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='Dimocarpus' AND (species='longan' OR species='longan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='montanum' OR junior_species='montanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='montanum' OR species='montanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='montanum' OR species='montanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='montanum' OR junior_species='montanum')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='Syzygium' AND (species='montanum' OR species='montanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='attenuata' OR junior_species='attenuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='attenuata' OR species='attenuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='attenuata' OR species='attenuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='attenuata' OR junior_species='attenuata')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='Knema' AND (species='attenuata' OR species='attenuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='grahamii' OR junior_species='grahami')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holigarna' AND (species='grahamii' OR species='grahami') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='grahamii' OR species='grahami')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='grahamii' OR junior_species='grahami')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='Holigarna' AND (species='grahamii' OR species='grahami') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlandra' AND (junior_species='travancorica' OR junior_species='travancorica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlandra' AND (species='travancorica' OR species='travancorica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlandra' AND (species='travancorica' OR species='travancorica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlandra' AND (junior_species='travancorica' OR junior_species='travancorica')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='Ochlandra' AND (species='travancorica' OR species='travancorica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holigarna' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='ferruginea' OR junior_species='ferruginea')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='Holigarna' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='pentandra' OR junior_species='pentandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydnocarpus' AND (species='pentandra' OR species='pentandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydnocarpus' AND (species='pentandra' OR species='pentandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='pentandra' OR junior_species='pentandra')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='Hydnocarpus' AND (species='pentandra' OR species='pentandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='zeylanicum' OR junior_species='zeylanicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='zeylanicum' OR species='zeylanicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='zeylanicum' OR species='zeylanicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='zeylanicum' OR junior_species='zeylanicum')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='Syzygium' AND (species='zeylanicum' OR species='zeylanicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cumini' OR junior_species='cuminii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cumini' OR species='cuminii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cumini' OR species='cuminii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cumini' OR junior_species='cuminii')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='Syzygium' AND (species='cumini' OR species='cuminii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='coriacea' OR junior_species='coriacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='coriacea' OR junior_species='coriacea')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='Litsea' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')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='Mangifera' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='tuberculatus' OR junior_species='tuberculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='tuberculatus' OR species='tuberculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='tuberculatus' OR species='tuberculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='tuberculatus' OR junior_species='tuberculatus')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='Elaeocarpus' AND (species='tuberculatus' OR species='tuberculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='laevigata' OR junior_species='laevigata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='laevigata' OR species='laevigata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='laevigata' OR species='laevigata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='laevigata' OR junior_species='laevigata')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='Litsea' AND (species='laevigata' OR species='laevigata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='esculenta' OR junior_species='esculenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='esculenta' OR species='esculenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='esculenta' OR species='esculenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='esculenta' OR junior_species='esculenta')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='Casearia' AND (species='esculenta' OR species='esculenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='indica' OR junior_species='indica')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='Garcinia' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='indicus' OR junior_species='indicus')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='Euonymus' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='laetum' OR junior_species='laetum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='laetum' OR species='laetum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='laetum' OR species='laetum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='laetum' OR junior_species='laetum')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='Syzygium' AND (species='laetum' OR species='laetum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='apetalum' OR junior_species='apetalum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calophyllum' AND (species='apetalum' OR species='apetalum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calophyllum' AND (species='apetalum' OR species='apetalum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='apetalum' OR junior_species='apetalum')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='Calophyllum' AND (species='apetalum' OR species='apetalum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathea' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyathea' AND (species='gigantea' OR species='gigantea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyathea' AND (species='gigantea' OR species='gigantea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathea' AND (junior_species='gigantea' OR junior_species='gigantea')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='Cyathea' AND (species='gigantea' OR species='gigantea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='polyanthum' OR junior_species='polyanthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calophyllum' AND (species='polyanthum' OR species='polyanthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calophyllum' AND (species='polyanthum' OR species='polyanthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='polyanthum' OR junior_species='polyanthum')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='Calophyllum' AND (species='polyanthum' OR species='polyanthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='wightiana' OR junior_species='wightiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinodaphne' AND (species='wightiana' OR species='wightiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinodaphne' AND (species='wightiana' OR species='wightiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='wightiana' OR junior_species='wightiana')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='Actinodaphne' AND (species='wightiana' OR species='wightiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='heyneana' OR junior_species='heyneana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='heyneana' OR species='heyneana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='heyneana' OR species='heyneana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='heyneana' OR junior_species='heyneana')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='Tabernaemontana' AND (species='heyneana' OR species='heyneana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='paniculata' OR junior_species='paniculata')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='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoon' AND (junior_species='fragrans' OR junior_species='fragrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monoon' AND (species='fragrans' OR species='fragrans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monoon' AND (species='fragrans' OR species='fragrans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoon' AND (junior_species='fragrans' OR junior_species='fragrans')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='Monoon' AND (species='fragrans' OR species='fragrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='malaelengi' OR junior_species='malaelengii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chionanthus' AND (species='malaelengi' OR species='malaelengii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chionanthus' AND (species='malaelengi' OR species='malaelengii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='malaelengi' OR junior_species='malaelengii')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='Chionanthus' AND (species='malaelengi' OR species='malaelengii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopegia' AND (junior_species='racemosa' OR junior_species='racemosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nothopegia' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothopegia' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopegia' AND (junior_species='racemosa' OR junior_species='racemosa')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='Nothopegia' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machilus' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machilus' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machilus' AND (species='glaucescens' OR species='glaucescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machilus' AND (junior_species='glaucescens' OR junior_species='glaucescens')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='Machilus' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='dioica' OR junior_species='dioica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olea' AND (species='dioica' OR species='dioica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olea' AND (species='dioica' OR species='dioica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='dioica' OR junior_species='dioica')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='Olea' AND (species='dioica' OR species='dioica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='serratus' OR junior_species='serratus')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='Elaeocarpus' AND (species='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='morella' OR species='morella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='morella' OR species='morella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')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='Garcinia' AND (species='morella' OR species='morella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='scholaris' OR junior_species='scholaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='scholaris' OR species='scholaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='scholaris' OR species='scholaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='scholaris' OR junior_species='scholaris')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='Alstonia' AND (species='scholaris' OR species='scholaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='venulosa' OR junior_species='venulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schefflera' AND (species='venulosa' OR species='venulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schefflera' AND (species='venulosa' OR species='venulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='venulosa' OR junior_species='venulosa')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='Schefflera' AND (species='venulosa' OR species='venulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arenga' AND (junior_species='wightii' OR junior_species='wighti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arenga' AND (species='wightii' OR species='wighti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arenga' AND (species='wightii' OR species='wighti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arenga' AND (junior_species='wightii' OR junior_species='wighti')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='Arenga' AND (species='wightii' OR species='wighti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='malabaricum' OR junior_species='malabaricum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memecylon' AND (species='malabaricum' OR species='malabaricum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='malabaricum' OR species='malabaricum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='malabaricum' OR junior_species='malabaricum')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='Memecylon' AND (species='malabaricum' OR species='malabaricum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leea' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leea' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leea' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leea' AND (junior_species='indica' OR junior_species='indica')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='Leea' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='latifolium' OR junior_species='latifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='latifolium' OR species='latifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='latifolium' OR species='latifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='latifolium' OR junior_species='latifolium')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='Combretum' AND (species='latifolium' OR species='latifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')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='Artocarpus' AND (species='hirsutus' OR species='hirsutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='ghatica' OR junior_species='ghatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='ghatica' OR species='ghatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='ghatica' OR species='ghatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='ghatica' OR junior_species='ghatica')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='Litsea' AND (species='ghatica' OR species='ghatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='deccanesis' OR junior_species='deccanesis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='deccanesis' OR species='deccanesis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='deccanesis' OR species='deccanesis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='deccanesis' OR junior_species='deccanesis')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='Litsea' AND (species='deccanesis' OR species='deccanesis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='terminale' OR junior_species='terminale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memecylon' AND (species='terminale' OR species='terminale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='terminale' OR species='terminale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='terminale' OR junior_species='terminale')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='Memecylon' AND (species='terminale' OR species='terminale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vateria' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vateria' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vateria' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vateria' AND (junior_species='indica' OR junior_species='indica')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='Vateria' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='spicata' OR junior_species='spicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='spicata' OR species='spicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='spicata' OR species='spicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='spicata' OR junior_species='spicata')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='Garcinia' AND (species='spicata' OR species='spicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='candolleana' OR junior_species='candolleana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='candolleana' OR species='candolleana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='candolleana' OR species='candolleana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='candolleana' OR junior_species='candolleana')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='candolleana' OR species='candolleana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='anacardium' OR junior_species='anacardium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semecarpus' AND (species='anacardium' OR species='anacardium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semecarpus' AND (species='anacardium' OR species='anacardium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='anacardium' OR junior_species='anacardium')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='Semecarpus' AND (species='anacardium' OR species='anacardium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='emarginatus' OR junior_species='emarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapindus' AND (species='emarginatus' OR species='emarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapindus' AND (species='emarginatus' OR species='emarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='emarginatus' OR junior_species='emarginatus')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='Sapindus' AND (species='emarginatus' OR species='emarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='ellipticum' OR junior_species='ellipticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glochidion' AND (species='ellipticum' OR species='ellipticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glochidion' AND (species='ellipticum' OR species='ellipticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='ellipticum' OR junior_species='ellipticum')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='Glochidion' AND (species='ellipticum' OR species='ellipticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryota' AND (junior_species='urens' OR junior_species='urens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryota' AND (species='urens' OR species='urens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryota' AND (species='urens' OR species='urens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryota' AND (junior_species='urens' OR junior_species='urens')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='Caryota' AND (species='urens' OR species='urens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='indica' OR junior_species='indica')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='Macaranga' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='hispida' OR junior_species='hispida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='hispida' OR species='hispida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='hispida' OR species='hispida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='hispida' OR junior_species='hispida')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='Ficus' AND (species='hispida' OR species='hispida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='tsjahela' OR junior_species='tsjahela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='tsjahela' OR species='tsjahela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='tsjahela' OR species='tsjahela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='tsjahela' OR junior_species='tsjahela')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='Ficus' AND (species='tsjahela' OR species='tsjahela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='strictum' OR junior_species='strictum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='strictum' OR species='strictum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='strictum' OR species='strictum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='strictum' OR junior_species='strictum')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='strictum' OR species='strictum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='philippensis' OR species='philippensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='philippensis' OR species='philippensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')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='philippensis' OR species='philippensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=239 The Ecological Register: Kathalkane
Kathalkane
Basic information
Sample name: Kathalkane

Reference: P. Rama Bhat and K. M. Kaveriappa. 2009. Ecological studies on Myristica swamp forests of Uttara Kannada, Karnataka, India. Tropical Ecology 50(2):329-337 [ER 98]
Geography
Country: India

State: Karnataka


Coordinate: 14° 15' 45" N, 74° 45' 30" E
Coordinate basis: stated in text as range

Geography comments: "in Gersoppa, about 45 km from Honnavar"
elevation range 500 to 530 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 29.9

CMT: 24.3

MAP: 3705.0

Habitat comments: "The monthly maximum temperature varied from 28.2 to 33.5ºC and the monthly minimum from 20.4 to 26.2ºC"

Methods
Life forms: trees

Sites: 20

Site area: 0.2

Sampling methods: quadrat

Sample size: 671 individuals

Seasons: dry

Size min: 10

Basal area: 382.64

Sampling comments: 10 x 10 m quadrats supposedly totalling an area of 2000 m2
the authors seem very sure of the area, but both the stem count and especially the basal area (382.64 m2) are extremely high for 0.2 ha, so I am assuming that a catastrophic error has been made and that the basal area is actually per ha instead of a total in m2

Metadata
Sample number: 239

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-25 12:05:19

Modified: 2017-11-02 03:32:24

Abundance distribution
63 species
16 singletons
total count 671
extrapolated richness: 114.9
Fisher's α: 17.033
geometric series k: 0.9280
Hurlbert's PIE: 0.9217
Shannon's H: 3.0749
Good's u: 0.9762
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Gymnacranthera farquhariana103
Myristica fatua97
Mastixia arborea62
Pinanga dicksonii59
Hopea ponga51
Dipterocarpus indicus48
Pandanus unipapillatus31
Lophopetalum wightianum29
Agrostistachys meeboldii14
Myristica malabarica9
Meiogyne pannosa9
Dimocarpus longan9
Syzygium montanum8
Knema attenuata7
Holigarna grahamii7
Ochlandra travancorica6
Holigarna ferruginea6
Hydnocarpus pentandra6
Syzygium zeylanicum5
Syzygium cumini5
Litsea coriacea5
Mangifera indica5
Elaeocarpus tuberculatus4
Litsea laevigata4
Casearia esculenta4
Garcinia indica4
Euonymus indicus4
Syzygium laetum3
Calophyllum apetalum3
Cyathea gigantea3
Calophyllum polyanthum2
Actinodaphne wightiana2
"Actinodaphne malabaricum"
Tabernaemontana heyneana2
Diospyros paniculata2
Monoon fragrans2
"Polyalthia fragrans"
Chionanthus malaelengi2
Nothopegia racemosa3
"Nothapegia racemosa"
Machilus glaucescens12
"Persea macrantha"
Olea dioica2
Elaeocarpus serratus2
Garcinia morella2
Alstonia scholaris2
Schefflera venulosa2
Arenga wightii2
Memecylon malabaricum2
Leea indica2
Combretum latifolium2
Artocarpus hirsutus1
Litsea ghatica1
Litsea deccanesis1
Memecylon terminale1
Vateria indica1
Garcinia spicata1
Diospyros candolleana1
Semecarpus anacardium1
Sapindus emarginatus1
"Sapindus emerginatus"
Glochidion ellipticum1
Caryota urens1
Macaranga indica1
Ficus hispida1
Ficus tsjahela1
Canarium strictum1
Mallotus philippensis1