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=4228 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4228SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3858SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4228 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='erectus' OR junior_species='erectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='erectus' OR species='erectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homo' AND (species='erectus' OR species='erectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='erectus' OR junior_species='erectus')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='Homo' AND (species='erectus' OR species='erectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')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='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' 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='Rhinolophus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinolophus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' 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='Rhinolophus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' 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='Ochotona' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' 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='Ochotona' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopoldamys' AND (junior_species='edwardsi' OR junior_species='edwardsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopoldamys' AND (species='edwardsi' OR species='edwardsii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopoldamys' AND (junior_species='edwardsi' OR junior_species='edwardsii')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='Leopoldamys' AND (species='edwardsi' OR species='edwardsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhizomys' AND (junior_species='sinensis' OR junior_species='sinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhizomys' AND (species='sinensis' OR species='sinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhizomys' AND (species='sinensis' OR species='sinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhizomys' AND (junior_species='sinensis' OR junior_species='sinensis')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='Rhizomys' AND (species='sinensis' OR species='sinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')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='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mosbachensis' OR junior_species='mosbachensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='mosbachensis' OR species='mosbachensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mosbachensis' OR junior_species='mosbachensis')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='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')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='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='sinensis' OR junior_species='sinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctereutes' AND (species='sinensis' OR species='sinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctereutes' AND (species='sinensis' OR species='sinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='sinensis' OR junior_species='sinensis')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='Nyctereutes' AND (species='sinensis' OR species='sinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')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='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuropoda' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ailuropoda' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuropoda' AND (junior_species='melanoleuca' OR junior_species='melanoleuca')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='Ailuropoda' AND (species='melanoleuca' OR species='melanoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctonyx' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctonyx' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctonyx' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctonyx' AND (junior_species='collaris' OR junior_species='collaris')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='Arctonyx' AND (species='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')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='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopuma' AND (junior_species='temminckii' OR junior_species='temmincki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopuma' AND (species='temminckii' OR species='temmincki') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopuma' AND (junior_species='temminckii' OR junior_species='temmincki')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='Catopuma' AND (species='temminckii' OR species='temmincki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neofelis' AND (junior_species='nebulosa' OR junior_species='nebulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neofelis' AND (species='nebulosa' OR species='nebulosa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neofelis' AND (junior_species='nebulosa' OR junior_species='nebulosa')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='Neofelis' AND (species='nebulosa' OR species='nebulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='tigris' OR junior_species='tigris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='tigris' OR species='tigris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='tigris' OR junior_species='tigris')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='Panthera' AND (species='tigris' OR species='tigris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')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='Panthera' AND (species='pardus' OR species='pardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homotherium' 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='Homotherium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homotherium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homotherium' 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='Homotherium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stegodon' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stegodon' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stegodon' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stegodon' AND (junior_species='orientalis' OR junior_species='orientalis')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='Stegodon' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicerorhinus' AND (junior_species='sumatrensis' OR junior_species='sumatrensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicerorhinus' AND (species='sumatrensis' OR species='sumatrensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicerorhinus' AND (species='sumatrensis' OR species='sumatrensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicerorhinus' AND (junior_species='sumatrensis' OR junior_species='sumatrensis')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='Dicerorhinus' AND (species='sumatrensis' OR species='sumatrensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='kirchbergensis' OR junior_species='kirchbergensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='kirchbergensis' OR species='kirchbergensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='kirchbergensis' OR species='kirchbergensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='kirchbergensis' OR junior_species='kirchbergensis')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='Stephanorhinus' AND (species='kirchbergensis' OR species='kirchbergensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirus' AND (junior_species='augustus' OR junior_species='augustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapirus' AND (species='augustus' OR species='augustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapirus' AND (species='augustus' OR species='augustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapirus' AND (junior_species='augustus' OR junior_species='augustus')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='Tapirus' AND (species='augustus' OR species='augustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='lydekkeri' OR junior_species='lydekkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='lydekkeri' OR species='lydekkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='lydekkeri' OR species='lydekkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='lydekkeri' OR junior_species='lydekkerii')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='Sus' AND (species='lydekkeri' OR species='lydekkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')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='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='reevesi' OR junior_species='reevesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='reevesi' OR species='reevesii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='reevesi' OR junior_species='reevesii')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='Muntiacus' AND (species='reevesi' OR species='reevesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='muntjak' OR junior_species='muntjak')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='muntjak' OR species='muntjak') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='muntjak' OR junior_species='muntjak')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='Muntiacus' AND (species='muntjak' OR species='muntjak') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='grayi' OR junior_species='grayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='grayi' OR species='grayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervus' AND (species='grayi' OR species='grayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='grayi' OR junior_species='grayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cervus' AND (species='grayi' OR species='grayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')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='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')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='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='gaurus' OR junior_species='gaurus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='gaurus' OR species='gaurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='gaurus' OR junior_species='gaurus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Bos' AND (species='gaurus' OR species='gaurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' 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='Bubalus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubalus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' 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='Bubalus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4228 The Ecological Register: Bailongdong
Bailongdong
Basic information
Sample name: Bailongdong

Sample aka: Bailong Cave

Reference: H. Tong, B. Zhang, X. Wu, and S. Qu. 2019. Mammalian fossils from the Middle Pleistocene human site of Bailongdong in Yunxi, Hubei. Acta Anthropologica Sinica 38(4):613-640 [ER 3858]
Geography
Country: China

State: Hubei


Coordinate: 32° 59' 40" N, 110° 31' 34" E
Time interval: Middle Pleistocene

Max Ma: 0.76

Min Ma: 0.509

Age basis: other

Geography comments: in Shenwuling, Anjia Township, Yunxi County
according to Kong et al. (2018) there is a 26Al/10Be date of 0.76 +/- 0.06, an ESR date of 0.509 +/- 0.016, and an age estimate based on magnetostratigraphy of 0.78 Ma, but the authors favour an estimate of 0.5 Ma based on biochronology

•
Environment
Lithology: claystone

Taphonomic context: cave

Archaeology: bone tools,stone tools

Habitat comments: two bone and and 60 stone tools are present
there is no discussion of accumulation agents or bone modification
according to Kong et al. (2018), the entire fossiliferous unit is claystone

Methods
Life forms: bats,carnivores,primates,rodents,ungulates,other small mammals

Sampling methods: quarry

Sample size: 106 specimens

Years: 1977, 1982, 2007, 2008, 2009

Sampling comments: the site was also excavated later, but most of the described fossils were obtained in 1977 and 1982
eight human teeth are mentioned but not described in detail: these are Homo erectus based on Kong et al. (2018)

Metadata
Sample number: 4228

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-04-15 08:21:54

Modified: 2023-04-14 22:45:56

Abundance distribution
33 species
9 singletons
total count 106
extrapolated richness: 65.3
Fisher's α: 16.431
geometric series k: 0.9371
Hurlbert's PIE: 0.9562
Shannon's H: 3.2883
Good's u: 0.9162
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Homo erectus8
Miniopterus schreibersii112.4 g insectivore
Rhinolophus sp.1
Ochotona sp.1
Leopoldamys edwardsi1321 g insectivore-frugivore
Rhizomys sinensis3
Hystrix brachyura subcristata5
"Hystrix subcristata"
Canis mosbachensis variabilis2
Cuon alpinus antiquus314 kg carnivore
"Cuon javanicus antiquus"
Nyctereutes sinensis1
Ursus thibetanus663 kg browser-frugivore
Ailuropoda melanoleuca baconi396 kg browser
"Ailuropoda baconi"
Arctonyx collaris rostratus6 invertivore
Pachycrocuta brevirostris sinensis8
"Pachycrocuta sinensis"
Catopuma temminckii310 kg carnivore
Neofelis nebulosa213 kg carnivore
Panthera tigris2168 kg carnivore
Panthera pardus133 kg carnivore
Homotherium sp.3
Stegodon orientalis3
Dicerorhinus sumatrensis3
Stephanorhinus kirchbergensis4
Tapirus augustus5
"Megatapirus augustus"
Sus lydekkeri7
Elaphodus cephalophus119 kg
Muntiacus cf. reevesi211 kg browser
Muntiacus muntjak219 kg browser
Cervus grayi2
Cervus unicolor4100 kg grazer-browser
"Rusa unicolor"
Pseudois nayaur633 kg grazer-browser
Capricornis sumatraensis kanjereus1
Bos (Bibos) gaurus grangeri5481 kg
Bubalus sp.1