Coordinate: 12° 30' N, 75° 39' E
JA: MAT, WMT, CMT based on nearby site; WMT and CMT estimated from figure
< 50 mm/mo precip from December through March (leading into warmest month, April
), almost exactly 100 mm in April, and never 50 - 100 mm
SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=48 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=48SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=11SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=48 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='arnottiana' OR junior_species='arnottiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holigarna' AND (species='arnottiana' OR species='arnottiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='arnottiana' OR species='arnottiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='arnottiana' OR junior_species='arnottiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Holigarna' AND (species='arnottiana' OR species='arnottiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holigarna' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Holigarna' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='grahamii' OR junior_species='grahami')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holigarna' AND (species='grahamii' OR species='grahami') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='grahamii' OR species='grahami')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' AND (junior_species='grahamii' OR junior_species='grahami')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Holigarna' AND (species='grahamii' OR species='grahami') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' 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='Holigarna' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holigarna' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holigarna' 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='Holigarna' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.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='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopegia' AND (junior_species='beddomei' OR junior_species='beddomeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nothopegia' AND (species='beddomei' OR species='beddomeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothopegia' AND (species='beddomei' OR species='beddomeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopegia' AND (junior_species='beddomei' OR junior_species='beddomeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nothopegia' AND (species='beddomei' OR species='beddomeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='auriculata' OR junior_species='auriculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semecarpus' AND (species='auriculata' OR species='auriculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semecarpus' AND (species='auriculata' OR species='auriculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='auriculata' OR junior_species='auriculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Semecarpus' AND (species='auriculata' OR species='auriculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' AND (junior_species='zeylanicus' OR junior_species='zeylanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyathocalyx' AND (species='zeylanicus' OR species='zeylanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyathocalyx' AND (species='zeylanicus' OR species='zeylanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathocalyx' AND (junior_species='zeylanicus' OR junior_species='zeylanicus')SELECT d.diet,d.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='zeylanicus' OR species='zeylanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' 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='Goniothalamus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goniothalamus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' 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='Goniothalamus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='coffeoides' OR junior_species='coffeoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyalthia' AND (species='coffeoides' OR species='coffeoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyalthia' AND (species='coffeoides' OR species='coffeoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='coffeoides' OR junior_species='coffeoides')SELECT d.diet,d.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='coffeoides' OR species='coffeoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoon' AND (junior_species='fragrans' OR junior_species='fragrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monoon' AND (species='fragrans' OR species='fragrans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monoon' AND (species='fragrans' OR species='fragrans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoon' AND (junior_species='fragrans' OR junior_species='fragrans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monoon' AND (species='fragrans' OR species='fragrans') 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='Caryota' AND (junior_species='urens' OR junior_species='urens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryota' AND (species='urens' OR species='urens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryota' AND (species='urens' OR species='urens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryota' AND (junior_species='urens' OR junior_species='urens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caryota' AND (species='urens' OR species='urens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pajanelia' 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='Pajanelia' AND (species='longifolia' OR species='longifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pajanelia' AND (species='longifolia' OR species='longifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pajanelia' 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='Pajanelia' AND (species='longifolia' OR species='longifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='strictum' OR junior_species='strictum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='strictum' OR species='strictum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='strictum' OR species='strictum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='strictum' OR junior_species='strictum')SELECT d.diet,d.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='strictum' OR species='strictum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='indicus' OR junior_species='indicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euonymus' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophopetalum' AND (junior_species='wightianum' OR junior_species='wightianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophopetalum' AND (species='wightianum' OR species='wightianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophopetalum' AND (species='wightianum' OR species='wightianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophopetalum' AND (junior_species='wightianum' OR junior_species='wightianum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophopetalum' AND (species='wightianum' OR species='wightianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtropis' AND (junior_species='wallichiana' OR junior_species='wallichiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtropis' AND (species='wallichiana' OR species='wallichiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtropis' AND (species='wallichiana' OR species='wallichiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtropis' AND (junior_species='wallichiana' OR junior_species='wallichiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microtropis' AND (species='wallichiana' OR species='wallichiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='polyanthum' OR junior_species='polyanthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calophyllum' AND (species='polyanthum' OR species='polyanthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calophyllum' AND (species='polyanthum' OR species='polyanthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='polyanthum' OR junior_species='polyanthum')SELECT d.diet,d.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='polyanthum' OR species='polyanthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='gummigutta' OR junior_species='gummigutta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='gummigutta' OR species='gummigutta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='gummigutta' OR species='gummigutta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='gummigutta' OR junior_species='gummigutta')SELECT d.diet,d.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='gummigutta' OR species='gummigutta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='morella' OR species='morella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='morella' OR species='morella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')SELECT d.diet,d.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='morella' OR species='morella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='talbotii' OR junior_species='talboti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='talbotii' OR species='talboti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='talbotii' OR species='talboti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='talbotii' OR junior_species='talboti')SELECT d.diet,d.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='talbotii' OR species='talboti') 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='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='Mastixia' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastixia' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastixia' 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='Mastixia' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipterocarpus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipterocarpus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipterocarpus' AND (junior_species='indicus' OR junior_species='indicus')SELECT d.diet,d.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='indicus' OR species='indicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='ponga' OR junior_species='ponga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hopea' AND (species='ponga' OR species='ponga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hopea' AND (species='ponga' OR species='ponga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='ponga' OR junior_species='ponga')SELECT d.diet,d.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='ponga' OR species='ponga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vateria' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vateria' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vateria' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vateria' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vateria' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='bourdillonii' OR junior_species='bourdilloni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='bourdillonii' OR species='bourdilloni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='bourdillonii' OR species='bourdilloni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='bourdillonii' OR junior_species='bourdilloni')SELECT d.diet,d.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='bourdillonii' OR species='bourdilloni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='ghatensis' OR junior_species='ghatensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='ghatensis' OR species='ghatensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='ghatensis' OR species='ghatensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='ghatensis' OR junior_species='ghatensis')SELECT d.diet,d.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='ghatensis' OR species='ghatensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pruriens' OR junior_species='pruriens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='pruriens' OR species='pruriens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='pruriens' OR species='pruriens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pruriens' OR junior_species='pruriens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='pruriens' OR species='pruriens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='sylvatica' OR species='sylvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='serratus' OR junior_species='serratus')SELECT d.diet,d.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='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrostistachys' AND (junior_species='meeboldii' OR junior_species='meeboldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrostistachys' AND (species='meeboldii' OR species='meeboldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrostistachys' AND (species='meeboldii' OR species='meeboldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrostistachys' AND (junior_species='meeboldii' OR junior_species='meeboldi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agrostistachys' AND (species='meeboldii' OR species='meeboldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='menasu' OR junior_species='menasu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='menasu' OR species='menasu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='menasu' OR species='menasu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='menasu' OR junior_species='menasu')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antidesma' AND (species='menasu' OR species='menasu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='courtallensis' OR junior_species='courtallensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baccaurea' AND (species='courtallensis' OR species='courtallensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baccaurea' AND (species='courtallensis' OR species='courtallensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baccaurea' AND (junior_species='courtallensis' OR junior_species='courtallensis')SELECT d.diet,d.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='courtallensis' OR species='courtallensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blachia' AND (junior_species='denudata' OR junior_species='denudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blachia' AND (species='denudata' OR species='denudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blachia' AND (species='denudata' OR species='denudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blachia' AND (junior_species='denudata' OR junior_species='denudata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blachia' AND (species='denudata' OR species='denudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blachia' AND (junior_species='umbellata' OR junior_species='umbellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blachia' AND (species='umbellata' OR species='umbellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blachia' AND (species='umbellata' OR species='umbellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blachia' AND (junior_species='umbellata' OR junior_species='umbellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blachia' AND (species='umbellata' OR species='umbellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='malabaricus' OR junior_species='malabaricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='malabaricus' OR species='malabaricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='malabaricus' OR species='malabaricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='malabaricus' OR junior_species='malabaricus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Croton' AND (species='malabaricus' OR species='malabaricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimorphocalyx' AND (junior_species='beddomei' OR junior_species='beddomeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dimorphocalyx' AND (species='beddomei' OR species='beddomeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimorphocalyx' AND (species='beddomei' OR species='beddomeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimorphocalyx' AND (junior_species='beddomei' OR junior_species='beddomeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dimorphocalyx' AND (species='beddomei' OR species='beddomeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='elata' OR junior_species='elata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='elata' OR species='elata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='elata' OR species='elata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='elata' OR junior_species='elata')SELECT d.diet,d.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='elata' OR species='elata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fahrenheitia' AND (junior_species='zeylanica' OR junior_species='zeylanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fahrenheitia' AND (species='zeylanica' OR species='zeylanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fahrenheitia' AND (species='zeylanica' OR species='zeylanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fahrenheitia' AND (junior_species='zeylanica' OR junior_species='zeylanica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fahrenheitia' AND (species='zeylanica' OR species='zeylanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='malabaricum' OR junior_species='malabaricum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glochidion' AND (species='malabaricum' OR species='malabaricum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glochidion' AND (species='malabaricum' OR species='malabaricum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='malabaricum' OR junior_species='malabaricum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glochidion' AND (species='malabaricum' OR species='malabaricum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='peltata' OR junior_species='peltata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='peltata' OR species='peltata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='peltata' OR species='peltata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='peltata' OR junior_species='peltata')SELECT d.diet,d.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='peltata' OR species='peltata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='philippensis' OR species='philippensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='philippensis' OR species='philippensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT d.diet,d.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='philippensis' OR species='philippensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='tetracoccus' OR junior_species='tetracoccus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='tetracoccus' OR species='tetracoccus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='tetracoccus' OR species='tetracoccus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='tetracoccus' OR junior_species='tetracoccus')SELECT d.diet,d.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='tetracoccus' OR species='tetracoccus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Humboldtia' AND (junior_species='brunonis' OR junior_species='brunonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Humboldtia' AND (species='brunonis' OR species='brunonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Humboldtia' AND (species='brunonis' OR species='brunonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Humboldtia' AND (junior_species='brunonis' OR junior_species='brunonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Humboldtia' AND (species='brunonis' OR species='brunonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kingiodendron' AND (junior_species='pinnatum' OR junior_species='pinnatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kingiodendron' AND (species='pinnatum' OR species='pinnatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kingiodendron' AND (species='pinnatum' OR species='pinnatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kingiodendron' AND (junior_species='pinnatum' OR junior_species='pinnatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kingiodendron' AND (species='pinnatum' OR species='pinnatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='graveolens' OR junior_species='graveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='graveolens' OR species='graveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='graveolens' OR species='graveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='graveolens' OR junior_species='graveolens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Casearia' AND (species='graveolens' OR species='graveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtia' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flacourtia' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flacourtia' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtia' AND (junior_species='montana' OR junior_species='montana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Flacourtia' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='alpina' OR junior_species='alpina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydnocarpus' AND (species='alpina' OR species='alpina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydnocarpus' AND (species='alpina' OR species='alpina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='alpina' OR junior_species='alpina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hydnocarpus' AND (species='alpina' OR species='alpina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='pentandra' OR junior_species='pentandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydnocarpus' AND (species='pentandra' OR species='pentandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydnocarpus' AND (species='pentandra' OR species='pentandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydnocarpus' AND (junior_species='pentandra' OR junior_species='pentandra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hydnocarpus' AND (species='pentandra' OR species='pentandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='tadulingamii' OR junior_species='tadulingami')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinodaphne' AND (species='tadulingamii' OR species='tadulingami') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinodaphne' AND (species='tadulingamii' OR species='tadulingami')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='tadulingamii' OR junior_species='tadulingami')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actinodaphne' AND (species='tadulingamii' OR species='tadulingami') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='wightii' OR junior_species='wighti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='wightii' OR species='wighti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='wightii' OR species='wighti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='wightii' OR junior_species='wighti')SELECT d.diet,d.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='wightii' OR species='wighti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='wightiana' OR junior_species='wightiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='wightiana' OR species='wightiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='wightiana' OR species='wightiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='wightiana' OR junior_species='wightiana')SELECT d.diet,d.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='wightiana' OR species='wightiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='floribunda' OR junior_species='floribunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='floribunda' OR species='floribunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='floribunda' OR species='floribunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='floribunda' OR junior_species='floribunda')SELECT d.diet,d.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='floribunda' OR species='floribunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machilus' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machilus' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machilus' AND (species='glaucescens' OR species='glaucescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machilus' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machilus' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='wightii' OR junior_species='wighti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memecylon' AND (species='wightii' OR species='wighti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='wightii' OR species='wighti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='wightii' OR junior_species='wighti')SELECT d.diet,d.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='wightii' OR species='wighti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' 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='Memecylon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' 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='Memecylon' 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='barberi' OR junior_species='barberii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglaia' AND (species='barberi' OR species='barberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaia' AND (species='barberi' OR species='barberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='barberi' OR junior_species='barberii')SELECT d.diet,d.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='barberi' OR species='barberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphanamixis' AND (junior_species='polystachya' OR junior_species='polystachya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphanamixis' AND (species='polystachya' OR species='polystachya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphanamixis' AND (species='polystachya' OR species='polystachya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphanamixis' AND (junior_species='polystachya' OR junior_species='polystachya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphanamixis' AND (species='polystachya' OR species='polystachya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reinwardtiodendron' AND (junior_species='anaimalaiense' OR junior_species='anaimalaiense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reinwardtiodendron' AND (species='anaimalaiense' OR species='anaimalaiense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Reinwardtiodendron' AND (species='anaimalaiense' OR species='anaimalaiense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reinwardtiodendron' AND (junior_species='anaimalaiense' OR junior_species='anaimalaiense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Reinwardtiodendron' AND (species='anaimalaiense' OR species='anaimalaiense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walsura' AND (junior_species='trifolia' OR junior_species='trifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walsura' AND (species='trifolia' OR species='trifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walsura' AND (species='trifolia' OR species='trifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walsura' AND (junior_species='trifolia' OR junior_species='trifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Walsura' AND (species='trifolia' OR species='trifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' AND (junior_species='toxicaria' OR junior_species='toxicaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antiaris' AND (species='toxicaria' OR species='toxicaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antiaris' AND (species='toxicaria' OR species='toxicaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' AND (junior_species='toxicaria' OR junior_species='toxicaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antiaris' AND (species='toxicaria' OR species='toxicaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='heterophyllus' OR junior_species='heterophyllus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='heterophyllus' OR species='heterophyllus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='heterophyllus' OR species='heterophyllus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='heterophyllus' OR junior_species='heterophyllus')SELECT d.diet,d.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='heterophyllus' OR species='heterophyllus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='hirsutus' OR species='hirsutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT d.diet,d.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='hirsutus' OR species='hirsutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='nervosa' OR junior_species='nervosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='nervosa' OR species='nervosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='nervosa' OR species='nervosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='nervosa' OR junior_species='nervosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ficus' AND (species='nervosa' OR species='nervosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='attenuata' OR junior_species='attenuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='attenuata' OR species='attenuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='attenuata' OR species='attenuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='attenuata' OR junior_species='attenuata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Knema' AND (species='attenuata' OR species='attenuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='dactyloides' OR junior_species='dactyloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='dactyloides' OR species='dactyloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='dactyloides' OR species='dactyloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='dactyloides' OR junior_species='dactyloides')SELECT d.diet,d.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='dactyloides' OR species='dactyloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='malabarica' OR junior_species='malabarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='malabarica' OR species='malabarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='malabarica' OR species='malabarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='malabarica' OR junior_species='malabarica')SELECT d.diet,d.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='malabarica' OR species='malabarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='gardneri' OR junior_species='gardnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='gardneri' OR species='gardnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='gardneri' OR species='gardnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='gardneri' OR junior_species='gardnerii')SELECT d.diet,d.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='gardneri' OR species='gardnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='hemisphericum' OR junior_species='hemisphericum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='hemisphericum' OR species='hemisphericum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='hemisphericum' OR species='hemisphericum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='hemisphericum' OR junior_species='hemisphericum')SELECT d.diet,d.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='hemisphericum' OR species='hemisphericum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='laetum' OR junior_species='laetum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='laetum' OR species='laetum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='laetum' OR species='laetum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='laetum' OR junior_species='laetum')SELECT d.diet,d.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='laetum' OR species='laetum') 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='Blepharistemma' AND (junior_species='membranifolia' OR junior_species='membranifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blepharistemma' AND (species='membranifolia' OR species='membranifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blepharistemma' AND (species='membranifolia' OR species='membranifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharistemma' AND (junior_species='membranifolia' OR junior_species='membranifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blepharistemma' AND (species='membranifolia' OR species='membranifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neonauclea' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neonauclea' AND (species='purpurea' OR species='purpurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neonauclea' AND (species='purpurea' OR species='purpurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neonauclea' AND (junior_species='purpurea' OR junior_species='purpurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neonauclea' AND (species='purpurea' OR species='purpurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycosmis' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glycosmis' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glycosmis' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycosmis' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glycosmis' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vepris' AND (junior_species='bilocularis' OR junior_species='bilocularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vepris' AND (species='bilocularis' OR species='bilocularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vepris' AND (species='bilocularis' OR species='bilocularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vepris' AND (junior_species='bilocularis' OR junior_species='bilocularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vepris' AND (species='bilocularis' OR species='bilocularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimocarpus' AND (junior_species='longan' OR junior_species='longan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dimocarpus' AND (species='longan' OR species='longan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimocarpus' AND (species='longan' OR species='longan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimocarpus' AND (junior_species='longan' OR junior_species='longan')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dimocarpus' AND (species='longan' OR species='longan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpullia' 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='Harpullia' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpullia' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpullia' 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='Harpullia' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otonephelium' AND (junior_species='stipulaceum' OR junior_species='stipulaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otonephelium' AND (species='stipulaceum' OR species='stipulaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otonephelium' AND (species='stipulaceum' OR species='stipulaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otonephelium' AND (junior_species='stipulaceum' OR junior_species='stipulaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Otonephelium' AND (species='stipulaceum' OR species='stipulaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='lanceolatum' OR junior_species='lanceolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='lanceolatum' OR species='lanceolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='lanceolatum' OR species='lanceolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='lanceolatum' OR junior_species='lanceolatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysophyllum' AND (species='lanceolatum' OR species='lanceolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isonandra' 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='Isonandra' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Isonandra' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isonandra' 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='Isonandra' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='ellipticum' OR junior_species='ellipticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='ellipticum' OR species='ellipticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='ellipticum' OR species='ellipticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='ellipticum' OR junior_species='ellipticum')SELECT d.diet,d.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='ellipticum' OR species='ellipticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heritiera' AND (junior_species='papilio' OR junior_species='papilio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heritiera' AND (species='papilio' OR species='papilio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heritiera' AND (species='papilio' OR species='papilio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heritiera' AND (junior_species='papilio' OR junior_species='papilio')SELECT d.diet,d.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='papilio' OR species='papilio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptonychia' AND (junior_species='moacunoides' OR junior_species='moacunoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptonychia' AND (species='moacunoides' OR species='moacunoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptonychia' AND (species='moacunoides' OR species='moacunoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptonychia' AND (junior_species='moacunoides' OR junior_species='moacunoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptonychia' AND (species='moacunoides' OR species='moacunoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterospermum' AND (junior_species='diversifolium' OR junior_species='diversifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterospermum' AND (species='diversifolium' OR species='diversifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterospermum' AND (species='diversifolium' OR species='diversifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterospermum' AND (junior_species='diversifolium' OR junior_species='diversifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterospermum' AND (species='diversifolium' OR species='diversifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' 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='Symplocos' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' 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='Symplocos' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='sinuata' OR junior_species='sinuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocnide' AND (species='sinuata' OR species='sinuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocnide' AND (species='sinuata' OR species='sinuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='sinuata' OR junior_species='sinuata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocnide' AND (species='sinuata' OR species='sinuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' 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='Callicarpa' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicarpa' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' 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='Callicarpa' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rinorea' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=48