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=3850 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3850SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3684SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3850 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='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='Dasyurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' 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='Dasyurus' 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='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='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='Aepyprymnus' 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='Aepyprymnus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aepyprymnus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aepyprymnus' 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='Aepyprymnus' 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='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='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='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='Pseudomys' 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='Pseudomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' 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='Pseudomys' AND (species='sp.' OR species='sp.') 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='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='Varanus' 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='Varanus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' 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='Varanus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclodomorphus' 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='Cyclodomorphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclodomorphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclodomorphus' 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='Cyclodomorphus' AND (species='sp.' OR species='sp.') 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='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='Kyarranus' 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='Kyarranus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kyarranus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kyarranus' 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='Kyarranus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neobatrachus' AND (junior_species='sudellae' OR junior_species='sudellae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neobatrachus' AND (species='sudellae' OR species='sudellae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neobatrachus' AND (species='sudellae' OR species='sudellae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neobatrachus' AND (junior_species='sudellae' OR junior_species='sudellae')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='Neobatrachus' AND (species='sudellae' OR species='sudellae') 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='Limnodynastes' AND (junior_species='dumerilii' OR junior_species='dumerili')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodynastes' AND (species='dumerilii' OR species='dumerili') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='dumerilii' OR species='dumerili')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='dumerilii' OR junior_species='dumerili')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='dumerilii' OR species='dumerili') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' 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='Limnodynastes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' 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='Limnodynastes' AND (species='sp.' OR species='sp.') 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='Saladelos' 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='Saladelos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saladelos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saladelos' 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='Saladelos' 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='Xanthomelon' AND (junior_species='pachystylum' OR junior_species='pachystylum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthomelon' AND (species='pachystylum' OR species='pachystylum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthomelon' AND (species='pachystylum' OR species='pachystylum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthomelon' AND (junior_species='pachystylum' OR junior_species='pachystylum')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='Xanthomelon' AND (species='pachystylum' OR species='pachystylum') 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='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='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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Velesunio' AND (junior_species='ambiguus' OR junior_species='ambiguus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Velesunio' AND (species='ambiguus' OR species='ambiguus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Velesunio' AND (species='ambiguus' OR species='ambiguus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Velesunio' AND (junior_species='ambiguus' OR junior_species='ambiguus')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='Velesunio' AND (species='ambiguus' OR species='ambiguus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corbicula' 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='Corbicula' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corbicula' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corbicula' 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='Corbicula' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plotiopsis' AND (junior_species='balonnensis' OR junior_species='balonnensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plotiopsis' AND (species='balonnensis' OR species='balonnensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plotiopsis' AND (species='balonnensis' OR species='balonnensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plotiopsis' AND (junior_species='balonnensis' OR junior_species='balonnensis')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='Plotiopsis' AND (species='balonnensis' OR species='balonnensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3850 The Ecological Register: QML1396 (Horizon D)
QML1396 (Horizon D)
Basic information
Sample name: QML1396 (Horizon D)

Reference: G. J. Price and I. H. Sobbe. 2005. Pleistocene palaeoecology and environmental change on the Darling Downs, Southeastern Queensland, Australia. Memoirs of the Queensland Museum 51(1):171-201 [ER 3684]
Geography
Country: Australia

State: Queensland


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

Time interval: Late Pleistocene

Section: 3684

Unit number: 2

Unit order: below to above

Ma: 0.083

Age basis: OSL

Geography comments: Site QML1396 is located in the Darling Downs, southeastern Queensland, which encompasses low rolling hills and plains west of the Great Dividing Range.
"QML1396 is exposed laterally over 70 metres in the southern bank of Kings Creek, in the southern Darling Downs".
There is an OSL date for Horizon D of 83000 ± 10000 BP (Price et al. 2011).

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Habitat comments: "Fluvial sediments of the region consist of clays, silts and sands that are generally derived from the erosion of Mesozoic sandstones and Miocene basalts of the Great Dividing Range".
"The modern Kings Creek catchment is fed by several mainly dry or intermittent watercourses, resulting in a relatively small geographic sampling area".
"As the Pleistocene catchment area was likely not markedly larger than present, it is unlikely that material from QML1396 was subjected to long distance fluvial transport".
"The entire deposit is characterised by a fining-upwards sequence ... with vertebrate fossil material generally restricted to Horizons B and D".
"Horizon D is represented by a series of coarse to fine quartz sand beds that are overlain by laterally discontinuous horizontal and sloping shelly lenses".

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

Sampling methods: screenwash

Sample size: 1607 specimens

Sampling comments: "A section was measured representing the entire depositional sequence exposed in the creek bank".
"Fossils were recovered by in situ collecting and sieving of sediment specifically to target smaller specimens".
"Sediments were washed using graded sieves of 10 mm to 1 mm".
"Approximately 700 kg of sediment was processed from Horizon D".

Metadata
Sample number: 3850

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-01-18 16:59:19

Modified: 2023-09-11 10:47:41

Abundance distribution
37 species
14 singletons
total count 1607
extrapolated richness: 73.6
Fisher's α: 6.757
geometric series k: 0.8254
Hurlbert's PIE: 0.5806
Shannon's H: 1.4568
Good's u: 0.9913
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 sp.1
Perameles bougainville1
Perameles nasuta1992 g
Aepyprymnus sp.1
Notamacropus agilis siva514 kg browser-grazer
"Macropus agilis siva"
Macropus titan1
Protemnodon anak2
Protemnodon brehus2
Pseudomys sp.4
Rattus sp.2
also 182 Muridae indet.
Elapidae indet.14
Varanus priscus4
"Megalania prisca"
Varanus sp.1
Cyclodomorphus sp.1
Tiliqua rugosa6
Sphenomorphus sp. 119
"Sphenomorphus group” sp. 1
Sphenomorphus sp. 26
"Sphenomorphus group” sp. 2
Tympanocryptis lineata15
Chelidae indet.4
Kyarranus sp.1
Neobatrachus sudellae2
"Neobatrachus sudelli"
Limnodynastes tasmaniensis8
Limnodynastes cf. dumerilii3
Limnodynastes sp.1
Teleostei indet.89
Saladelos sp.1
Strangesta sp.1
Xanthomelon pachystylum1
Austrosuccinea sp.1
Gyrocochlea sp. 135
Gyrocochlea sp. 25
Coencharopa sp.9
Gyraulus gilberti249
Velesunio ambiguus10
at least 10 specimens
Corbicula australis100
"Corbicula (Cobiculina) australis" - at least 100 specimens
Plotiopsis balonnensis1000
"Thiara (Plotiopsis) balonnensis" - at least 1000 specimens