SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=996 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=996SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=688SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=996 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagus' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagus' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fagus' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tsuga' AND (junior_species='sieboldii' OR junior_species='sieboldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tsuga' AND (species='sieboldii' OR species='sieboldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tsuga' AND (species='sieboldii' OR species='sieboldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tsuga' AND (junior_species='sieboldii' OR junior_species='sieboldi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tsuga' AND (species='sieboldii' OR species='sieboldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagus' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagus' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagus' AND (junior_species='crenata' OR junior_species='crenata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fagus' AND (species='crenata' OR species='crenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pieris' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='grossa' OR junior_species='grossa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='grossa' OR species='grossa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='grossa' OR species='grossa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='grossa' OR junior_species='grossa')SELECT d.diet,d.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='grossa' OR species='grossa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='sieboldianum' OR junior_species='sieboldianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='sieboldianum' OR species='sieboldianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='sieboldianum' OR species='sieboldianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='sieboldianum' OR junior_species='sieboldianum')SELECT d.diet,d.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='sieboldianum' OR species='sieboldianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpinus' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='firma' OR junior_species='firma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abies' AND (species='firma' OR species='firma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abies' AND (species='firma' OR species='firma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='firma' OR junior_species='firma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abies' AND (species='firma' OR species='firma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='tschonoskii' OR junior_species='tschonoski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='tschonoskii' OR species='tschonoski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='tschonoskii' OR species='tschonoski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='tschonoskii' OR junior_species='tschonoski')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpinus' AND (species='tschonoskii' OR species='tschonoski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='cordata' OR junior_species='cordata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='cordata' OR species='cordata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='cordata' OR species='cordata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='cordata' OR junior_species='cordata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpinus' AND (species='cordata' OR species='cordata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swida' AND (junior_species='controversa' OR junior_species='controversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swida' AND (species='controversa' OR species='controversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swida' AND (species='controversa' OR species='controversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swida' AND (junior_species='controversa' OR junior_species='controversa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Swida' AND (species='controversa' OR species='controversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rufinerve' OR junior_species='rufinerve')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='rufinerve' OR species='rufinerve') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='rufinerve' OR species='rufinerve')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='rufinerve' OR junior_species='rufinerve')SELECT d.diet,d.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='rufinerve' OR species='rufinerve') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='schmidtii' OR junior_species='schmidti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='schmidtii' OR species='schmidti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='schmidtii' OR species='schmidti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='schmidtii' OR junior_species='schmidti')SELECT d.diet,d.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='schmidtii' OR species='schmidti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clethra' AND (junior_species='barbinervis' OR junior_species='barbinervis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clethra' AND (species='barbinervis' OR species='barbinervis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clethra' AND (species='barbinervis' OR species='barbinervis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clethra' AND (junior_species='barbinervis' OR junior_species='barbinervis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clethra' AND (species='barbinervis' OR species='barbinervis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stewartia' AND (junior_species='pseudocamellia' OR junior_species='pseudocamellia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stewartia' AND (junior_species='pseudocamellia' OR junior_species='pseudocamellia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stewartia' AND (species='pseudocamellia' OR species='pseudocamellia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='nikoense' OR junior_species='nikoense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='nikoense' OR species='nikoense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='nikoense' OR species='nikoense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='nikoense' OR junior_species='nikoense')SELECT d.diet,d.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='nikoense' OR species='nikoense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalopanax' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kalopanax' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kalopanax' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalopanax' AND (junior_species='pictus' OR junior_species='pictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kalopanax' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='palmatum' OR junior_species='palmatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='palmatum' OR species='palmatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='palmatum' OR species='palmatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='palmatum' OR junior_species='palmatum')SELECT d.diet,d.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='palmatum' OR species='palmatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='macropoda' OR junior_species='macropoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='macropoda' OR species='macropoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='macropoda' OR species='macropoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='macropoda' OR junior_species='macropoda')SELECT d.diet,d.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='macropoda' OR species='macropoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpinus' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpinus' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpinus' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carpinus' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='platypoda' OR junior_species='platypoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='platypoda' OR species='platypoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='platypoda' OR species='platypoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='platypoda' OR junior_species='platypoda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fraxinus' AND (species='platypoda' OR species='platypoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='mongolica' OR junior_species='mongolica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='mongolica' OR species='mongolica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='mongolica' OR species='mongolica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='mongolica' OR junior_species='mongolica')SELECT d.diet,d.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='mongolica' OR species='mongolica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='sargentii' OR junior_species='sargenti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='sargentii' OR species='sargenti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='sargentii' OR species='sargenti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='sargentii' OR junior_species='sargenti')SELECT d.diet,d.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='sargentii' OR species='sargenti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grayana' OR junior_species='grayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='grayana' OR species='grayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='grayana' OR species='grayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='grayana' OR junior_species='grayana')SELECT d.diet,d.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='grayana' OR species='grayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliosma' AND (junior_species='myriantha' OR junior_species='myriantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliosma' AND (species='myriantha' OR species='myriantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliosma' AND (species='myriantha' OR species='myriantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliosma' AND (junior_species='myriantha' OR junior_species='myriantha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meliosma' AND (species='myriantha' OR species='myriantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picea' AND (junior_species='polita' OR junior_species='polita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picea' AND (species='polita' OR species='polita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picea' AND (species='polita' OR species='polita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picea' AND (junior_species='polita' OR junior_species='polita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picea' AND (species='polita' OR species='polita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tilia' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tilia' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tilia' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tilia' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tilia' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='obassia' OR junior_species='obassia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='obassia' OR species='obassia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='obassia' OR species='obassia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='obassia' OR junior_species='obassia')SELECT d.diet,d.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='obassia' OR species='obassia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelkova' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelkova' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelkova' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelkova' AND (junior_species='serrata' OR junior_species='serrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelkova' AND (species='serrata' OR species='serrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='tenuifolium' OR species='tenuifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acer' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanea' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castanea' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanea' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanea' AND (junior_species='crenata' OR junior_species='crenata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Castanea' AND (species='crenata' OR species='crenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Larix' AND (junior_species='kaempferi' OR junior_species='kaempferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Larix' AND (species='kaempferi' OR species='kaempferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Larix' AND (species='kaempferi' OR species='kaempferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Larix' AND (junior_species='kaempferi' OR junior_species='kaempferii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Larix' AND (species='kaempferi' OR species='kaempferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='lanuginosa' OR species='lanuginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fraxinus' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' 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='Magnolia' AND (species='obovata' OR species='obovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Magnolia' AND (species='obovata' OR species='obovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magnolia' 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='Magnolia' AND (species='obovata' OR species='obovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='japonicum' OR junior_species='japonicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='japonicum' OR species='japonicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='japonicum' OR species='japonicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='japonicum' OR junior_species='japonicum')SELECT d.diet,d.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='japonicum' OR species='japonicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chengiopanax' AND (junior_species='sciadophylloides' OR junior_species='sciadophylloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chengiopanax' AND (junior_species='sciadophylloides' OR junior_species='sciadophylloides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chengiopanax' AND (species='sciadophylloides' OR species='sciadophylloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alnus' AND (junior_species='firma' OR junior_species='firma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alnus' AND (species='firma' OR species='firma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alnus' AND (species='firma' OR species='firma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alnus' AND (junior_species='firma' OR junior_species='firma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alnus' AND (species='firma' OR species='firma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorbus' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorbus' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorbus' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='micranthum' OR junior_species='micranthum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='micranthum' OR species='micranthum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='micranthum' OR species='micranthum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='micranthum' OR junior_species='micranthum')SELECT d.diet,d.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='micranthum' OR species='micranthum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='homolepis' OR junior_species='homolepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abies' AND (species='homolepis' OR species='homolepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abies' AND (species='homolepis' OR species='homolepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abies' AND (junior_species='homolepis' OR junior_species='homolepis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abies' AND (species='homolepis' OR species='homolepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='maximowicziana' OR junior_species='maximowicziana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Betula' AND (species='maximowicziana' OR species='maximowicziana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Betula' AND (species='maximowicziana' OR species='maximowicziana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Betula' AND (junior_species='maximowicziana' OR junior_species='maximowicziana')SELECT d.diet,d.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='maximowicziana' OR species='maximowicziana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phellodendron' AND (junior_species='amurense' OR junior_species='amurense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phellodendron' AND (species='amurense' OR species='amurense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phellodendron' AND (species='amurense' OR species='amurense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phellodendron' AND (junior_species='amurense' OR junior_species='amurense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phellodendron' AND (species='amurense' OR species='amurense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='sieboldiana' OR junior_species='sieboldiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraxinus' AND (species='sieboldiana' OR species='sieboldiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraxinus' AND (species='sieboldiana' OR species='sieboldiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraxinus' AND (junior_species='sieboldiana' OR junior_species='sieboldiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fraxinus' AND (species='sieboldiana' OR species='sieboldiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Benthamidia' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Benthamidia' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Benthamidia' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Benthamidia' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Benthamidia' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='shirasawanum' OR junior_species='shirasawanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='shirasawanum' OR species='shirasawanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='shirasawanum' OR species='shirasawanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='shirasawanum' OR junior_species='shirasawanum')SELECT d.diet,d.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='shirasawanum' OR species='shirasawanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='distylum' OR junior_species='distylum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='distylum' OR species='distylum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='distylum' OR species='distylum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='distylum' OR junior_species='distylum')SELECT d.diet,d.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='distylum' OR species='distylum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cladrastis' AND (junior_species='sikokiana' OR junior_species='sikokiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cladrastis' AND (species='sikokiana' OR species='sikokiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cladrastis' AND (species='sikokiana' OR species='sikokiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cladrastis' AND (junior_species='sikokiana' OR junior_species='sikokiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cladrastis' AND (species='sikokiana' OR species='sikokiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinidia' 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='Actinidia' AND (species='arguta' OR species='arguta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinidia' AND (species='arguta' OR species='arguta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinidia' 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='Actinidia' AND (species='arguta' OR species='arguta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostyrax' AND (junior_species='hispida' OR junior_species='hispida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostyrax' AND (species='hispida' OR species='hispida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostyrax' AND (species='hispida' OR species='hispida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostyrax' AND (junior_species='hispida' OR junior_species='hispida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostyrax' AND (species='hispida' OR species='hispida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='cissifolium' OR junior_species='cissifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='cissifolium' OR species='cissifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='cissifolium' OR species='cissifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='cissifolium' OR junior_species='cissifolium')SELECT d.diet,d.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='cissifolium' OR species='cissifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhododendron' AND (junior_species='dilatanum' OR junior_species='dilatanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhododendron' AND (species='dilatanum' OR species='dilatanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhododendron' AND (species='dilatanum' OR species='dilatanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhododendron' AND (junior_species='dilatanum' OR junior_species='dilatanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhododendron' AND (species='dilatanum' OR species='dilatanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enkianthus' AND (junior_species='cernuus' OR junior_species='cernuus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enkianthus' AND (species='cernuus' OR species='cernuus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enkianthus' AND (species='cernuus' OR species='cernuus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enkianthus' AND (junior_species='cernuus' OR junior_species='cernuus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enkianthus' AND (species='cernuus' OR species='cernuus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizophragma' AND (junior_species='hydrangeoides' OR junior_species='hydrangeoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schizophragma' AND (species='hydrangeoides' OR species='hydrangeoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schizophragma' AND (species='hydrangeoides' OR species='hydrangeoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizophragma' AND (junior_species='hydrangeoides' OR junior_species='hydrangeoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schizophragma' AND (species='hydrangeoides' OR species='hydrangeoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='carpinifolium' OR junior_species='carpinifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='carpinifolium' OR species='carpinifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='carpinifolium' OR species='carpinifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='carpinifolium' OR junior_species='carpinifolium')SELECT d.diet,d.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='carpinifolium' OR species='carpinifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gamblea' AND (junior_species='innovans' OR junior_species='innovans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gamblea' AND (species='innovans' OR species='innovans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gamblea' AND (species='innovans' OR species='innovans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gamblea' AND (junior_species='innovans' OR junior_species='innovans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gamblea' AND (species='innovans' OR species='innovans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clerodendrum' AND (junior_species='trichotomum' OR junior_species='trichotomum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clerodendrum' AND (species='trichotomum' OR species='trichotomum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clerodendrum' AND (species='trichotomum' OR species='trichotomum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clerodendrum' AND (junior_species='trichotomum' OR junior_species='trichotomum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clerodendrum' AND (species='trichotomum' OR species='trichotomum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malus' AND (junior_species='tschonoskii' OR junior_species='tschonoski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malus' AND (species='tschonoskii' OR species='tschonoski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malus' AND (species='tschonoskii' OR species='tschonoski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malus' AND (junior_species='tschonoskii' OR junior_species='tschonoski')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Malus' AND (species='tschonoskii' OR species='tschonoski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='maximowiczii' OR junior_species='maximowiczi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='maximowiczii' OR species='maximowiczi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='maximowiczii' OR species='maximowiczi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='maximowiczii' OR junior_species='maximowiczi')SELECT d.diet,d.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='maximowiczii' OR species='maximowiczi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='sieboldianus' OR junior_species='sieboldianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='sieboldianus' OR species='sieboldianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='sieboldianus' OR species='sieboldianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='sieboldianus' OR junior_species='sieboldianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euonymus' AND (species='sieboldianus' OR species='sieboldianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='mono' OR junior_species='mono')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='mono' OR species='mono') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='mono' OR species='mono')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='mono' OR junior_species='mono')SELECT d.diet,d.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='mono' OR species='mono') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enkianthus' AND (junior_species='campanulatus' OR junior_species='campanulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enkianthus' AND (species='campanulatus' OR species='campanulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enkianthus' AND (species='campanulatus' OR species='campanulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enkianthus' AND (junior_species='campanulatus' OR junior_species='campanulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enkianthus' AND (species='campanulatus' OR species='campanulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyonia' AND (junior_species='ovalifolia' OR junior_species='ovalifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lyonia' AND (species='ovalifolia' OR species='ovalifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lyonia' AND (species='ovalifolia' OR species='ovalifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyonia' AND (junior_species='ovalifolia' OR junior_species='ovalifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lyonia' AND (species='ovalifolia' OR species='ovalifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrus' AND (junior_species='orbiculatus' OR junior_species='orbiculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrus' AND (species='orbiculatus' OR species='orbiculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrus' AND (species='orbiculatus' OR species='orbiculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrus' AND (junior_species='orbiculatus' OR junior_species='orbiculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celastrus' AND (species='orbiculatus' OR species='orbiculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Torreya' AND (junior_species='nucifera' OR junior_species='nucifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Torreya' AND (species='nucifera' OR species='nucifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Torreya' AND (species='nucifera' OR species='nucifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Torreya' AND (junior_species='nucifera' OR junior_species='nucifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Torreya' AND (species='nucifera' OR species='nucifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='pendula' OR junior_species='pendula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunus' AND (species='pendula' OR species='pendula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='pendula' OR species='pendula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' AND (junior_species='pendula' OR junior_species='pendula')SELECT d.diet,d.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='pendula' OR species='pendula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='fortunei' OR junior_species='fortuneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='fortunei' OR species='fortuneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='fortunei' OR species='fortuneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='fortunei' OR junior_species='fortuneii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euonymus' AND (species='fortunei' OR species='fortuneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='alnifolia' OR junior_species='alnifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorbus' AND (species='alnifolia' OR species='alnifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorbus' AND (species='alnifolia' OR species='alnifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorbus' AND (junior_species='alnifolia' OR junior_species='alnifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorbus' AND (species='alnifolia' OR species='alnifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wisteria' 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='Wisteria' AND (species='floribunda' OR species='floribunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wisteria' AND (species='floribunda' OR species='floribunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wisteria' 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='Wisteria' AND (species='floribunda' OR species='floribunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhododendron' AND (junior_species='wadanum' OR junior_species='wadanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhododendron' AND (species='wadanum' OR species='wadanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhododendron' AND (species='wadanum' OR species='wadanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhododendron' AND (junior_species='wadanum' OR junior_species='wadanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhododendron' AND (species='wadanum' OR species='wadanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='piperitum' OR junior_species='piperitum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='piperitum' OR species='piperitum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='piperitum' OR species='piperitum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='piperitum' OR junior_species='piperitum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zanthoxylum' AND (species='piperitum' OR species='piperitum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='crataegifolium' OR junior_species='crataegifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acer' AND (species='crataegifolium' OR species='crataegifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acer' AND (species='crataegifolium' OR species='crataegifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acer' AND (junior_species='crataegifolium' OR junior_species='crataegifolium')SELECT d.diet,d.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='crataegifolium' OR species='crataegifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sambucus' AND (junior_species='racemosa' OR junior_species='racemosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sambucus' AND (species='racemosa' OR species='racemosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sambucus' AND (species='racemosa' OR species='racemosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sambucus' AND (junior_species='racemosa' OR junior_species='racemosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sambucus' AND (species='racemosa' OR species='racemosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='furcatum' OR junior_species='furcatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Viburnum' AND (species='furcatum' OR species='furcatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Viburnum' AND (species='furcatum' OR species='furcatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viburnum' AND (junior_species='furcatum' OR junior_species='furcatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Viburnum' AND (species='furcatum' OR species='furcatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' AND (junior_species='mollis' OR junior_species='mollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicarpa' AND (species='mollis' OR species='mollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicarpa' AND (species='mollis' OR species='mollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' AND (junior_species='mollis' OR junior_species='mollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicarpa' AND (species='mollis' OR species='mollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='oxyphyllus' OR junior_species='oxyphyllus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='oxyphyllus' OR species='oxyphyllus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='oxyphyllus' OR species='oxyphyllus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='oxyphyllus' OR junior_species='oxyphyllus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euonymus' AND (species='oxyphyllus' OR species='oxyphyllus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitis' AND (junior_species='coignetiae' OR junior_species='coignetiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitis' AND (species='coignetiae' OR species='coignetiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitis' AND (species='coignetiae' OR species='coignetiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitis' AND (junior_species='coignetiae' OR junior_species='coignetiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vitis' AND (species='coignetiae' OR species='coignetiae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=996 The Ecological Register: Chichibu Mountains
Chichibu Mountains
Basic information
Sample name: Chichibu Mountains

Reference: H. Sawada, T. Ohkubo, M. Kaji, and K. Oomura. 2005. Spatial distribution and topographic dependence of vegetation types and tree populations of natural forests in the Chichibu Mountains, central Japan. Journal of the Japanese Forestry Society 87(4):293-303 [ER 688]
Geography
Country: Japan


Coordinate: 35° 56' 13" N, 138° 48' 18" E
Coordinate basis: stated in text

Geography comments: coordinate based on ranges given in text
altitude 1142 to 1314 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 8.9

MAP: 1416.0

Methods
Life forms: trees

Sites: 110

Site area: 6.875

Sampling methods: quadrat

Sample size: 7894 individuals

Size min: 5

Basal area: 316.9

Sampling comments: 110 25 x 25 m plots

Metadata
Sample number: 996

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-07-03 21:09:42

Modified: 2014-08-22 03:13:11

Abundance distribution
76 species
8 singletons
total count 7894
extrapolated richness: 95.3
Fisher's α: 11.658
geometric series k: 0.9029
Hurlbert's PIE: 0.8915
Shannon's H: 2.9260
Good's u: 0.9990
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Fagus japonica2119
Tsuga sieboldii601
Fagus crenata368
Pieris japonica990
Betula grossa72
Acer sieboldianum313
Carpinus laxiflora270
Abies firma117
Carpinus tschonoskii100
Carpinus cordata356
Swida controversa53
Acer rufinerve81
Betula schmidtii19
Clethra barbinervis518
"Clethra barvinervis"
Stewartia pseudocamellia159
Acer nikoense21
Kalopanax pictus18
Acer palmatum amoenum120
Ilex macropoda connivens144
Carpinus japonica74
Fraxinus platypoda14
Quercus mongolica crispula55
"Quercus crispula"
Prunus sargentii23
Prunus grayana49
Meliosma myriantha244
Picea polita20
Tilia japonica18
Styrax obassia120
Zelkova serrata14
Acer tenuifolium ambiguum91
Castanea crenata13
Larix kaempferi17
"Larix kaemaferi"
Fraxinus lanuginosa86
Magnolia obovata18
Acer japonicum110
Chengiopanax sciadophylloides38
"Acanthopanax sciadophylloides"
Alnus firma8
Sorbus japonica12
Acer micranthum63
Abies homolepis50
Betula maximowicziana11
Phellodendron amurense7
Fraxinus sieboldiana27
Benthamidia japonica38
Acer shirasawanum10
Acer distylum11
Cladrastis sikokiana2
Actinidia arguta35
Pterostyrax hispida2
Acer cissifolium11
Rhododendron dilatanum33
Enkianthus cernuus rubens29
Schizophragma hydrangeoides16
Acer carpinifolium8
Gamblea innovans1
"Evodiopanax innovans"
Clerodendrum trichotomum11
Malus tschonoskii8
Prunus maximowiczii1
Euonymus sieboldianus2
Acer mono trichobasis17
Enkianthus campanulatus6
Lyonia ovalifolia elliptica2
Celastrus orbiculatus5
Torreya nucifera4
Prunus pendula ascendens1
Euonymus fortunei3
Sorbus alnifolia2
Wisteria floribunda3
Rhododendron wadanum3
Zanthoxylum piperitum2
Acer crataegifolium2
Sambucus racemosa sieboldiana1
Viburnum furcatum1
Callicarpa mollis1
Euonymus oxyphyllus1
Vitis coignetiae1