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=213 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=213SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=84SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=213 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentapanax' AND (junior_species='angelicifolius' OR junior_species='angelicifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentapanax' AND (junior_species='angelicifolius' OR junior_species='angelicifolius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carica' AND (junior_species='quercifolia' OR junior_species='quercifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carica' AND (species='quercifolia' OR species='quercifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carica' AND (species='quercifolia' OR species='quercifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carica' AND (junior_species='quercifolia' OR junior_species='quercifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carica' AND (species='quercifolia' OR species='quercifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='triflora' OR junior_species='triflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='triflora' OR species='triflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='triflora' OR species='triflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='triflora' OR junior_species='triflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='triflora' OR species='triflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anadenanthera' AND (junior_species='colubrina' OR junior_species='colubrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anadenanthera' AND (species='colubrina' OR species='colubrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anadenanthera' AND (species='colubrina' OR species='colubrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anadenanthera' AND (junior_species='colubrina' OR junior_species='colubrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anadenanthera' AND (species='colubrina' OR species='colubrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='contortisiliquum' OR junior_species='contortisiliquum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='contortisiliquum' OR junior_species='contortisiliquum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapiptadenia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parapiptadenia' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parapiptadenia' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapiptadenia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parapiptadenia' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tipuana' AND (junior_species='tipu' OR junior_species='tipu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tipuana' AND (species='tipu' OR species='tipu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tipuana' AND (species='tipu' OR species='tipu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tipuana' AND (junior_species='tipu' OR junior_species='tipu')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tipuana' AND (species='tipu' OR species='tipu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylosma' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylosma' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylosma' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylosma' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xylosma' AND (species='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juglans' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Juglans' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Juglans' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juglans' AND (junior_species='australis' OR junior_species='australis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Juglans' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='porphyrium' OR junior_species='porphyrium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='porphyrium' OR species='porphyrium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='porphyrium' OR species='porphyrium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='porphyrium' OR junior_species='porphyrium')SELECT d.diet,d.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='porphyrium' OR species='porphyrium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='lilloi' OR junior_species='lilloii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cedrela' AND (species='lilloi' OR species='lilloii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cedrela' AND (species='lilloi' OR species='lilloii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='lilloi' OR junior_species='lilloii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cedrela' AND (species='lilloi' OR species='lilloii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morus' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morus' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morus' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morus' AND (junior_species='alba' OR junior_species='alba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morus' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='laetevirens' OR junior_species='laetevirens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrsine' AND (species='laetevirens' OR species='laetevirens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrsine' AND (species='laetevirens' OR species='laetevirens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='laetevirens' OR junior_species='laetevirens')SELECT d.diet,d.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='laetevirens' OR species='laetevirens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocalyx' AND (junior_species='salicifolius' OR junior_species='salicifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocalyx' AND (junior_species='salicifolius' OR junior_species='salicifolius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='uniflora' OR junior_species='uniflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='uniflora' OR species='uniflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='uniflora' OR species='uniflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='uniflora' OR junior_species='uniflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='uniflora' OR species='uniflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcianthes' AND (junior_species='pungens' OR junior_species='pungens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrcianthes' AND (species='pungens' OR species='pungens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrcianthes' AND (species='pungens' OR species='pungens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcianthes' AND (junior_species='pungens' OR junior_species='pungens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrcianthes' AND (species='pungens' OR species='pungens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisonia' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pisonia' AND (species='ambigua' OR species='ambigua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pisonia' AND (species='ambigua' OR species='ambigua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisonia' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pisonia' AND (species='ambigua' OR species='ambigua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='tucumanum' OR junior_species='tucumanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piper' AND (species='tucumanum' OR species='tucumanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piper' AND (species='tucumanum' OR species='tucumanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='tucumanum' OR junior_species='tucumanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piper' AND (species='tucumanum' OR species='tucumanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='apetala' OR junior_species='apetala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruprechtia' AND (species='apetala' OR species='apetala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruprechtia' AND (species='apetala' OR species='apetala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='apetala' OR junior_species='apetala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ruprechtia' AND (species='apetala' OR species='apetala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' 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='Ruprechtia' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruprechtia' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' 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='Ruprechtia' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Randia' AND (junior_species='spinosa' OR junior_species='spinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Randia' AND (species='spinosa' OR species='spinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Randia' AND (species='spinosa' OR species='spinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Randia' AND (junior_species='spinosa' OR junior_species='spinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Randia' AND (species='spinosa' OR species='spinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='aurantium' OR junior_species='aurantium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Citrus' AND (species='aurantium' OR species='aurantium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Citrus' AND (species='aurantium' OR species='aurantium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='aurantium' OR junior_species='aurantium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Citrus' AND (species='aurantium' OR species='aurantium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagara' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagara' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fagara' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='edulis' OR junior_species='edulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='edulis' OR species='edulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='edulis' OR junior_species='edulis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allophylus' AND (species='edulis' OR species='edulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='vernalis' OR junior_species='vernalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='vernalis' OR species='vernalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='vernalis' OR species='vernalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='vernalis' OR junior_species='vernalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupania' AND (species='vernalis' OR species='vernalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='marginatum' OR junior_species='marginatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='marginatum' OR species='marginatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='marginatum' OR species='marginatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='marginatum' OR junior_species='marginatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysophyllum' AND (species='marginatum' OR species='marginatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solanum' AND (junior_species='riparium' OR junior_species='riparium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solanum' AND (species='riparium' OR species='riparium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solanum' AND (species='riparium' OR species='riparium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solanum' AND (junior_species='riparium' OR junior_species='riparium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solanum' AND (species='riparium' OR species='riparium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vassobia' AND (junior_species='breviflora' OR junior_species='breviflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vassobia' AND (species='breviflora' OR species='breviflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vassobia' AND (species='breviflora' OR species='breviflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vassobia' AND (junior_species='breviflora' OR junior_species='breviflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vassobia' AND (species='breviflora' OR species='breviflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocarpus' AND (junior_species='popayanensis' OR junior_species='popayanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliocarpus' AND (species='popayanensis' OR species='popayanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliocarpus' AND (species='popayanensis' OR species='popayanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocarpus' AND (junior_species='popayanensis' OR junior_species='popayanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliocarpus' AND (species='popayanensis' OR species='popayanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boehmeria' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boehmeria' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boehmeria' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boehmeria' AND (junior_species='caudata' OR junior_species='caudata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Boehmeria' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='baccifera' OR junior_species='baccifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urera' AND (species='baccifera' OR species='baccifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urera' AND (species='baccifera' OR species='baccifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='baccifera' OR junior_species='baccifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urera' AND (species='baccifera' OR species='baccifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='caracasana' OR junior_species='caracasana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urera' AND (species='caracasana' OR species='caracasana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urera' AND (species='caracasana' OR species='caracasana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='caracasana' OR junior_species='caracasana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urera' AND (species='caracasana' OR species='caracasana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duranta' AND (junior_species='serratifolia' OR junior_species='serratifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Duranta' AND (species='serratifolia' OR species='serratifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duranta' AND (species='serratifolia' OR species='serratifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duranta' AND (junior_species='serratifolia' OR junior_species='serratifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Duranta' AND (species='serratifolia' OR species='serratifolia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=213 The Ecological Register: Parque Sierra de San Javier (6 ha plot)
Parque Sierra de San Javier (6 ha plot)
Basic information
Sample name: Parque Sierra de San Javier (6 ha plot)

Reference: A. Malizia and H. R. Grau. 2006. Liana-host tree associations in a subtropical montane forest of north-western Argentina. Journal of Tropical Ecology 22(3):331-339 [ER 84]
Geography
Country: Argentina

State: Tucuman


Coordinate: 27° 30' S, 65° 40' W
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 18.0

MAP: 1400.0

Habitat comments: "annual rainfall is 1300-1500 mm and is distributed in a monsoonal regime... Frosts occur between June and August"

Methods
Life forms: trees

Sites: 1

Site area: 6

Site length: 200

Site width: 300

Sampling methods: quadrat

Sample size: 2315 individuals

Years: 1992

Size min: 10

Metadata
Sample number: 213

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-22 11:02:27

Modified: 2017-11-23 01:22:14

Abundance distribution
33 species
5 singletons
total count 2315
extrapolated richness: 43.3
Fisher's α: 5.451
geometric series k: 0.8264
Hurlbert's PIE: 0.9095
Shannon's H: 2.6850
Good's u: 0.9978
Each square represents a species. Square sizes are proportional to counts.
Register