SELECT * FROM samples WHERE sample_no=139
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=51
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=139 ORDER BY register_no ASC
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='oleoides' OR junior_species='oleoides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='oleoides' OR species='oleoides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='oleoides' OR species='oleoides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='oleoides' OR junior_species='oleoides')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quercus' AND (species='oleoides' OR species='oleoides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Hymenaea' AND (species='courbaril' OR species='courbaril')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='zapota' OR junior_species='zapota')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manilkara' AND (species='zapota' OR species='zapota') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Manilkara' AND (species='zapota' OR species='zapota')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='zapota' OR junior_species='zapota')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manilkara' AND (species='zapota' OR species='zapota') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='terniflora' OR junior_species='terniflora')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sloanea' AND (species='terniflora' OR species='terniflora') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sloanea' AND (species='terniflora' OR species='terniflora')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='terniflora' OR junior_species='terniflora')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sloanea' AND (species='terniflora' OR species='terniflora') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luehea' AND (junior_species='spp.' OR junior_species='spp.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luehea' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Luehea' AND (species='spp.' OR species='spp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luehea' AND (junior_species='spp.' OR junior_species='spp.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Luehea' AND (species='spp.' OR species='spp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='sp.' OR junior_species='sp.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='sp.' OR species='sp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='sp.' OR junior_species='sp.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ficus' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dilodendron' AND (junior_species='costaricense' OR junior_species='costaricense')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dilodendron' AND (species='costaricense' OR species='costaricense') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Dilodendron' AND (species='costaricense' OR species='costaricense')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dilodendron' AND (junior_species='costaricense' OR junior_species='costaricense')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dilodendron' AND (species='costaricense' OR species='costaricense') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycophyllum' AND (junior_species='candidissimum' OR junior_species='candidissimum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycophyllum' AND (species='candidissimum' OR species='candidissimum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Calycophyllum' AND (species='candidissimum' OR species='candidissimum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycophyllum' AND (junior_species='candidissimum' OR junior_species='candidissimum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calycophyllum' AND (species='candidissimum' OR species='candidissimum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exostema' AND (junior_species='mexicanum' OR junior_species='mexicanum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Exostema' AND (species='mexicanum' OR species='mexicanum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Exostema' AND (species='mexicanum' OR species='mexicanum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Exostema' AND (junior_species='mexicanum' OR junior_species='mexicanum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Exostema' AND (species='mexicanum' OR species='mexicanum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='cainito' OR junior_species='cainito')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='cainito' OR species='cainito') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='cainito' OR species='cainito')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='cainito' OR junior_species='cainito')
SELECT d.diet,d.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='cainito' OR species='cainito') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachira' AND (junior_species='quinata' OR junior_species='quinata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachira' AND (species='quinata' OR species='quinata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pachira' AND (species='quinata' OR species='quinata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachira' AND (junior_species='quinata' OR junior_species='quinata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachira' AND (species='quinata' OR species='quinata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castilla' AND (junior_species='elastica' OR junior_species='elastica')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castilla' AND (species='elastica' OR species='elastica') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Castilla' AND (species='elastica' OR species='elastica')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castilla' AND (junior_species='elastica' OR junior_species='elastica')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Castilla' AND (species='elastica' OR species='elastica') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliricidia' AND (junior_species='sepium' OR junior_species='sepium')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gliricidia' AND (species='sepium' OR species='sepium') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Gliricidia' AND (species='sepium' OR species='sepium')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliricidia' AND (junior_species='sepium' OR junior_species='sepium')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gliricidia' AND (species='sepium' OR species='sepium') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='arborea' OR species='arborea')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' 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='Licania' AND (species='arborea' OR species='arborea') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='odorata' OR junior_species='odorata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cedrela' AND (species='odorata' OR species='odorata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cedrela' AND (species='odorata' OR species='odorata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='odorata' OR junior_species='odorata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cedrela' AND (species='odorata' OR species='odorata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='mombin' OR junior_species='mombin')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spondias' AND (species='mombin' OR species='mombin') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Spondias' AND (species='mombin' OR species='mombin')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='mombin' OR junior_species='mombin')
SELECT d.diet,d.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='mombin' OR species='mombin') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guettarda' AND (junior_species='macrosperma' OR junior_species='macrosperma')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guettarda' AND (species='macrosperma' OR species='macrosperma') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Guettarda' AND (species='macrosperma' OR species='macrosperma')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guettarda' AND (junior_species='macrosperma' OR junior_species='macrosperma')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Guettarda' AND (species='macrosperma' OR species='macrosperma') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' AND (species='purpurea' OR species='purpurea') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Annona' AND (species='purpurea' OR species='purpurea')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' AND (species='purpurea' OR species='purpurea') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lysiloma' 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='Lysiloma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Lysiloma' AND (species='sp.' OR species='sp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lysiloma' 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='Lysiloma' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sp.' OR junior_species='sp.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='veraguensis' OR junior_species='veraguensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='veraguensis' OR species='veraguensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='veraguensis' OR species='veraguensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='veraguensis' OR junior_species='veraguensis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocotea' AND (species='veraguensis' OR species='veraguensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateleia' AND (junior_species='herbertsmithii' OR junior_species='herbertsmithi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateleia' AND (species='herbertsmithii' OR species='herbertsmithi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ateleia' AND (species='herbertsmithii' OR species='herbertsmithi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateleia' AND (junior_species='herbertsmithii' OR junior_species='herbertsmithi')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ateleia' AND (species='herbertsmithii' OR species='herbertsmithi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='alicastrum' OR species='alicastrum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zuelania' AND (junior_species='guidonia' OR junior_species='guidonia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zuelania' AND (species='guidonia' OR species='guidonia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Zuelania' AND (species='guidonia' OR species='guidonia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zuelania' AND (junior_species='guidonia' OR junior_species='guidonia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zuelania' AND (species='guidonia' OR species='guidonia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erblichia' AND (junior_species='odorata' OR junior_species='odorata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erblichia' AND (species='odorata' OR species='odorata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Erblichia' AND (species='odorata' OR species='odorata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erblichia' AND (junior_species='odorata' OR junior_species='odorata')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erblichia' AND (species='odorata' OR species='odorata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bursera' AND (junior_species='simaruba' OR junior_species='simaruba')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bursera' AND (species='simaruba' OR species='simaruba') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Bursera' AND (species='simaruba' OR species='simaruba')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bursera' AND (junior_species='simaruba' OR junior_species='simaruba')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bursera' AND (species='simaruba' OR species='simaruba') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='myrtilloides' OR junior_species='myrtilloides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='myrtilloides' OR species='myrtilloides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='myrtilloides' OR species='myrtilloides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='myrtilloides' OR junior_species='myrtilloides')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mouriri' AND (species='myrtilloides' OR species='myrtilloides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='sylvestris' OR junior_species='sylvestris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='sylvestris' OR species='sylvestris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='sylvestris' OR junior_species='sylvestris')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Casearia' AND (species='sylvestris' OR species='sylvestris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='ochracea' OR junior_species='ochracea')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='ochracea' OR species='ochracea')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='ochracea' OR junior_species='ochracea')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='ochracea' OR species='ochracea') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciadodendron' AND (junior_species='excelsum' OR junior_species='excelsum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciadodendron' AND (species='excelsum' OR species='excelsum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sciadodendron' AND (species='excelsum' OR species='excelsum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciadodendron' AND (junior_species='excelsum' OR junior_species='excelsum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sciadodendron' AND (species='excelsum' OR species='excelsum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='edulis' OR junior_species='edulis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rheedia' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Rheedia' AND (species='edulis' OR species='edulis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheedia' AND (junior_species='edulis' OR junior_species='edulis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rheedia' AND (species='edulis' OR species='edulis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guazuma' AND (junior_species='ulmifolia' OR junior_species='ulmifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guazuma' AND (junior_species='ulmifolia' OR junior_species='ulmifolia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='thelocarpum' OR junior_species='thelocarpum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='thelocarpum' OR species='thelocarpum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='thelocarpum' OR species='thelocarpum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='thelocarpum' OR junior_species='thelocarpum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapium' AND (species='thelocarpum' OR species='thelocarpum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='sp.' OR species='sp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardisia' AND (junior_species='revoluta' OR junior_species='revoluta')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ardisia' AND (species='revoluta' OR species='revoluta') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ardisia' AND (species='revoluta' OR species='revoluta')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardisia' AND (junior_species='revoluta' OR junior_species='revoluta')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ardisia' AND (species='revoluta' OR species='revoluta') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='vera' OR junior_species='vera')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='vera' OR species='vera') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='vera' OR species='vera')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='vera' OR junior_species='vera')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Inga' AND (species='vera' OR species='vera') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='florbunda' OR junior_species='florbunda')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixora' AND (species='florbunda' OR species='florbunda') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ixora' AND (species='florbunda' OR species='florbunda')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='florbunda' OR junior_species='florbunda')
SELECT d.diet,d.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='florbunda' OR species='florbunda') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sebastiania' AND (junior_species='confusa' OR junior_species='confusa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sebastiania' AND (species='confusa' OR species='confusa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sebastiania' AND (species='confusa' OR species='confusa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sebastiania' AND (junior_species='confusa' OR junior_species='confusa')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sebastiania' AND (species='confusa' OR species='confusa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='arguta' OR junior_species='arguta')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='arguta' OR species='arguta') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='arguta' OR species='arguta')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='arguta' OR junior_species='arguta')
SELECT d.diet,d.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='arguta' OR species='arguta') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Krugio' AND (junior_species='dendronferrumi' OR junior_species='dendronferrumii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Krugio' AND (species='dendronferrumi' OR species='dendronferrumii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Krugio' AND (species='dendronferrumi' OR species='dendronferrumii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Krugio' AND (junior_species='dendronferrumi' OR junior_species='dendronferrumii')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Krugio' AND (species='dendronferrumi' OR species='dendronferrumii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cochlospermum' AND (junior_species='vitifolium' OR junior_species='vitifolium')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cochlospermum' AND (species='vitifolium' OR species='vitifolium') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cochlospermum' AND (species='vitifolium' OR species='vitifolium')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cochlospermum' AND (junior_species='vitifolium' OR junior_species='vitifolium')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cochlospermum' AND (species='vitifolium' OR species='vitifolium') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='panamensis' OR junior_species='panamensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='panamensis' OR species='panamensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='panamensis' OR species='panamensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='panamensis' OR junior_species='panamensis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cordia' AND (species='panamensis' OR species='panamensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simarouba' AND (junior_species='glauca' OR junior_species='glauca')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simarouba' AND (species='glauca' OR species='glauca') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Simarouba' AND (species='glauca' OR species='glauca')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simarouba' AND (junior_species='glauca' OR junior_species='glauca')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Simarouba' AND (species='glauca' OR species='glauca') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='praecox' OR junior_species='praecox')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='praecox' OR species='praecox') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='praecox' OR species='praecox')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='praecox' OR junior_species='praecox')
SELECT d.diet,d.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='praecox' OR species='praecox') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalbergia' AND (junior_species='retusa' OR junior_species='retusa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dalbergia' AND (species='retusa' OR species='retusa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Dalbergia' AND (species='retusa' OR species='retusa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dalbergia' AND (junior_species='retusa' OR junior_species='retusa')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dalbergia' AND (species='retusa' OR species='retusa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' 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='Coccoloba' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Coccoloba' AND (species='sp.' OR species='sp.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' 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='Coccoloba' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='guatemalensis' OR species='guatemalensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupania' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonandra' 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='Agonandra' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Agonandra' AND (species='macrocarpa' OR species='macrocarpa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonandra' 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='Agonandra' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thouinidium' AND (junior_species='decandrum' OR junior_species='decandrum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thouinidium' AND (species='decandrum' OR species='decandrum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Thouinidium' AND (species='decandrum' OR species='decandrum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thouinidium' AND (junior_species='decandrum' OR junior_species='decandrum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thouinidium' AND (species='decandrum' OR species='decandrum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picramnia' AND (junior_species='quaternaria' OR junior_species='quaternaria')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picramnia' AND (species='quaternaria' OR species='quaternaria') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Picramnia' AND (species='quaternaria' OR species='quaternaria')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picramnia' AND (junior_species='quaternaria' OR junior_species='quaternaria')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picramnia' AND (species='quaternaria' OR species='quaternaria') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rehdera' AND (junior_species='trinervis' OR junior_species='trinervis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rehdera' AND (species='trinervis' OR species='trinervis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Rehdera' AND (species='trinervis' OR species='trinervis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rehdera' AND (junior_species='trinervis' OR junior_species='trinervis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rehdera' AND (species='trinervis' OR species='trinervis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='apetala' OR junior_species='apetala')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='apetala' OR species='apetala') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='apetala' OR species='apetala')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='apetala' OR junior_species='apetala')
SELECT d.diet,d.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='apetala' OR species='apetala') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' 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='Astronium' AND (species='graveolens' OR species='graveolens') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Astronium' AND (species='graveolens' OR species='graveolens')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' 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='Astronium' AND (species='graveolens' OR species='graveolens') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeiba' AND (junior_species='tibourbou' OR junior_species='tibourbou')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apeiba' AND (species='tibourbou' OR species='tibourbou') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Apeiba' AND (species='tibourbou' OR species='tibourbou')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeiba' AND (junior_species='tibourbou' OR junior_species='tibourbou')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apeiba' AND (species='tibourbou' OR species='tibourbou') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Annona' AND (species='reticulata' OR species='reticulata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annona' 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='Annona' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' AND (junior_species='edulis' OR junior_species='edulis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alibertia' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alibertia' AND (species='edulis' OR species='edulis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' AND (junior_species='edulis' OR junior_species='edulis')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alibertia' AND (species='edulis' OR species='edulis') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=139
SELECT genus FROM register WHERE register_no IN (56199,30117,58399,82378,29002,79728,28748,97623,9162,92787) AND species REGEXP '^[a-z]*$'
The Ecological Register: Bosque Humedo
Bosque Humedo
Basic information
Sample name: Bosque Humedo

Sample aka: Santa Rosa National Park

Reference: R. J. Burnham. 1997. Stand characteristics and leaf litter composition of a dry forest hectare in Santa Rosa National Park, Costa Rica. Biotropica 29(4):384-395 [ER 51]
Geography
Country: Costa Rica


Coordinate: 10° 53' N, 85° 47' W
Coordinate basis: based on nearby landmark

Geography comments: JA: "about one km from the SRNP Administration Area": coordinate based on Santa Rosa National Park
altitude range of Santa Rosa National Park is 0 to 350 m but most of it is on a plateau at 200 to 350 m based on Janzen (1984, Journal of the Kansas Entomological Society)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

WMT: 34.0

CMT: 31.0

MAP: 1614.0

Habitat comments: JA: CMT 30 to 32, WMT 32 to 36

Methods
Life forms: trees

Sites: 1

Site area: 1

Sampling methods: quadrat

Sample size: 352 individuals

Years: 1994

Days: 5

Size min: 10

Basal area: 20.4

Metadata
Sample number: 139

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-05 11:55:12

Modified: 2017-11-11 02:57:13

Abundance distribution
56 species
15 singletons
total count 352
geometric series index: 102.7
Fisher's α: 18.771
geometric series k: 0.9365
Hurlbert's PIE: 0.9541
Shannon's H: 3.4507
Good's u: 0.9576
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Quercus oleoides22
Hymenaea courbaril27
Manilkara zapota37
Sloanea terniflora19
Luehea spp.30
Ficus sp.1
Dilodendron costaricense13
Calycophyllum candidissimum10
Exostema mexicanum17
Chrysophyllum cainito7
Pachira quinata2
"Bombacopsis quinatum"
Castilla elastica8
Gliricidia sepium2
Licania arborea2
Cedrela odorata5
Spondias mombin4
Guettarda macrosperma9
Annona purpurea12
Lysiloma sp.5
Eugenia sp.18
Ocotea veraguensis13
Ateleia herbertsmithii3
Brosimum alicastrum5
Zuelania guidonia6
Erblichia odorata2
Bursera simaruba2
Mouriri myrtilloides8
Casearia sylvestris9
"Casearia silvestris"
Tabebuia ochracea2
Sciadodendron excelsum2
Rheedia edulis4
Guazuma ulmifolia3
Sapium thelocarpum3
Trichilia sp.4
Ardisia revoluta3
Inga vera3
Ixora florbunda2
Sebastiania confusa5
Casearia arguta2
Krugio dendronferrumi2
Cochlospermum vitifolium1
Cordia panamensis3
Simarouba glauca1
Casearia praecox1
Dalbergia retusa1
Coccoloba sp.1
Cupania guatemalensis2
Agonandra macrocarpa1
Thouinidium decandrum1
Picramnia quaternaria1
Rehdera trinervis1
Sterculia apetala1
Astronium graveolens1
Apeiba tibourbou1
Annona reticulata1
Alibertia edulis1