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=2069 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2069SELECT 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=2069 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='acronychioides' OR junior_species='acronychioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronychia' AND (species='acronychioides' OR species='acronychioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronychia' AND (species='acronychioides' OR species='acronychioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronychia' AND (junior_species='acronychioides' OR junior_species='acronychioides')SELECT d.diet,d.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='acronychioides' OR species='acronychioides') 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='Aleurites' AND (junior_species='rockinghamensis' OR junior_species='rockinghamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleurites' AND (species='rockinghamensis' OR species='rockinghamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleurites' AND (species='rockinghamensis' OR species='rockinghamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleurites' AND (junior_species='rockinghamensis' OR junior_species='rockinghamensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aleurites' AND (species='rockinghamensis' OR species='rockinghamensis') 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='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='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='Cerbera' AND (junior_species='inflata' OR junior_species='inflata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerbera' AND (species='inflata' OR species='inflata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerbera' AND (species='inflata' OR species='inflata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerbera' AND (junior_species='inflata' OR junior_species='inflata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cerbera' AND (species='inflata' OR species='inflata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clausena' AND (junior_species='brevistyla' OR junior_species='brevistyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clausena' AND (species='brevistyla' OR species='brevistyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clausena' AND (species='brevistyla' OR species='brevistyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clausena' AND (junior_species='brevistyla' OR junior_species='brevistyla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clausena' AND (species='brevistyla' OR species='brevistyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistanthus' AND (junior_species='semiopacus' OR junior_species='semiopacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cleistanthus' AND (species='semiopacus' OR species='semiopacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cleistanthus' AND (species='semiopacus' OR species='semiopacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistanthus' AND (junior_species='semiopacus' OR junior_species='semiopacus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cleistanthus' AND (species='semiopacus' OR species='semiopacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='insularis' OR junior_species='insularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='insularis' OR species='insularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='insularis' OR species='insularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='insularis' OR junior_species='insularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Croton' AND (species='insularis' OR species='insularis') 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='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='Dinosperma' AND (junior_species='erythrococcum' OR junior_species='erythrococcum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinosperma' AND (species='erythrococcum' OR species='erythrococcum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinosperma' AND (species='erythrococcum' OR species='erythrococcum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosperma' AND (junior_species='erythrococcum' OR junior_species='erythrococcum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dinosperma' AND (species='erythrococcum' OR species='erythrococcum') 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='Elaeodendron' AND (junior_species='melanocarpum' OR junior_species='melanocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeodendron' AND (species='melanocarpum' OR species='melanocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeodendron' AND (species='melanocarpum' OR species='melanocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeodendron' AND (junior_species='melanocarpum' OR junior_species='melanocarpum')SELECT d.diet,d.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='melanocarpum' OR species='melanocarpum') 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='Flindersia' AND (junior_species='schottiana' OR junior_species='schottiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Flindersia' AND (species='schottiana' OR species='schottiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flindersia' AND (species='schottiana' OR species='schottiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flindersia' AND (junior_species='schottiana' OR junior_species='schottiana')SELECT d.diet,d.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='schottiana' OR species='schottiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='sessiliflorum' OR junior_species='sessiliflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glochidion' AND (species='sessiliflorum' OR species='sessiliflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glochidion' AND (species='sessiliflorum' OR species='sessiliflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glochidion' AND (junior_species='sessiliflorum' OR junior_species='sessiliflorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glochidion' AND (species='sessiliflorum' OR species='sessiliflorum') 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='Helicia' AND (junior_species='australasica' OR junior_species='australasica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicia' AND (species='australasica' OR species='australasica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicia' AND (species='australasica' OR species='australasica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='australasica' OR junior_species='australasica')SELECT d.diet,d.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='australasica' OR species='australasica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalium' AND (junior_species='circumpinnatum' OR junior_species='circumpinnatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalium' AND (species='circumpinnatum' OR species='circumpinnatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalium' AND (species='circumpinnatum' OR species='circumpinnatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalium' AND (junior_species='circumpinnatum' OR junior_species='circumpinnatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Homalium' AND (species='circumpinnatum' OR species='circumpinnatum') 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='Mischocarpus' AND (junior_species='pyriformis' OR junior_species='pyriformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mischocarpus' AND (species='pyriformis' OR species='pyriformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mischocarpus' AND (species='pyriformis' OR species='pyriformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='pyriformis' OR junior_species='pyriformis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mischocarpus' AND (species='pyriformis' OR species='pyriformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='stipitatus' OR junior_species='stipitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mischocarpus' AND (species='stipitatus' OR species='stipitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mischocarpus' AND (species='stipitatus' OR species='stipitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='stipitatus' OR junior_species='stipitatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mischocarpus' AND (species='stipitatus' OR species='stipitatus') 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='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='Pouteria' AND (junior_species='xerocarpa' OR junior_species='xerocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='xerocarpa' OR species='xerocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='xerocarpa' OR species='xerocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='xerocarpa' OR junior_species='xerocarpa')SELECT d.diet,d.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='xerocarpa' OR species='xerocarpa') 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='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='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 * FROM register WHERE sample_no=2069 The Ecological Register: Downfall Creek
Downfall Creek
Basic information
Sample name: Downfall Creek

Sample aka: EP2

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: -17.14616° S, 145.586884° E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 20.7

MAP: 1403.0

Methods
Life forms: trees

Sites: 1

Site area: 0.513

Sample size: 462 individuals

Years: 1971

Size min: 10

Basal area: 14.3025

Metadata
Sample number: 2069

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-14 13:23:48

Modified: 2016-06-14 03:23:48

Abundance distribution
35 species
7 singletons
total count 462
extrapolated richness: 54.4
Fisher's α: 8.793
geometric series k: 0.8781
Hurlbert's PIE: 0.9186
Shannon's H: 2.8704
Good's u: 0.9849
Each square represents a species. Square sizes are proportional to counts.
Register