Coordinate: 1° 11' S, 47° 19' W
SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=3327 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3327SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3060SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3327 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abarema' AND (junior_species='cochleatum' OR junior_species='cochleatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abarema' AND (species='cochleatum' OR species='cochleatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abarema' AND (species='cochleatum' OR species='cochleatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abarema' AND (junior_species='cochleatum' OR junior_species='cochleatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abarema' AND (species='cochleatum' OR species='cochleatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acacia' AND (junior_species='multipinnata' OR junior_species='multipinnata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acacia' AND (species='multipinnata' OR species='multipinnata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acacia' AND (species='multipinnata' OR species='multipinnata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acacia' AND (junior_species='multipinnata' OR junior_species='multipinnata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acacia' AND (species='multipinnata' OR species='multipinnata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alouea' 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='Alouea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alouea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alouea' 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='Alouea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allophylus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaioua' 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='Amaioua' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amaioua' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaioua' 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='Amaioua' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambelania' AND (junior_species='acida' OR junior_species='acida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambelania' AND (species='acida' OR species='acida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambelania' AND (species='acida' OR species='acida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambelania' AND (junior_species='acida' OR junior_species='acida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ambelania' AND (species='acida' OR species='acida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelocera' AND (junior_species='edentula' OR junior_species='edentula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ampelocera' AND (species='edentula' OR species='edentula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ampelocera' AND (species='edentula' OR species='edentula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelocera' AND (junior_species='edentula' OR junior_species='edentula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ampelocera' AND (species='edentula' OR species='edentula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphirrox' AND (junior_species='surinamensis' OR junior_species='surinamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphirrox' AND (species='surinamensis' OR species='surinamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphirrox' AND (species='surinamensis' OR species='surinamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphirrox' AND (junior_species='surinamensis' OR junior_species='surinamensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphirrox' AND (species='surinamensis' OR species='surinamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacardium' AND (junior_species='giganteum' OR junior_species='giganteum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anacardium' AND (species='giganteum' OR species='giganteum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anacardium' AND (species='giganteum' OR species='giganteum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anacardium' AND (junior_species='giganteum' OR junior_species='giganteum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anacardium' AND (species='giganteum' OR species='giganteum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andira' AND (junior_species='retusa' OR junior_species='retusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andira' AND (species='retusa' OR species='retusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andira' AND (species='retusa' OR species='retusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andira' AND (junior_species='retusa' OR junior_species='retusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andira' AND (species='retusa' OR species='retusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aniba' AND (junior_species='panurensis' OR junior_species='panurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aniba' AND (species='panurensis' OR species='panurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aniba' AND (species='panurensis' OR species='panurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aniba' AND (junior_species='panurensis' OR junior_species='panurensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aniba' AND (species='panurensis' OR species='panurensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Annona' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' 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='Apeiba' AND (junior_species='burchellii' OR junior_species='burchelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apeiba' AND (species='burchellii' OR species='burchelli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apeiba' AND (species='burchellii' OR species='burchelli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeiba' AND (junior_species='burchellii' OR junior_species='burchelli')SELECT d.diet,d.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='burchellii' OR species='burchelli') 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='Apuleia' AND (junior_species='leiocarpa' OR junior_species='leiocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apuleia' AND (species='leiocarpa' OR species='leiocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apuleia' AND (species='leiocarpa' OR species='leiocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apuleia' AND (junior_species='leiocarpa' OR junior_species='leiocarpa')SELECT d.diet,d.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='leiocarpa' OR species='leiocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arrabidaea' AND (junior_species='tuberculata' OR junior_species='tuberculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arrabidaea' AND (species='tuberculata' OR species='tuberculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arrabidaea' AND (species='tuberculata' OR species='tuberculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arrabidaea' AND (junior_species='tuberculata' OR junior_species='tuberculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arrabidaea' AND (species='tuberculata' OR species='tuberculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='desmanthum' OR junior_species='desmanthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='desmanthum' OR species='desmanthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='desmanthum' OR species='desmanthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='desmanthum' OR junior_species='desmanthum')SELECT d.diet,d.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='desmanthum' OR species='desmanthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='eleanum' OR junior_species='eleanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='eleanum' OR species='eleanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='eleanum' OR species='eleanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='eleanum' OR junior_species='eleanum')SELECT d.diet,d.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='eleanum' OR species='eleanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='nitidum' OR junior_species='nitidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='nitidum' OR species='nitidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='nitidum' OR species='nitidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='nitidum' OR junior_species='nitidum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aspidosperma' AND (species='nitidum' OR species='nitidum') ORDER BY year,last_namesSELECT 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='Bagassa' 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='Bagassa' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bagassa' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bagassa' 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='Bagassa' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='rutilans' OR junior_species='rutilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bauhinia' AND (species='rutilans' OR species='rutilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bauhinia' AND (species='rutilans' OR species='rutilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='rutilans' OR junior_species='rutilans')SELECT d.diet,d.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='rutilans' OR species='rutilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' 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='Bauhinia' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bauhinia' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' 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='Bauhinia' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='jariensis' OR junior_species='jariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bauhinia' AND (species='jariensis' OR species='jariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bauhinia' AND (species='jariensis' OR species='jariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='jariensis' OR junior_species='jariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bauhinia' AND (species='jariensis' OR species='jariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='macrostachya' OR junior_species='macrostachya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bauhinia' AND (species='macrostachya' OR species='macrostachya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bauhinia' AND (species='macrostachya' OR species='macrostachya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauhinia' AND (junior_species='macrostachya' OR junior_species='macrostachya')SELECT d.diet,d.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='macrostachya' OR species='macrostachya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='lactescens' OR junior_species='lactescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='lactescens' OR species='lactescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='lactescens' OR species='lactescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='lactescens' OR junior_species='lactescens')SELECT d.diet,d.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='lactescens' OR species='lactescens') 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='Calycolpus' 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='Calycolpus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycolpus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycolpus' 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='Calycolpus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calyptranthes' 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='Calyptranthes' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calyptranthes' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calyptranthes' 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='Calyptranthes' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calyptranthes' 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='Calyptranthes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calyptranthes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calyptranthes' 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='Calyptranthes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campomanesia' AND (junior_species='aromatica' OR junior_species='aromatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campomanesia' AND (species='aromatica' OR species='aromatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campomanesia' AND (species='aromatica' OR species='aromatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campomanesia' AND (junior_species='aromatica' OR junior_species='aromatica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campomanesia' AND (species='aromatica' OR species='aromatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carapa' 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='Carapa' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carapa' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carapa' 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='Carapa' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='glabrum' OR junior_species='glabrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryocar' AND (species='glabrum' OR species='glabrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryocar' AND (species='glabrum' OR species='glabrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='glabrum' OR junior_species='glabrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caryocar' AND (species='glabrum' OR species='glabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='vilossum' OR junior_species='vilossum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryocar' AND (species='vilossum' OR species='vilossum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryocar' AND (species='vilossum' OR species='vilossum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryocar' AND (junior_species='vilossum' OR junior_species='vilossum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caryocar' AND (species='vilossum' OR species='vilossum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='decandra' OR junior_species='decandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='decandra' OR species='decandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='decandra' OR species='decandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='decandra' OR junior_species='decandra')SELECT d.diet,d.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='decandra' OR species='decandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='mariquitensis' OR junior_species='mariquitensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='mariquitensis' OR species='mariquitensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='mariquitensis' OR species='mariquitensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='mariquitensis' OR junior_species='mariquitensis')SELECT d.diet,d.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='mariquitensis' OR species='mariquitensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='distachya' OR junior_species='distachya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='distachya' OR species='distachya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='distachya' OR species='distachya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='distachya' OR junior_species='distachya')SELECT d.diet,d.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='distachya' OR species='distachya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusa' OR junior_species='obtusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='obtusa' OR species='obtusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='obtusa' OR species='obtusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='obtusa' OR junior_species='obtusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cecropia' AND (species='obtusa' OR species='obtusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='sciadophylla' OR junior_species='sciadophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='sciadophylla' OR species='sciadophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='sciadophylla' OR species='sciadophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='sciadophylla' OR junior_species='sciadophylla')SELECT d.diet,d.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='sciadophylla' OR species='sciadophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaecrista' AND (junior_species='bahiae' OR junior_species='bahiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaecrista' AND (species='bahiae' OR species='bahiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaecrista' AND (species='bahiae' OR species='bahiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaecrista' AND (junior_species='bahiae' OR junior_species='bahiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chamaecrista' AND (species='bahiae' OR species='bahiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chanouchiton' AND (junior_species='kapleri' OR junior_species='kaplerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chanouchiton' AND (species='kapleri' OR species='kaplerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chanouchiton' AND (species='kapleri' OR species='kaplerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chanouchiton' AND (junior_species='kapleri' OR junior_species='kaplerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chanouchiton' AND (species='kapleri' OR species='kaplerii') 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='Combretum' AND (junior_species='laxum' OR junior_species='laxum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='laxum' OR species='laxum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='laxum' OR species='laxum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='laxum' OR junior_species='laxum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Combretum' AND (species='laxum' OR species='laxum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conceveiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conceveiba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conceveiba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conceveiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conceveiba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' 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='Copaifera' AND (species='duckei' OR species='duckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copaifera' AND (species='duckei' OR species='duckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' 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='Copaifera' AND (species='duckei' OR species='duckeii') 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='Cordia' AND (junior_species='scabrida' OR junior_species='scabrida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='scabrida' OR species='scabrida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='scabrida' OR species='scabrida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='scabrida' OR junior_species='scabrida')SELECT d.diet,d.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='scabrida' OR species='scabrida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='scabrifolia' OR junior_species='scabrifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='scabrifolia' OR species='scabrifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='scabrifolia' OR species='scabrifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='scabrifolia' OR junior_species='scabrifolia')SELECT d.diet,d.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='scabrifolia' OR species='scabrifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couepia' AND (junior_species='magnoliaefolia' OR junior_species='magnoliaefolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Couepia' AND (species='magnoliaefolia' OR species='magnoliaefolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Couepia' AND (species='magnoliaefolia' OR species='magnoliaefolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couepia' AND (junior_species='magnoliaefolia' OR junior_species='magnoliaefolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Couepia' AND (species='magnoliaefolia' OR species='magnoliaefolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couepia' 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='Couepia' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Couepia' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couepia' 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='Couepia' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Couratari' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Couratari' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Couratari' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' 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='Couratari' AND (species='multiflora' OR species='multiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Couratari' AND (species='multiflora' OR species='multiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Couratari' 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='Couratari' AND (species='multiflora' OR species='multiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' AND (junior_species='ovalis' OR junior_species='ovalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coussarea' AND (species='ovalis' OR species='ovalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coussarea' AND (species='ovalis' OR species='ovalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' AND (junior_species='ovalis' OR junior_species='ovalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coussarea' AND (species='ovalis' OR species='ovalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' 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='Coussarea' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coussarea' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' 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='Coussarea' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='cajucara' OR junior_species='cajucara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='cajucara' OR species='cajucara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='cajucara' OR species='cajucara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='cajucara' OR junior_species='cajucara')SELECT d.diet,d.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='cajucara' OR species='cajucara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='matourense' OR junior_species='matourense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='matourense' OR species='matourense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='matourense' OR species='matourense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='matourense' OR junior_species='matourense')SELECT d.diet,d.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='matourense' OR species='matourense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='scrobiculata' OR junior_species='scrobiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='scrobiculata' OR species='scrobiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='scrobiculata' OR species='scrobiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='scrobiculata' OR junior_species='scrobiculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupania' AND (species='scrobiculata' OR species='scrobiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Davilla' AND (junior_species='kunthii' OR junior_species='kunthi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Davilla' AND (species='kunthii' OR species='kunthi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Davilla' AND (species='kunthii' OR species='kunthi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Davilla' AND (junior_species='kunthii' OR junior_species='kunthi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Davilla' AND (species='kunthii' OR species='kunthi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrobangia' AND (species='boliviana' OR species='boliviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrobangia' AND (species='boliviana' OR species='boliviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobangia' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrobangia' AND (species='boliviana' OR species='boliviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derris' 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='Derris' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Derris' AND (species='latifolia' OR species='latifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derris' 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='Derris' AND (species='latifolia' OR species='latifolia') 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='Diospyros' AND (junior_species='artanthaefolia' OR junior_species='artanthaefolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='artanthaefolia' OR species='artanthaefolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='artanthaefolia' OR species='artanthaefolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='artanthaefolia' OR junior_species='artanthaefolia')SELECT d.diet,d.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='artanthaefolia' OR species='artanthaefolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='melinonii' OR junior_species='melinoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='melinonii' OR species='melinoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='melinonii' OR species='melinoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='melinonii' OR junior_species='melinoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='melinonii' OR species='melinoni') 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='Drypetes' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drypetes' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enterolobium' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enterolobium' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enterolobium' AND (species='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erisma' AND (junior_species='uncinatum' OR junior_species='uncinatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erisma' AND (species='uncinatum' OR species='uncinatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erisma' AND (species='uncinatum' OR species='uncinatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erisma' AND (junior_species='uncinatum' OR junior_species='uncinatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erisma' AND (species='uncinatum' OR species='uncinatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='ovata' OR junior_species='ovata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='ovata' OR species='ovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='ovata' OR species='ovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='ovata' OR junior_species='ovata')SELECT d.diet,d.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='ovata' OR species='ovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='amazonica' OR species='amazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='amazonica' OR species='amazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT d.diet,d.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='amazonica' OR species='amazonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='collina' OR junior_species='collina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='collina' OR species='collina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='collina' OR species='collina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='collina' OR junior_species='collina')SELECT d.diet,d.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='collina' OR species='collina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='coriacea' OR junior_species='coriacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='coriacea' OR junior_species='coriacea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eschweilera' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='pedicellata' OR junior_species='pedicellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='pedicellata' OR species='pedicellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='pedicellata' OR species='pedicellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='pedicellata' OR junior_species='pedicellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eschweilera' AND (species='pedicellata' OR species='pedicellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='teijoi' OR junior_species='teijoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='teijoi' OR species='teijoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='teijoi' OR species='teijoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='teijoi' OR junior_species='teijoii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='teijoi' OR species='teijoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='lambertia' OR junior_species='lambertia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='lambertia' OR species='lambertia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='lambertia' OR species='lambertia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='lambertia' OR junior_species='lambertia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='lambertia' OR species='lambertia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='mimius' OR junior_species='mimius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='mimius' OR species='mimius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='mimius' OR species='mimius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='mimius' OR junior_species='mimius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='mimius' OR species='mimius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='patrisii' OR junior_species='patrisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='patrisii' OR species='patrisi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='patrisii' OR species='patrisi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='patrisii' OR junior_species='patrisi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='patrisii' OR species='patrisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='gameleira' OR junior_species='gameleira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='gameleira' OR species='gameleira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='gameleira' OR species='gameleira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='gameleira' OR junior_species='gameleira')SELECT d.diet,d.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='gameleira' OR species='gameleira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='anibifolia' OR junior_species='anibifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Franchetella' AND (species='anibifolia' OR species='anibifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Franchetella' AND (species='anibifolia' OR species='anibifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='anibifolia' OR junior_species='anibifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Franchetella' AND (species='anibifolia' OR species='anibifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='gongrypii' OR junior_species='gongrypi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Franchetella' AND (species='gongrypii' OR species='gongrypi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Franchetella' AND (species='gongrypii' OR species='gongrypi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='gongrypii' OR junior_species='gongrypi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Franchetella' AND (species='gongrypii' OR species='gongrypi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='jariensis' OR junior_species='jariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Franchetella' AND (species='jariensis' OR species='jariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Franchetella' AND (species='jariensis' OR species='jariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='jariensis' OR junior_species='jariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Franchetella' AND (species='jariensis' OR species='jariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='sagotiana' OR junior_species='sagotiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Franchetella' AND (species='sagotiana' OR species='sagotiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Franchetella' AND (species='sagotiana' OR species='sagotiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franchetella' AND (junior_species='sagotiana' OR junior_species='sagotiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Franchetella' AND (species='sagotiana' OR species='sagotiana') 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='Geissospermum' AND (junior_species='velozii' OR junior_species='velozi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geissospermum' AND (species='velozii' OR species='velozi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geissospermum' AND (species='velozii' OR species='velozi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geissospermum' AND (junior_species='velozii' OR junior_species='velozi')SELECT d.diet,d.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='velozii' OR species='velozi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goupia' AND (junior_species='glabra' OR junior_species='glabra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Goupia' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goupia' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goupia' AND (junior_species='glabra' OR junior_species='glabra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Goupia' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='kunthiana' OR junior_species='kunthiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='kunthiana' OR species='kunthiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='kunthiana' OR species='kunthiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='kunthiana' OR junior_species='kunthiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Guarea' AND (species='kunthiana' OR species='kunthiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guatteria' AND (junior_species='poeppigiana' OR junior_species='poeppigiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guatteria' AND (species='poeppigiana' OR species='poeppigiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guatteria' AND (species='poeppigiana' OR species='poeppigiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guatteria' AND (junior_species='poeppigiana' OR junior_species='poeppigiana')SELECT d.diet,d.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='poeppigiana' OR species='poeppigiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='augusta' OR junior_species='augusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gustavia' AND (species='augusta' OR species='augusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gustavia' AND (species='augusta' OR species='augusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='augusta' OR junior_species='augusta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gustavia' AND (species='augusta' OR species='augusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebepetalum' AND (junior_species='humirifolium' OR junior_species='humirifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hebepetalum' AND (species='humirifolium' OR species='humirifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hebepetalum' AND (species='humirifolium' OR species='humirifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebepetalum' AND (junior_species='humirifolium' OR junior_species='humirifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hebepetalum' AND (species='humirifolium' OR species='humirifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heisteria' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heisteria' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heisteria' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicostylis' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicostylis' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='elegans' OR junior_species='elegans')SELECT d.diet,d.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='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='pedunculata' OR junior_species='pedunculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicostylis' AND (species='pedunculata' OR species='pedunculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicostylis' AND (species='pedunculata' OR species='pedunculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='pedunculata' OR junior_species='pedunculata')SELECT d.diet,d.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='pedunculata' OR species='pedunculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' 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='Helicostylis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicostylis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' 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='Helicostylis' 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='tomentosa' OR junior_species='tomentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicostylis' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicostylis' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicostylis' AND (junior_species='tomentosa' OR junior_species='tomentosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicostylis' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropteris' 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='Heteropteris' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropteris' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropteris' 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='Heteropteris' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Himatanthus' AND (junior_species='sucuuba' OR junior_species='sucuuba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Himatanthus' AND (species='sucuuba' OR species='sucuuba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Himatanthus' AND (species='sucuuba' OR species='sucuuba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Himatanthus' AND (junior_species='sucuuba' OR junior_species='sucuuba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Himatanthus' AND (species='sucuuba' OR species='sucuuba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippocratea' 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='Hippocratea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippocratea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippocratea' 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='Hippocratea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirtella' 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='Hirtella' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirtella' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirtella' 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='Hirtella' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Humiriastrum' 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='Humiriastrum' AND (species='excelsum' OR species='excelsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Humiriastrum' AND (species='excelsum' OR species='excelsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Humiriastrum' 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='Humiriastrum' AND (species='excelsum' OR species='excelsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' 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='Hymenaea' AND (species='parvifolia' OR species='parvifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenaea' AND (species='parvifolia' OR species='parvifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' 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='Hymenaea' AND (species='parvifolia' OR species='parvifolia') 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='falcistipula' OR junior_species='falcistipula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='falcistipula' OR species='falcistipula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='falcistipula' OR species='falcistipula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='falcistipula' OR junior_species='falcistipula')SELECT d.diet,d.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='falcistipula' OR species='falcistipula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='gracilifolia' OR junior_species='gracilifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='gracilifolia' OR species='gracilifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='gracilifolia' OR species='gracilifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='gracilifolia' OR junior_species='gracilifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Inga' AND (species='gracilifolia' OR species='gracilifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='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='Inga' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' 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='Inga' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='marginata' OR junior_species='marginata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='marginata' OR species='marginata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='marginata' OR species='marginata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='marginata' OR junior_species='marginata')SELECT d.diet,d.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='marginata' OR species='marginata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='rubiginosa' OR species='rubiginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='rubiginosa' OR species='rubiginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')SELECT d.diet,d.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='rubiginosa' OR species='rubiginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='splendens' OR junior_species='splendens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='splendens' OR junior_species='splendens')SELECT d.diet,d.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='splendens' OR species='splendens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='thibaudiana' OR junior_species='thibaudiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='thibaudiana' OR species='thibaudiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='thibaudiana' OR species='thibaudiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='thibaudiana' OR junior_species='thibaudiana')SELECT d.diet,d.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='thibaudiana' OR species='thibaudiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iriartera' 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='Iriartera' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iriartera' AND (species='exorrhiza' OR species='exorrhiza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iriartera' 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='Iriartera' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='sagotiana' OR junior_species='sagotiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iryanthera' AND (species='sagotiana' OR species='sagotiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iryanthera' AND (species='sagotiana' OR species='sagotiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iryanthera' AND (junior_species='sagotiana' OR junior_species='sagotiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iryanthera' AND (species='sagotiana' OR species='sagotiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Jacaratia' AND (junior_species='spinosa' OR junior_species='spinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jacaratia' AND (species='spinosa' OR species='spinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jacaratia' AND (species='spinosa' OR species='spinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacaratia' AND (junior_species='spinosa' OR junior_species='spinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jacaratia' AND (species='spinosa' OR species='spinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacmellea' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacmellea' AND (species='aculeata' OR species='aculeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacmellea' AND (species='aculeata' OR species='aculeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacmellea' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacmellea' AND (species='aculeata' OR species='aculeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacunaria' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacunaria' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='crenata' OR junior_species='crenata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacunaria' AND (species='crenata' OR species='crenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='jenmanii' OR junior_species='jenmani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacunaria' AND (species='jenmanii' OR species='jenmani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacunaria' AND (species='jenmanii' OR species='jenmani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacunaria' AND (junior_species='jenmanii' OR junior_species='jenmani')SELECT d.diet,d.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='jenmanii' OR species='jenmani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laetia' AND (junior_species='procera' OR junior_species='procera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laetia' AND (species='procera' OR species='procera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laetia' AND (species='procera' OR species='procera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laetia' AND (junior_species='procera' OR junior_species='procera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Laetia' AND (species='procera' OR species='procera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='idatimon' OR junior_species='idatimon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='idatimon' OR species='idatimon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='idatimon' OR species='idatimon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='idatimon' OR junior_species='idatimon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lecythis' AND (species='idatimon' OR species='idatimon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='lurida' OR junior_species='lurida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='lurida' OR species='lurida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='lurida' OR species='lurida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='lurida' OR junior_species='lurida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lecythis' AND (species='lurida' OR species='lurida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='pisonis' OR junior_species='pisonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecythis' AND (species='pisonis' OR species='pisonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecythis' AND (species='pisonis' OR species='pisonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecythis' AND (junior_species='pisonis' OR junior_species='pisonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lecythis' AND (species='pisonis' OR species='pisonis') 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='Licania' AND (junior_species='canescens' OR junior_species='canescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licania' AND (species='canescens' OR species='canescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='canescens' OR species='canescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='canescens' OR junior_species='canescens')SELECT d.diet,d.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='canescens' OR species='canescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='heteromorpha' OR junior_species='heteromorpha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licania' AND (species='heteromorpha' OR species='heteromorpha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='heteromorpha' OR species='heteromorpha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='heteromorpha' OR junior_species='heteromorpha')SELECT d.diet,d.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='heteromorpha' OR species='heteromorpha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='membranacea' OR junior_species='membranacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licania' AND (species='membranacea' OR species='membranacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='membranacea' OR species='membranacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='membranacea' OR junior_species='membranacea')SELECT d.diet,d.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='membranacea' OR species='membranacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='octandra' OR junior_species='octandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licania' AND (species='octandra' OR species='octandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='octandra' OR species='octandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='octandra' OR junior_species='octandra')SELECT d.diet,d.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='octandra' OR species='octandra') 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='Lindackeria' 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='Lindackeria' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lindackeria' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindackeria' 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='Lindackeria' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luheopsis' 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='Luheopsis' AND (species='duckeana' OR species='duckeana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luheopsis' AND (species='duckeana' OR species='duckeana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luheopsis' 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='Luheopsis' AND (species='duckeana' OR species='duckeana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' 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='Mabea' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabea' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' 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='Mabea' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macfadyena' AND (junior_species='unguiscali' OR junior_species='unguiscalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macfadyena' AND (species='unguiscali' OR species='unguiscalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macfadyena' AND (species='unguiscali' OR species='unguiscalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macfadyena' AND (junior_species='unguiscali' OR junior_species='unguiscalii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macfadyena' AND (species='unguiscali' OR species='unguiscalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaerium' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaerium' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' AND (junior_species='ferox' OR junior_species='ferox')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machaerium' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' 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='Machaerium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaerium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerium' 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='Machaerium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mapouria' 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='Mapouria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mapouria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mapouria' 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='Mapouria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maprounea' 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='Maprounea' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maprounea' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maprounea' 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='Maprounea' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maquira' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maquira' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maquira' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Marmaroxylum' 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='Marmaroxylum' AND (species='racemosum' OR species='racemosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmaroxylum' AND (species='racemosum' OR species='racemosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmaroxylum' 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='Marmaroxylum' AND (species='racemosum' OR species='racemosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matayba' 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='Matayba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Matayba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matayba' 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='Matayba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matayba' AND (junior_species='macrostylis' OR junior_species='macrostylis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Matayba' AND (species='macrostylis' OR species='macrostylis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Matayba' AND (species='macrostylis' OR species='macrostylis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Matayba' AND (junior_species='macrostylis' OR junior_species='macrostylis')SELECT d.diet,d.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='macrostylis' OR species='macrostylis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='myrsinoides' OR junior_species='myrsinoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maytenus' AND (species='myrsinoides' OR species='myrsinoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maytenus' AND (species='myrsinoides' OR species='myrsinoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='myrsinoides' OR junior_species='myrsinoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maytenus' AND (species='myrsinoides' OR species='myrsinoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maytenus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maytenus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maytenus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrodrea' 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='Metrodrea' AND (species='flavida' OR species='flavida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metrodrea' AND (species='flavida' OR species='flavida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrodrea' 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='Metrodrea' AND (species='flavida' OR species='flavida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='serialis' OR junior_species='serialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miconia' AND (species='serialis' OR species='serialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='serialis' OR species='serialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='serialis' OR junior_species='serialis')SELECT d.diet,d.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='serialis' OR species='serialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='tetrasperma' OR junior_species='tetrasperma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miconia' AND (species='tetrasperma' OR species='tetrasperma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='tetrasperma' OR species='tetrasperma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='tetrasperma' OR junior_species='tetrasperma')SELECT d.diet,d.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='tetrasperma' OR species='tetrasperma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miconia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Miconia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='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='Micropholis' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' 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='Micropholis' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='venutosa' OR junior_species='venutosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropholis' AND (species='venutosa' OR species='venutosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropholis' AND (species='venutosa' OR species='venutosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropholis' AND (junior_species='venutosa' OR junior_species='venutosa')SELECT d.diet,d.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='venutosa' OR species='venutosa') 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='Mouriri' AND (junior_species='brachyanthera' OR junior_species='brachyanthera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='brachyanthera' OR species='brachyanthera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='brachyanthera' OR species='brachyanthera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='brachyanthera' OR junior_species='brachyanthera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mouriri' AND (species='brachyanthera' OR species='brachyanthera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrcia' AND (species='amazonica' OR species='amazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrcia' AND (species='amazonica' OR species='amazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrcia' AND (species='amazonica' OR species='amazonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='laruotteana' OR junior_species='laruotteana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrcia' AND (species='laruotteana' OR species='laruotteana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrcia' AND (species='laruotteana' OR species='laruotteana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='laruotteana' OR junior_species='laruotteana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrcia' AND (species='laruotteana' OR species='laruotteana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrcia' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrcia' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcia' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrcia' AND (species='sylvatica' OR species='sylvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' AND (junior_species='tenella' OR junior_species='tenella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrciaria' AND (species='tenella' OR species='tenella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrciaria' AND (species='tenella' OR species='tenella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrciaria' AND (junior_species='tenella' OR junior_species='tenella')SELECT d.diet,d.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='tenella' OR species='tenella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='globosa' OR junior_species='globosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectandra' AND (species='globosa' OR species='globosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectandra' AND (species='globosa' OR species='globosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='globosa' OR junior_species='globosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nectandra' AND (species='globosa' OR species='globosa') 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='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='Newtonia' AND (junior_species='psilostachya' OR junior_species='psilostachya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Newtonia' AND (species='psilostachya' OR species='psilostachya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Newtonia' AND (species='psilostachya' OR species='psilostachya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Newtonia' AND (junior_species='psilostachya' OR junior_species='psilostachya')SELECT d.diet,d.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='psilostachya' OR species='psilostachya') 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='Ocotea' AND (junior_species='cajumari' OR junior_species='cajumarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='cajumari' OR species='cajumarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='cajumari' OR species='cajumarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='cajumari' OR junior_species='cajumarii')SELECT d.diet,d.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='cajumari' OR species='cajumarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='rubra' OR junior_species='rubra')SELECT d.diet,d.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='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocotea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenocarpus' AND (junior_species='distichus' OR junior_species='distichus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenocarpus' AND (species='distichus' OR species='distichus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenocarpus' AND (species='distichus' OR species='distichus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenocarpus' AND (junior_species='distichus' OR junior_species='distichus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oenocarpus' AND (species='distichus' OR species='distichus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='flava' OR junior_species='flava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ormosia' AND (species='flava' OR species='flava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ormosia' AND (species='flava' OR species='flava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='flava' OR junior_species='flava')SELECT d.diet,d.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='flava' OR species='flava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosa' 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='Ormosa' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ormosa' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosa' 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='Ormosa' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parahancomia' AND (junior_species='amapa' OR junior_species='amapa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parahancomia' AND (species='amapa' OR species='amapa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parahancomia' AND (species='amapa' OR species='amapa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parahancomia' AND (junior_species='amapa' OR junior_species='amapa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parahancomia' AND (species='amapa' OR species='amapa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' AND (junior_species='rodolphii' OR junior_species='rodolphi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parinari' AND (species='rodolphii' OR species='rodolphi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parinari' AND (species='rodolphii' OR species='rodolphi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' AND (junior_species='rodolphii' OR junior_species='rodolphi')SELECT d.diet,d.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='rodolphii' OR species='rodolphi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='gigantocarpa' OR junior_species='gigantocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkia' AND (species='gigantocarpa' OR species='gigantocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='gigantocarpa' OR species='gigantocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='gigantocarpa' OR junior_species='gigantocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parkia' AND (species='gigantocarpa' OR species='gigantocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' 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='Parkia' AND (species='ulei' OR species='uleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='ulei' OR species='uleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' 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='Parkia' AND (species='ulei' OR species='uleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='oblanceolata' OR junior_species='oblanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Planchonella' AND (species='oblanceolata' OR species='oblanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planchonella' AND (species='oblanceolata' OR species='oblanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='oblanceolata' OR junior_species='oblanceolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Planchonella' AND (species='oblanceolata' OR species='oblanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' 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='Planchonella' AND (species='prieurii' OR species='prieuri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planchonella' AND (species='prieurii' OR species='prieuri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' 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='Planchonella' AND (species='prieurii' OR species='prieuri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonophora' AND (junior_species='schomburgkiana' OR junior_species='schomburgkiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonophora' AND (species='schomburgkiana' OR species='schomburgkiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonophora' AND (species='schomburgkiana' OR species='schomburgkiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonophora' AND (junior_species='schomburgkiana' OR junior_species='schomburgkiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pogonophora' AND (species='schomburgkiana' OR species='schomburgkiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poraqueiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poraqueiba' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poraqueiba' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poraqueiba' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poraqueiba' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pourouma' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pourouma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='velutina' OR junior_species='velutina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pourouma' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='echinocarpa' OR junior_species='echinocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='echinocarpa' OR species='echinocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='echinocarpa' OR species='echinocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='echinocarpa' OR junior_species='echinocarpa')SELECT d.diet,d.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='echinocarpa' OR species='echinocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='heterosepala' OR junior_species='heterosepala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='heterosepala' OR species='heterosepala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='heterosepala' OR species='heterosepala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='heterosepala' OR junior_species='heterosepala')SELECT d.diet,d.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='heterosepala' OR species='heterosepala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='hispida' OR junior_species='hispida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='hispida' OR species='hispida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='hispida' OR species='hispida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='hispida' OR junior_species='hispida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='hispida' OR species='hispida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='lasiocarpa' OR junior_species='lasiocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='lasiocarpa' OR species='lasiocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='lasiocarpa' OR species='lasiocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='lasiocarpa' OR junior_species='lasiocarpa')SELECT d.diet,d.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='lasiocarpa' OR species='lasiocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='oblanceolata' OR junior_species='oblanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='oblanceolata' OR species='oblanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='oblanceolata' OR species='oblanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='oblanceolata' OR junior_species='oblanceolata')SELECT d.diet,d.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='oblanceolata' OR species='oblanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='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='Pradosia' AND (junior_species='graunulosa' OR junior_species='graunulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pradosia' AND (species='graunulosa' OR species='graunulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pradosia' AND (species='graunulosa' OR species='graunulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pradosia' AND (junior_species='graunulosa' OR junior_species='graunulosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pradosia' AND (species='graunulosa' OR species='graunulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='subserratum' OR junior_species='subserratum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='subserratum' OR species='subserratum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='subserratum' OR species='subserratum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='subserratum' OR junior_species='subserratum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='subserratum' OR species='subserratum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='decandrum' OR junior_species='decandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='decandrum' OR species='decandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='decandrum' OR species='decandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='decandrum' OR junior_species='decandrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='decandrum' OR species='decandrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='pallidum' OR junior_species='pallidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='pallidum' OR species='pallidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='pallidum' OR species='pallidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='pallidum' OR junior_species='pallidum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='pallidum' OR species='pallidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='pilosum' OR junior_species='pilosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='pilosum' OR species='pilosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='pilosum' OR species='pilosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='pilosum' OR junior_species='pilosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='pilosum' OR species='pilosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sagotianum' OR junior_species='sagotianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='sagotianum' OR species='sagotianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sagotianum' OR species='sagotianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sagotianum' OR junior_species='sagotianum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='sagotianum' OR species='sagotianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='tenuifolium' OR species='tenuifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='trifoliolatum' OR junior_species='trifoliolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='trifoliolatum' OR species='trifoliolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='trifoliolatum' OR species='trifoliolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='trifoliolatum' OR junior_species='trifoliolatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protium' AND (species='trifoliolatum' OR species='trifoliolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='myrtifolia' OR junior_species='myrtifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='myrtifolia' OR species='myrtifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='myrtifolia' OR species='myrtifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='myrtifolia' OR junior_species='myrtifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prunus' AND (species='myrtifolia' OR species='myrtifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='murure' OR junior_species='murure')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudolmedia' AND (species='murure' OR species='murure') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudolmedia' AND (species='murure' OR species='murure')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='murure' OR junior_species='murure')SELECT d.diet,d.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='murure' OR species='murure') 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='Qualea' AND (junior_species='albiflora' OR junior_species='albiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Qualea' AND (species='albiflora' OR species='albiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Qualea' AND (species='albiflora' OR species='albiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Qualea' AND (junior_species='albiflora' OR junior_species='albiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Qualea' AND (species='albiflora' OR species='albiflora') 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='Quiina' 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='Quiina' AND (species='duckei' OR species='duckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quiina' AND (species='duckei' OR species='duckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiina' 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='Quiina' AND (species='duckei' OR species='duckeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Radikoferella' 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='Radikoferella' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Radikoferella' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Radikoferella' 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='Radikoferella' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rheedia' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rheedia' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rheedia' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='passoura' OR junior_species='passoura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='passoura' OR species='passoura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='passoura' OR species='passoura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='passoura' OR junior_species='passoura')SELECT d.diet,d.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='passoura' OR species='passoura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccoglottis' 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='Saccoglottis' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saccoglottis' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccoglottis' 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='Saccoglottis' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandwithiodoxa' AND (junior_species='egregia' OR junior_species='egregia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sandwithiodoxa' AND (species='egregia' OR species='egregia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sandwithiodoxa' AND (species='egregia' OR species='egregia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandwithiodoxa' AND (junior_species='egregia' OR junior_species='egregia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sandwithiodoxa' AND (species='egregia' OR species='egregia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='pueppigii' OR junior_species='pueppigi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='pueppigii' OR species='pueppigi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='pueppigii' OR species='pueppigi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='pueppigii' OR junior_species='pueppigi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapium' AND (species='pueppigii' OR species='pueppigi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='marmieri' OR junior_species='marmierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='marmieri' OR species='marmierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='marmieri' OR species='marmierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='marmieri' OR junior_species='marmierii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapium' AND (species='marmieri' OR species='marmierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='morototoni' OR junior_species='morototonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schefflera' AND (species='morototoni' OR species='morototonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schefflera' AND (species='morototoni' OR species='morototonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='morototoni' OR junior_species='morototonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schefflera' AND (species='morototoni' OR species='morototonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerolobium' AND (junior_species='paraense' OR junior_species='paraense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerolobium' AND (species='paraense' OR species='paraense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerolobium' AND (species='paraense' OR species='paraense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerolobium' AND (junior_species='paraense' OR junior_species='paraense')SELECT d.diet,d.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='paraense' OR species='paraense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Senna' AND (junior_species='bahiai' OR junior_species='bahiaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Senna' AND (species='bahiai' OR species='bahiaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Senna' AND (species='bahiai' OR species='bahiaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Senna' AND (junior_species='bahiai' OR junior_species='bahiaii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Senna' AND (species='bahiai' OR species='bahiaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaruba' AND (junior_species='amara' OR junior_species='amara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simaruba' AND (species='amara' OR species='amara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simaruba' AND (species='amara' OR species='amara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaruba' AND (junior_species='amara' OR junior_species='amara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Simaruba' AND (species='amara' OR species='amara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaruba' 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='Simaruba' AND (species='multiflora' OR species='multiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simaruba' AND (species='multiflora' OR species='multiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simaruba' 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='Simaruba' AND (species='multiflora' OR species='multiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='garckeana' OR junior_species='garckeana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sloanea' AND (species='garckeana' OR species='garckeana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sloanea' AND (species='garckeana' OR species='garckeana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='garckeana' OR junior_species='garckeana')SELECT d.diet,d.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='garckeana' OR species='garckeana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='pilosa' OR junior_species='pilosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='pilosa' OR species='pilosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='pilosa' OR species='pilosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='pilosa' OR junior_species='pilosa')SELECT d.diet,d.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='pilosa' OR species='pilosa') 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='Sterculia' 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='Sterculia' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' 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='Sterculia' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strychnos' AND (junior_species='pechii' OR junior_species='pechi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strychnos' AND (species='pechii' OR species='pechi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strychnos' AND (species='pechii' OR species='pechi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strychnos' AND (junior_species='pechii' OR junior_species='pechi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strychnos' AND (species='pechii' OR species='pechi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stryphnodendron' AND (junior_species='pulcherrimum' OR junior_species='pulcherrimum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stryphnodendron' AND (species='pulcherrimum' OR species='pulcherrimum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stryphnodendron' AND (species='pulcherrimum' OR species='pulcherrimum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stryphnodendron' AND (junior_species='pulcherrimum' OR junior_species='pulcherrimum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stryphnodendron' AND (species='pulcherrimum' OR species='pulcherrimum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='arborescens' OR junior_species='arborescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='arborescens' OR species='arborescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='arborescens' OR species='arborescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='arborescens' OR junior_species='arborescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swartzia' AND (species='arborescens' OR species='arborescens') 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='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='Tachigali' 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='Tachigali' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigali' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' 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='Tachigali' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='myrmecophila' OR junior_species='myrmecophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachigali' AND (species='myrmecophila' OR species='myrmecophila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigali' AND (species='myrmecophila' OR species='myrmecophila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='myrmecophila' OR junior_species='myrmecophila')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachigali' AND (species='myrmecophila' OR species='myrmecophila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' 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='Tachigali' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigali' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' 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='Tachigali' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='retusa' OR junior_species='retusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talisia' AND (species='retusa' OR species='retusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talisia' AND (species='retusa' OR species='retusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='retusa' OR junior_species='retusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Talisia' AND (species='retusa' OR species='retusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' 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='Talisia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talisia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' 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='Talisia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='subalbens' OR junior_species='subalbens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talisia' AND (species='subalbens' OR species='subalbens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talisia' AND (species='subalbens' OR species='subalbens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talisia' AND (junior_species='subalbens' OR junior_species='subalbens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Talisia' AND (species='subalbens' OR species='subalbens') 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='Terminalia' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='amazonica' OR species='amazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='amazonica' OR species='amazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='amazonica' OR species='amazonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='argentea' OR junior_species='argentea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='argentea' OR species='argentea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='argentea' OR species='argentea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='argentea' OR junior_species='argentea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='argentea' OR species='argentea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' 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='Terminalia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' 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='Terminalia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='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='Tetrapteryx' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrapteryx' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrapteryx' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrapteryx' AND (junior_species='discolor' OR junior_species='discolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetrapteryx' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='grandiflorum' OR junior_species='grandiflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='grandiflorum' OR species='grandiflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='grandiflorum' OR species='grandiflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='grandiflorum' OR junior_species='grandiflorum')SELECT d.diet,d.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='grandiflorum' OR species='grandiflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='speciosum' OR junior_species='speciosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='speciosum' OR species='speciosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='speciosum' OR species='speciosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='speciosum' OR junior_species='speciosum')SELECT d.diet,d.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='speciosum' OR species='speciosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='paraense' OR junior_species='paraense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='paraense' OR species='paraense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='paraense' OR species='paraense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='paraense' OR junior_species='paraense')SELECT d.diet,d.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='paraense' OR species='paraense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tovomita' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tovomita' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tovomita' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT d.diet,d.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='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trattinickia' AND (junior_species='rhoifolia' OR junior_species='rhoifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trattinickia' AND (species='rhoifolia' OR species='rhoifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trattinickia' AND (species='rhoifolia' OR species='rhoifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trattinickia' AND (junior_species='rhoifolia' OR junior_species='rhoifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trattinickia' AND (species='rhoifolia' OR species='rhoifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='rubra' OR junior_species='rubra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichilia' AND (species='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='micrantha' OR junior_species='micrantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='micrantha' OR species='micrantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='micrantha' OR species='micrantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='micrantha' OR junior_species='micrantha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichilia' AND (species='micrantha' OR species='micrantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichilia' AND (species='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='septentrionalis' OR species='septentrionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='septentrionalis' OR species='septentrionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichilia' AND (species='septentrionalis' OR species='septentrionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trymatococcus' AND (junior_species='oligandrus' OR junior_species='oligandrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trymatococcus' AND (species='oligandrus' OR species='oligandrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trymatococcus' AND (species='oligandrus' OR species='oligandrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trymatococcus' AND (junior_species='oligandrus' OR junior_species='oligandrus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trymatococcus' AND (species='oligandrus' OR species='oligandrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelii' OR junior_species='micheli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='michelii' OR species='micheli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='michelii' OR species='micheli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='michelii' OR junior_species='micheli')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Virola' AND (species='michelii' OR species='micheli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Vitex' AND (junior_species='triflora' OR junior_species='triflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='triflora' OR species='triflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='triflora' OR species='triflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='triflora' OR junior_species='triflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vitex' AND (species='triflora' OR species='triflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='regnelliana' OR junior_species='regnelliana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='regnelliana' OR species='regnelliana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='regnelliana' OR species='regnelliana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='regnelliana' OR junior_species='regnelliana')SELECT d.diet,d.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='regnelliana' OR species='regnelliana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zollernia' 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='Zollernia' AND (species='paraensis' OR species='paraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zollernia' AND (species='paraensis' OR species='paraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zollernia' 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='Zollernia' AND (species='paraensis' OR species='paraensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3327