Coordinate: 4° 36' 31" N, 54° 16' 44" W
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=183 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=183SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=72SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=183 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Qualea' AND (junior_species='rosea' OR junior_species='rosea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Qualea' AND (species='rosea' OR species='rosea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Qualea' AND (species='rosea' OR species='rosea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Qualea' AND (junior_species='rosea' OR junior_species='rosea')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='Qualea' AND (species='rosea' OR species='rosea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='persistens' OR junior_species='persistens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='persistens' OR species='persistens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='persistens' OR species='persistens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='persistens' OR junior_species='persistens')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='Lecythis' AND (species='persistens' OR species='persistens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' 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='Eschweilera' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' 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='Eschweilera' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='grandiflora' OR junior_species='grandiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='grandiflora' OR species='grandiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='grandiflora' OR species='grandiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='grandiflora' OR junior_species='grandiflora')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='Eschweilera' AND (species='grandiflora' OR species='grandiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minquartia' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Minquartia' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Minquartia' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minquartia' AND (junior_species='guianensis' OR junior_species='guianensis')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='Minquartia' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chimarrhis' AND (junior_species='turbinata' OR junior_species='turbinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chimarrhis' AND (species='turbinata' OR species='turbinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chimarrhis' AND (species='turbinata' OR species='turbinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chimarrhis' AND (junior_species='turbinata' OR junior_species='turbinata')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='Chimarrhis' AND (species='turbinata' OR species='turbinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='scrobiculata' OR junior_species='scrobiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='scrobiculata' OR species='scrobiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='scrobiculata' OR species='scrobiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='scrobiculata' OR junior_species='scrobiculata')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='Cupania' AND (species='scrobiculata' OR species='scrobiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrobangia' AND (species='boliviana' OR species='boliviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrobangia' AND (species='boliviana' OR species='boliviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' AND (junior_species='boliviana' OR junior_species='boliviana')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='Dendrobangia' AND (species='boliviana' OR species='boliviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='longipedunculata' OR junior_species='longipedunculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='longipedunculata' OR species='longipedunculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='longipedunculata' OR species='longipedunculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='longipedunculata' OR junior_species='longipedunculata')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='longipedunculata' OR species='longipedunculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='aurantiaca' OR species='aurantiaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')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='Lecythis' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='subincanum' OR junior_species='subincanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='subincanum' OR species='subincanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='subincanum' OR species='subincanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='subincanum' OR junior_species='subincanum')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='Theobroma' AND (species='subincanum' OR species='subincanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' 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='Psychotria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' 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='Psychotria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='pruriens' OR junior_species='pruriens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='pruriens' OR species='pruriens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='pruriens' OR species='pruriens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='pruriens' OR junior_species='pruriens')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='Sterculia' AND (species='pruriens' OR species='pruriens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='nitida' OR junior_species='nitida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xylopia' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='hexapetala' OR junior_species='hexapetala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gustavia' AND (species='hexapetala' OR species='hexapetala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gustavia' AND (species='hexapetala' OR species='hexapetala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='hexapetala' OR junior_species='hexapetala')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='Gustavia' AND (species='hexapetala' OR species='hexapetala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='sagotiana' OR junior_species='sagotiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iryanthera' AND (species='sagotiana' OR species='sagotiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iryanthera' AND (species='sagotiana' OR species='sagotiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='sagotiana' OR junior_species='sagotiana')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='Iryanthera' AND (species='sagotiana' OR species='sagotiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miconia' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='acuminata' OR junior_species='acuminata')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='Miconia' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='opacum' OR junior_species='opacum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='opacum' OR species='opacum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='opacum' OR species='opacum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='opacum' OR junior_species='opacum')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='Protium' AND (species='opacum' OR species='opacum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='duckei' OR junior_species='duckeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='duckei' OR species='duckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='duckei' OR species='duckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='duckei' OR junior_species='duckeii')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='duckei' OR species='duckeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='melinonii' OR junior_species='melinoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachigali' AND (species='melinonii' OR species='melinoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigali' AND (species='melinonii' OR species='melinoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='melinonii' OR junior_species='melinoni')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='Tachigali' AND (species='melinonii' OR species='melinoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapura' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapura' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' AND (junior_species='guianensis' OR junior_species='guianensis')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='Tapura' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='kwatae' OR junior_species='kwatae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='kwatae' OR species='kwatae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='kwatae' OR species='kwatae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='kwatae' OR junior_species='kwatae')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='Virola' AND (species='kwatae' OR species='kwatae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='huberi' OR junior_species='huberii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='huberi' OR species='huberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='huberi' OR species='huberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='huberi' OR junior_species='huberii')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='huberi' OR species='huberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poraqueiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poraqueiba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poraqueiba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poraqueiba' AND (junior_species='guianensis' OR junior_species='guianensis')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='Poraqueiba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodostemonodaphne' AND (junior_species='kunthiana' OR junior_species='kunthiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodostemonodaphne' AND (species='kunthiana' OR species='kunthiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodostemonodaphne' AND (species='kunthiana' OR species='kunthiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodostemonodaphne' AND (junior_species='kunthiana' OR junior_species='kunthiana')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='Rhodostemonodaphne' AND (species='kunthiana' OR species='kunthiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' 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='Sloanea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sloanea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' 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='Sloanea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vantanea' AND (junior_species='parviflora' OR junior_species='parviflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vantanea' AND (species='parviflora' OR species='parviflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vantanea' AND (species='parviflora' OR species='parviflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vantanea' AND (junior_species='parviflora' OR junior_species='parviflora')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='Vantanea' AND (species='parviflora' OR species='parviflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aniba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aniba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aniba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aniba' AND (junior_species='guianensis' OR junior_species='guianensis')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='Aniba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombacopsis' AND (junior_species='nervosa' OR junior_species='nervosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombacopsis' AND (species='nervosa' OR species='nervosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombacopsis' AND (species='nervosa' OR species='nervosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombacopsis' AND (junior_species='nervosa' OR junior_species='nervosa')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='Bombacopsis' AND (species='nervosa' OR species='nervosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='glabrum' OR junior_species='glabrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryocar' AND (species='glabrum' OR species='glabrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryocar' AND (species='glabrum' OR species='glabrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='glabrum' OR junior_species='glabrum')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='Caryocar' AND (species='glabrum' OR species='glabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erisma' AND (junior_species='uncinatum' OR junior_species='uncinatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erisma' AND (species='uncinatum' OR species='uncinatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erisma' AND (species='uncinatum' OR species='uncinatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erisma' AND (junior_species='uncinatum' OR junior_species='uncinatum')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='Erisma' AND (species='uncinatum' OR species='uncinatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fusaea' AND (junior_species='longifolia' OR junior_species='longifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fusaea' AND (species='longifolia' OR species='longifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fusaea' AND (species='longifolia' OR species='longifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fusaea' AND (junior_species='longifolia' OR junior_species='longifolia')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='Fusaea' AND (species='longifolia' OR species='longifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacaranda' AND (junior_species='copaia' OR junior_species='copaia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jacaranda' AND (species='copaia' OR species='copaia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jacaranda' AND (species='copaia' OR species='copaia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacaranda' AND (junior_species='copaia' OR junior_species='copaia')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='Jacaranda' AND (species='copaia' OR species='copaia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loreya' AND (junior_species='arborescens' OR junior_species='arborescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loreya' AND (species='arborescens' OR species='arborescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loreya' AND (species='arborescens' OR species='arborescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loreya' AND (junior_species='arborescens' OR junior_species='arborescens')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='Loreya' AND (species='arborescens' OR species='arborescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' AND (junior_species='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrciaria' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrciaria' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' AND (junior_species='dubia' OR junior_species='dubia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrciaria' AND (species='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrtaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') 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='Pouteria' AND (junior_species='cuspidata' OR junior_species='cuspidata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='cuspidata' OR species='cuspidata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='cuspidata' OR species='cuspidata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='cuspidata' OR junior_species='cuspidata')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='cuspidata' OR species='cuspidata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='decandrum' OR junior_species='decandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='decandrum' OR species='decandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='decandrum' OR species='decandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='decandrum' OR junior_species='decandrum')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='Protium' AND (species='decandrum' OR species='decandrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruizterania' AND (junior_species='albiflora' OR junior_species='albiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruizterania' AND (species='albiflora' OR species='albiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruizterania' AND (species='albiflora' OR species='albiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruizterania' AND (junior_species='albiflora' OR junior_species='albiflora')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='Ruizterania' AND (species='albiflora' OR species='albiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaba' AND (junior_species='polyphylla' OR junior_species='polyphylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simaba' AND (species='polyphylla' OR species='polyphylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simaba' AND (species='polyphylla' OR species='polyphylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaba' AND (junior_species='polyphylla' OR junior_species='polyphylla')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='Simaba' AND (species='polyphylla' OR species='polyphylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unonopsis' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Unonopsis' AND (species='rufescens' OR species='rufescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Unonopsis' AND (species='rufescens' OR species='rufescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unonopsis' AND (junior_species='rufescens' OR junior_species='rufescens')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='Unonopsis' AND (species='rufescens' OR species='rufescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaioua' 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='Amaioua' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amaioua' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaioua' 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='Amaioua' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='carbonaria' OR junior_species='carbonaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='carbonaria' OR species='carbonaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='carbonaria' OR species='carbonaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='carbonaria' OR junior_species='carbonaria')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='carbonaria' OR species='carbonaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goupia' 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='Goupia' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goupia' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goupia' 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='Goupia' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' 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='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='Inga' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' 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='sarmentosa' OR junior_species='sarmentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='sarmentosa' OR species='sarmentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='sarmentosa' OR species='sarmentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='sarmentosa' OR junior_species='sarmentosa')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='sarmentosa' OR species='sarmentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacmellea' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacmellea' AND (species='aculeata' OR species='aculeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacmellea' AND (species='aculeata' OR species='aculeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacmellea' AND (junior_species='aculeata' OR junior_species='aculeata')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='Lacmellea' AND (species='aculeata' OR species='aculeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laetia' AND (junior_species='procera' OR junior_species='procera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laetia' AND (species='procera' OR species='procera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laetia' AND (species='procera' OR species='procera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laetia' AND (junior_species='procera' OR junior_species='procera')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='Laetia' AND (species='procera' OR species='procera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' 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='Cordia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' 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='Cordia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='holcogyne' OR junior_species='holcogyne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='holcogyne' OR species='holcogyne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='holcogyne' OR species='holcogyne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='holcogyne' OR junior_species='holcogyne')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='Lecythis' AND (species='holcogyne' OR species='holcogyne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='huberi' OR junior_species='huberii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='huberi' OR species='huberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='huberi' OR species='huberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='huberi' OR junior_species='huberii')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='Mouriri' AND (species='huberi' OR species='huberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrtaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='coccinea' OR junior_species='coccinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ormosia' AND (species='coccinea' OR species='coccinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ormosia' AND (species='coccinea' OR species='coccinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='coccinea' OR junior_species='coccinea')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='Ormosia' AND (species='coccinea' OR species='coccinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='singularis' OR junior_species='singularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='singularis' OR species='singularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='singularis' OR species='singularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='singularis' OR junior_species='singularis')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='singularis' OR species='singularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pradosia' AND (junior_species='ptychandra' OR junior_species='ptychandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pradosia' AND (species='ptychandra' OR species='ptychandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pradosia' AND (species='ptychandra' OR species='ptychandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pradosia' AND (junior_species='ptychandra' OR junior_species='ptychandra')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='Pradosia' AND (species='ptychandra' OR species='ptychandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='giganteum' OR junior_species='giganteum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='giganteum' OR species='giganteum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='giganteum' OR species='giganteum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='giganteum' OR junior_species='giganteum')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='Protium' AND (species='giganteum' OR species='giganteum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psidium' 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='Psidium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psidium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psidium' 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='Psidium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' 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='Tetragastris' AND (species='panamensis' OR species='panamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragastris' AND (species='panamensis' OR species='panamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' 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='Tetragastris' AND (species='panamensis' OR species='panamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyrsodium' AND (junior_species='puberulum' OR junior_species='puberulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyrsodium' AND (species='puberulum' OR species='puberulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyrsodium' AND (species='puberulum' OR species='puberulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyrsodium' AND (junior_species='puberulum' OR junior_species='puberulum')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='Thyrsodium' AND (species='puberulum' OR species='puberulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' 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='Tovomita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tovomita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' 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='Tovomita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelii' OR junior_species='micheli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='michelii' OR species='micheli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='michelii' OR species='micheli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelii' OR junior_species='micheli')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='Virola' AND (species='michelii' OR species='micheli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='tomentosa' OR junior_species='tomentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vochysia' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vochysia' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='tomentosa' OR junior_species='tomentosa')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='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vouarana' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vouarana' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vouarana' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vouarana' AND (junior_species='guianensis' OR junior_species='guianensis')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='Vouarana' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' 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='Allophylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' 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='Allophylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' 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='Allophylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' 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='Allophylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='marcgravianum' OR junior_species='marcgravianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='marcgravianum' OR species='marcgravianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='marcgravianum' OR species='marcgravianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='marcgravianum' OR junior_species='marcgravianum')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='marcgravianum' OR species='marcgravianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astrocaryum' AND (junior_species='sciophilum' OR junior_species='sciophilum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astrocaryum' AND (species='sciophilum' OR species='sciophilum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astrocaryum' AND (species='sciophilum' OR species='sciophilum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astrocaryum' AND (junior_species='sciophilum' OR junior_species='sciophilum')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='Astrocaryum' AND (species='sciophilum' OR species='sciophilum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bocoa' AND (junior_species='prouacensis' OR junior_species='prouacensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bocoa' AND (species='prouacensis' OR species='prouacensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bocoa' AND (species='prouacensis' OR species='prouacensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bocoa' AND (junior_species='prouacensis' OR junior_species='prouacensis')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='Bocoa' AND (species='prouacensis' OR species='prouacensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='rubescens' OR junior_species='rubescens')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='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capirona' AND (junior_species='decorticans' OR junior_species='decorticans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capirona' AND (species='decorticans' OR species='decorticans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capirona' AND (species='decorticans' OR species='decorticans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capirona' AND (junior_species='decorticans' OR junior_species='decorticans')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='Capirona' AND (species='decorticans' OR species='decorticans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusa' OR junior_species='obtusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='obtusa' OR species='obtusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='obtusa' OR species='obtusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusa' OR junior_species='obtusa')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='obtusa' OR species='obtusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiloclinium' AND (junior_species='cognatum' OR junior_species='cognatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheiloclinium' AND (species='cognatum' OR species='cognatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheiloclinium' AND (species='cognatum' OR species='cognatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiloclinium' AND (junior_species='cognatum' OR junior_species='cognatum')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='Cheiloclinium' AND (species='cognatum' OR species='cognatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='prieurii' OR junior_species='prieuri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='prieurii' OR species='prieuri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='prieurii' OR species='prieuri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='prieurii' OR junior_species='prieuri')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='Chrysophyllum' AND (species='prieurii' OR species='prieuri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conceveiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conceveiba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conceveiba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conceveiba' AND (junior_species='guianensis' OR junior_species='guianensis')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='Conceveiba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Couratari' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Couratari' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' AND (junior_species='guianensis' OR junior_species='guianensis')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='Couratari' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='nitens' OR junior_species='nitens')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='Dacryodes' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='variabilis' OR junior_species='variabilis')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='Drypetes' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dussia' 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='Dussia' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dussia' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dussia' 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='Dussia' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='apiculata' OR junior_species='apiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='apiculata' OR species='apiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='apiculata' OR species='apiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='apiculata' OR junior_species='apiculata')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='Eschweilera' AND (species='apiculata' OR species='apiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='chartaceifolia' OR junior_species='chartaceifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='chartaceifolia' OR species='chartaceifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='chartaceifolia' OR species='chartaceifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='chartaceifolia' OR junior_species='chartaceifolia')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='Eschweilera' AND (species='chartaceifolia' OR species='chartaceifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='pedicellata' OR junior_species='pedicellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='pedicellata' OR species='pedicellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='pedicellata' OR species='pedicellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='pedicellata' OR junior_species='pedicellata')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='Eschweilera' AND (species='pedicellata' OR species='pedicellata') 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='Eugenia' AND (junior_species='patrisii' OR junior_species='patrisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='patrisii' OR species='patrisi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='patrisii' OR species='patrisi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='patrisii' OR junior_species='patrisi')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='patrisii' OR species='patrisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ferdinandusa' AND (junior_species='paraensis' OR junior_species='paraensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ferdinandusa' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ferdinandusa' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ferdinandusa' AND (junior_species='paraensis' OR junior_species='paraensis')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='Ferdinandusa' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') 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='Henriettella' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Henriettella' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Henriettella' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henriettella' AND (junior_species='flavescens' OR junior_species='flavescens')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='Henriettella' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='gracilifolia' OR junior_species='gracilifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='gracilifolia' OR species='gracilifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='gracilifolia' OR species='gracilifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='gracilifolia' OR junior_species='gracilifolia')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='gracilifolia' OR species='gracilifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='pezizifera' OR junior_species='pezizifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='pezizifera' OR species='pezizifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='pezizifera' OR species='pezizifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='pezizifera' OR junior_species='pezizifera')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='pezizifera' OR species='pezizifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacunaria' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacunaria' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='crenata' OR junior_species='crenata')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='Lacunaria' AND (species='crenata' OR species='crenata') 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='Lecythis' AND (junior_species='poiteaui' OR junior_species='poiteauii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='poiteaui' OR species='poiteauii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='poiteaui' OR species='poiteauii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='poiteaui' OR junior_species='poiteauii')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='Lecythis' AND (species='poiteaui' OR species='poiteauii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='praeclara' OR junior_species='praeclara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='praeclara' OR species='praeclara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='praeclara' OR species='praeclara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='praeclara' OR junior_species='praeclara')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='Lecythis' AND (species='praeclara' OR species='praeclara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macoubea' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macoubea' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macoubea' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macoubea' AND (junior_species='guianensis' OR junior_species='guianensis')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='Macoubea' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maquira' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maquira' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='guianensis' OR junior_species='guianensis')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='Maquira' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' 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='Maytenus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maytenus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' 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='Maytenus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' 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='Miconia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='guyanensis' OR junior_species='guyanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropholis' AND (species='guyanensis' OR species='guyanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='guyanensis' OR species='guyanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='guyanensis' OR junior_species='guyanensis')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='Micropholis' AND (species='guyanensis' OR species='guyanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='sanctaerosae' OR junior_species='sanctaerosae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropholis' AND (species='sanctaerosae' OR species='sanctaerosae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='sanctaerosae' OR species='sanctaerosae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='sanctaerosae' OR junior_species='sanctaerosae')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='Micropholis' AND (species='sanctaerosae' OR species='sanctaerosae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moronobea' AND (junior_species='coccinea' OR junior_species='coccinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moronobea' AND (species='coccinea' OR species='coccinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moronobea' AND (species='coccinea' OR species='coccinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moronobea' AND (junior_species='coccinea' OR junior_species='coccinea')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='Moronobea' AND (species='coccinea' OR species='coccinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='crassifolia' OR junior_species='crassifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='crassifolia' OR species='crassifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='crassifolia' OR species='crassifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='crassifolia' OR junior_species='crassifolia')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='Mouriri' AND (species='crassifolia' OR species='crassifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' 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='Mouriri' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' 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='Mouriri' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrtaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrtaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrtaceae' 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='Myrtaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' 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='Neea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' 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='Neea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctaginaceae' 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='Nyctaginaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctaginaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctaginaceae' 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='Nyctaginaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='schomburgkiana' OR junior_species='schomburgkiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='schomburgkiana' OR species='schomburgkiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='schomburgkiana' OR species='schomburgkiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='schomburgkiana' OR junior_species='schomburgkiana')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='schomburgkiana' OR species='schomburgkiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteophloeum' AND (junior_species='platyspermum' OR junior_species='platyspermum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osteophloeum' AND (species='platyspermum' OR species='platyspermum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteophloeum' AND (species='platyspermum' OR species='platyspermum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteophloeum' AND (junior_species='platyspermum' OR junior_species='platyspermum')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='Osteophloeum' AND (species='platyspermum' OR species='platyspermum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkia' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='nitida' OR junior_species='nitida')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='Parkia' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' 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='Platymiscium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platymiscium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' 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='Platymiscium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Posoqueria' 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='Posoqueria' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Posoqueria' AND (species='latifolia' OR species='latifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Posoqueria' 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='Posoqueria' AND (species='latifolia' OR species='latifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='velutina' OR junior_species='velutina')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='Pourouma' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='bangii' OR junior_species='bangi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='bangii' OR species='bangi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='bangii' OR species='bangi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='bangii' OR junior_species='bangi')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='bangii' OR species='bangi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='decorticans' OR junior_species='decorticans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='decorticans' OR species='decorticans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='decorticans' OR species='decorticans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='decorticans' OR junior_species='decorticans')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='decorticans' OR species='decorticans') 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='fimbriata' OR junior_species='fimbriata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='fimbriata' OR species='fimbriata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='fimbriata' OR species='fimbriata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='fimbriata' OR junior_species='fimbriata')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='fimbriata' OR species='fimbriata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='guianensis' OR junior_species='guianensis')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='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='jariensis' OR junior_species='jariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='jariensis' OR species='jariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='jariensis' OR species='jariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='jariensis' OR junior_species='jariensis')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='jariensis' OR species='jariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='petiolata' OR junior_species='petiolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='petiolata' OR species='petiolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='petiolata' OR species='petiolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='petiolata' OR junior_species='petiolata')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='petiolata' OR species='petiolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='rodriguesiana' OR junior_species='rodriguesiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='rodriguesiana' OR species='rodriguesiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='rodriguesiana' OR species='rodriguesiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='rodriguesiana' OR junior_species='rodriguesiana')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='rodriguesiana' OR species='rodriguesiana') 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='Pouteria' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='speciosa' OR junior_species='speciosa')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='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='torta' OR junior_species='torta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='torta' OR species='torta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='torta' OR species='torta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='torta' OR junior_species='torta')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='torta' OR species='torta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='guianense' OR species='guianense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='guianense' OR species='guianense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='guianense' OR species='guianense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' 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='Protium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopiptadenia' AND (junior_species='suaveolens' OR junior_species='suaveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopiptadenia' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopiptadenia' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopiptadenia' AND (junior_species='suaveolens' OR junior_species='suaveolens')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='Pseudopiptadenia' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodostemonodaphne' AND (junior_species='rufovirgata' OR junior_species='rufovirgata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodostemonodaphne' AND (species='rufovirgata' OR species='rufovirgata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodostemonodaphne' AND (species='rufovirgata' OR species='rufovirgata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodostemonodaphne' AND (junior_species='rufovirgata' OR junior_species='rufovirgata')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='Rhodostemonodaphne' AND (species='rufovirgata' OR species='rufovirgata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siparuna' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siparuna' AND (species='cristata' OR species='cristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='cristata' OR junior_species='cristata')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='Siparuna' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stryphnodendron' AND (junior_species='polystachyum' OR junior_species='polystachyum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stryphnodendron' AND (species='polystachyum' OR species='polystachyum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stryphnodendron' AND (species='polystachyum' OR species='polystachyum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stryphnodendron' AND (junior_species='polystachyum' OR junior_species='polystachyum')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='Stryphnodendron' AND (species='polystachyum' OR species='polystachyum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' 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='Styrax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' 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='Styrax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' 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='Styrax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' 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='Styrax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' 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='Symphonia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symphonia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' 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='Symphonia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Handroanthus' AND (junior_species='serratifolius' OR junior_species='serratifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Handroanthus' AND (species='serratifolius' OR species='serratifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Handroanthus' AND (species='serratifolius' OR species='serratifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Handroanthus' AND (junior_species='serratifolius' OR junior_species='serratifolius')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='Handroanthus' AND (species='serratifolius' OR species='serratifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' 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='Tabernaemontana' AND (species='attenuata' OR species='attenuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='attenuata' OR species='attenuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' 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='Tabernaemontana' AND (species='attenuata' OR species='attenuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='undulata' OR junior_species='undulata')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='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='simaboides' OR junior_species='simaboides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talisia' AND (species='simaboides' OR species='simaboides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talisia' AND (species='simaboides' OR species='simaboides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='simaboides' OR junior_species='simaboides')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='Talisia' AND (species='simaboides' OR species='simaboides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirira' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapirira' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapirira' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirira' AND (junior_species='guianensis' OR junior_species='guianensis')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='Tapirira' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirira' AND (junior_species='obtusa' OR junior_species='obtusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapirira' AND (species='obtusa' OR species='obtusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapirira' AND (species='obtusa' OR species='obtusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirira' AND (junior_species='obtusa' OR junior_species='obtusa')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='Tapirira' AND (species='obtusa' OR species='obtusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='amazonia' OR junior_species='amazonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='amazonia' OR species='amazonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='amazonia' OR species='amazonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='amazonia' OR junior_species='amazonia')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='Terminalia' AND (species='amazonia' OR species='amazonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='velutina' OR junior_species='velutina')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='Theobroma' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyrsodium' AND (junior_species='spruceanum' OR junior_species='spruceanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyrsodium' AND (species='spruceanum' OR species='spruceanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyrsodium' AND (species='spruceanum' OR species='spruceanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyrsodium' AND (junior_species='spruceanum' OR junior_species='spruceanum')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='Thyrsodium' AND (species='spruceanum' OR species='spruceanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' 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='Tovomita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tovomita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' 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='Tovomita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='multicostata' OR junior_species='multicostata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='multicostata' OR species='multicostata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='multicostata' OR species='multicostata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='multicostata' OR junior_species='multicostata')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='Virola' AND (species='multicostata' OR species='multicostata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='triflora' OR junior_species='triflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='triflora' OR species='triflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='triflora' OR species='triflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='triflora' OR junior_species='triflora')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='Vitex' AND (species='triflora' OR species='triflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygia' 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='Zygia' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygia' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygia' 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='Zygia' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=183