Coordinate: 0° 36' 54" N, 99° 27' 23" E
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=186 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=186SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=74SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=186 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='javanicum' OR junior_species='javanicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alangium' AND (species='javanicum' OR species='javanicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alangium' AND (species='javanicum' OR species='javanicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='javanicum' OR junior_species='javanicum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alangium' AND (species='javanicum' OR species='javanicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='sessilifolia' OR junior_species='sessilifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchanania' AND (species='sessilifolia' OR species='sessilifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchanania' AND (species='sessilifolia' OR species='sessilifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='sessilifolia' OR junior_species='sessilifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Buchanania' AND (species='sessilifolia' OR species='sessilifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='swintonioides' OR junior_species='swintonioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='swintonioides' OR species='swintonioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='swintonioides' OR species='swintonioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='swintonioides' OR junior_species='swintonioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mangifera' AND (species='swintonioides' OR species='swintonioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='laurina' OR junior_species='laurina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='laurina' OR species='laurina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='laurina' OR species='laurina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='laurina' OR junior_species='laurina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mangifera' AND (species='laurina' OR species='laurina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='caesia' OR junior_species='caesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanochyla' AND (species='caesia' OR species='caesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanochyla' AND (species='caesia' OR species='caesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='caesia' OR junior_species='caesia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanochyla' AND (species='caesia' OR species='caesia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='bracteata' OR junior_species='bracteata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanochyla' AND (species='bracteata' OR species='bracteata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanochyla' AND (species='bracteata' OR species='bracteata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='bracteata' OR junior_species='bracteata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanochyla' AND (species='bracteata' OR species='bracteata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swintonia' AND (junior_species='glauca' OR junior_species='glauca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swintonia' AND (species='glauca' OR species='glauca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swintonia' AND (species='glauca' OR species='glauca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swintonia' AND (junior_species='glauca' OR junior_species='glauca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swintonia' AND (species='glauca' OR species='glauca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Annonaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Annonaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annonaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Annonaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' AND (junior_species='biovulatus' OR junior_species='biovulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyathocalyx' AND (species='biovulatus' OR species='biovulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyathocalyx' AND (species='biovulatus' OR species='biovulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' AND (junior_species='biovulatus' OR junior_species='biovulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyathocalyx' AND (species='biovulatus' OR species='biovulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' 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='Cyathocalyx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyathocalyx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' 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='Cyathocalyx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melodorum' AND (junior_species='kentii' OR junior_species='kenti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melodorum' AND (species='kentii' OR species='kenti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melodorum' AND (species='kentii' OR species='kenti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melodorum' AND (junior_species='kentii' OR junior_species='kenti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melodorum' AND (species='kentii' OR species='kenti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mezzettia' AND (junior_species='parviflora' OR junior_species='parviflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mezzettia' AND (species='parviflora' OR species='parviflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mezzettia' AND (species='parviflora' OR species='parviflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mezzettia' AND (junior_species='parviflora' OR junior_species='parviflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mezzettia' AND (species='parviflora' OR species='parviflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='cauliflora' OR junior_species='cauliflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyalthia' AND (species='cauliflora' OR species='cauliflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyalthia' AND (species='cauliflora' OR species='cauliflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='cauliflora' OR junior_species='cauliflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyalthia' AND (species='cauliflora' OR species='cauliflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='lateriflora' OR junior_species='lateriflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyalthia' AND (species='lateriflora' OR species='lateriflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyalthia' AND (species='lateriflora' OR species='lateriflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='lateriflora' OR junior_species='lateriflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyalthia' AND (species='lateriflora' OR species='lateriflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maasia' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maasia' AND (species='sumatrana' OR species='sumatrana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maasia' AND (species='sumatrana' OR species='sumatrana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maasia' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maasia' AND (species='sumatrana' OR species='sumatrana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sageraea' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sageraea' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sageraea' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sageraea' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sageraea' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='malayana' OR junior_species='malayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='malayana' OR species='malayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='malayana' OR species='malayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='malayana' OR junior_species='malayana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xylopia' AND (species='malayana' OR species='malayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncosperma' AND (junior_species='horridum' OR junior_species='horridum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oncosperma' AND (species='horridum' OR species='horridum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oncosperma' AND (species='horridum' OR species='horridum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncosperma' AND (junior_species='horridum' OR junior_species='horridum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oncosperma' AND (species='horridum' OR species='horridum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vernonia' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vernonia' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vernonia' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vernonia' AND (junior_species='arborea' OR junior_species='arborea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vernonia' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Durio' AND (species='malaccensis' OR species='malaccensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Durio' AND (species='malaccensis' OR species='malaccensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Durio' AND (species='malaccensis' OR species='malaccensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='oxleyanus' OR junior_species='oxleyanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Durio' AND (species='oxleyanus' OR species='oxleyanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Durio' AND (species='oxleyanus' OR species='oxleyanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='oxleyanus' OR junior_species='oxleyanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Durio' AND (species='oxleyanus' OR species='oxleyanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='zibethinus' OR junior_species='zibethinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Durio' AND (species='zibethinus' OR species='zibethinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Durio' AND (species='zibethinus' OR species='zibethinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Durio' AND (junior_species='zibethinus' OR junior_species='zibethinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Durio' AND (species='zibethinus' OR species='zibethinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neesia' 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='Neesia' AND (species='altissima' OR species='altissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neesia' AND (species='altissima' OR species='altissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neesia' 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='Neesia' AND (species='altissima' OR species='altissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='littorale' OR junior_species='littorale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='littorale' OR species='littorale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='littorale' OR species='littorale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='littorale' OR junior_species='littorale')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canarium' AND (species='littorale' OR species='littorale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='patentinervium' OR junior_species='patentinervium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='patentinervium' OR species='patentinervium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='patentinervium' OR species='patentinervium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='patentinervium' OR junior_species='patentinervium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canarium' AND (species='patentinervium' OR species='patentinervium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='laxa' OR junior_species='laxa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='laxa' OR species='laxa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='laxa' OR species='laxa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='laxa' OR junior_species='laxa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dacryodes' AND (species='laxa' OR species='laxa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='rostrata' OR species='rostrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='rostrata' OR species='rostrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dacryodes' AND (species='rostrata' OR species='rostrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' 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='Dacryodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' 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='Dacryodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='apiculata' OR junior_species='apiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Santiria' AND (species='apiculata' OR species='apiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Santiria' AND (species='apiculata' OR species='apiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='apiculata' OR junior_species='apiculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Santiria' AND (species='apiculata' OR species='apiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='laevigata' OR junior_species='laevigata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Santiria' AND (species='laevigata' OR species='laevigata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Santiria' AND (species='laevigata' OR species='laevigata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='laevigata' OR junior_species='laevigata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Santiria' AND (species='laevigata' OR species='laevigata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' 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='Santiria' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Santiria' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' 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='Santiria' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kokoona' AND (junior_species='littoralis' OR junior_species='littoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kokoona' AND (species='littoralis' OR species='littoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kokoona' AND (species='littoralis' OR species='littoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kokoona' AND (junior_species='littoralis' OR junior_species='littoralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kokoona' AND (species='littoralis' OR species='littoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='rigidum' OR junior_species='rigidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calophyllum' AND (species='rigidum' OR species='rigidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calophyllum' AND (species='rigidum' OR species='rigidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='rigidum' OR junior_species='rigidum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calophyllum' AND (species='rigidum' OR species='rigidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratoxylum' 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='Cratoxylum' AND (species='arborescens' OR species='arborescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cratoxylum' AND (species='arborescens' OR species='arborescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratoxylum' 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='Cratoxylum' AND (species='arborescens' OR species='arborescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='gaudichaudii' OR junior_species='gaudichaudi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='gaudichaudii' OR species='gaudichaudi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='gaudichaudii' OR species='gaudichaudi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='gaudichaudii' OR junior_species='gaudichaudi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Garcinia' AND (species='gaudichaudii' OR species='gaudichaudi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='havilandii' OR junior_species='havilandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='havilandii' OR species='havilandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='havilandii' OR species='havilandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='havilandii' OR junior_species='havilandi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Garcinia' AND (species='havilandii' OR species='havilandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' 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='Garcinia' AND (species='parvifolia' OR species='parvifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='parvifolia' OR species='parvifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' 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='Garcinia' AND (species='parvifolia' OR species='parvifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' 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='Garcinia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' 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='Garcinia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' 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='Mesua' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesua' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' 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='Mesua' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesua' AND (species='ferrea' OR species='ferrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesua' AND (species='ferrea' OR species='ferrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesua' AND (species='ferrea' OR species='ferrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastixia' AND (junior_species='trichotoma' OR junior_species='trichotoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastixia' AND (species='trichotoma' OR species='trichotoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastixia' AND (species='trichotoma' OR species='trichotoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastixia' AND (junior_species='trichotoma' OR junior_species='trichotoma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mastixia' AND (species='trichotoma' OR species='trichotoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisoptera' AND (junior_species='costata' OR junior_species='costata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisoptera' AND (species='costata' OR species='costata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisoptera' AND (species='costata' OR species='costata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisoptera' AND (junior_species='costata' OR junior_species='costata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisoptera' AND (species='costata' OR species='costata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='palembanicus' OR junior_species='palembanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipterocarpus' AND (species='palembanicus' OR species='palembanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipterocarpus' AND (species='palembanicus' OR species='palembanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='palembanicus' OR junior_species='palembanicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dipterocarpus' AND (species='palembanicus' OR species='palembanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='beccariana' OR junior_species='beccariana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hopea' AND (species='beccariana' OR species='beccariana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hopea' AND (species='beccariana' OR species='beccariana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='beccariana' OR junior_species='beccariana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hopea' AND (species='beccariana' OR species='beccariana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hopea' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hopea' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='nigra' OR junior_species='nigra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hopea' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='exelliptica' OR junior_species='exelliptica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='exelliptica' OR species='exelliptica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='exelliptica' OR species='exelliptica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='exelliptica' OR junior_species='exelliptica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Shorea' AND (species='exelliptica' OR species='exelliptica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='gibbosa' OR junior_species='gibbosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='gibbosa' OR species='gibbosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='gibbosa' OR species='gibbosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='gibbosa' OR junior_species='gibbosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Shorea' AND (species='gibbosa' OR species='gibbosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='parvifolia' OR species='parvifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='parvifolia' OR species='parvifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='parvifolia' OR species='parvifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='platyclados' OR junior_species='platyclados')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='platyclados' OR species='platyclados') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='platyclados' OR species='platyclados')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='platyclados' OR junior_species='platyclados')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Shorea' AND (species='platyclados' OR species='platyclados') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' 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='Shorea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='mangachapoi' OR junior_species='mangachapoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vatica' AND (species='mangachapoi' OR species='mangachapoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vatica' AND (species='mangachapoi' OR species='mangachapoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='mangachapoi' OR junior_species='mangachapoii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vatica' AND (species='mangachapoi' OR species='mangachapoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' 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='Vatica' AND (species='micrantha' OR species='micrantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vatica' AND (species='micrantha' OR species='micrantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' 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='Vatica' AND (species='micrantha' OR species='micrantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='perakensis' OR junior_species='perakensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vatica' AND (species='perakensis' OR species='perakensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vatica' AND (species='perakensis' OR species='perakensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='perakensis' OR junior_species='perakensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vatica' AND (species='perakensis' OR species='perakensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pseudomalabarica' OR junior_species='pseudomalabarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='pseudomalabarica' OR species='pseudomalabarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='pseudomalabarica' OR species='pseudomalabarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pseudomalabarica' OR junior_species='pseudomalabarica')SELECT d.diet,d.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='pseudomalabarica' OR species='pseudomalabarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sumatrana' OR species='sumatrana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sumatrana' OR species='sumatrana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT d.diet,d.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='sumatrana' OR species='sumatrana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='mastersii' OR junior_species='mastersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='mastersii' OR species='mastersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='mastersii' OR species='mastersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='mastersii' OR junior_species='mastersi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='mastersii' OR species='mastersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='parvifolius' OR junior_species='parvifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='parvifolius' OR species='parvifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='parvifolius' OR species='parvifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='parvifolius' OR junior_species='parvifolius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='parvifolius' OR species='parvifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='antennifera' OR junior_species='antennifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='antennifera' OR species='antennifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='antennifera' OR species='antennifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='antennifera' OR junior_species='antennifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aporosa' AND (species='antennifera' OR species='antennifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='falcifera' OR junior_species='falcifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='falcifera' OR species='falcifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='falcifera' OR species='falcifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='falcifera' OR junior_species='falcifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aporosa' AND (species='falcifera' OR species='falcifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='grandistipula' OR junior_species='grandistipula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='grandistipula' OR species='grandistipula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='grandistipula' OR species='grandistipula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='grandistipula' OR junior_species='grandistipula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aporosa' AND (species='grandistipula' OR species='grandistipula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='maingayi' OR junior_species='maingayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='maingayi' OR species='maingayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='maingayi' OR species='maingayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='maingayi' OR junior_species='maingayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aporosa' AND (species='maingayi' OR species='maingayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='symplocoides' OR junior_species='symplocoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporosa' AND (species='symplocoides' OR species='symplocoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporosa' AND (species='symplocoides' OR species='symplocoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporosa' AND (junior_species='symplocoides' OR junior_species='symplocoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aporosa' AND (species='symplocoides' OR species='symplocoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='brevipes' OR junior_species='brevipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baccaurea' AND (species='brevipes' OR species='brevipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baccaurea' AND (species='brevipes' OR species='brevipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='brevipes' OR junior_species='brevipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Baccaurea' AND (species='brevipes' OR species='brevipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='dulcis' OR junior_species='dulcis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baccaurea' AND (species='dulcis' OR species='dulcis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baccaurea' AND (species='dulcis' OR species='dulcis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='dulcis' OR junior_species='dulcis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Baccaurea' AND (species='dulcis' OR species='dulcis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' 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='Baccaurea' AND (species='multiflora' OR species='multiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baccaurea' AND (species='multiflora' OR species='multiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' 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='Baccaurea' AND (species='multiflora' OR species='multiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blumeodendron' AND (junior_species='tokbrai' OR junior_species='tokbraii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blumeodendron' AND (species='tokbrai' OR species='tokbraii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blumeodendron' AND (species='tokbrai' OR species='tokbraii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blumeodendron' AND (junior_species='tokbrai' OR junior_species='tokbraii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blumeodendron' AND (species='tokbrai' OR species='tokbraii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='longifolia' OR junior_species='longifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='longifolia' OR species='longifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='longifolia' OR species='longifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='longifolia' OR junior_species='longifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drypetes' AND (species='longifolia' OR species='longifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='gigantea' OR species='gigantea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='gigantea' OR species='gigantea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaranga' AND (species='gigantea' OR species='gigantea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='hosei' OR junior_species='hoseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='hosei' OR species='hoseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='hosei' OR species='hoseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='hosei' OR junior_species='hoseii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaranga' AND (species='hosei' OR species='hoseii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='hypoleuca' OR species='hypoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaranga' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='lowii' OR junior_species='lowi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='lowii' OR species='lowi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='lowii' OR species='lowi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='lowii' OR junior_species='lowi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaranga' AND (species='lowii' OR species='lowi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='penangensis' OR junior_species='penangensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='penangensis' OR species='penangensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='penangensis' OR species='penangensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='penangensis' OR junior_species='penangensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mallotus' AND (species='penangensis' OR species='penangensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscortechinia' AND (junior_species='kingii' OR junior_species='kingi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscortechinia' AND (species='kingii' OR species='kingi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscortechinia' AND (species='kingii' OR species='kingi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscortechinia' AND (junior_species='kingii' OR junior_species='kingi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neoscortechinia' AND (species='kingii' OR species='kingi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pimelodendron' AND (junior_species='griffithianum' OR junior_species='griffithianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pimelodendron' AND (species='griffithianum' OR species='griffithianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pimelodendron' AND (species='griffithianum' OR species='griffithianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pimelodendron' AND (junior_species='griffithianum' OR junior_species='griffithianum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pimelodendron' AND (species='griffithianum' OR species='griffithianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychopyxis' AND (junior_species='kingii' OR junior_species='kingi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychopyxis' AND (species='kingii' OR species='kingi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychopyxis' AND (species='kingii' OR species='kingi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychopyxis' AND (junior_species='kingii' OR junior_species='kingi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptychopyxis' AND (species='kingii' OR species='kingi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balakata' AND (junior_species='baccata' OR junior_species='baccata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balakata' AND (species='baccata' OR species='baccata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balakata' AND (species='baccata' OR species='baccata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balakata' AND (junior_species='baccata' OR junior_species='baccata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Balakata' AND (species='baccata' OR species='baccata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' 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='Archidendron' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archidendron' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' 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='Archidendron' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='bubalinum' OR junior_species='bubalinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archidendron' AND (species='bubalinum' OR species='bubalinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archidendron' AND (species='bubalinum' OR species='bubalinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='bubalinum' OR junior_species='bubalinum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archidendron' AND (species='bubalinum' OR species='bubalinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fabaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fabaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fabaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fabaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fabaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koompassia' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Koompassia' AND (species='malaccensis' OR species='malaccensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Koompassia' AND (species='malaccensis' OR species='malaccensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koompassia' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Koompassia' AND (species='malaccensis' OR species='malaccensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ormosia' AND (species='sumatrana' OR species='sumatrana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ormosia' AND (species='sumatrana' OR species='sumatrana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ormosia' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT d.diet,d.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='sumatrana' OR species='sumatrana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' 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='Parkia' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' 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='Parkia' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' 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='Castanopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' 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='Castanopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' 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='Castanopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' 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='Castanopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='bennetii' OR junior_species='benneti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='bennetii' OR species='benneti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='bennetii' OR species='benneti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='bennetii' OR junior_species='benneti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithocarpus' AND (species='bennetii' OR species='benneti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='cyclophorus' OR junior_species='cyclophorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='cyclophorus' OR species='cyclophorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='cyclophorus' OR species='cyclophorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='cyclophorus' OR junior_species='cyclophorus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithocarpus' AND (species='cyclophorus' OR species='cyclophorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' 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='Lithocarpus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' 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='Lithocarpus' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='hystrix' OR junior_species='hystrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='hystrix' OR species='hystrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='hystrix' OR species='hystrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='hystrix' OR junior_species='hystrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithocarpus' AND (species='hystrix' OR species='hystrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithocarpus' AND (species='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' 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='Lithocarpus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' 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='Lithocarpus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='argentata' OR junior_species='argentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='argentata' OR species='argentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='argentata' OR species='argentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='argentata' OR junior_species='argentata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quercus' AND (species='argentata' OR species='argentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='gemelliflora' OR junior_species='gemelliflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='gemelliflora' OR species='gemelliflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='gemelliflora' OR species='gemelliflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='gemelliflora' OR junior_species='gemelliflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quercus' AND (species='gemelliflora' OR species='gemelliflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='subsericea' OR junior_species='subsericea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='subsericea' OR species='subsericea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='subsericea' OR species='subsericea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='subsericea' OR junior_species='subsericea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quercus' AND (species='subsericea' OR species='subsericea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ryparosa' AND (junior_species='caesia' OR junior_species='caesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ryparosa' AND (species='caesia' OR species='caesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ryparosa' AND (species='caesia' OR species='caesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ryparosa' AND (junior_species='caesia' OR junior_species='caesia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ryparosa' AND (species='caesia' OR species='caesia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platea' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platea' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platea' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platea' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platea' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphne' AND (junior_species='peduncularis' OR junior_species='peduncularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alseodaphne' AND (species='peduncularis' OR species='peduncularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alseodaphne' AND (species='peduncularis' OR species='peduncularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphne' AND (junior_species='peduncularis' OR junior_species='peduncularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alseodaphne' AND (species='peduncularis' OR species='peduncularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='dictyoneura' OR junior_species='dictyoneura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='dictyoneura' OR species='dictyoneura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='dictyoneura' OR species='dictyoneura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='dictyoneura' OR junior_species='dictyoneura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Beilschmiedia' AND (species='dictyoneura' OR species='dictyoneura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='madang' OR junior_species='madang')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='madang' OR species='madang') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='madang' OR species='madang')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='madang' OR junior_species='madang')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Beilschmiedia' AND (species='madang' OR species='madang') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='ferrea' OR species='ferrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='ferrea' OR species='ferrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='ferrea' OR species='ferrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' 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='Cryptocarya' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' 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='Cryptocarya' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='firma' OR junior_species='firma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='firma' OR species='firma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='firma' OR species='firma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='firma' OR junior_species='firma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Litsea' AND (species='firma' OR species='firma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='odorifera' OR junior_species='odorifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='odorifera' OR species='odorifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='odorifera' OR species='odorifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='odorifera' OR junior_species='odorifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Litsea' AND (species='odorifera' OR species='odorifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='resinosa' OR junior_species='resinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='resinosa' OR species='resinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='resinosa' OR species='resinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='resinosa' OR junior_species='resinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Litsea' AND (species='resinosa' OR species='resinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' 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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='oligoneurum' OR junior_species='oligoneurum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memecylon' AND (species='oligoneurum' OR species='oligoneurum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='oligoneurum' OR species='oligoneurum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='oligoneurum' OR junior_species='oligoneurum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memecylon' AND (species='oligoneurum' OR species='oligoneurum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' AND (junior_species='cordata' OR junior_species='cordata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pternandra' AND (species='cordata' OR species='cordata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pternandra' AND (species='cordata' OR species='cordata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' AND (junior_species='cordata' OR junior_species='cordata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pternandra' AND (species='cordata' OR species='cordata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pternandra' AND (species='rostrata' OR species='rostrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pternandra' AND (species='rostrata' OR species='rostrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pternandra' AND (species='rostrata' OR species='rostrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' 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='Pternandra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pternandra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pternandra' 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='Pternandra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='ganggo' OR junior_species='ganggo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglaia' AND (species='ganggo' OR species='ganggo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaia' AND (species='ganggo' OR species='ganggo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='ganggo' OR junior_species='ganggo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aglaia' AND (species='ganggo' OR species='ganggo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='odoratissima' OR junior_species='odoratissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglaia' AND (species='odoratissima' OR species='odoratissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaia' AND (species='odoratissima' OR species='odoratissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='odoratissima' OR junior_species='odoratissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aglaia' AND (species='odoratissima' OR species='odoratissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' 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='Aglaia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' 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='Aglaia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chisocheton' AND (junior_species='patens' OR junior_species='patens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chisocheton' AND (species='patens' OR species='patens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chisocheton' AND (species='patens' OR species='patens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chisocheton' AND (junior_species='patens' OR junior_species='patens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chisocheton' AND (species='patens' OR species='patens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='cauliflorum' OR junior_species='cauliflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='cauliflorum' OR junior_species='cauliflorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' 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='Dysoxylum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' 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='Dysoxylum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandoricum' AND (junior_species='koetjape' OR junior_species='koetjape')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sandoricum' AND (species='koetjape' OR species='koetjape') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sandoricum' AND (species='koetjape' OR species='koetjape')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandoricum' AND (junior_species='koetjape' OR junior_species='koetjape')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sandoricum' AND (species='koetjape' OR species='koetjape') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='kemando' OR junior_species='kemando')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='kemando' OR species='kemando') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='kemando' OR species='kemando')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='kemando' OR junior_species='kemando')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artocarpus' AND (species='kemando' OR species='kemando') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artocarpus' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='drupacea' OR junior_species='drupacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='drupacea' OR species='drupacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='drupacea' OR species='drupacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='drupacea' OR junior_species='drupacea')SELECT d.diet,d.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='drupacea' OR species='drupacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horsfieldia' AND (junior_species='polyspherula' OR junior_species='polyspherula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Horsfieldia' AND (species='polyspherula' OR species='polyspherula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Horsfieldia' AND (species='polyspherula' OR species='polyspherula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horsfieldia' AND (junior_species='polyspherula' OR junior_species='polyspherula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Horsfieldia' AND (species='polyspherula' OR species='polyspherula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Knema' AND (species='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='latericia' OR junior_species='latericia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='latericia' OR species='latericia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='latericia' OR species='latericia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='latericia' OR junior_species='latericia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Knema' AND (species='latericia' OR species='latericia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='laurina' OR junior_species='laurina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='laurina' OR species='laurina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='laurina' OR species='laurina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='laurina' OR junior_species='laurina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Knema' AND (species='laurina' OR species='laurina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='iners' OR junior_species='iners')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='iners' OR species='iners') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='iners' OR species='iners')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='iners' OR junior_species='iners')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myristica' AND (species='iners' OR species='iners') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Embelia' 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='Embelia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Embelia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Embelia' 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='Embelia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='acuminatum' OR junior_species='acuminatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='acuminatum' OR species='acuminatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='acuminatum' OR species='acuminatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='acuminatum' OR junior_species='acuminatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='acuminatum' OR species='acuminatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='antisepticum' OR junior_species='antisepticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='antisepticum' OR species='antisepticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='antisepticum' OR species='antisepticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='antisepticum' OR junior_species='antisepticum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='antisepticum' OR species='antisepticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='chloranthum' OR junior_species='chloranthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='chloranthum' OR species='chloranthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='chloranthum' OR species='chloranthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='chloranthum' OR junior_species='chloranthum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='chloranthum' OR species='chloranthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='confertum' OR junior_species='confertum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='confertum' OR species='confertum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='confertum' OR species='confertum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='confertum' OR junior_species='confertum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='confertum' OR species='confertum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cymosum' OR junior_species='cymosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cymosum' OR species='cymosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cymosum' OR species='cymosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cymosum' OR junior_species='cymosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='cymosum' OR species='cymosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='fastigiatum' OR junior_species='fastigiatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='fastigiatum' OR species='fastigiatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='fastigiatum' OR species='fastigiatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='fastigiatum' OR junior_species='fastigiatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='fastigiatum' OR species='fastigiatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='flosculifera' OR junior_species='flosculifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='flosculifera' OR species='flosculifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='flosculifera' OR species='flosculifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='flosculifera' OR junior_species='flosculifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='flosculifera' OR species='flosculifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='griffithii' OR junior_species='griffithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='griffithii' OR species='griffithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='griffithii' OR species='griffithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='griffithii' OR junior_species='griffithi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='griffithii' OR species='griffithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='racemosum' OR species='racemosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='racemosum' OR species='racemosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='racemosum' OR species='racemosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tristaniopsis' AND (junior_species='whiteana' OR junior_species='whiteana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tristaniopsis' AND (species='whiteana' OR species='whiteana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tristaniopsis' AND (species='whiteana' OR species='whiteana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tristaniopsis' AND (junior_species='whiteana' OR junior_species='whiteana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tristaniopsis' AND (species='whiteana' OR species='whiteana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='ceylanica' OR junior_species='ceylanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strombosia' AND (species='ceylanica' OR species='ceylanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strombosia' AND (species='ceylanica' OR species='ceylanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='ceylanica' OR junior_species='ceylanica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strombosia' AND (species='ceylanica' OR species='ceylanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chionanthus' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chionanthus' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chionanthus' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='rufum' OR junior_species='rufum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthophyllum' AND (species='rufum' OR species='rufum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthophyllum' AND (species='rufum' OR species='rufum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='rufum' OR junior_species='rufum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthophyllum' AND (species='rufum' OR species='rufum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicia' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicia' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='serrata' OR junior_species='serrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicia' AND (species='serrata' OR species='serrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atuna' 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='Atuna' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atuna' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atuna' 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='Atuna' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='arborea' OR junior_species='arborea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prunus' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grisea' OR junior_species='grisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='grisea' OR species='grisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='grisea' OR species='grisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grisea' OR junior_species='grisea')SELECT d.diet,d.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='grisea' OR species='grisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aidia' 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='Aidia' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aidia' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aidia' 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='Aidia' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' 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='Canthium' AND (species='glabrum' OR species='glabrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='glabrum' OR species='glabrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' 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='Canthium' AND (species='glabrum' OR species='glabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricalysia' AND (junior_species='singularis' OR junior_species='singularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tricalysia' AND (species='singularis' OR species='singularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tricalysia' AND (species='singularis' OR species='singularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tricalysia' AND (junior_species='singularis' OR junior_species='singularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tricalysia' AND (species='singularis' OR species='singularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleropyrum' AND (junior_species='wallichianum' OR junior_species='wallichianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scleropyrum' AND (species='wallichianum' OR species='wallichianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scleropyrum' AND (species='wallichianum' OR species='wallichianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleropyrum' AND (junior_species='wallichianum' OR junior_species='wallichianum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scleropyrum' AND (species='wallichianum' OR species='wallichianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='chryseum' OR junior_species='chryseum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephelium' AND (species='chryseum' OR species='chryseum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephelium' AND (species='chryseum' OR species='chryseum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='chryseum' OR junior_species='chryseum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nephelium' AND (species='chryseum' OR species='chryseum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='cuspidatum' OR junior_species='cuspidatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephelium' AND (species='cuspidatum' OR species='cuspidatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephelium' AND (species='cuspidatum' OR species='cuspidatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='cuspidatum' OR junior_species='cuspidatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nephelium' AND (species='cuspidatum' OR species='cuspidatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='lappaceum' OR junior_species='lappaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephelium' AND (species='lappaceum' OR species='lappaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephelium' AND (species='lappaceum' OR species='lappaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephelium' AND (junior_species='lappaceum' OR junior_species='lappaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nephelium' AND (species='lappaceum' OR species='lappaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermum' AND (junior_species='laevigatum' OR junior_species='laevigatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xerospermum' AND (species='laevigatum' OR species='laevigatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xerospermum' AND (species='laevigatum' OR species='laevigatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermum' AND (junior_species='laevigatum' OR junior_species='laevigatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xerospermum' AND (species='laevigatum' OR species='laevigatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='gutta' OR junior_species='gutta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='gutta' OR species='gutta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='gutta' OR species='gutta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='gutta' OR junior_species='gutta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaquium' AND (species='gutta' OR species='gutta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='hexandrum' OR junior_species='hexandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='hexandrum' OR species='hexandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='hexandrum' OR species='hexandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='hexandrum' OR junior_species='hexandrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaquium' AND (species='hexandrum' OR species='hexandrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='quercifolium' OR junior_species='quercifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='quercifolium' OR species='quercifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='quercifolium' OR species='quercifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='quercifolium' OR junior_species='quercifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaquium' AND (species='quercifolium' OR species='quercifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='rostratum' OR junior_species='rostratum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='rostratum' OR species='rostratum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='rostratum' OR species='rostratum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='rostratum' OR junior_species='rostratum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaquium' AND (species='rostratum' OR species='rostratum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Payena' AND (junior_species='leerii' OR junior_species='leeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Payena' AND (species='leerii' OR species='leeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Payena' AND (species='leerii' OR species='leeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Payena' AND (junior_species='leerii' OR junior_species='leeri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Payena' AND (species='leerii' OR species='leeri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Planchonella' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planchonella' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' AND (junior_species='nitida' OR junior_species='nitida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Planchonella' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='malaccensis' OR species='malaccensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='malaccensis' OR species='malaccensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT d.diet,d.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='malaccensis' OR species='malaccensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heritiera' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heritiera' AND (species='sumatrana' OR species='sumatrana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heritiera' AND (species='sumatrana' OR species='sumatrana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heritiera' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heritiera' AND (species='sumatrana' OR species='sumatrana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='urceolata' OR junior_species='urceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='urceolata' OR species='urceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='urceolata' OR species='urceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='urceolata' OR junior_species='urceolata')SELECT d.diet,d.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='urceolata' OR species='urceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='paralleloneurus' OR junior_species='paralleloneurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='paralleloneurus' OR species='paralleloneurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='paralleloneurus' OR species='paralleloneurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='paralleloneurus' OR junior_species='paralleloneurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Styrax' AND (species='paralleloneurus' OR species='paralleloneurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' 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='Symplocos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' 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='Symplocos' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gordonia' AND (junior_species='singaporioana' OR junior_species='singaporioana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gordonia' AND (species='singaporioana' OR species='singaporioana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gordonia' AND (species='singaporioana' OR species='singaporioana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gordonia' AND (junior_species='singaporioana' OR junior_species='singaporioana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gordonia' AND (species='singaporioana' OR species='singaporioana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrenaria' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrenaria' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrenaria' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrenaria' AND (junior_species='serrata' OR junior_species='serrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrenaria' AND (species='serrata' OR species='serrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thea' 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='Thea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thea' 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='Thea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquilaria' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquilaria' AND (species='malaccensis' OR species='malaccensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquilaria' AND (species='malaccensis' OR species='malaccensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquilaria' AND (junior_species='malaccensis' OR junior_species='malaccensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aquilaria' AND (species='malaccensis' OR species='malaccensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonystylus' AND (junior_species='forbesii' OR junior_species='forbesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonystylus' AND (species='forbesii' OR species='forbesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonystylus' AND (species='forbesii' OR species='forbesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonystylus' AND (junior_species='forbesii' OR junior_species='forbesi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gonystylus' AND (species='forbesii' OR species='forbesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='quinata' OR junior_species='quinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='quinata' OR species='quinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='quinata' OR species='quinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='quinata' OR junior_species='quinata')SELECT d.diet,d.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='quinata' OR species='quinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unidentified' AND (junior_species='family' OR junior_species='family')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Unidentified' AND (species='family' OR species='family') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Unidentified' AND (species='family' OR species='family')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unidentified' AND (junior_species='family' OR junior_species='family')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Unidentified' AND (species='family' OR species='family') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=186