Coordinate: 25° 30' N, 91° 18' E
MAP applies to the study period only; CMT and WMT estimated from figure
SELECT * FROM samples WHERE sample_no=1004
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=693
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=1004 ORDER BY register_no ASC
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' 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='Acer' AND (species='laevigatum' OR species='laevigatum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='laevigatum' OR species='laevigatum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' 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='Acer' AND (species='laevigatum' OR species='laevigatum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='oblongum' OR junior_species='oblongum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='oblongum' OR species='oblongum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='oblongum' OR species='oblongum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='oblongum' OR junior_species='oblongum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acer' AND (species='oblongum' OR species='oblongum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='obovata' OR junior_species='obovata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinodaphne' AND (species='obovata' OR species='obovata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Actinodaphne' AND (species='obovata' OR species='obovata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='obovata' OR junior_species='obovata')
SELECT d.diet,d.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='obovata' OR species='obovata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphnopsis' AND (junior_species='petiolaris' OR junior_species='petiolaris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphnopsis' AND (junior_species='petiolaris' OR junior_species='petiolaris')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='alnoides' OR junior_species='alnoides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='alnoides' OR species='alnoides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='alnoides' OR species='alnoides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='alnoides' OR junior_species='alnoides')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Betula' AND (species='alnoides' OR species='alnoides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='purpurella' OR junior_species='purpurella')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castanopsis' AND (species='purpurella' OR species='purpurella') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='purpurella' OR species='purpurella')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='purpurella' OR junior_species='purpurella')
SELECT d.diet,d.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='purpurella' OR species='purpurella') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='bejolghota' OR junior_species='bejolghota')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='bejolghota' OR species='bejolghota') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='bejolghota' OR species='bejolghota')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='bejolghota' OR junior_species='bejolghota')
SELECT d.diet,d.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='bejolghota' OR species='bejolghota') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='glaucescens' OR species='glaucescens')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' 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='Cinnamomum' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' 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='Cryptocarya' AND (species='floribunda' OR species='floribunda') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='floribunda' OR species='floribunda')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' 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='Cryptocarya' AND (species='floribunda' OR species='floribunda') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='racemosus' OR junior_species='racemosus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drimycarpus' AND (species='racemosus' OR species='racemosus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Drimycarpus' AND (species='racemosus' OR species='racemosus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='racemosus' OR junior_species='racemosus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drimycarpus' AND (species='racemosus' OR species='racemosus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sikkimensis' OR junior_species='sikkimensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='sikkimensis' OR species='sikkimensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='sikkimensis' OR species='sikkimensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sikkimensis' OR junior_species='sikkimensis')
SELECT d.diet,d.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='sikkimensis' OR species='sikkimensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engelhardia' AND (junior_species='spicata' OR junior_species='spicata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Engelhardia' AND (species='spicata' OR species='spicata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Engelhardia' AND (species='spicata' OR species='spicata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engelhardia' AND (junior_species='spicata' OR junior_species='spicata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Engelhardia' AND (species='spicata' OR species='spicata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='altissima' OR species='altissima') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='altissima' OR species='altissima')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='altissima' OR species='altissima') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='virens' OR junior_species='virens')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='virens' OR species='virens')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='virens' OR junior_species='virens')
SELECT d.diet,d.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='virens' OR species='virens') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='tinctoria' OR junior_species='tinctoria')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='tinctoria' OR species='tinctoria') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='tinctoria' OR species='tinctoria')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='tinctoria' OR junior_species='tinctoria')
SELECT d.diet,d.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='tinctoria' OR species='tinctoria') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='angustifolia' OR junior_species='angustifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='angustifolia' OR species='angustifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='angustifolia' OR species='angustifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='angustifolia' OR junior_species='angustifolia')
SELECT d.diet,d.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='angustifolia' OR species='angustifolia') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='fenestratus' OR junior_species='fenestratus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='fenestratus' OR species='fenestratus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='fenestratus' OR species='fenestratus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='fenestratus' OR junior_species='fenestratus')
SELECT d.diet,d.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='fenestratus' OR species='fenestratus') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='doltsopa' OR junior_species='doltsopa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Magnolia' AND (species='doltsopa' OR species='doltsopa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Magnolia' AND (species='doltsopa' OR species='doltsopa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' AND (junior_species='doltsopa' OR junior_species='doltsopa')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Magnolia' AND (species='doltsopa' OR species='doltsopa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='cassia' OR junior_species='cassia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neolitsea' AND (species='cassia' OR species='cassia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Neolitsea' AND (species='cassia' OR species='cassia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='cassia' OR junior_species='cassia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neolitsea' AND (species='cassia' OR species='cassia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='gamblei' OR junior_species='gambleii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Persea' AND (species='gamblei' OR species='gambleii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Persea' AND (species='gamblei' OR species='gambleii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='gamblei' OR junior_species='gambleii')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Persea' AND (species='gamblei' OR species='gambleii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' 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='Persea' AND (species='odoratissima' OR species='odoratissima') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Persea' AND (species='odoratissima' OR species='odoratissima')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' 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='Persea' AND (species='odoratissima' OR species='odoratissima') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='neriifolius' OR junior_species='neriifolius')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podocarpus' AND (species='neriifolius' OR species='neriifolius') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Podocarpus' AND (species='neriifolius' OR species='neriifolius')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='neriifolius' OR junior_species='neriifolius')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Podocarpus' AND (species='neriifolius' OR species='neriifolius') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='jenkinsii' OR junior_species='jenkinsi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='jenkinsii' OR species='jenkinsi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='jenkinsii' OR species='jenkinsi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='jenkinsii' OR junior_species='jenkinsi')
SELECT d.diet,d.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='jenkinsii' OR species='jenkinsi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcosperma' 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='Sarcosperma' AND (species='griffithii' OR species='griffithi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sarcosperma' AND (species='griffithii' OR species='griffithi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcosperma' 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='Sarcosperma' AND (species='griffithii' OR species='griffithi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schima' AND (junior_species='wallichii' OR junior_species='wallichi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schima' AND (species='wallichii' OR species='wallichi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Schima' AND (species='wallichii' OR species='wallichi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schima' AND (junior_species='wallichii' OR junior_species='wallichi')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schima' AND (species='wallichii' OR species='wallichi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='axillaris' OR junior_species='axillaris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spondias' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Spondias' AND (species='axillaris' OR species='axillaris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='axillaris' OR junior_species='axillaris')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spondias' AND (species='axillaris' OR species='axillaris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='tetragonum' OR junior_species='tetragonum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='tetragonum' OR species='tetragonum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='tetragonum' OR species='tetragonum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='tetragonum' OR junior_species='tetragonum')
SELECT d.diet,d.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='tetragonum' OR species='tetragonum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='bunius' OR junior_species='bunius')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='bunius' OR species='bunius') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='bunius' OR species='bunius')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='bunius' OR junior_species='bunius')
SELECT d.diet,d.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='bunius' OR species='bunius') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='assamica' OR junior_species='assamica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='assamica' OR species='assamica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='assamica' OR species='assamica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='assamica' OR junior_species='assamica')
SELECT d.diet,d.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='assamica' OR species='assamica') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='tamala' OR junior_species='tamala')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='tamala' OR species='tamala') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='tamala' OR species='tamala')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='tamala' OR junior_species='tamala')
SELECT d.diet,d.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='tamala' OR species='tamala') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='latipes' OR junior_species='latipes')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Citrus' AND (species='latipes' OR species='latipes') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Citrus' AND (species='latipes' OR species='latipes')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='latipes' OR junior_species='latipes')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Citrus' AND (species='latipes' OR species='latipes') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='kaki' OR junior_species='kakii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='kaki' OR species='kakii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='kaki' OR species='kakii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='kaki' OR junior_species='kakii')
SELECT d.diet,d.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='kaki' OR species='kakii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='gobara' OR junior_species='gobara')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='gobara' OR species='gobara') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='gobara' OR species='gobara')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='gobara' OR junior_species='gobara')
SELECT d.diet,d.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='gobara' OR species='gobara') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='lancifolius' OR junior_species='lancifolius')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='lancifolius' OR species='lancifolius') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='lancifolius' OR species='lancifolius')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='lancifolius' OR junior_species='lancifolius')
SELECT d.diet,d.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='lancifolius' OR species='lancifolius') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='nerifolia' OR junior_species='nerifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='nerifolia' OR species='nerifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='nerifolia' OR species='nerifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='nerifolia' OR junior_species='nerifolia')
SELECT d.diet,d.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='nerifolia' OR species='nerifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='nilagirica' OR junior_species='nilagirica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicia' AND (species='nilagirica' OR species='nilagirica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Helicia' AND (species='nilagirica' OR species='nilagirica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='nilagirica' OR junior_species='nilagirica')
SELECT d.diet,d.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='nilagirica' OR species='nilagirica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='embelioides' OR junior_species='embelioides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='embelioides' OR species='embelioides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='embelioides' OR species='embelioides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='embelioides' OR junior_species='embelioides')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ilex' AND (species='embelioides' OR species='embelioides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='latifolia' OR junior_species='latifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lindera' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Lindera' AND (species='latifolia' OR species='latifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='latifolia' OR junior_species='latifolia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lindera' AND (species='latifolia' OR species='latifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='reticulata' OR junior_species='reticulata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lindera' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Lindera' AND (species='reticulata' OR species='reticulata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='reticulata' OR junior_species='reticulata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lindera' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='semecarpifolia' OR junior_species='semecarpifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='semecarpifolia' OR species='semecarpifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='semecarpifolia' OR species='semecarpifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='semecarpifolia' OR junior_species='semecarpifolia')
SELECT d.diet,d.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='semecarpifolia' OR species='semecarpifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='denticulata' OR junior_species='denticulata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='denticulata' OR species='denticulata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='denticulata' OR species='denticulata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='denticulata' OR junior_species='denticulata')
SELECT d.diet,d.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='denticulata' OR species='denticulata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropanax' AND (junior_species='dispermus' OR junior_species='dispermus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropanax' AND (species='dispermus' OR species='dispermus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Macropanax' AND (species='dispermus' OR species='dispermus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropanax' AND (junior_species='dispermus' OR junior_species='dispermus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macropanax' AND (species='dispermus' OR species='dispermus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manglietia' AND (junior_species='insignis' OR junior_species='insignis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manglietia' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Manglietia' AND (species='insignis' OR species='insignis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manglietia' AND (junior_species='insignis' OR junior_species='insignis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manglietia' AND (species='insignis' OR species='insignis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melia' AND (junior_species='azedarach' OR junior_species='azedarach')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melia' AND (species='azedarach' OR species='azedarach') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Melia' AND (species='azedarach' OR species='azedarach')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melia' AND (junior_species='azedarach' OR junior_species='azedarach')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melia' AND (species='azedarach' OR species='azedarach') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morella' AND (junior_species='esculenta' OR junior_species='esculenta')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morella' AND (species='esculenta' OR species='esculenta') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Morella' AND (species='esculenta' OR species='esculenta')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morella' AND (junior_species='esculenta' OR junior_species='esculenta')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morella' AND (species='esculenta' OR species='esculenta') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='semiserrata' OR junior_species='semiserrata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrsine' AND (species='semiserrata' OR species='semiserrata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Myrsine' AND (species='semiserrata' OR species='semiserrata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='semiserrata' OR junior_species='semiserrata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrsine' AND (species='semiserrata' OR species='semiserrata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='bombycina' OR junior_species='bombycina')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Persea' AND (species='bombycina' OR species='bombycina') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Persea' AND (species='bombycina' OR species='bombycina')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' AND (junior_species='bombycina' OR junior_species='bombycina')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Persea' AND (species='bombycina' OR species='bombycina') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' 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='Persea' AND (species='parviflora' OR species='parviflora') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Persea' AND (species='parviflora' OR species='parviflora')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Persea' 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='Persea' AND (species='parviflora' OR species='parviflora') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='monadelphum' OR junior_species='monadelphum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pithecellobium' AND (species='monadelphum' OR species='monadelphum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pithecellobium' AND (species='monadelphum' OR species='monadelphum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' AND (junior_species='monadelphum' OR junior_species='monadelphum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pithecellobium' AND (species='monadelphum' OR species='monadelphum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' 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='Pithecellobium' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pithecellobium' AND (species='acuminata' OR species='acuminata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithecellobium' 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='Pithecellobium' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='rarak' OR junior_species='rarak')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapindus' AND (species='rarak' OR species='rarak') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sapindus' AND (species='rarak' OR species='rarak')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapindus' AND (junior_species='rarak' OR junior_species='rarak')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapindus' AND (species='rarak' OR species='rarak') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' 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='Schefflera' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Schefflera' AND (species='hypoleuca' OR species='hypoleuca')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' 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='Schefflera' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='acutifolia' OR junior_species='acutifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capparis' AND (species='acutifolia' OR species='acutifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Capparis' AND (species='acutifolia' OR species='acutifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='acutifolia' OR junior_species='acutifolia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Capparis' AND (species='acutifolia' OR species='acutifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coffea' AND (junior_species='khasiana' OR junior_species='khasiana')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coffea' AND (species='khasiana' OR species='khasiana') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Coffea' AND (species='khasiana' OR species='khasiana')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coffea' AND (junior_species='khasiana' OR junior_species='khasiana')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coffea' AND (species='khasiana' OR species='khasiana') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmos' AND (junior_species='longiflorus' OR junior_species='longiflorus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmos' AND (species='longiflorus' OR species='longiflorus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Desmos' AND (species='longiflorus' OR species='longiflorus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmos' AND (junior_species='longiflorus' OR junior_species='longiflorus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Desmos' AND (species='longiflorus' OR species='longiflorus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='kunthianum' OR junior_species='kunthianum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='kunthianum' OR species='kunthianum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='kunthianum' OR species='kunthianum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='kunthianum' OR junior_species='kunthianum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythroxylum' AND (species='kunthianum' OR species='kunthianum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='simplicissima' OR junior_species='simplicissima')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='simplicissima' OR species='simplicissima') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='simplicissima' OR species='simplicissima')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='simplicissima' OR junior_species='simplicissima')
SELECT d.diet,d.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='simplicissima' OR species='simplicissima') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Itea' AND (junior_species='chinensis' OR junior_species='chinensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Itea' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Itea' AND (species='chinensis' OR species='chinensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Itea' AND (junior_species='chinensis' OR junior_species='chinensis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Itea' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='subsessilis' OR junior_species='subsessilis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixora' AND (species='subsessilis' OR species='subsessilis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ixora' AND (species='subsessilis' OR species='subsessilis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='subsessilis' OR junior_species='subsessilis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ixora' AND (species='subsessilis' OR species='subsessilis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='salicifolia' OR junior_species='salicifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lindera' AND (species='salicifolia' OR species='salicifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Lindera' AND (species='salicifolia' OR species='salicifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindera' AND (junior_species='salicifolia' OR junior_species='salicifolia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lindera' AND (species='salicifolia' OR species='salicifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paramignya' 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='Paramignya' AND (species='micrantha' OR species='micrantha') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Paramignya' AND (species='micrantha' OR species='micrantha')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paramignya' 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='Paramignya' AND (species='micrantha' OR species='micrantha') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' 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='Phoebe' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Phoebe' AND (species='lanceolata' OR species='lanceolata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' 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='Phoebe' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pittosporum' AND (junior_species='podocarpum' OR junior_species='podocarpum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pittosporum' AND (species='podocarpum' OR species='podocarpum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pittosporum' AND (species='podocarpum' OR species='podocarpum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pittosporum' AND (junior_species='podocarpum' OR junior_species='podocarpum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pittosporum' AND (species='podocarpum' OR species='podocarpum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcococca' AND (junior_species='pruniformis' OR junior_species='pruniformis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcococca' AND (species='pruniformis' OR species='pruniformis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sarcococca' AND (species='pruniformis' OR species='pruniformis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcococca' AND (junior_species='pruniformis' OR junior_species='pruniformis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sarcococca' AND (species='pruniformis' OR species='pruniformis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='hamiltonii' OR junior_species='hamiltoni')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='hamiltonii' OR species='hamiltoni') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='hamiltonii' OR species='hamiltoni')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='hamiltonii' OR junior_species='hamiltoni')
SELECT d.diet,d.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='hamiltonii' OR species='hamiltoni') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='serrulatus' OR junior_species='serrulatus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='serrulatus' OR species='serrulatus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='serrulatus' OR species='serrulatus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='serrulatus' OR junior_species='serrulatus')
SELECT d.diet,d.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='serrulatus' OR species='serrulatus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='pyrifolia' OR junior_species='pyrifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symplocos' AND (species='pyrifolia' OR species='pyrifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='pyrifolia' OR species='pyrifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='pyrifolia' OR junior_species='pyrifolia')
SELECT d.diet,d.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='pyrifolia' OR species='pyrifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='spicata' OR junior_species='spicata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symplocos' AND (species='spicata' OR species='spicata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Symplocos' AND (species='spicata' OR species='spicata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symplocos' AND (junior_species='spicata' OR junior_species='spicata')
SELECT d.diet,d.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='spicata' OR species='spicata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wendlandia' AND (junior_species='wallichii' OR junior_species='wallichi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wendlandia' AND (species='wallichii' OR species='wallichi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Wendlandia' AND (species='wallichii' OR species='wallichi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wendlandia' AND (junior_species='wallichii' OR junior_species='wallichi')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wendlandia' AND (species='wallichii' OR species='wallichi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fissistigma' AND (junior_species='verrucosum' OR junior_species='verrucosum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fissistigma' AND (species='verrucosum' OR species='verrucosum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Fissistigma' AND (species='verrucosum' OR species='verrucosum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fissistigma' AND (junior_species='verrucosum' OR junior_species='verrucosum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fissistigma' AND (species='verrucosum' OR species='verrucosum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melodinus' AND (junior_species='monogynous' OR junior_species='monogynous')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melodinus' AND (species='monogynous' OR species='monogynous') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Melodinus' AND (species='monogynous' OR species='monogynous')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melodinus' AND (junior_species='monogynous' OR junior_species='monogynous')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melodinus' AND (species='monogynous' OR species='monogynous') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rourea' AND (junior_species='minor' OR junior_species='minor')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rourea' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Rourea' AND (species='minor' OR species='minor')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rourea' AND (junior_species='minor' OR junior_species='minor')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rourea' AND (species='minor' OR species='minor') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='venulosa' OR junior_species='venulosa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schefflera' AND (species='venulosa' OR species='venulosa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Schefflera' AND (species='venulosa' OR species='venulosa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schefflera' AND (junior_species='venulosa' OR junior_species='venulosa')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schefflera' AND (species='venulosa' OR species='venulosa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrastigma' AND (junior_species='leucostaphylum' OR junior_species='leucostaphylum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrastigma' AND (species='leucostaphylum' OR species='leucostaphylum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tetrastigma' AND (species='leucostaphylum' OR species='leucostaphylum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrastigma' AND (junior_species='leucostaphylum' OR junior_species='leucostaphylum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetrastigma' AND (species='leucostaphylum' OR species='leucostaphylum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupidanthus' AND (junior_species='calyptratus' OR junior_species='calyptratus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupidanthus' AND (species='calyptratus' OR species='calyptratus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tupidanthus' AND (species='calyptratus' OR species='calyptratus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupidanthus' AND (junior_species='calyptratus' OR junior_species='calyptratus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tupidanthus' AND (species='calyptratus' OR species='calyptratus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Angiospermae' 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='Angiospermae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Angiospermae' AND (species='indet.' OR species='indet.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Angiospermae' 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='Angiospermae' AND (species='indet.' OR species='indet.') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=1004
SELECT genus FROM register WHERE register_no IN (50295,23106,44037,31204,56134,19984,91270,14385,87973,27926) AND species REGEXP '^[a-z]*$'