SELECT * FROM samples WHERE sample_no=2082
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=2115
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=2082 ORDER BY register_no ASC
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronychia' AND (junior_species='acidula' OR junior_species='acidula')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronychia' AND (species='acidula' OR species='acidula') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Acronychia' AND (species='acidula' OR species='acidula')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronychia' AND (junior_species='acidula' OR junior_species='acidula')
SELECT d.diet,d.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='acidula' OR species='acidula') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='villosum' OR junior_species='villosum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alangium' AND (species='villosum' OR species='villosum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alangium' AND (species='villosum' OR species='villosum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='villosum' OR junior_species='villosum')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alangium' AND (species='villosum' OR species='villosum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alphitonia' AND (junior_species='petriei' OR junior_species='petrieii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alphitonia' AND (species='petriei' OR species='petrieii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alphitonia' AND (species='petriei' OR species='petrieii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alphitonia' AND (junior_species='petriei' OR junior_species='petrieii')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alphitonia' AND (species='petriei' OR species='petrieii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='scholaris' OR junior_species='scholaris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='scholaris' OR species='scholaris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='scholaris' OR species='scholaris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='scholaris' OR junior_species='scholaris')
SELECT d.diet,d.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='scholaris' OR species='scholaris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='erostre' OR junior_species='erostre')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='erostre' OR species='erostre') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='erostre' OR species='erostre')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='erostre' OR junior_species='erostre')
SELECT d.diet,d.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='erostre' OR species='erostre') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archontophoenix' AND (junior_species='cunninghamii' OR junior_species='cunninghami')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archontophoenix' AND (species='cunninghamii' OR species='cunninghami') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Archontophoenix' AND (species='cunninghamii' OR species='cunninghami')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archontophoenix' AND (junior_species='cunninghamii' OR junior_species='cunninghami')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archontophoenix' AND (species='cunninghamii' OR species='cunninghami') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodendron' AND (junior_species='actinophyllum' OR junior_species='actinophyllum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyrodendron' AND (species='actinophyllum' OR species='actinophyllum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Argyrodendron' AND (species='actinophyllum' OR species='actinophyllum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodendron' AND (junior_species='actinophyllum' OR junior_species='actinophyllum')
SELECT d.diet,d.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='actinophyllum' OR species='actinophyllum') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='oliveri' OR junior_species='oliverii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='oliveri' OR species='oliverii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='oliveri' OR species='oliverii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='oliveri' OR junior_species='oliverii')
SELECT d.diet,d.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='oliveri' OR species='oliverii') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT 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,year
SELECT *,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_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='photinophylla' OR junior_species='photinophylla')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocnide' AND (species='photinophylla' OR species='photinophylla') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Dendrocnide' AND (species='photinophylla' OR species='photinophylla')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='photinophylla' OR junior_species='photinophylla')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocnide' AND (species='photinophylla' OR species='photinophylla') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='cowleyana' OR junior_species='cowleyana')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='cowleyana' OR species='cowleyana') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='cowleyana' OR species='cowleyana')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='cowleyana' OR junior_species='cowleyana')
SELECT d.diet,d.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='cowleyana' OR species='cowleyana') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='muelleri' OR junior_species='muellerii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endiandra' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Endiandra' AND (species='muelleri' OR species='muellerii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endiandra' AND (junior_species='muelleri' OR junior_species='muellerii')
SELECT d.diet,d.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='muelleri' OR species='muellerii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='destruens' OR junior_species='destruens')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='destruens' OR species='destruens') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='destruens' OR species='destruens')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='destruens' OR junior_species='destruens')
SELECT d.diet,d.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='destruens' OR species='destruens') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='leptoclada' OR junior_species='leptoclada')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='leptoclada' OR species='leptoclada') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='leptoclada' OR species='leptoclada')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='leptoclada' OR junior_species='leptoclada')
SELECT d.diet,d.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='leptoclada' OR species='leptoclada') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tree' AND (species='indet.' OR species='indet.')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='leefeana' OR junior_species='leefeana')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='leefeana' OR species='leefeana') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='leefeana' OR species='leefeana')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='leefeana' OR junior_species='leefeana')
SELECT d.diet,d.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='leefeana' OR species='leefeana') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melicope' AND (junior_species='vitiflora' OR junior_species='vitiflora')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melicope' AND (species='vitiflora' OR species='vitiflora') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Melicope' AND (species='vitiflora' OR species='vitiflora')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melicope' AND (junior_species='vitiflora' OR junior_species='vitiflora')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melicope' AND (species='vitiflora' OR species='vitiflora') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='lachnocarpus' OR junior_species='lachnocarpus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mischocarpus' AND (species='lachnocarpus' OR species='lachnocarpus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mischocarpus' AND (species='lachnocarpus' OR species='lachnocarpus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='lachnocarpus' OR junior_species='lachnocarpus')
SELECT d.diet,d.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='lachnocarpus' OR species='lachnocarpus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='macrocarpus' OR junior_species='macrocarpus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mischocarpus' AND (species='macrocarpus' OR species='macrocarpus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mischocarpus' AND (species='macrocarpus' OR species='macrocarpus')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mischocarpus' AND (junior_species='macrocarpus' OR junior_species='macrocarpus')
SELECT d.diet,d.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='macrocarpus' OR species='macrocarpus') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niemeyera' AND (junior_species='prunifera' OR junior_species='prunifera')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niemeyera' AND (species='prunifera' OR species='prunifera') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Niemeyera' AND (species='prunifera' OR species='prunifera')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niemeyera' AND (junior_species='prunifera' OR junior_species='prunifera')
SELECT d.diet,d.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='prunifera' OR species='prunifera') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyosma' AND (junior_species='rhytophloia' OR junior_species='rhytophloia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyosma' AND (species='rhytophloia' OR species='rhytophloia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Polyosma' AND (species='rhytophloia' OR species='rhytophloia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyosma' AND (junior_species='rhytophloia' OR junior_species='rhytophloia')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyosma' AND (species='rhytophloia' OR species='rhytophloia') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cryptophlebium' OR junior_species='cryptophlebium')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cryptophlebium' OR species='cryptophlebium') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cryptophlebium' OR species='cryptophlebium')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cryptophlebium' OR junior_species='cryptophlebium')
SELECT d.diet,d.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='cryptophlebium' OR species='cryptophlebium') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapeinosperma' AND (junior_species='pseudojambosa' OR junior_species='pseudojambosa')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapeinosperma' AND (species='pseudojambosa' OR species='pseudojambosa') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Tapeinosperma' AND (species='pseudojambosa' OR species='pseudojambosa')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapeinosperma' AND (junior_species='pseudojambosa' OR junior_species='pseudojambosa')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tapeinosperma' AND (species='pseudojambosa' OR species='pseudojambosa') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toona' AND (junior_species='hexandra' OR junior_species='hexandra')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toona' AND (species='hexandra' OR species='hexandra') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Toona' AND (species='hexandra' OR species='hexandra')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toona' AND (junior_species='hexandra' OR junior_species='hexandra')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Toona' AND (species='hexandra' OR species='hexandra') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilkiea' AND (junior_species='macrophylla' OR junior_species='macrophylla')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wilkiea' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Wilkiea' AND (species='macrophylla' OR species='macrophylla')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilkiea' AND (junior_species='macrophylla' OR junior_species='macrophylla')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wilkiea' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=2082
SELECT genus FROM register WHERE register_no IN (79261,30620,2457,16033,110,54330,82042,29429,49540,2272) AND species REGEXP '^[a-z]*$'
The Ecological Register: Eungella
Eungella
Basic information
Sample name: Eungella

