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=2073 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2073SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2115SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2073 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acmena' AND (junior_species='resa' OR junior_species='resa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acmena' AND (species='resa' OR species='resa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acmena' AND (species='resa' OR species='resa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acmena' AND (junior_species='resa' OR junior_species='resa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acmena' AND (species='resa' OR species='resa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antirhea' 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='Antirhea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antirhea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antirhea' 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='Antirhea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodytes' AND (junior_species='brachystylis' OR junior_species='brachystylis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodytes' AND (species='brachystylis' OR species='brachystylis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodytes' AND (species='brachystylis' OR species='brachystylis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodytes' AND (junior_species='brachystylis' OR junior_species='brachystylis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apodytes' AND (species='brachystylis' OR species='brachystylis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='grandiflorum' OR junior_species='grandiflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archidendron' AND (species='grandiflorum' OR species='grandiflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archidendron' AND (species='grandiflorum' OR species='grandiflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='grandiflorum' OR junior_species='grandiflorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archidendron' AND (species='grandiflorum' OR species='grandiflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='vaillantii' OR junior_species='vaillanti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archidendron' AND (species='vaillantii' OR species='vaillanti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archidendron' AND (species='vaillantii' OR species='vaillanti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archidendron' AND (junior_species='vaillantii' OR junior_species='vaillanti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archidendron' AND (species='vaillantii' OR species='vaillanti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodendron' 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='Argyrodendron' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyrodendron' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodendron' 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='Argyrodendron' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atractocarpus' AND (junior_species='fitzalanii' OR junior_species='fitzalani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atractocarpus' AND (species='fitzalanii' OR species='fitzalani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atractocarpus' AND (species='fitzalanii' OR species='fitzalani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atractocarpus' AND (junior_species='fitzalanii' OR junior_species='fitzalani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atractocarpus' AND (species='fitzalanii' OR species='fitzalani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrobuxus' AND (junior_species='megacarpus' OR junior_species='megacarpus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Austrobuxus' AND (species='megacarpus' OR species='megacarpus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Austrobuxus' AND (species='megacarpus' OR species='megacarpus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrobuxus' AND (junior_species='megacarpus' OR junior_species='megacarpus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Austrobuxus' AND (species='megacarpus' OR species='megacarpus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanops' AND (junior_species='australiana' OR junior_species='australiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balanops' AND (species='australiana' OR species='australiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balanops' AND (species='australiana' OR species='australiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanops' AND (junior_species='australiana' OR junior_species='australiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Balanops' AND (species='australiana' OR species='australiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='bancroftii' OR junior_species='bancrofti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='bancroftii' OR species='bancrofti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='bancroftii' OR species='bancrofti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='bancroftii' OR junior_species='bancrofti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Beilschmiedia' AND (species='bancroftii' OR species='bancrofti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='collina' OR junior_species='collina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='collina' OR species='collina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='collina' OR species='collina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='collina' OR junior_species='collina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Beilschmiedia' AND (species='collina' OR species='collina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buckinghamia' AND (junior_species='celsissima' OR junior_species='celsissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buckinghamia' AND (species='celsissima' OR species='celsissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buckinghamia' AND (species='celsissima' OR species='celsissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buckinghamia' AND (junior_species='celsissima' OR junior_species='celsissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Buckinghamia' AND (species='celsissima' OR species='celsissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardwellia' AND (junior_species='sublimis' OR junior_species='sublimis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardwellia' AND (species='sublimis' OR species='sublimis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardwellia' AND (species='sublimis' OR species='sublimis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardwellia' AND (junior_species='sublimis' OR junior_species='sublimis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cardwellia' AND (species='sublimis' OR species='sublimis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnarvonia' AND (junior_species='araliifolia' OR junior_species='araliifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carnarvonia' AND (species='araliifolia' OR species='araliifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carnarvonia' AND (species='araliifolia' OR species='araliifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnarvonia' AND (junior_species='araliifolia' OR junior_species='araliifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carnarvonia' AND (species='araliifolia' OR species='araliifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='costulata' OR junior_species='costulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='costulata' OR species='costulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='costulata' OR species='costulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='costulata' OR junior_species='costulata')SELECT d.diet,d.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='costulata' OR species='costulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalepidia' AND (junior_species='heyana' OR junior_species='heyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catalepidia' AND (species='heyana' OR species='heyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catalepidia' AND (species='heyana' OR species='heyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalepidia' AND (junior_species='heyana' OR junior_species='heyana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catalepidia' AND (species='heyana' OR species='heyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratopetalum' AND (junior_species='succirubrum' OR junior_species='succirubrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratopetalum' AND (species='succirubrum' OR species='succirubrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratopetalum' AND (species='succirubrum' OR species='succirubrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratopetalum' AND (junior_species='succirubrum' OR junior_species='succirubrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratopetalum' AND (species='succirubrum' OR species='succirubrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chionanthus' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chionanthus' AND (species='axillaris' OR species='axillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionanthus' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chionanthus' AND (species='axillaris' OR species='axillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='laubatii' OR junior_species='laubati')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='laubatii' OR species='laubati') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='laubatii' OR species='laubati')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='laubatii' OR junior_species='laubati')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cinnamomum' AND (species='laubatii' OR species='laubati') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnesmocarpon' AND (junior_species='dasyantha' OR junior_species='dasyantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnesmocarpon' AND (species='dasyantha' OR species='dasyantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnesmocarpon' AND (species='dasyantha' OR species='dasyantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnesmocarpon' AND (junior_species='dasyantha' OR junior_species='dasyantha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cnesmocarpon' AND (species='dasyantha' OR species='dasyantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynocarpus' AND (junior_species='cribbianus' OR junior_species='cribbianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corynocarpus' AND (species='cribbianus' OR species='cribbianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corynocarpus' AND (species='cribbianus' OR species='cribbianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynocarpus' AND (junior_species='cribbianus' OR junior_species='cribbianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corynocarpus' AND (species='cribbianus' OR species='cribbianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='angulata' OR junior_species='angulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='angulata' OR species='angulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='angulata' OR species='angulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='angulata' OR junior_species='angulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='angulata' OR species='angulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='corrugata' OR junior_species='corrugata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='corrugata' OR species='corrugata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='corrugata' OR species='corrugata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='corrugata' OR junior_species='corrugata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='corrugata' OR species='corrugata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='densiflora' OR junior_species='densiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='densiflora' OR species='densiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='densiflora' OR species='densiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='densiflora' OR junior_species='densiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='densiflora' OR species='densiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='grandis' OR junior_species='grandis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='lividula' OR junior_species='lividula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='lividula' OR species='lividula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='lividula' OR species='lividula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='lividula' OR junior_species='lividula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='lividula' OR species='lividula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='oblata' OR junior_species='oblata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='oblata' OR species='oblata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='oblata' OR species='oblata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='oblata' OR junior_species='oblata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptocarya' AND (species='oblata' OR species='oblata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Darlingia' AND (junior_species='darlingiana' OR junior_species='darlingiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Darlingia' AND (species='darlingiana' OR species='darlingiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Darlingia' AND (species='darlingiana' OR species='darlingiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Darlingia' AND (junior_species='darlingiana' OR junior_species='darlingiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Darlingia' AND (species='darlingiana' OR species='darlingiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denhamia' AND (junior_species='viridissima' OR junior_species='viridissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Denhamia' AND (species='viridissima' OR species='viridissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Denhamia' AND (species='viridissima' OR species='viridissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denhamia' AND (junior_species='viridissima' OR junior_species='viridissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Denhamia' AND (species='viridissima' OR species='viridissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryadodaphne' 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='Dryadodaphne' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryadodaphne' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryadodaphne' 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='Dryadodaphne' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='carolinae' OR junior_species='carolinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='carolinae' OR species='carolinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='carolinae' OR species='carolinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='carolinae' OR junior_species='carolinae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='carolinae' OR species='carolinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='elliffii' OR junior_species='elliffi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='elliffii' OR species='elliffi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='elliffii' OR species='elliffi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='elliffii' OR junior_species='elliffi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='elliffii' OR species='elliffi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='largiflorens' OR junior_species='largiflorens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='largiflorens' OR species='largiflorens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='largiflorens' OR species='largiflorens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='largiflorens' OR junior_species='largiflorens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='largiflorens' OR species='largiflorens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sericopetalus' OR junior_species='sericopetalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='sericopetalus' OR species='sericopetalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='sericopetalus' OR species='sericopetalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='sericopetalus' OR junior_species='sericopetalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeocarpus' AND (species='sericopetalus' OR species='sericopetalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Endiandra' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='dielsiana' OR junior_species='dielsiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='dielsiana' OR species='dielsiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='dielsiana' OR species='dielsiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='dielsiana' OR junior_species='dielsiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Endiandra' AND (species='dielsiana' OR species='dielsiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='montana' OR junior_species='montana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Endiandra' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='phaeocarpa' OR junior_species='phaeocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='phaeocarpa' OR species='phaeocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='phaeocarpa' OR species='phaeocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='phaeocarpa' OR junior_species='phaeocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Endiandra' AND (species='phaeocarpa' OR species='phaeocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='crassipes' OR junior_species='crassipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='crassipes' OR species='crassipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='crassipes' OR species='crassipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='crassipes' OR junior_species='crassipes')SELECT d.diet,d.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='crassipes' OR species='crassipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='acuminata' OR junior_species='acuminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Flindersia' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='bourjotiana' OR junior_species='bourjotiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='bourjotiana' OR species='bourjotiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='bourjotiana' OR species='bourjotiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='bourjotiana' OR junior_species='bourjotiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Flindersia' AND (species='bourjotiana' OR species='bourjotiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='brayleyana' OR junior_species='brayleyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='brayleyana' OR species='brayleyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='brayleyana' OR species='brayleyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='brayleyana' OR junior_species='brayleyana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Flindersia' AND (species='brayleyana' OR species='brayleyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='pimenteliana' OR junior_species='pimenteliana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='pimenteliana' OR species='pimenteliana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='pimenteliana' OR species='pimenteliana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='pimenteliana' OR junior_species='pimenteliana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Flindersia' AND (species='pimenteliana' OR species='pimenteliana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franciscodendron' AND (junior_species='laurifolium' OR junior_species='laurifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Franciscodendron' AND (species='laurifolium' OR species='laurifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Franciscodendron' AND (species='laurifolium' OR species='laurifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Franciscodendron' AND (junior_species='laurifolium' OR junior_species='laurifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Franciscodendron' AND (species='laurifolium' OR species='laurifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Garcinia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Goniothalamus' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goniothalamus' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' AND (junior_species='australis' OR junior_species='australis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Goniothalamus' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='grayi' OR junior_species='grayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gossia' AND (species='grayi' OR species='grayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gossia' AND (species='grayi' OR species='grayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='grayi' OR junior_species='grayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gossia' AND (species='grayi' OR species='grayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='lewisensis' OR junior_species='lewisensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gossia' AND (species='lewisensis' OR species='lewisensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gossia' AND (species='lewisensis' OR species='lewisensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='lewisensis' OR junior_species='lewisensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gossia' AND (species='lewisensis' OR species='lewisensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halfordia' AND (junior_species='kendack' OR junior_species='kendack')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halfordia' AND (species='kendack' OR species='kendack') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halfordia' AND (species='kendack' OR species='kendack')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halfordia' AND (junior_species='kendack' OR junior_species='kendack')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halfordia' AND (species='kendack' OR species='kendack') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='grayi' OR junior_species='grayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicia' AND (species='grayi' OR species='grayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicia' AND (species='grayi' OR species='grayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='grayi' OR junior_species='grayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicia' AND (species='grayi' OR species='grayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='oreogena' OR junior_species='oreogena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixora' AND (species='oreogena' OR species='oreogena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixora' AND (species='oreogena' OR species='oreogena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixora' AND (junior_species='oreogena' OR junior_species='oreogena')SELECT d.diet,d.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='oreogena' OR species='oreogena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='connorsii' OR junior_species='connorsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='connorsii' OR species='connorsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='connorsii' OR species='connorsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='connorsii' OR junior_species='connorsi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Litsea' AND (species='connorsii' OR species='connorsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='achradifolia' OR junior_species='achradifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrsine' AND (species='achradifolia' OR species='achradifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrsine' AND (species='achradifolia' OR species='achradifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='achradifolia' OR junior_species='achradifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrsine' AND (species='achradifolia' OR species='achradifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='dealbata' OR junior_species='dealbata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neolitsea' AND (species='dealbata' OR species='dealbata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neolitsea' AND (species='dealbata' OR species='dealbata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neolitsea' AND (junior_species='dealbata' OR junior_species='dealbata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neolitsea' AND (species='dealbata' OR species='dealbata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niemeyera' 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='Niemeyera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niemeyera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niemeyera' 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='Niemeyera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oraniopsis' AND (junior_species='appendiculata' OR junior_species='appendiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oraniopsis' AND (species='appendiculata' OR species='appendiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oraniopsis' AND (species='appendiculata' OR species='appendiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oraniopsis' AND (junior_species='appendiculata' OR junior_species='appendiculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oraniopsis' AND (species='appendiculata' OR species='appendiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placospermum' AND (junior_species='coriaceum' OR junior_species='coriaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Placospermum' AND (species='coriaceum' OR species='coriaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Placospermum' AND (species='coriaceum' OR species='coriaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placospermum' AND (junior_species='coriaceum' OR junior_species='coriaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Placospermum' AND (species='coriaceum' OR species='coriaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' 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='Planchonella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Planchonella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Planchonella' 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='Planchonella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='australiana' OR junior_species='australiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyscias' AND (species='australiana' OR species='australiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyscias' AND (species='australiana' OR species='australiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='australiana' OR junior_species='australiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyscias' AND (species='australiana' OR species='australiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyscias' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyscias' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='elegans' OR junior_species='elegans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyscias' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='euphlebia' OR junior_species='euphlebia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='euphlebia' OR species='euphlebia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='euphlebia' OR species='euphlebia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='euphlebia' OR junior_species='euphlebia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='euphlebia' OR species='euphlebia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='pearsoniorum' OR junior_species='pearsoniorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='pearsoniorum' OR species='pearsoniorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='pearsoniorum' OR species='pearsoniorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='pearsoniorum' OR junior_species='pearsoniorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='pearsoniorum' OR species='pearsoniorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prumnopitys' AND (junior_species='ladei' OR junior_species='ladeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prumnopitys' AND (species='ladei' OR species='ladeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prumnopitys' AND (species='ladei' OR species='ladeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prumnopitys' AND (junior_species='ladei' OR junior_species='ladeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prumnopitys' AND (species='ladei' OR species='ladeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psydrax' AND (junior_species='montigena' OR junior_species='montigena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psydrax' AND (species='montigena' OR species='montigena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psydrax' AND (species='montigena' OR species='montigena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psydrax' AND (junior_species='montigena' OR junior_species='montigena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psydrax' AND (species='montigena' OR species='montigena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcopteryx' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcopteryx' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcopteryx' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcopteryx' AND (junior_species='montana' OR junior_species='montana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sarcopteryx' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcotoechia' AND (junior_species='cuneata' OR junior_species='cuneata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcotoechia' AND (species='cuneata' OR species='cuneata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcotoechia' AND (species='cuneata' OR species='cuneata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcotoechia' AND (junior_species='cuneata' OR junior_species='cuneata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sarcotoechia' AND (species='cuneata' OR species='cuneata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sloanea' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sloanea' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='australis' OR junior_species='australis')SELECT d.diet,d.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='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='macbrydei' OR junior_species='macbrydeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sloanea' AND (species='macbrydei' OR species='macbrydeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sloanea' AND (species='macbrydei' OR species='macbrydeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sloanea' AND (junior_species='macbrydei' OR junior_species='macbrydeii')SELECT d.diet,d.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='macbrydei' OR species='macbrydeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphalmium' AND (junior_species='racemosum' OR junior_species='racemosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphalmium' AND (species='racemosum' OR species='racemosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphalmium' AND (species='racemosum' OR species='racemosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphalmium' AND (junior_species='racemosum' OR junior_species='racemosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sphalmium' AND (species='racemosum' OR species='racemosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocarpus' AND (junior_species='davallioides' OR junior_species='davallioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocarpus' AND (species='davallioides' OR species='davallioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocarpus' AND (species='davallioides' OR species='davallioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocarpus' AND (junior_species='davallioides' OR junior_species='davallioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenocarpus' AND (species='davallioides' OR species='davallioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streblus' AND (junior_species='glaber' OR junior_species='glaber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streblus' AND (species='glaber' OR species='glaber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streblus' AND (species='glaber' OR species='glaber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streblus' AND (junior_species='glaber' OR junior_species='glaber')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Streblus' AND (species='glaber' OR species='glaber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synima' AND (junior_species='cordierorum' OR junior_species='cordierorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synima' AND (species='cordierorum' OR species='cordierorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synima' AND (species='cordierorum' OR species='cordierorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synima' AND (junior_species='cordierorum' OR junior_species='cordierorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synima' AND (species='cordierorum' OR species='cordierorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synima' 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='Synima' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synima' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synima' 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='Synima' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synoum' AND (junior_species='glandulosum' OR junior_species='glandulosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synoum' AND (species='glandulosum' OR species='glandulosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synoum' AND (species='glandulosum' OR species='glandulosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synoum' AND (junior_species='glandulosum' OR junior_species='glandulosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synoum' AND (species='glandulosum' OR species='glandulosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cormiflorum' OR junior_species='cormiflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cormiflorum' OR species='cormiflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cormiflorum' OR species='cormiflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cormiflorum' OR junior_species='cormiflorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='cormiflorum' OR species='cormiflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='endophloium' OR junior_species='endophloium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='endophloium' OR species='endophloium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='endophloium' OR species='endophloium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='endophloium' OR junior_species='endophloium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='endophloium' OR species='endophloium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='johnsonii' OR junior_species='johnsoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='johnsonii' OR species='johnsoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='johnsonii' OR species='johnsoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='johnsonii' OR junior_species='johnsoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='johnsonii' OR species='johnsoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='luehmannii' OR junior_species='luehmanni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='luehmannii' OR species='luehmanni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='luehmannii' OR species='luehmanni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='luehmannii' OR junior_species='luehmanni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='luehmannii' OR species='luehmanni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='wesa' OR junior_species='wesa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='wesa' OR species='wesa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='wesa' OR species='wesa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='wesa' OR junior_species='wesa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syzygium' AND (species='wesa' OR species='wesa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='octandrum' OR junior_species='octandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthophyllum' AND (species='octandrum' OR species='octandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthophyllum' AND (species='octandrum' OR species='octandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='octandrum' OR junior_species='octandrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthophyllum' AND (species='octandrum' OR species='octandrum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2073 The Ecological Register: Mount Lewis
Mount Lewis
Basic information
Sample name: Mount Lewis

Sample aka: EP18

Reference: M. G. Bradford, H. T. Murphy, A. J. Ford, D. Hogan, and D. J. Metcalfe. 2014. Long-term stem inventory data from tropical rain forest plots in Australia. Ecology 95:2362 [ER 2115]
Geography
Country: Australia

State: Queensland


Coordinate: -16.52264° S, 145.266556° E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 19.2

MAP: 2676.0

Methods
Life forms: trees

Sites: 1

Site area: 0.51

Sampling methods: quadrat

Sample size: 454 individuals

Years: 1973

Size min: 10

Basal area: 30.4455

Metadata
Sample number: 2073

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-14 13:31:40

Modified: 2016-06-14 03:31:40

Abundance distribution
81 species
21 singletons
total count 454
extrapolated richness: 147.8
Fisher's α: 28.697
geometric series k: 0.9516
Hurlbert's PIE: 0.9650
Shannon's H: 3.8342
Good's u: 0.9539
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Acmena resa3
Antirhea sp. Mt Misery (L.W.Jessup+ GJD3136)2
Apodytes brachystylis3
Archidendron grandiflorum10
Archidendron vaillantii7
Argyrodendron sp. Mt Haig ( L.S.Smith+ 14307)14
Atractocarpus fitzalanii tenuipes8
Austrobuxus megacarpus1
Balanops australiana2
Beilschmiedia bancroftii5
Beilschmiedia collina19
Buckinghamia celsissima2
Cardwellia sublimis8
Carnarvonia araliifolia montana2
Casearia costulata2
Catalepidia heyana2
Ceratopetalum succirubrum2
Chionanthus axillaris6
Cinnamomum laubatii5
Cnesmocarpon dasyantha2
Corynocarpus cribbianus3
Cryptocarya angulata6
Cryptocarya corrugata25
Cryptocarya densiflora3
Cryptocarya grandis8
Cryptocarya lividula24
Cryptocarya oblata5
Darlingia darlingiana12
Denhamia viridissima2
Diospyros sp. Mt Lewis (L.S.Smith 10107)8
Dryadodaphne sp. Mt Lewis (B.P.Hyland+ RFK1496)1
Elaeocarpus carolinae5
Elaeocarpus elliffii4
Elaeocarpus largiflorens retinervis7
Elaeocarpus sericopetalus4
Endiandra acuminata4
Endiandra dielsiana4
Endiandra montana2
Endiandra phaeocarpa1
Ficus crassipes1
Flindersia acuminata4
Flindersia bourjotiana11
Flindersia brayleyana5
Flindersia pimenteliana1
Franciscodendron laurifolium3
Garcinia sp. Davies Creek (J.G.Tracey 14745)14
Goniothalamus australis21
Gossia grayi1
Gossia lewisensis1
Halfordia kendack1
Helicia grayi1
Ixora oreogena7
Litsea connorsii1
Myrsine achradifolia5
Neolitsea dealbata1
Niemeyera sp. Mt Lewis (A.K.Irvine 1402)4
Oraniopsis appendiculata1
Placospermum coriaceum7
Planchonella sp. Mt. Lewis (B.Hyland 14048)53
Polyscias australiana1
Polyscias elegans1
Pouteria euphlebia17
Pouteria pearsoniorum2
Prumnopitys ladei1
Psydrax montigena2
Sarcopteryx montana2
Sarcotoechia cuneata3
Sloanea australis parviflora1
Sloanea macbrydei5
Sphalmium racemosum2
Stenocarpus davallioides4
Streblus glaber australianus1
Synima cordierorum19
Synima sp. Mt Carbine (L.W.Jessup+ GJM995)1
Synoum glandulosum paniculosum4
Syzygium cormiflorum1
Syzygium endophloium3
Syzygium johnsonii1
Syzygium luehmannii1
Syzygium wesa2
Xanthophyllum octandrum4