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=3868 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3868SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3691SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3868 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='scincoides' OR junior_species='scincoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='scincoides' OR species='scincoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='scincoides' OR species='scincoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='scincoides' OR junior_species='scincoides')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='Tiliqua' AND (species='scincoides' OR species='scincoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latagallina' AND (junior_species='naracoortensis' OR junior_species='naracoortensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Latagallina' AND (species='naracoortensis' OR species='naracoortensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Latagallina' AND (species='naracoortensis' OR species='naracoortensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latagallina' AND (junior_species='naracoortensis' OR junior_species='naracoortensis')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='Latagallina' AND (species='naracoortensis' OR species='naracoortensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='viverrinus' OR junior_species='viverrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyurus' AND (species='viverrinus' OR species='viverrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyurus' AND (species='viverrinus' OR species='viverrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='viverrinus' OR junior_species='viverrinus')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='viverrinus' OR species='viverrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='laniarius' OR junior_species='laniarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcophilus' AND (species='laniarius' OR species='laniarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcophilus' AND (species='laniarius' OR species='laniarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='laniarius' OR junior_species='laniarius')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='laniarius' OR species='laniarius') 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='Isoodon' 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='Isoodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Isoodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' 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='Isoodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')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='nasuta' OR species='nasuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolarctos' AND (junior_species='stirtoni' OR junior_species='stirtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascolarctos' AND (species='stirtoni' OR species='stirtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phascolarctos' AND (species='stirtoni' OR species='stirtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolarctos' AND (junior_species='stirtoni' OR junior_species='stirtonii')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='stirtoni' OR species='stirtonii') 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='Vombatus' AND (junior_species='ursinus' OR junior_species='ursinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vombatus' AND (species='ursinus' OR species='ursinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' AND (junior_species='ursinus' OR junior_species='ursinus')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='ursinus' OR species='ursinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolonus' AND (junior_species='gigas' OR junior_species='gigas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascolonus' AND (species='gigas' OR species='gigas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phascolonus' AND (species='gigas' OR species='gigas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolonus' AND (junior_species='gigas' OR junior_species='gigas')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='Phascolonus' AND (species='gigas' OR species='gigas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramsayia' AND (junior_species='magna' OR junior_species='magna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramsayia' AND (species='magna' OR species='magna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramsayia' AND (species='magna' OR species='magna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramsayia' AND (junior_species='magna' OR junior_species='magna')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='Ramsayia' AND (species='magna' OR species='magna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palorchestes' AND (junior_species='azael' OR junior_species='azael')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palorchestes' AND (species='azael' OR species='azael') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palorchestes' AND (species='azael' OR species='azael')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palorchestes' AND (junior_species='azael' OR junior_species='azael')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='Palorchestes' AND (species='azael' OR species='azael') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palorchestes' AND (junior_species='parvus' OR junior_species='parvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palorchestes' AND (species='parvus' OR species='parvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palorchestes' AND (species='parvus' OR species='parvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palorchestes' AND (junior_species='parvus' OR junior_species='parvus')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='Palorchestes' AND (species='parvus' OR species='parvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nototherium' AND (junior_species='inerme' OR junior_species='inerme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nototherium' AND (species='inerme' OR species='inerme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nototherium' AND (species='inerme' OR species='inerme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nototherium' AND (junior_species='inerme' OR junior_species='inerme')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='Nototherium' AND (species='inerme' OR species='inerme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potorous' AND (junior_species='tridactylus' OR junior_species='tridactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potorous' AND (species='tridactylus' OR species='tridactylus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potorous' AND (junior_species='tridactylus' OR junior_species='tridactylus')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='tridactylus' OR species='tridactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aepyprymnus' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aepyprymnus' AND (species='rufescens' OR species='rufescens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aepyprymnus' AND (junior_species='rufescens' OR junior_species='rufescens')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='Aepyprymnus' AND (species='rufescens' OR species='rufescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' 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='Bettongia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' 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='Bettongia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='oreas' OR junior_species='oreas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sthenurus' AND (species='oreas' OR species='oreas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sthenurus' AND (species='oreas' OR species='oreas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='oreas' OR junior_species='oreas')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='Sthenurus' AND (species='oreas' OR species='oreas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procoptodon' AND (junior_species='rapha' OR junior_species='rapha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procoptodon' AND (species='rapha' OR species='rapha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Procoptodon' AND (species='rapha' OR species='rapha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procoptodon' AND (junior_species='rapha' OR junior_species='rapha')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='rapha' OR species='rapha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='anak' OR junior_species='anak')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protemnodon' AND (species='anak' OR species='anak') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='anak' OR species='anak')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='anak' OR junior_species='anak')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='anak' OR species='anak') 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='Protemnodon' AND (junior_species='roechus' OR junior_species='roechus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protemnodon' AND (species='roechus' OR species='roechus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='roechus' OR species='roechus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='roechus' OR junior_species='roechus')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='roechus' OR species='roechus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylogale' 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='Thylogale' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylogale' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylogale' 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='Thylogale' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='giganteus' OR junior_species='giganteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='giganteus' OR species='giganteus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='giganteus' OR junior_species='giganteus')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='giganteus' OR species='giganteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='titan' OR junior_species='titan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='titan' OR species='titan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropus' AND (species='titan' OR species='titan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='titan' OR junior_species='titan')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='titan' OR species='titan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')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='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notamacropus' AND (species='dorsalis' OR species='dorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='dorsalis' OR junior_species='dorsalis')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='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='parryi' OR junior_species='parryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='parryi' OR species='parryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notamacropus' AND (species='parryi' OR species='parryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='parryi' OR junior_species='parryii')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='parryi' OR species='parryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodentia' 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='Rodentia' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rodentia' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodentia' 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='Rodentia' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3868 The Ecological Register: Cement Mills, Gore
Cement Mills, Gore
Basic information
Sample name: Cement Mills, Gore

Reference: A. Bartholomai. 1977. The fossil vertebrate fauna from Pleistocene deposits at Cement Mills, Gore, southeastern Queensland. Memoirs of the Queensland Museum 18(1):41-51 [ER 3691]
Geography
Country: Australia

State: Queensland


Coordinate: 28° 16' 48" S, 151° 28' 48" E
Coordinate basis: stated in text

Time interval: Late Pleistocene

Min Ma: 0.0536

Age basis: U/Th

Geography comments: "Cement Mills, Gore, is located approximately 70 km northeast of Texas", a town in the Goondiwindi Region of southern Queensland.
U/Th dating of two megafaunal teeth from the deposit "yielded almost identical ages of 53.6 ± 0.2 ka and 53.9 ± 0.3 ka" (Price et al. 2009).
These dates most likely represent minimum ages for the fossil accumulation, due to the nature of U/Th dating on fossil bone and teeth.

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: carnivore accumulation,cave,fissure fill

Habitat comments: "The cave and fissure deposits from Cement Mills occur in the Devonian–Carboniferous limestones of the Texas Beds that form part of the larger Wooloomin-Texas Block of the New England Fold Belt".
"Fossiliferous sediments are represented by cemented breccia fissure-fills and cemented cave floor sediments that are dominated by clays, silts and carbonate nodules".
"Only a single stratigraphic faunal-bearing unit has been recognised within the deposit".
"Faunal elements likely entered the caves and fissures via marsupial predators that used the caves as lairs, and wash and fill processes".

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

Sampling methods: quarry

Sample size: 291 specimens

Sampling comments: No specific excavation details are provided. The counts below are of the remains described by Bartholomai (1977), which seems to report all faunal material that has ever been collected from the site.

Metadata
Sample number: 3868

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-01-31 15:13:28

Modified: 2022-03-04 03:05:12

Abundance distribution
30 species
13 singletons
total count 291
extrapolated richness: 73.2
Fisher's α: 8.393
geometric series k: 0.8509
Hurlbert's PIE: 0.8059
Shannon's H: 2.1749
Good's u: 0.9555
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Tiliqua scincoides1
Latagallina naracoortensis1
"Progura naracoortensis"
Dasyurus cf. viverrinus1
Sarcophilus laniarius33
Thylacinus cynocephalus2
Isoodon sp.2
Perameles nasuta32992 g
Phascolarctos stirtoni1
Thylacoleo carnifex9
Vombatus ursinus529 kg
Phascolonus gigas2
Ramsayia magna2
"Phascolomis magnus"
Palorchestes azael1
Palorchestes cf. parvus1
Nototherium inerme1
also 2 Diprotodontidae indet.
Potorous cf. tridactylus3731 g
Aepyprymnus rufescens222.9 kg
Bettongia sp.1
Sthenurus oreas1
Procoptodon cf. rapha1
Protemnodon anak2
Protemnodon brehus1
Protemnodon roechus2
Thylogale sp.1
Macropus giganteus338 kg grazer
Macropus titan1
Notamacropus cf. agilis siva314 kg browser-grazer
"Macropus agilis siva"
Notamacropus dorsalis44
"Macropus dorsalis"
Notamacropus parryi108
"Macropus parryi"
Rodentia indet.4