Sample aka: EP37

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

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAP: 2400.0

Methods
Life forms: trees

Sites: 1

Site area: 0.517

Sampling methods: quadrat

Sample size: 386 individuals

Years: 1977

Size min: 10

Basal area: 30.1085

Metadata
Sample number: 2082

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-14 13:38:43

Modified: 2016-06-14 03:38:43

Abundance distribution
33 species
10 singletons
total count 386
geometric series index: 58.3
Fisher's α: 8.634
geometric series k: 0.8629
Hurlbert's PIE: 0.8595
Shannon's H: 2.5360
Good's u: 0.9741
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Acmena resa16
Acronychia acidula5
Alangium villosum polyosmoides11
Alphitonia petriei4
Alstonia scholaris3
Antidesma erostre1
Archontophoenix cunninghamii112
Argyrodendron actinophyllum diversifolium13
Cinnamomum laubatii11
Cinnamomum oliveri1
Cryptocarya angulata74
Cryptocarya corrugata8
Cryptocarya grandis18
Dendrocnide photinophylla33
Endiandra cowleyana3
Endiandra muelleri bracteata2
Ficus destruens2
Ficus leptoclada1
Tree indet. Aq5204541
Gen.(Aq520454) sp. (Shute Harbour D.A.Halford Q811)
Litsea leefeana14
Melicope vitiflora1
Mischocarpus lachnocarpus1
Mischocarpus macrocarpus1
Niemeyera prunifera1
Polyosma rhytophloia5
Polyscias australiana1
Synoum glandulosum paniculosum3
Syzygium cryptophlebium7
Syzygium wesa12
Tapeinosperma pseudojambosa4
Steganthera laxiflora14
"Tetrasynandra laxiflora"
Toona hexandra1
"Toona ciliata"
Wilkiea macrophylla2