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=3321 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3321SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3058SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3321 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' AND (junior_species='lecointei' OR junior_species='lecointeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astronium' AND (species='lecointei' OR species='lecointeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astronium' AND (species='lecointei' OR species='lecointeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' AND (junior_species='lecointei' OR junior_species='lecointeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Astronium' AND (species='lecointei' OR species='lecointeii') 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='Bocageopsis' AND (junior_species='multiflora' OR junior_species='multiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bocageopsis' AND (species='multiflora' OR species='multiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bocageopsis' AND (species='multiflora' OR species='multiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bocageopsis' AND (junior_species='multiflora' OR junior_species='multiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bocageopsis' AND (species='multiflora' OR species='multiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guatteria' 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='Guatteria' AND (species='procera' OR species='procera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guatteria' AND (species='procera' OR species='procera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guatteria' 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='Guatteria' AND (species='procera' OR species='procera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rollinia' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rollinia' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rollinia' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rollinia' AND (junior_species='insignis' OR junior_species='insignis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rollinia' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='carapanauba' OR junior_species='carapanauba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='carapanauba' OR species='carapanauba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='carapanauba' OR species='carapanauba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='carapanauba' OR junior_species='carapanauba')SELECT d.diet,d.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='carapanauba' OR species='carapanauba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='oblongum' OR junior_species='oblongum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='oblongum' OR species='oblongum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='oblongum' OR species='oblongum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='oblongum' OR junior_species='oblongum')SELECT d.diet,d.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='oblongum' OR species='oblongum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geissospermum' AND (junior_species='sericeum' OR junior_species='sericeum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geissospermum' AND (species='sericeum' OR species='sericeum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geissospermum' AND (species='sericeum' OR species='sericeum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geissospermum' AND (junior_species='sericeum' OR junior_species='sericeum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geissospermum' AND (species='sericeum' OR species='sericeum') 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='Tabebuia' AND (junior_species='impetiginosa' OR junior_species='impetiginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='impetiginosa' OR species='impetiginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='impetiginosa' OR species='impetiginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='impetiginosa' OR junior_species='impetiginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='impetiginosa' OR species='impetiginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='serratifolia' OR junior_species='serratifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='serratifolia' OR species='serratifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='serratifolia' OR species='serratifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='serratifolia' OR junior_species='serratifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='serratifolia' OR species='serratifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bixa' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bixa' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bixa' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bixa' AND (junior_species='arborea' OR junior_species='arborea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bixa' AND (species='arborea' OR species='arborea') 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='Huberodendron' AND (junior_species='swietenioides' OR junior_species='swietenioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Huberodendron' AND (species='swietenioides' OR species='swietenioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Huberodendron' AND (species='swietenioides' OR species='swietenioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Huberodendron' AND (junior_species='swietenioides' OR junior_species='swietenioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Huberodendron' AND (species='swietenioides' OR species='swietenioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='ochrocalyx' OR junior_species='ochrocalyx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='ochrocalyx' OR species='ochrocalyx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='ochrocalyx' OR species='ochrocalyx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='ochrocalyx' OR junior_species='ochrocalyx')SELECT d.diet,d.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='ochrocalyx' OR species='ochrocalyx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='goeldiana' OR junior_species='goeldiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='goeldiana' OR species='goeldiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='goeldiana' OR species='goeldiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='goeldiana' OR junior_species='goeldiana')SELECT d.diet,d.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='goeldiana' OR species='goeldiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crepidospermum' AND (junior_species='rhoifolium' OR junior_species='rhoifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crepidospermum' AND (species='rhoifolium' OR species='rhoifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crepidospermum' AND (species='rhoifolium' OR species='rhoifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crepidospermum' AND (junior_species='rhoifolium' OR junior_species='rhoifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crepidospermum' AND (species='rhoifolium' OR species='rhoifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='altissima' OR junior_species='altissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragastris' AND (species='altissima' OR species='altissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragastris' AND (species='altissima' OR species='altissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='altissima' OR junior_species='altissima')SELECT d.diet,d.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='altissima' OR species='altissima') 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='Tetragastris' AND (junior_species='trifoliolata' OR junior_species='trifoliolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragastris' AND (species='trifoliolata' OR species='trifoliolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragastris' AND (species='trifoliolata' OR species='trifoliolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='trifoliolata' OR junior_species='trifoliolata')SELECT d.diet,d.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='trifoliolata' OR species='trifoliolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchenavia' AND (junior_species='parvifolia' OR junior_species='parvifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchenavia' AND (species='parvifolia' OR species='parvifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchenavia' AND (species='parvifolia' OR species='parvifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchenavia' AND (junior_species='parvifolia' OR junior_species='parvifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Buchenavia' AND (species='parvifolia' OR species='parvifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='latifolia' OR species='latifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='latifolia' OR species='latifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parinari' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parinari' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parinari' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' 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='Tapura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' 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='Tapura' 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='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Aparisthmium' AND (junior_species='cordatum' OR junior_species='cordatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aparisthmium' AND (species='cordatum' OR species='cordatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aparisthmium' AND (species='cordatum' OR species='cordatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aparisthmium' AND (junior_species='cordatum' OR junior_species='cordatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aparisthmium' AND (species='cordatum' OR species='cordatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' 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='Croton' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' 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='Croton' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hevea' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hevea' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hevea' AND (species='brasiliensis' OR species='brasiliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hevea' AND (junior_species='brasiliensis' OR junior_species='brasiliensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hevea' AND (species='brasiliensis' OR species='brasiliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabea' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabea' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' AND (junior_species='caudata' OR junior_species='caudata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mabea' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrandra' 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='Micrandra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrandra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrandra' 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='Micrandra' 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='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='Casearia' AND (species='grandiflora' OR species='grandiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='grandiflora' OR species='grandiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='grandiflora' OR species='grandiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symphonia' AND (species='globulifera' OR species='globulifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symphonia' AND (species='globulifera' OR species='globulifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')SELECT d.diet,d.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='globulifera' OR species='globulifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' AND (junior_species='macrophylla' OR junior_species='macrophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tovomita' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tovomita' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' AND (junior_species='macrophylla' OR junior_species='macrophylla')SELECT d.diet,d.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='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vismia' AND (junior_species='cayennensis' OR junior_species='cayennensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vismia' AND (species='cayennensis' OR species='cayennensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vismia' AND (species='cayennensis' OR species='cayennensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vismia' AND (junior_species='cayennensis' OR junior_species='cayennensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vismia' AND (species='cayennensis' OR species='cayennensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' 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='Dendrobangia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrobangia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' 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='Dendrobangia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicypellum' AND (junior_species='manausense' OR junior_species='manausense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicypellum' AND (species='manausense' OR species='manausense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicypellum' AND (species='manausense' OR species='manausense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicypellum' AND (junior_species='manausense' OR junior_species='manausense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dicypellum' AND (species='manausense' OR species='manausense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='canaliculata' OR junior_species='canaliculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='canaliculata' OR species='canaliculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='canaliculata' OR species='canaliculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='canaliculata' OR junior_species='canaliculata')SELECT d.diet,d.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='canaliculata' OR species='canaliculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='opifera' OR junior_species='opifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='opifera' OR species='opifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='opifera' OR species='opifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='opifera' OR junior_species='opifera')SELECT d.diet,d.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='opifera' OR species='opifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bertholletia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bertholletia' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bertholletia' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bertholletia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bertholletia' AND (species='excelsa' OR species='excelsa') 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='Eschweilera' AND (junior_species='fracta' OR junior_species='fracta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='fracta' OR species='fracta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='fracta' OR species='fracta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='fracta' OR junior_species='fracta')SELECT d.diet,d.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='fracta' OR species='fracta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='odora' OR junior_species='odora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='odora' OR species='odora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='odora' OR species='odora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='odora' OR junior_species='odora')SELECT d.diet,d.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='odora' OR species='odora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' 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='Eschweilera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' 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='Eschweilera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apuleia' AND (junior_species='molaris' OR junior_species='molaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apuleia' AND (species='molaris' OR species='molaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apuleia' AND (species='molaris' OR species='molaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apuleia' AND (junior_species='molaris' OR junior_species='molaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apuleia' AND (species='molaris' OR species='molaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='acreana' OR junior_species='acreana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bauhinia' AND (species='acreana' OR species='acreana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bauhinia' AND (species='acreana' OR species='acreana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='acreana' OR junior_species='acreana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bauhinia' AND (species='acreana' OR species='acreana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' AND (junior_species='multijuga' OR junior_species='multijuga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copaifera' AND (species='multijuga' OR species='multijuga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copaifera' AND (species='multijuga' OR species='multijuga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' AND (junior_species='multijuga' OR junior_species='multijuga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Copaifera' AND (species='multijuga' OR species='multijuga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='guianense' OR species='guianense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='guianense' OR species='guianense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialium' AND (species='guianense' OR species='guianense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplotropis' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplotropis' AND (species='purpurea' OR species='purpurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplotropis' AND (species='purpurea' OR species='purpurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplotropis' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diplotropis' AND (species='purpurea' OR species='purpurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipteryx' AND (junior_species='odorata' OR junior_species='odorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipteryx' AND (species='odorata' OR species='odorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipteryx' AND (species='odorata' OR species='odorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipteryx' AND (junior_species='odorata' OR junior_species='odorata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dipteryx' AND (species='odorata' OR species='odorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipteryx' 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='Dipteryx' AND (species='polyphylla' OR species='polyphylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipteryx' AND (species='polyphylla' OR species='polyphylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipteryx' 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='Dipteryx' AND (species='polyphylla' OR species='polyphylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenaea' AND (species='courbaril' OR species='courbaril')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenolobium' AND (junior_species='excelsum' OR junior_species='excelsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenolobium' AND (species='excelsum' OR species='excelsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenolobium' AND (species='excelsum' OR species='excelsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenolobium' AND (junior_species='excelsum' OR junior_species='excelsum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hymenolobium' AND (species='excelsum' OR species='excelsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='alba' OR junior_species='alba')SELECT d.diet,d.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='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='obtusata' OR junior_species='obtusata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='obtusata' OR species='obtusata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='obtusata' OR species='obtusata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='obtusata' OR junior_species='obtusata')SELECT d.diet,d.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='obtusata' OR species='obtusata') 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='Newtonia' 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='Newtonia' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Newtonia' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Newtonia' 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='Newtonia' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' 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='Ormosia' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ormosia' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' 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='Ormosia' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peltogyne' AND (junior_species='catingae' OR junior_species='catingae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peltogyne' AND (species='catingae' OR species='catingae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peltogyne' AND (species='catingae' OR species='catingae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peltogyne' AND (junior_species='catingae' OR junior_species='catingae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peltogyne' AND (species='catingae' OR species='catingae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peltogyne' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peltogyne' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peltogyne' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peltogyne' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peltogyne' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='racemosum' OR junior_species='racemosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pithecellobium' AND (species='racemosum' OR species='racemosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pithecellobium' AND (species='racemosum' OR species='racemosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='racemosum' OR junior_species='racemosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pithecellobium' AND (species='racemosum' OR species='racemosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' 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='Platymiscium' AND (species='duckei' OR species='duckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platymiscium' AND (species='duckei' OR species='duckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' 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='Platymiscium' AND (species='duckei' OR species='duckeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='rohrii' OR junior_species='rohri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocarpus' AND (species='rohrii' OR species='rohri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='rohrii' OR species='rohri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='rohrii' OR junior_species='rohri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterocarpus' AND (species='rohrii' OR species='rohri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerolobium' AND (junior_species='melanocarpum' OR junior_species='melanocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerolobium' AND (species='melanocarpum' OR species='melanocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerolobium' AND (species='melanocarpum' OR species='melanocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerolobium' AND (junior_species='melanocarpum' OR junior_species='melanocarpum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sclerolobium' AND (species='melanocarpum' OR species='melanocarpum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='corrugata' OR junior_species='corrugata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='corrugata' OR species='corrugata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='corrugata' OR species='corrugata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='corrugata' OR junior_species='corrugata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swartzia' AND (species='corrugata' OR species='corrugata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='ingifolia' OR junior_species='ingifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='ingifolia' OR species='ingifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='ingifolia' OR species='ingifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='ingifolia' OR junior_species='ingifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swartzia' AND (species='ingifolia' OR species='ingifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='reticulata' OR species='reticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swartzia' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigalia' AND (junior_species='myremecophilla' OR junior_species='myremecophilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachigalia' AND (species='myremecophilla' OR species='myremecophilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigalia' AND (species='myremecophilla' OR species='myremecophilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigalia' AND (junior_species='myremecophilla' OR junior_species='myremecophilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachigalia' AND (species='myremecophilla' OR species='myremecophilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigalia' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachigalia' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigalia' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigalia' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachigalia' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zollernia' 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='Zollernia' AND (species='grandiflora' OR species='grandiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zollernia' AND (species='grandiflora' OR species='grandiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zollernia' 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='Zollernia' AND (species='grandiflora' OR species='grandiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byrsonima' 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='Byrsonima' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Byrsonima' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Byrsonima' 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='Byrsonima' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bellucia' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bellucia' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bellucia' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bellucia' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bellucia' AND (species='imperialis' OR species='imperialis') 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='Mouriria' 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='Mouriria' AND (species='huberi' OR species='huberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriria' AND (species='huberi' OR species='huberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriria' 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='Mouriria' AND (species='huberi' OR species='huberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='odorata' OR junior_species='odorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cedrela' AND (species='odorata' OR species='odorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cedrela' AND (species='odorata' OR species='odorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='odorata' OR junior_species='odorata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cedrela' AND (species='odorata' OR species='odorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='carinata' OR junior_species='carinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='carinata' OR junior_species='carinata')SELECT d.diet,d.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='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' 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='Guarea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' 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='Guarea' 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='silvatica' OR junior_species='silvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='silvatica' OR species='silvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='silvatica' OR species='silvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='silvatica' OR junior_species='silvatica')SELECT d.diet,d.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='silvatica' OR species='silvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='trichilioides' OR junior_species='trichilioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='trichilioides' OR species='trichilioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='trichilioides' OR species='trichilioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='trichilioides' OR junior_species='trichilioides')SELECT d.diet,d.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='trichilioides' OR species='trichilioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='decipiens' OR junior_species='decipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siparuna' AND (species='decipiens' OR species='decipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siparuna' AND (species='decipiens' OR species='decipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='decipiens' OR junior_species='decipiens')SELECT d.diet,d.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='decipiens' OR species='decipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='acutifolium' OR junior_species='acutifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='acutifolium' OR species='acutifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='acutifolium' OR species='acutifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='acutifolium' OR junior_species='acutifolium')SELECT d.diet,d.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='acutifolium' OR species='acutifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='guyanense' OR junior_species='guyanense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='guyanense' OR species='guyanense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='guyanense' OR species='guyanense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='guyanense' OR junior_species='guyanense')SELECT d.diet,d.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='guyanense' OR species='guyanense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='parinarioides' OR junior_species='parinarioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='parinarioides' OR species='parinarioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='parinarioides' OR species='parinarioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='parinarioides' OR junior_species='parinarioides')SELECT d.diet,d.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='parinarioides' OR species='parinarioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='potabile' OR junior_species='potabile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='potabile' OR species='potabile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='potabile' OR species='potabile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='potabile' OR junior_species='potabile')SELECT d.diet,d.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='potabile' OR species='potabile') 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='Castiloa' AND (junior_species='ulei' OR junior_species='uleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castiloa' AND (species='ulei' OR species='uleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castiloa' AND (species='ulei' OR species='uleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castiloa' AND (junior_species='ulei' OR junior_species='uleii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Castiloa' AND (species='ulei' OR species='uleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='leucoma' OR junior_species='leucoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='leucoma' OR species='leucoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='leucoma' OR species='leucoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='leucoma' OR junior_species='leucoma')SELECT d.diet,d.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='leucoma' OR species='leucoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' 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='Clarisia' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clarisia' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' 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='Clarisia' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' 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='Clarisia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clarisia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clarisia' 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='Clarisia' AND (species='sp.' OR species='sp.') 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='Helicostylis' AND (junior_species='podogyne' OR junior_species='podogyne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicostylis' AND (species='podogyne' OR species='podogyne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicostylis' AND (species='podogyne' OR species='podogyne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='podogyne' OR junior_species='podogyne')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicostylis' AND (species='podogyne' OR species='podogyne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='sclerophylla' OR junior_species='sclerophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maquira' AND (species='sclerophylla' OR species='sclerophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maquira' AND (species='sclerophylla' OR species='sclerophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='sclerophylla' OR junior_species='sclerophylla')SELECT d.diet,d.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='sclerophylla' OR species='sclerophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' 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='Maquira' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maquira' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' 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='Maquira' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naucelopsis' 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='Naucelopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naucelopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naucelopsis' 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='Naucelopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perebea' AND (junior_species='concinna' OR junior_species='concinna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perebea' AND (species='concinna' OR species='concinna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perebea' AND (species='concinna' OR species='concinna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perebea' AND (junior_species='concinna' OR junior_species='concinna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perebea' AND (species='concinna' OR species='concinna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='longipendula' OR junior_species='longipendula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='longipendula' OR species='longipendula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='longipendula' OR species='longipendula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='longipendula' OR junior_species='longipendula')SELECT d.diet,d.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='longipendula' OR species='longipendula') 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='Pseudolmedia' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudolmedia' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudolmedia' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='laevis' OR junior_species='laevis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudolmedia' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' 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='Sorocea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorocea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' 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='Sorocea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='tricornis' OR junior_species='tricornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iryanthera' AND (species='tricornis' OR species='tricornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iryanthera' AND (species='tricornis' OR species='tricornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='tricornis' OR junior_species='tricornis')SELECT d.diet,d.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='tricornis' OR species='tricornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='calophylloidea' OR junior_species='calophylloidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='calophylloidea' OR species='calophylloidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='calophylloidea' OR species='calophylloidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='calophylloidea' OR junior_species='calophylloidea')SELECT d.diet,d.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='calophylloidea' OR species='calophylloidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelli' OR junior_species='michellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='michelli' OR species='michellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='michelli' OR species='michellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelli' OR junior_species='michellii')SELECT d.diet,d.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='michelli' OR species='michellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' 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='Myrciaria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrciaria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' 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='Myrciaria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' AND (junior_species='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='Heisteria' 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='Heisteria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heisteria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' 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='Heisteria' AND (species='sp.' OR species='sp.') 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='Astrocaryum' AND (junior_species='tucuma' OR junior_species='tucuma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astrocaryum' AND (species='tucuma' OR species='tucuma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astrocaryum' AND (species='tucuma' OR species='tucuma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astrocaryum' AND (junior_species='tucuma' OR junior_species='tucuma')SELECT d.diet,d.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='tucuma' OR species='tucuma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euterpe' AND (junior_species='precatoria' OR junior_species='precatoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euterpe' AND (species='precatoria' OR species='precatoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euterpe' AND (species='precatoria' OR species='precatoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euterpe' AND (junior_species='precatoria' OR junior_species='precatoria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euterpe' AND (species='precatoria' OR species='precatoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iriartella' AND (junior_species='setigera' OR junior_species='setigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iriartella' AND (species='setigera' OR species='setigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iriartella' AND (species='setigera' OR species='setigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iriartella' AND (junior_species='setigera' OR junior_species='setigera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iriartella' AND (species='setigera' OR species='setigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orbignya' 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='Orbignya' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orbignya' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orbignya' 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='Orbignya' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Socratea' AND (junior_species='exorrhiza' OR junior_species='exorrhiza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Socratea' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Socratea' AND (species='exorrhiza' OR species='exorrhiza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Socratea' AND (junior_species='exorrhiza' OR junior_species='exorrhiza')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Socratea' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maripa' 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='Maripa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maripa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maripa' 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='Maripa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Roupala' 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='Roupala' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Roupala' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Roupala' 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='Roupala' 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='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='Lacunaria' AND (species='grandiflora' OR species='grandiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacunaria' AND (species='grandiflora' OR species='grandiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' 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='Lacunaria' AND (species='grandiflora' OR species='grandiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' 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='Alibertia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alibertia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' 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='Alibertia' AND (species='sp.' OR species='sp.') 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='Metrodorea' AND (junior_species='flavida' OR junior_species='flavida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metrodorea' AND (species='flavida' OR species='flavida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metrodorea' AND (species='flavida' OR species='flavida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrodorea' AND (junior_species='flavida' OR junior_species='flavida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Metrodorea' AND (species='flavida' OR species='flavida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='rhoifolium' OR junior_species='rhoifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='rhoifolium' OR species='rhoifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='rhoifolium' OR species='rhoifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='rhoifolium' OR junior_species='rhoifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zanthoxylum' AND (species='rhoifolium' OR species='rhoifolium') 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='Lucuma' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lucuma' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lucuma' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lucuma' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lucuma' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' 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='Manilkara' AND (species='huberi' OR species='huberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manilkara' AND (species='huberi' OR species='huberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' 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='Manilkara' AND (species='huberi' OR species='huberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='mensalis' OR junior_species='mensalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropholis' AND (species='mensalis' OR species='mensalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='mensalis' OR species='mensalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='mensalis' OR junior_species='mensalis')SELECT d.diet,d.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='mensalis' OR species='mensalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' 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='Micropholis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' 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='Micropholis' 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='venulosa' OR junior_species='venulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropholis' AND (species='venulosa' OR species='venulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='venulosa' OR species='venulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='venulosa' OR junior_species='venulosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micropholis' AND (species='venulosa' OR species='venulosa') 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='Matayba' 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='Matayba' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Matayba' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matayba' 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='Matayba' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaba' AND (junior_species='cedron' OR junior_species='cedron')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simaba' AND (species='cedron' OR species='cedron') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simaba' AND (species='cedron' OR species='cedron')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaba' AND (junior_species='cedron' OR junior_species='cedron')SELECT d.diet,d.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='cedron' OR species='cedron') 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='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='Theobroma' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='sylvestris' OR species='sylvestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT d.diet,d.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='sylvestris' OR species='sylvestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeiba' AND (junior_species='echinata' OR junior_species='echinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apeiba' AND (species='echinata' OR species='echinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apeiba' AND (species='echinata' OR species='echinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeiba' AND (junior_species='echinata' OR junior_species='echinata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apeiba' AND (species='echinata' OR species='echinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lueheopsis' AND (junior_species='duckeana' OR junior_species='duckeana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lueheopsis' AND (species='duckeana' OR species='duckeana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lueheopsis' AND (species='duckeana' OR species='duckeana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lueheopsis' AND (junior_species='duckeana' OR junior_species='duckeana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lueheopsis' AND (species='duckeana' OR species='duckeana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leonia' 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='Leonia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leonia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leonia' 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='Leonia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' 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='Rinorea' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' 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='Rinorea' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Qualea' 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='Qualea' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Qualea' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Qualea' 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='Qualea' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='vismiaefolia' OR junior_species='vismiaefolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vochysia' AND (species='vismiaefolia' OR species='vismiaefolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vochysia' AND (species='vismiaefolia' OR species='vismiaefolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='vismiaefolia' OR junior_species='vismiaefolia')SELECT d.diet,d.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='vismiaefolia' OR species='vismiaefolia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3321 The Ecological Register: Linha 605 (hectare II)
Linha 605 (hectare II)
Basic information
Sample name: Linha 605 (hectare II)

Reference: M. L. Absy, G. T. Prance, and E. M. Barbosa. 1987. Inventário florístico de floresta natural na área da estrada Cuiabá-Porto Velho (BR - 364). Acta Amazonica 16/17(1):85-121 [ER 3058]
Geography
Country: Brazil

State: Rondônia


Coordinate: -9.63° S, -61.95° W
Coordinate basis: estimated from map

Geography comments: "along the Cuiabã-Ponto Velho Highway (BR-364)... in the municipality o£ Jaru, branch road 605"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: unprotected

Substrate: ground surface

Habitat comments: undisturbed rain forest

Methods
Life forms: trees

Sites: 1

Site area: 1

Site length: 10

Site width: 1000

Sampling methods: belt transect

Sample size: 449 individuals

Size min: 10

Sampling comments: one half of a 20 x 1000 m transect

Metadata
Sample number: 3321

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-08-06 17:23:23

Modified: 2019-08-06 07:23:23

Abundance distribution
137 species
51 singletons
total count 449
extrapolated richness: 317.0
Fisher's α: 67.192
geometric series k: 0.9808
Hurlbert's PIE: 0.9860
Shannon's H: 4.5605
Good's u: 0.8867
Each square represents a species. Square sizes are proportional to counts.
Register
Astronium lecointei5
Tapirira guianensis1
Bocageopsis multiflora1
Guatteria procera11
Rollinia insignis pallida2
Aspidosperma carapanauba2
Aspidosperma oblongum2
Geissospermum sericeum1
Jacaranda copaia1
Tabebuia impetiginosa3
Tabebuia serratifolia1
Bixa arborea1
Bombacopsis nervosa2
Huberodendron swietenioides1
Quararibea ochrocalyx2
Cordia goeldiana3
Crepidospermum rhoifolium4
Tetragastris altissima9
Tetragastris panamensis3
Tetragastris trifoliolata8
Buchenavia parvifolia1
Licania latifolia2
Licania sp.5
Parinari excelsa1
Tapura sp.2
Diospyros sp.1
Sloanea sp.1
Aparisthmium cordatum3
Croton sp.1
Hevea brasiliensis1
Mabea caudata3
Micrandra sp.11
Casearia grandiflora2
Symphonia globulifera3
Tovomita macrophylla1
Vismia cayennensis2
Dendrobangia sp.1
Dicypellum manausense2
Ocotea canaliculata1
Ocotea opifera3
Bertholletia excelsa1
Couratari guianensis2
Eschweilera fracta1
Eschweilera odora7
Eschweilera sp.12
Apuleia molaris1
Bauhinia acreana8
Copaifera multijuga3
Dialium guianense1
Diplotropis purpurea coriacea1
Dipteryx odorata3
Dipteryx polyphylla1
Hymenaea courbaril1
Hymenolobium excelsum2
Inga alba9
Inga obtusata3
Inga sp.10
Newtonia suaveolens2
Ormosia paraensis3
Peltogyne catingae glabra3
Peltogyne paniculata1
Pithecellobium racemosum2
Platymiscium duckei1
Pterocarpus rohrii2
Sclerolobium melanocarpum14
Swartzia corrugata1
Swartzia ingifolia3
Swartzia reticulata1
Tachigalia myremecophilla5
Tachigalia paniculata5
Zollernia grandiflora1
Byrsonima sp.1
Bellucia imperialis1
Miconia sp.5
Mouriria huberi1
Cedrela odorata1
Guarea carinata2
Guarea sp.1
Guarea silvatica3
Guarea trichilioides7
Siparuna decipiens2
Brosimum acutifolium interfectum2
Brosimum guyanense2
Brosimum parinarioides parinarioides1
Brosimum potabile2
Brosimum rubescens7
Castiloa ulei2
Cecropia leucoma1
Clarisia racemosa1
Clarisia sp.7
Ficus sp.1
Helicostylis podogyne8
Maquira sclerophylla1
Maquira sp.3
Naucelopsis sp.7
Perebea concinna1
Pourouma longipendula1
Pourouma sp.4
Pseudolmedia laevis12
Sorocea sp.3
Iryanthera tricornis2
Virola calophylloidea9
Virola michelli4
Myrciaria sp.6
Neea sp.5
Heisteria sp.5
Minquartia guianensis3
Astrocaryum tucuma1
Euterpe precatoria14
Iriartella setigera3
Orbignya speciosa11
Socratea exorrhiza2
Maripa sp.1
Roupala sp.1
Lacunaria grandiflora1
Alibertia sp.1
Chimarrhis turbinata1
Metrodorea flavida2
Zanthoxylum rhoifolium3
Chrysophyllum prieurii5
Lucuma macrocarpa8
Manilkara huberi1
Micropholis mensalis2
Micropholis sp.3
Micropholis venulosa1
Pouteria sp.14
Matayba sp.2
Simaba cedron2
Sterculia pruriens3
Theobroma subincanum1
Theobroma sylvestris1
Apeiba echinata4
Lueheopsis duckeana2
Leonia sp.3
Rinorea guianensis7
Qualea paraensis1
Vochysia vismiaefolia4