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=3851 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3851SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3685SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3851 ORDER BY register_no ASCSELECT 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='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='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='Perameles' AND (junior_species='sobbei' OR junior_species='sobbeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='sobbei' OR species='sobbeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perameles' AND (species='sobbei' OR species='sobbeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='sobbei' OR junior_species='sobbeii')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='sobbei' OR species='sobbeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' 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='Vombatus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vombatus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' 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='Vombatus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' 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='Diprotodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diprotodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' 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='Diprotodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troposodon' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troposodon' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troposodon' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troposodon' AND (junior_species='minor' OR junior_species='minor')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='Troposodon' AND (species='minor' OR species='minor') 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='Macropus' AND (junior_species='pearsoni' OR junior_species='pearsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='pearsoni' OR species='pearsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropus' AND (species='pearsoni' OR species='pearsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='pearsoni' OR junior_species='pearsonii')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='pearsoni' OR species='pearsonii') 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='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='Pseudomys' 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='Pseudomys' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' 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='Pseudomys' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' 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='Rattus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' 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='Rattus' AND (species='sp.' OR species='sp.') 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='Dromaius' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromaius' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')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='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tribonyx' AND (junior_species='mortierii' OR junior_species='mortieri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tribonyx' AND (species='mortierii' OR species='mortieri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tribonyx' AND (species='mortierii' OR species='mortieri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tribonyx' AND (junior_species='mortierii' OR junior_species='mortieri')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='Tribonyx' AND (species='mortierii' OR species='mortieri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocodylidae' 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='Crocodylidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocodylidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocodylidae' 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='Crocodylidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elapidae' 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='Elapidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elapidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elapidae' 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='Elapidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='priscus' OR junior_species='priscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='priscus' OR species='priscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='priscus' OR species='priscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='priscus' OR junior_species='priscus')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='Varanus' AND (species='priscus' OR species='priscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='rugosa' OR species='rugosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='rugosa' OR species='rugosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')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='rugosa' OR species='rugosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Intellagama' AND (junior_species='lesueurii' OR junior_species='lesueuri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Intellagama' AND (species='lesueurii' OR species='lesueuri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Intellagama' AND (species='lesueurii' OR species='lesueuri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Intellagama' AND (junior_species='lesueurii' OR junior_species='lesueuri')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='Intellagama' AND (species='lesueurii' OR species='lesueuri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tympanocryptis' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tympanocryptis' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tympanocryptis' AND (junior_species='lineata' OR junior_species='lineata')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='Tympanocryptis' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelidae' 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='Chelidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chelidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelidae' 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='Chelidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')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='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teleostei' 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='Teleostei' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Teleostei' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teleostei' 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='Teleostei' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrosuccinea' 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='Austrosuccinea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Austrosuccinea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrosuccinea' 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='Austrosuccinea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strangesta' 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='Strangesta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strangesta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strangesta' 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='Strangesta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyrocochlea' 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='Gyrocochlea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gyrocochlea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyrocochlea' 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='Gyrocochlea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coencharopa' 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='Coencharopa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coencharopa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coencharopa' 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='Coencharopa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyraulus' AND (junior_species='gilberti' OR junior_species='gilbertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gyraulus' AND (species='gilberti' OR species='gilbertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gyraulus' AND (species='gilberti' OR species='gilbertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyraulus' AND (junior_species='gilberti' OR junior_species='gilbertii')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='Gyraulus' AND (species='gilberti' OR species='gilbertii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3851 The Ecological Register: QML796 (Horizon A1)
QML796 (Horizon A1)
Basic information
Sample name: QML796 (Horizon A1)

Reference: G. J. Price and G. E. Webb. 2006. Late Pleistocene sedimentology, taphonomy and megafauna extinction on the Darling Downs, southeastern Queensland. Australian Journal of Earth Sciences 53(6):947-970 [ER 3685]
Geography
Country: Australia

State: Queensland


Coordinate: 27° 56' S, 151° 51' E
Coordinate basis: estimated from map

Time interval: Late Pleistocene

Section: 3685

Unit number: 1

Unit order: above to below

Max Ma: 0.055

Min Ma: 0.0548

Age basis: U/Th

Geography comments: "Site QML796 is located in the northern bank of Kings Creek, in the Darling Downs, southeastern Queensland, around 200 m downstream from site QML1396".
Two U/Th dates on fossilised teeth from Horizon A1 range from 55.0 ± 0.3 ka to 54.8 ± 0.6 ka (Price et al. 2011).
Earlier U/Th and C14 dates on bivalve shells are considered to be unreliable.

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Habitat comments: "The modern Kings Creek catchment is fed from the east by shallow, ephemeral watercourses".
The QML796 deposit contains both high-velocity lateral accretion (channel) and low-velocity vertical accretion (overbank) deposits with three highly fossiliferous horizons".
"The A1 horizon is the uppermost unit, and its geometry indicates crevasse channel and splay deposition on the floodplain adjacent to the channel belt".
"Taphonomic data suggest that most of the identifiable material was accumulated and transported into the deposit from the surrounding proximal floodplain, with the small size of the palaeocatchment precluding any long distance transport of the material".

Methods
Life forms: rodents,other large mammals,other small mammals,birds,lizards,snakes,turtles,other reptiles,frogs,fishes,snails

Sampling methods: quarry,screenwash

Sample size: 336 specimens

Sampling comments: "Fossils were recovered from an exposed vertical section by in situ collecting and removal of bulk sediment to target smaller specimens".
"A 3x2 m plot was surveyed on the ground above the site, and 1x1 m quadrats were excavated in 10 cm increments using trowels and brushes".
"The excavation continued to a depth of 2.3 metres, yielding a total of 24 cubic metres of sediment and material processed".
"Excavated sediment was washed using 10 and 1 mm graded sieves".
"Specimens of Velesunio ambiguus, Corbicula australis (bivalves) and Plotiopsis balonnensis (a freshwater gastropod) were extremely common in each main fossiliferous horizon (represented by several thousand individuals), and thus, their abundance data were not recorded".

Metadata
Sample number: 3851

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-01-19 16:35:58

Modified: 2023-04-29 04:56:08

Abundance distribution
33 species
10 singletons
total count 336
extrapolated richness: 60.1
Fisher's α: 9.069
geometric series k: 0.8671
Hurlbert's PIE: 0.8496
Shannon's H: 2.4540
Good's u: 0.9703
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sminthopsis sp.1
Dasyurus viverrinus4
also 7 Dasyurus sp. "possibly D. viverrinus"
Sarcophilus laniarius5
also 4 Dasyuridae indet.
Perameles nasuta3992 g
Perameles sobbei6
also 1 Perameles sp. and 11 Peramelidae indet.
Vombatus sp.1
also 1 Vombatidae indet.
Diprotodon sp.2
Troposodon minor3
Macropus titan4
Macropus pearsoni1
also 1 Macropus sp.
Protemnodon brehus1
Protemnodon anak3
also 2 Protemnodon sp. and 33 Macropodidae indet.
Pseudomys australis4
Rattus sp.7
"R. tunneyi or R. sordidus"
Hydromys chrysogaster1
also 478 Muridae indet.
Dromaius novaehollandiae132 kg insectivore-omnivore
Tribonyx mortierii1
"Gallinula mortierii" - also 6 Aves indet.
Crocodylidae indet.1
Elapidae indet.17
Varanus priscus58
"Megalania prisca"; also 3 Varanus sp.
Tiliqua rugosa7
Sphenomorphus sp. 15
"Sphenomorphus Group sp. 1"
Sphenomorphus sp. 26
"Sphenomorphus Group sp. 2"
Intellagama lesueurii3
"Physignathus leseurii"
Tympanocryptis lineata16
Chelidae indet.4
Limnodynastes tasmaniensis4
Teleostei indet.96
Austrosuccinea sp.1
Strangesta sp.1
Gyrocochlea sp.9
Coencharopa sp.2
Gyraulus gilberti58