Coordinate: 18° 32' N, 95° 6' W
altitude of the plot itself is 140 to 165 m
precipitation per month is never less than 100 mm
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=115 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=115SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=38SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=115 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='radlkoferi' OR junior_species='radlkoferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spondias' AND (species='radlkoferi' OR species='radlkoferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spondias' AND (species='radlkoferi' OR species='radlkoferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='radlkoferi' OR junior_species='radlkoferii')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='Spondias' AND (species='radlkoferi' OR species='radlkoferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' 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='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Annonaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' 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='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymbopetalum' AND (junior_species='baillonii' OR junior_species='bailloni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymbopetalum' AND (species='baillonii' OR species='bailloni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymbopetalum' AND (species='baillonii' OR species='bailloni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymbopetalum' AND (junior_species='baillonii' OR junior_species='bailloni')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='Cymbopetalum' AND (species='baillonii' OR species='bailloni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsteronia' AND (junior_species='viridescens' OR junior_species='viridescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsteronia' AND (species='viridescens' OR species='viridescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsteronia' AND (species='viridescens' OR species='viridescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsteronia' AND (junior_species='viridescens' OR junior_species='viridescens')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='Forsteronia' AND (species='viridescens' OR species='viridescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapranthus' AND (junior_species='microcarpus' OR junior_species='microcarpus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapranthus' AND (species='microcarpus' OR species='microcarpus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapranthus' AND (species='microcarpus' OR species='microcarpus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapranthus' AND (junior_species='microcarpus' OR junior_species='microcarpus')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='Sapranthus' AND (species='microcarpus' OR species='microcarpus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='megalocarpon' OR junior_species='megalocarpon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='megalocarpon' OR species='megalocarpon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='megalocarpon' OR species='megalocarpon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='megalocarpon' OR junior_species='megalocarpon')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='Aspidosperma' AND (species='megalocarpon' OR species='megalocarpon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropanax' AND (junior_species='arboreus' OR junior_species='arboreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropanax' AND (species='arboreus' OR species='arboreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropanax' AND (species='arboreus' OR species='arboreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropanax' AND (junior_species='arboreus' OR junior_species='arboreus')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='Dendropanax' AND (species='arboreus' OR species='arboreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemmadenia' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemmadenia' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')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='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupatorium' 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='Eupatorium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupatorium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupatorium' 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='Eupatorium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bernoullia' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bernoullia' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bernoullia' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bernoullia' AND (junior_species='flammea' OR junior_species='flammea')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='Bernoullia' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='funebris' OR junior_species='funebris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='funebris' OR species='funebris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='funebris' OR species='funebris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='funebris' OR junior_species='funebris')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='Quararibea' AND (species='funebris' OR species='funebris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='guatemalteca' OR junior_species='guatemalteca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='guatemalteca' OR species='guatemalteca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='guatemalteca' OR species='guatemalteca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='guatemalteca' OR junior_species='guatemalteca')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='Quararibea' AND (species='guatemalteca' OR species='guatemalteca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='megalantha' OR junior_species='megalantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='megalantha' OR species='megalantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='megalantha' OR species='megalantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='megalantha' OR junior_species='megalantha')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='Cordia' AND (species='megalantha' OR species='megalantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='stellifera' OR junior_species='stellifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='stellifera' OR species='stellifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='stellifera' OR species='stellifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='stellifera' OR junior_species='stellifera')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='Cordia' AND (species='stellifera' OR species='stellifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bursera' AND (junior_species='simaruba' OR junior_species='simaruba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bursera' AND (species='simaruba' OR species='simaruba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bursera' AND (species='simaruba' OR species='simaruba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bursera' AND (junior_species='simaruba' OR junior_species='simaruba')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='Bursera' AND (species='simaruba' OR species='simaruba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='baduca' OR junior_species='baduca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capparis' AND (species='baduca' OR species='baduca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capparis' AND (species='baduca' OR species='baduca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='baduca' OR junior_species='baduca')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='Capparis' AND (species='baduca' OR species='baduca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crataeva' AND (junior_species='tapia' OR junior_species='tapia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crataeva' AND (species='tapia' OR species='tapia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crataeva' AND (species='tapia' OR species='tapia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crataeva' AND (junior_species='tapia' OR junior_species='tapia')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='Crataeva' AND (species='tapia' OR species='tapia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liabum' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liabum' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liabum' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liabum' AND (junior_species='discolor' OR junior_species='discolor')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='Liabum' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callichlamys' AND (junior_species='latifolia' OR junior_species='latifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callichlamys' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callichlamys' AND (species='latifolia' OR species='latifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callichlamys' AND (junior_species='latifolia' OR junior_species='latifolia')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='Callichlamys' AND (species='latifolia' OR species='latifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichapetalum' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichapetalum' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichapetalum' AND (species='donnellsmithii' OR species='donnellsmithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichapetalum' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')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='Dichapetalum' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='tabascense' OR junior_species='tabascense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='tabascense' OR species='tabascense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='tabascense' OR species='tabascense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='tabascense' OR junior_species='tabascense')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='tabascense' OR species='tabascense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='schiedeanus' OR junior_species='schiedeanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='schiedeanus' OR species='schiedeanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='schiedeanus' OR species='schiedeanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='schiedeanus' OR junior_species='schiedeanus')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='Croton' AND (species='schiedeanus' OR species='schiedeanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphalea' AND (junior_species='oleifera' OR junior_species='oleifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omphalea' AND (species='oleifera' OR species='oleifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omphalea' AND (species='oleifera' OR species='oleifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphalea' AND (junior_species='oleifera' OR junior_species='oleifera')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='Omphalea' AND (species='oleifera' OR species='oleifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='nitidum' OR junior_species='nitidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='nitidum' OR species='nitidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='nitidum' OR species='nitidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='nitidum' OR junior_species='nitidum')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='Sapium' AND (species='nitidum' OR species='nitidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pleuranthodendron' AND (junior_species='lindenii' OR junior_species='lindeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pleuranthodendron' AND (species='lindenii' OR species='lindeni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pleuranthodendron' AND (species='lindenii' OR species='lindeni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pleuranthodendron' AND (junior_species='lindenii' OR junior_species='lindeni')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='Pleuranthodendron' AND (species='lindenii' OR species='lindeni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lunania' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lunania' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lunania' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lunania' AND (junior_species='mexicana' OR junior_species='mexicana')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='Lunania' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauraceae' 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='Lauraceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lauraceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauraceae' 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='Lauraceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauraceae' 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='Lauraceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lauraceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauraceae' 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='Lauraceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='edulis' OR junior_species='edulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rheedia' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rheedia' AND (species='edulis' OR species='edulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='edulis' OR junior_species='edulis')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='Rheedia' AND (species='edulis' OR species='edulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mappia' AND (junior_species='longipes' OR junior_species='longipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mappia' AND (species='longipes' OR species='longipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mappia' AND (species='longipes' OR species='longipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mappia' AND (junior_species='longipes' OR junior_species='longipes')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='Mappia' AND (species='longipes' OR species='longipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' 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='Nectandra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectandra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' 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='Nectandra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='n.' OR junior_species='n.')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='Inga' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' AND (junior_species='floribundum' OR junior_species='floribundum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaerium' AND (species='floribundum' OR species='floribundum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaerium' AND (species='floribundum' OR species='floribundum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' AND (junior_species='floribundum' OR junior_species='floribundum')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='Machaerium' AND (species='floribundum' OR species='floribundum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropteris' AND (junior_species='laurifolia' OR junior_species='laurifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropteris' AND (species='laurifolia' OR species='laurifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropteris' AND (species='laurifolia' OR species='laurifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropteris' AND (junior_species='laurifolia' OR junior_species='laurifolia')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='Heteropteris' AND (species='laurifolia' OR species='laurifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='ambigens' OR junior_species='ambigens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectandra' AND (species='ambigens' OR species='ambigens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectandra' AND (species='ambigens' OR species='ambigens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='ambigens' OR junior_species='ambigens')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='Nectandra' AND (species='ambigens' OR species='ambigens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='martiana' OR junior_species='martiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='martiana' OR species='martiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='martiana' OR species='martiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='martiana' OR junior_species='martiana')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='Trichilia' AND (species='martiana' OR species='martiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='dendrodaphne' OR junior_species='dendrodaphne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='dendrodaphne' OR species='dendrodaphne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='dendrodaphne' OR species='dendrodaphne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='dendrodaphne' OR junior_species='dendrodaphne')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='dendrodaphne' OR species='dendrodaphne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abuta' AND (junior_species='panamensis' OR junior_species='panamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abuta' AND (species='panamensis' OR species='panamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abuta' AND (species='panamensis' OR species='panamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abuta' AND (junior_species='panamensis' OR junior_species='panamensis')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='Abuta' AND (species='panamensis' OR species='panamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='cotinifolia' OR junior_species='cotinifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='cotinifolia' OR species='cotinifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='cotinifolia' OR species='cotinifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='cotinifolia' OR junior_species='cotinifolia')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='cotinifolia' OR species='cotinifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='purpusii' OR junior_species='purpusi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='purpusii' OR species='purpusi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='purpusii' OR species='purpusi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='purpusii' OR junior_species='purpusi')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='Albizia' AND (species='purpusii' OR species='purpusi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynometra' AND (junior_species='retusa' OR junior_species='retusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynometra' AND (species='retusa' OR species='retusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynometra' AND (species='retusa' OR species='retusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynometra' AND (junior_species='retusa' OR junior_species='retusa')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='Cynometra' AND (species='retusa' OR species='retusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='guianense' OR species='guianense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='guianense' OR species='guianense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')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='Dialium' AND (species='guianense' OR species='guianense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dussia' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dussia' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dussia' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dussia' AND (junior_species='mexicana' OR junior_species='mexicana')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='Dussia' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paullinia' AND (junior_species='costaricensis' OR junior_species='costaricensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paullinia' AND (species='costaricensis' OR species='costaricensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paullinia' AND (species='costaricensis' OR species='costaricensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paullinia' AND (junior_species='costaricensis' OR junior_species='costaricensis')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='Paullinia' AND (species='costaricensis' OR species='costaricensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myriocarpa' AND (junior_species='longipes' OR junior_species='longipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myriocarpa' AND (species='longipes' OR species='longipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myriocarpa' AND (species='longipes' OR species='longipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myriocarpa' AND (junior_species='longipes' OR junior_species='longipes')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='Myriocarpa' AND (species='longipes' OR species='longipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchocarpus' AND (junior_species='cruentus' OR junior_species='cruentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchocarpus' AND (species='cruentus' OR species='cruentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchocarpus' AND (species='cruentus' OR species='cruentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchocarpus' AND (junior_species='cruentus' OR junior_species='cruentus')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='Lonchocarpus' AND (species='cruentus' OR species='cruentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchocarpus' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchocarpus' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchocarpus' AND (species='guatemalensis' OR species='guatemalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchocarpus' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')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='Lonchocarpus' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='arboreum' OR junior_species='arboreum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pithecellobium' AND (species='arboreum' OR species='arboreum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pithecellobium' AND (species='arboreum' OR species='arboreum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='arboreum' OR junior_species='arboreum')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='Pithecellobium' AND (species='arboreum' OR species='arboreum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='rohrii' OR junior_species='rohri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocarpus' AND (species='rohrii' OR species='rohri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='rohrii' OR species='rohri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='rohrii' OR junior_species='rohri')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='Pterocarpus' AND (species='rohrii' OR species='rohri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatairea' AND (junior_species='lundellii' OR junior_species='lundelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vatairea' AND (species='lundellii' OR species='lundelli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vatairea' AND (species='lundellii' OR species='lundelli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatairea' AND (junior_species='lundellii' OR junior_species='lundelli')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='Vatairea' AND (species='lundellii' OR species='lundelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Robinsonella' AND (junior_species='mirandae' OR junior_species='mirandae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Robinsonella' AND (species='mirandae' OR species='mirandae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Robinsonella' AND (species='mirandae' OR species='mirandae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Robinsonella' AND (junior_species='mirandae' OR junior_species='mirandae')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='Robinsonella' AND (species='mirandae' OR species='mirandae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='bijuga' OR junior_species='bijuga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='bijuga' OR species='bijuga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='bijuga' OR species='bijuga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='bijuga' OR junior_species='bijuga')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='Guarea' AND (species='bijuga' OR species='bijuga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='glabra' OR junior_species='glabra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='glabra' OR junior_species='glabra')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='Guarea' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='grandifolia' OR junior_species='grandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='grandifolia' OR species='grandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='grandifolia' OR junior_species='grandifolia')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='Guarea' AND (species='grandifolia' OR species='grandifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='alicastrum' OR species='alicastrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')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='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusifolia' OR junior_species='obtusifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='obtusifolia' OR species='obtusifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='obtusifolia' OR species='obtusifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusifolia' OR junior_species='obtusifolia')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='Cecropia' AND (species='obtusifolia' OR species='obtusifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' AND (junior_species='biflora' OR junior_species='biflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clarisia' AND (species='biflora' OR species='biflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clarisia' AND (species='biflora' OR species='biflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' AND (junior_species='biflora' OR junior_species='biflora')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='Clarisia' AND (species='biflora' OR species='biflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='colubrinae' OR junior_species='colubrinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='colubrinae' OR species='colubrinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='colubrinae' OR species='colubrinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='colubrinae' OR junior_species='colubrinae')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='colubrinae' OR species='colubrinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='insipida' OR junior_species='insipida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='insipida' OR species='insipida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='insipida' OR species='insipida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='insipida' OR junior_species='insipida')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='insipida' OR species='insipida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poulsenia' AND (junior_species='armata' OR junior_species='armata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poulsenia' AND (species='armata' OR species='armata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poulsenia' AND (species='armata' OR species='armata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poulsenia' AND (junior_species='armata' OR junior_species='armata')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='Poulsenia' AND (species='armata' OR species='armata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='oxyphyllaria' OR junior_species='oxyphyllaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudolmedia' AND (species='oxyphyllaria' OR species='oxyphyllaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudolmedia' AND (species='oxyphyllaria' OR species='oxyphyllaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='oxyphyllaria' OR junior_species='oxyphyllaria')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='Pseudolmedia' AND (species='oxyphyllaria' OR species='oxyphyllaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trophis' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trophis' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trophis' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trophis' AND (junior_species='mexicana' OR junior_species='mexicana')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='Trophis' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' 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='Neea' AND (species='psychotrioides' OR species='psychotrioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neea' AND (species='psychotrioides' OR species='psychotrioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' 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='Neea' AND (species='psychotrioides' OR species='psychotrioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='amalago' OR junior_species='amalago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piper' AND (species='amalago' OR species='amalago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piper' AND (species='amalago' OR species='amalago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='amalago' OR junior_species='amalago')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='Piper' AND (species='amalago' OR species='amalago') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='barbadensis' OR junior_species='barbadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccoloba' AND (species='barbadensis' OR species='barbadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccoloba' AND (species='barbadensis' OR species='barbadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='barbadensis' OR junior_species='barbadensis')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='Coccoloba' AND (species='barbadensis' OR species='barbadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faramea' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faramea' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faramea' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faramea' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Faramea' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='chagrensis' OR junior_species='chagrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychotria' AND (species='chagrensis' OR species='chagrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='chagrensis' OR species='chagrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='chagrensis' OR junior_species='chagrensis')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='Psychotria' AND (species='chagrensis' OR species='chagrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='faxlucens' OR junior_species='faxlucens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychotria' AND (species='faxlucens' OR species='faxlucens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='faxlucens' OR species='faxlucens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='faxlucens' OR junior_species='faxlucens')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='Psychotria' AND (species='faxlucens' OR species='faxlucens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='simiarum' OR junior_species='simiarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychotria' AND (species='simiarum' OR species='simiarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='simiarum' OR species='simiarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='simiarum' OR junior_species='simiarum')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='Psychotria' AND (species='simiarum' OR species='simiarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='kellermanii' OR junior_species='kellermani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='kellermanii' OR species='kellermani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='kellermanii' OR species='kellermani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='kellermanii' OR junior_species='kellermani')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='Zanthoxylum' AND (species='kellermanii' OR species='kellermani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='campostachis' OR junior_species='campostachis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='campostachis' OR species='campostachis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='campostachis' OR species='campostachis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='campostachis' OR junior_species='campostachis')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='Allophylus' AND (species='campostachis' OR species='campostachis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='saponaria' OR junior_species='saponaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapindus' AND (species='saponaria' OR species='saponaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapindus' AND (species='saponaria' OR species='saponaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='saponaria' OR junior_species='saponaria')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='saponaria' OR species='saponaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipholis' AND (junior_species='minutiflora' OR junior_species='minutiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipholis' AND (species='minutiflora' OR species='minutiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipholis' AND (species='minutiflora' OR species='minutiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipholis' AND (junior_species='minutiflora' OR junior_species='minutiflora')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='Dipholis' AND (species='minutiflora' OR species='minutiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='campechiana' OR junior_species='campechiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='campechiana' OR species='campechiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='campechiana' OR species='campechiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='campechiana' OR junior_species='campechiana')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='Pouteria' AND (species='campechiana' OR species='campechiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='durlandii' OR junior_species='durlandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='durlandii' OR species='durlandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='durlandii' OR species='durlandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='durlandii' OR junior_species='durlandi')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='Pouteria' AND (species='durlandii' OR species='durlandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' 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='Pouteria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' 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='Pouteria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turpinia' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turpinia' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turpinia' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turpinia' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Turpinia' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mortoniodendron' AND (junior_species='guatemalense' OR junior_species='guatemalense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mortoniodendron' AND (species='guatemalense' OR species='guatemalense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mortoniodendron' AND (species='guatemalense' OR species='guatemalense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mortoniodendron' AND (junior_species='guatemalense' OR junior_species='guatemalense')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='Mortoniodendron' AND (species='guatemalense' OR species='guatemalense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichospermum' AND (junior_species='mexicanum' OR junior_species='mexicanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichospermum' AND (species='mexicanum' OR species='mexicanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichospermum' AND (species='mexicanum' OR species='mexicanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichospermum' AND (junior_species='mexicanum' OR junior_species='mexicanum')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='Trichospermum' AND (species='mexicanum' OR species='mexicanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelocera' AND (junior_species='hottlei' OR junior_species='hottleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ampelocera' AND (species='hottlei' OR species='hottleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ampelocera' AND (species='hottlei' OR species='hottleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelocera' AND (junior_species='hottlei' OR junior_species='hottleii')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='Ampelocera' AND (species='hottlei' OR species='hottleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegiphila' AND (junior_species='costaricensis' OR junior_species='costaricensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegiphila' AND (species='costaricensis' OR species='costaricensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegiphila' AND (species='costaricensis' OR species='costaricensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegiphila' AND (junior_species='costaricensis' OR junior_species='costaricensis')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='Aegiphila' AND (species='costaricensis' OR species='costaricensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthion' AND (junior_species='oblanceolatum' OR junior_species='oblanceolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthion' AND (species='oblanceolatum' OR species='oblanceolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthion' AND (species='oblanceolatum' OR species='oblanceolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthion' AND (junior_species='oblanceolatum' OR junior_species='oblanceolatum')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='Orthion' AND (species='oblanceolatum' OR species='oblanceolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='guatemalensis' OR species='guatemalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')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='Rinorea' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vochysia' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vochysia' AND (species='guatemalensis' OR species='guatemalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')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='Vochysia' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=115