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=3955 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3955SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3722SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3955 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalibgwilia' AND (junior_species='ramsayi' OR junior_species='ramsayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalibgwilia' AND (species='ramsayi' OR species='ramsayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalibgwilia' AND (species='ramsayi' OR species='ramsayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalibgwilia' AND (junior_species='ramsayi' OR junior_species='ramsayii')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='Megalibgwilia' AND (species='ramsayi' OR species='ramsayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyglossus' AND (junior_species='aculeatus' OR junior_species='aculeatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyglossus' AND (species='aculeatus' OR species='aculeatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyglossus' AND (junior_species='aculeatus' OR junior_species='aculeatus')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='Tachyglossus' AND (species='aculeatus' OR species='aculeatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murrayglossus' AND (junior_species='hacketti' OR junior_species='hackettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Murrayglossus' AND (species='hacketti' OR species='hackettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Murrayglossus' AND (species='hacketti' OR species='hackettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Murrayglossus' AND (junior_species='hacketti' OR junior_species='hackettii')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='Murrayglossus' AND (species='hacketti' OR species='hackettii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thylacinus' AND (species='cynocephalus' OR species='cynocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylacinus' AND (species='cynocephalus' OR species='cynocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')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='Thylacinus' AND (species='cynocephalus' OR species='cynocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='geoffroii' OR junior_species='geoffroi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyurus' AND (species='geoffroii' OR species='geoffroi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyurus' AND (species='geoffroii' OR species='geoffroi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='geoffroii' OR junior_species='geoffroi')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='Dasyurus' AND (species='geoffroii' OR species='geoffroi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='harrisii' OR junior_species='harrisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcophilus' AND (species='harrisii' OR species='harrisi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='harrisii' OR junior_species='harrisi')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='Sarcophilus' AND (species='harrisii' OR species='harrisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antechinus' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antechinus' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='flavipes' OR junior_species='flavipes')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='Antechinus' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascogale' AND (junior_species='tapoatafa' OR junior_species='tapoatafa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascogale' AND (species='tapoatafa' OR species='tapoatafa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phascogale' AND (species='tapoatafa' OR species='tapoatafa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascogale' AND (junior_species='tapoatafa' OR junior_species='tapoatafa')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='Phascogale' AND (species='tapoatafa' OR species='tapoatafa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' 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='Sminthopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' 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='Sminthopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='obesulus' OR junior_species='obesulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isoodon' AND (species='obesulus' OR species='obesulus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='obesulus' OR junior_species='obesulus')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='Isoodon' AND (species='obesulus' OR species='obesulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='bougainville' OR junior_species='bougainville')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='bougainville' OR species='bougainville') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perameles' AND (species='bougainville' OR species='bougainville')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='bougainville' OR junior_species='bougainville')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='Perameles' AND (species='bougainville' OR species='bougainville') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' AND (junior_species='hacketti' OR junior_species='hackettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vombatus' AND (species='hacketti' OR species='hackettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vombatus' AND (species='hacketti' OR species='hackettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' AND (junior_species='hacketti' OR junior_species='hackettii')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='Vombatus' AND (species='hacketti' OR species='hackettii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolarctos' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascolarctos' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolarctos' AND (junior_species='cinereus' OR junior_species='cinereus')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='Phascolarctos' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygomaturus' AND (junior_species='trilobus' OR junior_species='trilobus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygomaturus' AND (species='trilobus' OR species='trilobus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygomaturus' AND (species='trilobus' OR species='trilobus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygomaturus' AND (junior_species='trilobus' OR junior_species='trilobus')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='Zygomaturus' AND (species='trilobus' OR species='trilobus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacoleo' AND (junior_species='carnifex' OR junior_species='carnifex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thylacoleo' AND (species='carnifex' OR species='carnifex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylacoleo' AND (species='carnifex' OR species='carnifex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacoleo' AND (junior_species='carnifex' OR junior_species='carnifex')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='Thylacoleo' AND (species='carnifex' OR species='carnifex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercartetus' AND (junior_species='concinnus' OR junior_species='concinnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercartetus' AND (species='concinnus' OR species='concinnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercartetus' AND (species='concinnus' OR species='concinnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercartetus' AND (junior_species='concinnus' OR junior_species='concinnus')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='Cercartetus' AND (species='concinnus' OR species='concinnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocheirus' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocheirus' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocheirus' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocheirus' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Pseudocheirus' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichosurus' AND (junior_species='vulpecula' OR junior_species='vulpecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichosurus' AND (species='vulpecula' OR species='vulpecula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichosurus' AND (junior_species='vulpecula' OR junior_species='vulpecula')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='Trichosurus' AND (species='vulpecula' OR species='vulpecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='penicillata' OR junior_species='penicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bettongia' AND (species='penicillata' OR species='penicillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='penicillata' OR species='penicillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='penicillata' OR junior_species='penicillata')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='Bettongia' AND (species='penicillata' OR species='penicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potorous' AND (junior_species='gilbertii' OR junior_species='gilberti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potorous' AND (species='gilbertii' OR species='gilberti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potorous' AND (species='gilbertii' OR species='gilberti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potorous' AND (junior_species='gilbertii' OR junior_species='gilberti')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='Potorous' AND (species='gilbertii' OR species='gilberti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congruus' AND (junior_species='kitcheneri' OR junior_species='kitchenerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Congruus' AND (species='kitcheneri' OR species='kitchenerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Congruus' AND (species='kitcheneri' OR species='kitchenerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congruus' AND (junior_species='kitcheneri' OR junior_species='kitchenerii')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='Congruus' AND (species='kitcheneri' OR species='kitchenerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')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='Macropus' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' 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='Macropus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' 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='Macropus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='eugenii' OR junior_species='eugeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='eugenii' OR species='eugeni') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='eugenii' OR junior_species='eugeni')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='Notamacropus' AND (species='eugenii' OR species='eugeni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='irma' OR junior_species='irma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='irma' OR species='irma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notamacropus' AND (species='irma' OR species='irma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='irma' OR junior_species='irma')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='Notamacropus' AND (species='irma' OR species='irma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='brehus' OR junior_species='brehus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protemnodon' AND (species='brehus' OR species='brehus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='brehus' OR species='brehus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='brehus' OR junior_species='brehus')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='Protemnodon' AND (species='brehus' OR species='brehus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setonix' AND (junior_species='brachyurus' OR junior_species='brachyurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setonix' AND (species='brachyurus' OR species='brachyurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setonix' AND (junior_species='brachyurus' OR junior_species='brachyurus')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='Setonix' AND (species='brachyurus' OR species='brachyurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procoptodon' AND (junior_species='browneorum' OR junior_species='browneorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procoptodon' AND (species='browneorum' OR species='browneorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Procoptodon' AND (species='browneorum' OR species='browneorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procoptodon' AND (junior_species='browneorum' OR junior_species='browneorum')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='Procoptodon' AND (species='browneorum' OR species='browneorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simosthenurus' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simosthenurus' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simosthenurus' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simosthenurus' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Simosthenurus' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroptera' 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='Chiroptera' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiroptera' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroptera' 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='Chiroptera' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydromys' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydromys' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydromys' AND (species='chrysogaster' OR species='chrysogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydromys' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')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='Hydromys' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='albocinereus' OR junior_species='albocinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='albocinereus' OR species='albocinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='albocinereus' OR species='albocinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='albocinereus' OR junior_species='albocinereus')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='Pseudomys' AND (species='albocinereus' OR species='albocinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='shortridgei' OR junior_species='shortridgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='shortridgei' OR species='shortridgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='shortridgei' OR species='shortridgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='shortridgei' OR junior_species='shortridgeii')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='Pseudomys' AND (species='shortridgei' OR species='shortridgeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='fuscipes' OR species='fuscipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='fuscipes' OR species='fuscipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='fuscipes' OR junior_species='fuscipes')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='Rattus' AND (species='fuscipes' OR species='fuscipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacertilia' 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='Lacertilia' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacertilia' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacertilia' 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='Lacertilia' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anura' 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='Anura' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anura' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anura' 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='Anura' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3955 The Ecological Register: Mammoth Cave
Mammoth Cave
Basic information
Sample name: Mammoth Cave

Reference: K. A. Forde, A. Baynes, and J. Dortch. 2016. Taphonomic analysis of the fossil mammals from Mammoth Cave: pitfall, carnivore lair or cultural site? [Unpublished manuscript]. [ER 3722]
Geography
Country: Australia

State: Western Australia


Coordinate: 34° 3' 29" S, 115° 1' 50" E
Coordinate basis: stated in text

Time interval: Late Pleistocene

Max Ma: 0.074

Min Ma: 0.0444

Age basis: OSL

Geography comments: "Mammoth Cave is one of some 300 karst features in dune limestone in the extreme southwest of Western Australia between Capes Leeuwin and Naturaliste".
"The ages of the Mammoth Cave deposits remain uncertain. U/Th series dating of the uppermost overlying flowstone puts the assemblage at greater than 44.4 ± 1.3 ka old (Roberts et al. 2001). Optically stimulated luminescence ages were also determined by Roberts et al., with burial sediments attached to bones giving ages of 63 ± 9 ka and 74 ± 10 ka".

•
Environment
Lithology: sandstone

Taphonomic context: pitfall trap

Habitat comments: "Mammoth Cave is a huge tunnel formed by the action of a shallow stream flowing over the Precambrian granitic gneiss basement rocks and dissolving the limestone from below".
Two units were distinguished during the original excavation: a lower unit of fairly coarse reddish sand that contained bones, snail shells, wood fragments and leaf casts in pieces of speleothem, and occasional bands of black loam. A thin layer of flowstone separated it from the overlying upper unit of yellowish sand which contained bones ‘much fresher in appearance’, suggesting these were younger than those in the lower unit".
"The faunal assemblage most likely entered the cave via the now closed solution pipes in the cave roof. This is based on the broad skeletal element representation, high proportion of medium to large ground-dwelling mammals susceptible to pitfall entrapment, and the consistency with the fauna from the nearby Tight Entrance Cave pitfall site".

Methods
Life forms: bats,rodents,other large mammals,other small mammals,birds,lizards,frogs

Sampling methods: quarry

Sample size: 2461 specimens

Sampled by: Glauert

Years: 1909 - 1915

Sampling comments: "Two richly fossiliferous deposits were excavated during the years 1909–1915. These were later termed the 'Glauert' and 'Le Souef' deposits, with most specimens deriving from the latter".
"Unfortunately, fossils from the two deposits and the two units within the Glauert excavation were not kept separate, and the sources of bones within Mammoth Cave can no longer be identified".
"More than 3,200 specimens from these excavations were catalogued into the Western Australian Museum vertebrate palaeontological collection, mainly in the 1960s". These were used to calculate the Number of Identified Specimens, which are reported in Forde et al. 2016 (unpublished).

Metadata
Sample number: 3955

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-07-28 12:17:10

Modified: 2022-07-28 02:19:19

Abundance distribution
37 species
4 singletons
total count 2461
extrapolated richness: 48.7
Fisher's α: 6.177
geometric series k: 0.8232
Hurlbert's PIE: 0.7414
Shannon's H: 1.9639
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Megalibgwilia ramsayi15
Tachyglossus aculeatus62.9 kg insectivore
Murrayglossus hacketti20
Thylacinus cynocephalus6
Dasyurus geoffroii6
Sarcophilus harrisii67.5 kg
Antechinus flavipes5
Phascogale tapoatafa4
Sminthopsis sp.1
Isoodon obesulus261.0 kg
"Isoodon fusciventer"
Perameles bougainville28
Vombatus hacketti107
also 1 Vombatidae indet.
Phascolarctos cinereus229.1 kg
Zygomaturus trilobus527
Thylacoleo carnifex1
Cercartetus concinnus4
Pseudocheirus occidentalis17
Trichosurus vulpecula152.1 kg folivore
Bettongia penicillata3
Potorous gilbertii97
Congruus kitcheneri11
Macropus fuliginosus5140 kg grazer-browser
Macropus sp.2
"large"
Notamacropus eugenii233.5 kg
Notamacropus irma14
Protemnodon brehus2
Setonix brachyurus11002.7 kg
Procoptodon browneorum81
Simosthenurus occidentalis207
also 281 Sthenurinae indet.
Chiroptera indet.4
Hydromys chrysogaster1
Pseudomys albocinereus2
Pseudomys shortridgei2
Rattus fuscipes25
Aves indet.14
Lacertilia indet.5
Anura indet.1