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=2084 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2084SELECT 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=2084 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acacia' AND (junior_species='celsa' OR junior_species='celsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acacia' AND (species='celsa' OR species='celsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acacia' AND (species='celsa' OR species='celsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acacia' AND (junior_species='celsa' OR junior_species='celsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acacia' AND (species='celsa' OR species='celsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronychia' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronychia' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronychia' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronychia' AND (junior_species='laevis' OR junior_species='laevis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acronychia' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agathis' AND (junior_species='robusta' OR junior_species='robusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agathis' AND (species='robusta' OR species='robusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agathis' AND (species='robusta' OR species='robusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agathis' AND (junior_species='robusta' OR junior_species='robusta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agathis' AND (species='robusta' OR species='robusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='muelleriana' OR junior_species='muelleriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='muelleriana' OR species='muelleriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='muelleriana' OR species='muelleriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='muelleriana' OR junior_species='muelleriana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alstonia' AND (species='muelleriana' OR species='muelleriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='bunius' OR junior_species='bunius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='bunius' OR species='bunius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='bunius' OR species='bunius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='bunius' OR junior_species='bunius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antidesma' AND (species='bunius' OR species='bunius') ORDER BY year,last_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='Argyrodendron' AND (junior_species='polyandrum' OR junior_species='polyandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyrodendron' AND (species='polyandrum' OR species='polyandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyrodendron' AND (species='polyandrum' OR species='polyandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodendron' AND (junior_species='polyandrum' OR junior_species='polyandrum')SELECT d.diet,d.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='polyandrum' OR species='polyandrum') 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='Backhousia' AND (junior_species='hughesii' OR junior_species='hughesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Backhousia' AND (species='hughesii' OR species='hughesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Backhousia' AND (species='hughesii' OR species='hughesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Backhousia' AND (junior_species='hughesii' OR junior_species='hughesi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Backhousia' AND (species='hughesii' OR species='hughesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocarya' AND (junior_species='involucrigera' OR junior_species='involucrigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blepharocarya' AND (species='involucrigera' OR species='involucrigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blepharocarya' AND (species='involucrigera' OR species='involucrigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocarya' AND (junior_species='involucrigera' OR junior_species='involucrigera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blepharocarya' AND (species='involucrigera' OR species='involucrigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachychiton' AND (junior_species='acerifolius' OR junior_species='acerifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachychiton' AND (species='acerifolius' OR species='acerifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachychiton' AND (species='acerifolius' OR species='acerifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachychiton' AND (junior_species='acerifolius' OR junior_species='acerifolius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brachychiton' AND (species='acerifolius' OR species='acerifolius') 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='Celtis' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celtis' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='hypospodia' OR junior_species='hypospodia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='hypospodia' OR species='hypospodia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='hypospodia' OR species='hypospodia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='hypospodia' OR junior_species='hypospodia')SELECT d.diet,d.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='hypospodia' OR species='hypospodia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupaniopsis' AND (junior_species='foveolata' OR junior_species='foveolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupaniopsis' AND (species='foveolata' OR species='foveolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupaniopsis' AND (species='foveolata' OR species='foveolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupaniopsis' AND (junior_species='foveolata' OR junior_species='foveolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupaniopsis' AND (species='foveolata' OR species='foveolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophyllum' AND (junior_species='coprosmoides' OR junior_species='coprosmoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophyllum' AND (species='coprosmoides' OR species='coprosmoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophyllum' AND (species='coprosmoides' OR species='coprosmoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophyllum' AND (junior_species='coprosmoides' OR junior_species='coprosmoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophyllum' AND (species='coprosmoides' OR species='coprosmoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decaspermum' AND (junior_species='humile' OR junior_species='humile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Decaspermum' AND (species='humile' OR species='humile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Decaspermum' AND (species='humile' OR species='humile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decaspermum' AND (junior_species='humile' OR junior_species='humile')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Decaspermum' AND (species='humile' OR species='humile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denhamia' AND (junior_species='celastroides' OR junior_species='celastroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Denhamia' AND (species='celastroides' OR species='celastroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Denhamia' AND (species='celastroides' OR species='celastroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denhamia' AND (junior_species='celastroides' OR junior_species='celastroides')SELECT d.diet,d.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='celastroides' OR species='celastroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pentamera' OR junior_species='pentamera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='pentamera' OR species='pentamera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='pentamera' OR species='pentamera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='pentamera' OR junior_species='pentamera')SELECT d.diet,d.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='pentamera' OR species='pentamera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='coorangooloo' OR junior_species='coorangooloo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='coorangooloo' OR species='coorangooloo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='coorangooloo' OR species='coorangooloo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='coorangooloo' OR junior_species='coorangooloo')SELECT d.diet,d.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='coorangooloo' OR species='coorangooloo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeodendron' AND (junior_species='australe' OR junior_species='australe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeodendron' AND (species='australe' OR species='australe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeodendron' AND (species='australe' OR species='australe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeodendron' AND (junior_species='australe' OR junior_species='australe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeodendron' AND (species='australe' OR species='australe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattostachys' AND (junior_species='megalantha' OR junior_species='megalantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattostachys' AND (species='megalantha' OR species='megalantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattostachys' AND (species='megalantha' OR species='megalantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattostachys' AND (junior_species='megalantha' OR junior_species='megalantha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elattostachys' AND (species='megalantha' OR species='megalantha') 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='Euroschinus' AND (junior_species='falcatus' OR junior_species='falcatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euroschinus' AND (species='falcatus' OR species='falcatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euroschinus' AND (species='falcatus' OR species='falcatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euroschinus' AND (junior_species='falcatus' OR junior_species='falcatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euroschinus' AND (species='falcatus' OR species='falcatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='watkinsiana' OR junior_species='watkinsiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='watkinsiana' OR species='watkinsiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='watkinsiana' OR species='watkinsiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='watkinsiana' OR junior_species='watkinsiana')SELECT d.diet,d.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='watkinsiana' OR species='watkinsiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='ifflana' OR junior_species='ifflana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='ifflana' OR species='ifflana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='ifflana' OR species='ifflana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='ifflana' OR junior_species='ifflana')SELECT d.diet,d.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='ifflana' OR species='ifflana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='bidwillii' OR junior_species='bidwilli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gossia' AND (species='bidwillii' OR species='bidwilli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gossia' AND (species='bidwillii' OR species='bidwilli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='bidwillii' OR junior_species='bidwilli')SELECT d.diet,d.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='bidwillii' OR species='bidwilli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='hillii' OR junior_species='hilli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gossia' AND (species='hillii' OR species='hilli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gossia' AND (species='hillii' OR species='hilli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gossia' AND (junior_species='hillii' OR junior_species='hilli')SELECT d.diet,d.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='hillii' OR species='hilli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='fawcettiana' OR junior_species='fawcettiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='fawcettiana' OR species='fawcettiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='fawcettiana' OR species='fawcettiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='fawcettiana' OR junior_species='fawcettiana')SELECT d.diet,d.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='fawcettiana' OR species='fawcettiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='philippensis' OR species='philippensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='philippensis' OR species='philippensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mallotus' AND (species='philippensis' OR species='philippensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='polyadenos' OR junior_species='polyadenos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallotus' AND (species='polyadenos' OR species='polyadenos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallotus' AND (species='polyadenos' OR species='polyadenos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallotus' AND (junior_species='polyadenos' OR junior_species='polyadenos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mallotus' AND (species='polyadenos' OR species='polyadenos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='disperma' OR junior_species='disperma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maytenus' AND (species='disperma' OR species='disperma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maytenus' AND (species='disperma' OR species='disperma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' AND (junior_species='disperma' OR junior_species='disperma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maytenus' AND (species='disperma' OR species='disperma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrsine' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrsine' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT d.diet,d.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='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olea' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olea' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Olea' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='grayae' OR junior_species='grayae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podocarpus' AND (species='grayae' OR species='grayae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podocarpus' AND (species='grayae' OR species='grayae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='grayae' OR junior_species='grayae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Podocarpus' AND (species='grayae' OR species='grayae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='nitidissima' OR junior_species='nitidissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyalthia' AND (species='nitidissima' OR species='nitidissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyalthia' AND (species='nitidissima' OR species='nitidissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='nitidissima' OR junior_species='nitidissima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyalthia' AND (species='nitidissima' OR species='nitidissima') 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='myrsinifolia' OR junior_species='myrsinifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='myrsinifolia' OR species='myrsinifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='myrsinifolia' OR species='myrsinifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='myrsinifolia' OR junior_species='myrsinifolia')SELECT d.diet,d.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='myrsinifolia' OR species='myrsinifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoweinmannia' AND (junior_species='lachnocarpa' OR junior_species='lachnocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoweinmannia' AND (species='lachnocarpa' OR species='lachnocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoweinmannia' AND (species='lachnocarpa' OR species='lachnocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoweinmannia' AND (junior_species='lachnocarpa' OR junior_species='lachnocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoweinmannia' AND (species='lachnocarpa' OR species='lachnocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psydrax' AND (junior_species='lamprophylla' OR junior_species='lamprophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psydrax' AND (species='lamprophylla' OR species='lamprophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psydrax' AND (species='lamprophylla' OR species='lamprophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psydrax' AND (junior_species='lamprophylla' OR junior_species='lamprophylla')SELECT d.diet,d.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='lamprophylla' OR species='lamprophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodamnia' AND (junior_species='costata' OR junior_species='costata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodamnia' AND (species='costata' OR species='costata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodamnia' AND (species='costata' OR species='costata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodamnia' AND (junior_species='costata' OR junior_species='costata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhodamnia' AND (species='costata' OR species='costata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodamnia' AND (junior_species='spongiosa' OR junior_species='spongiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodamnia' AND (species='spongiosa' OR species='spongiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodamnia' AND (species='spongiosa' OR species='spongiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodamnia' AND (junior_species='spongiosa' OR junior_species='spongiosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhodamnia' AND (species='spongiosa' OR species='spongiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodomyrtus' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodomyrtus' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodomyrtus' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodomyrtus' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhodomyrtus' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcomelicope' AND (junior_species='simplicifolia' OR junior_species='simplicifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcomelicope' AND (species='simplicifolia' OR species='simplicifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcomelicope' AND (species='simplicifolia' OR species='simplicifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcomelicope' AND (junior_species='simplicifolia' OR junior_species='simplicifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sarcomelicope' AND (species='simplicifolia' OR species='simplicifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scolopia' AND (junior_species='braunii' OR junior_species='brauni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scolopia' AND (species='braunii' OR species='brauni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scolopia' AND (species='braunii' OR species='brauni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scolopia' AND (junior_species='braunii' OR junior_species='brauni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scolopia' AND (species='braunii' OR species='brauni') 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='Steganthera' 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='Steganthera' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steganthera' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steganthera' 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='Steganthera' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2084 The Ecological Register: Agapetes SA
Agapetes SA
Basic information
Sample name: Agapetes SA

Sample aka: EP40

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.28017° S, 145.10231° E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 20.7

MAP: 2097.0

Methods
Life forms: trees

Sites: 1

Site area: 0.524

Sampling methods: quadrat

Sample size: 496 individuals

Years: 1978

Size min: 10

Basal area: 27.7593

Metadata
Sample number: 2084

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-14 13:42:24

Modified: 2016-06-14 03:42:24

Abundance distribution
47 species
9 singletons
total count 496
extrapolated richness: 76.3
Fisher's α: 12.749
geometric series k: 0.9012
Hurlbert's PIE: 0.8995
Shannon's H: 2.9183
Good's u: 0.9819
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Acacia celsa5
Acronychia laevis7
Agathis robusta23
Alstonia muelleriana6
Antidesma bunius8
Archidendron grandiflorum2
Argyrodendron polyandrum55
Atractocarpus fitzalanii tenuipes16
Backhousia hughesii120
Blepharocarya involucrigera5
Brachychiton acerifolius4
Buckinghamia celsissima9
Celtis paniculata1
Cryptocarya hypospodia3
Cupaniopsis foveolata5
Cyclophyllum coprosmoides4
Decaspermum humile1
Denhamia celastroides8
Diospyros pentamera3
Elaeocarpus coorangooloo3
Elaeodendron australe Windsor Tableland (B.P.Hyland 5574)19
Elattostachys megalantha1
Endiandra acuminata1
Euroschinus falcatus falcatus2
Ficus watkinsiana2
Flindersia ifflana30
Gossia bidwillii5
Gossia hillii1
Litsea fawcettiana2
Mallotus philippensis7
Mallotus polyadenos62
Maytenus disperma2
Myrsine variabilis3
Olea paniculata7
Podocarpus grayae1
Polyalthia nitidissima21
Polyscias elegans3
Pouteria myrsinifolia1
Pseudoweinmannia lachnocarpa13
Psydrax lamprophylla f. latissima3
Rhodamnia costata1
Rhodamnia spongiosa2
Rhodomyrtus macrocarpa2
Sarcomelicope simplicifolia simplicifolia3
Scolopia braunii2
Syzygium cormiflorum11
Steganthera laxiflora1
"Tetrasynandra laxiflora"