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=3995 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3995SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3747SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3995 ORDER BY register_no ASCSELECT 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='Lagorchestes' AND (junior_species='leporides' OR junior_species='leporides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagorchestes' AND (species='leporides' OR species='leporides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagorchestes' AND (species='leporides' OR species='leporides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagorchestes' AND (junior_species='leporides' OR junior_species='leporides')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='Lagorchestes' AND (species='leporides' OR species='leporides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' 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='Antechinus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antechinus' AND (species='agilis' OR species='agilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' 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='Antechinus' AND (species='agilis' OR species='agilis') 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='Dasyurus' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyurus' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyurus' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='maculatus' OR junior_species='maculatus')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='maculatus' OR species='maculatus') 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='Ningaui' AND (junior_species='yvonneae' OR junior_species='yvonneae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ningaui' AND (species='yvonneae' OR species='yvonneae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ningaui' AND (species='yvonneae' OR species='yvonneae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ningaui' AND (junior_species='yvonneae' OR junior_species='yvonneae')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='Ningaui' AND (species='yvonneae' OR species='yvonneae') 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='crassicaudata' OR junior_species='crassicaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sminthopsis' AND (species='crassicaudata' OR species='crassicaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='crassicaudata' OR species='crassicaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='crassicaudata' OR junior_species='crassicaudata')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='crassicaudata' OR species='crassicaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sminthopsis' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='murina' OR junior_species='murina')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='murina' OR species='murina') 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='Perameles' AND (junior_species='gunnii' OR junior_species='gunni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='gunnii' OR species='gunni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perameles' AND (species='gunnii' OR species='gunni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='gunnii' OR junior_species='gunni')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='gunnii' OR species='gunni') 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='lesueur' OR junior_species='lesueur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bettongia' AND (species='lesueur' OR species='lesueur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='lesueur' OR species='lesueur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='lesueur' OR junior_species='lesueur')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='lesueur' OR species='lesueur') 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='platyops' OR junior_species='platyops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potorous' AND (species='platyops' OR species='platyops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potorous' AND (species='platyops' OR species='platyops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potorous' AND (junior_species='platyops' OR junior_species='platyops')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='platyops' OR species='platyops') 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='Cercartetus' AND (junior_species='lepidus' OR junior_species='lepidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercartetus' AND (species='lepidus' OR species='lepidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercartetus' AND (species='lepidus' OR species='lepidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercartetus' AND (junior_species='lepidus' OR junior_species='lepidus')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='lepidus' OR species='lepidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercartetus' AND (junior_species='nanus' OR junior_species='nanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercartetus' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercartetus' AND (junior_species='nanus' OR junior_species='nanus')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='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocheirus' AND (junior_species='peregrinus' OR junior_species='peregrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocheirus' AND (species='peregrinus' OR species='peregrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocheirus' AND (species='peregrinus' OR species='peregrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocheirus' AND (junior_species='peregrinus' OR junior_species='peregrinus')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='peregrinus' OR species='peregrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='breviceps' OR junior_species='breviceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petaurus' AND (species='breviceps' OR species='breviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petaurus' AND (species='breviceps' OR species='breviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='breviceps' OR junior_species='breviceps')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='Petaurus' AND (species='breviceps' OR species='breviceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='norfolcensis' OR junior_species='norfolcensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petaurus' AND (species='norfolcensis' OR species='norfolcensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petaurus' AND (species='norfolcensis' OR species='norfolcensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='norfolcensis' OR junior_species='norfolcensis')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='Petaurus' AND (species='norfolcensis' OR species='norfolcensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrobates' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrobates' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrobates' AND (species='pygmaeus' OR species='pygmaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrobates' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')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='Acrobates' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conilurus' AND (junior_species='albipes' OR junior_species='albipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conilurus' AND (species='albipes' OR species='albipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conilurus' AND (species='albipes' OR species='albipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conilurus' AND (junior_species='albipes' OR junior_species='albipes')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='Conilurus' AND (species='albipes' OR species='albipes') 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='Mastacomys' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastacomys' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastacomys' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastacomys' AND (junior_species='fuscus' OR junior_species='fuscus')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='Mastacomys' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notomys' AND (junior_species='mitchellii' OR junior_species='mitchelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notomys' AND (species='mitchellii' OR species='mitchelli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notomys' AND (species='mitchellii' OR species='mitchelli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notomys' AND (junior_species='mitchellii' OR junior_species='mitchelli')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='Notomys' AND (species='mitchellii' OR species='mitchelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='apodemoides' OR junior_species='apodemoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='apodemoides' OR species='apodemoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='apodemoides' OR species='apodemoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='apodemoides' OR junior_species='apodemoides')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='apodemoides' OR species='apodemoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='auritus' OR junior_species='auritus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='auritus' OR species='auritus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='auritus' OR species='auritus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='auritus' OR junior_species='auritus')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='auritus' OR species='auritus') 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='Pseudomys' AND (junior_species='fumeus' OR junior_species='fumeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='fumeus' OR species='fumeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='fumeus' OR species='fumeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='fumeus' OR junior_species='fumeus')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='fumeus' OR species='fumeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='gouldii' OR junior_species='gouldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='gouldii' OR species='gouldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='gouldii' OR species='gouldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='gouldii' OR junior_species='gouldi')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='gouldii' OR species='gouldi') 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='Rattus' AND (junior_species='lutreolus' OR junior_species='lutreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='lutreolus' OR species='lutreolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='lutreolus' OR species='lutreolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='lutreolus' OR junior_species='lutreolus')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='lutreolus' OR species='lutreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='tunneyi' OR junior_species='tunneyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='tunneyi' OR species='tunneyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='tunneyi' OR species='tunneyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='tunneyi' OR junior_species='tunneyii')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='tunneyi' OR species='tunneyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedionomus' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedionomus' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pedionomus' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedionomus' AND (junior_species='torquatus' OR junior_species='torquatus')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='Pedionomus' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turnix' AND (junior_species='velox' OR junior_species='velox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turnix' AND (species='velox' OR species='velox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turnix' AND (species='velox' OR species='velox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turnix' AND (junior_species='velox' OR junior_species='velox')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='Turnix' AND (species='velox' OR species='velox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coturnix' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coturnix' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='pectoralis' OR junior_species='pectoralis')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='Coturnix' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyto' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyto' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' AND (junior_species='alba' OR junior_species='alba')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='Tyto' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' 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='Tyto' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyto' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyto' 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='Tyto' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegotheles' AND (junior_species='cristatus' OR junior_species='cristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegotheles' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegotheles' AND (species='cristatus' OR species='cristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegotheles' AND (junior_species='cristatus' OR junior_species='cristatus')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='Aegotheles' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podargus' AND (junior_species='strigoides' OR junior_species='strigoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podargus' AND (species='strigoides' OR species='strigoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podargus' AND (species='strigoides' OR species='strigoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podargus' AND (junior_species='strigoides' OR junior_species='strigoides')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='Podargus' AND (species='strigoides' OR species='strigoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypotaenidia' AND (junior_species='philippensis' OR junior_species='philippensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypotaenidia' AND (species='philippensis' OR species='philippensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypotaenidia' AND (species='philippensis' OR species='philippensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypotaenidia' AND (junior_species='philippensis' OR junior_species='philippensis')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='Hypotaenidia' AND (species='philippensis' OR species='philippensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='fluminea' OR junior_species='fluminea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porzana' AND (species='fluminea' OR species='fluminea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porzana' AND (species='fluminea' OR species='fluminea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porzana' AND (junior_species='fluminea' OR junior_species='fluminea')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='Porzana' AND (species='fluminea' OR species='fluminea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnorhina' AND (junior_species='tibicen' OR junior_species='tibicen')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnorhina' AND (species='tibicen' OR species='tibicen') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnorhina' AND (species='tibicen' OR species='tibicen')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnorhina' AND (junior_species='tibicen' OR junior_species='tibicen')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='Gymnorhina' AND (species='tibicen' OR species='tibicen') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' 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='Corvus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corvus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' 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='Corvus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='neoxena' OR junior_species='neoxena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='neoxena' OR species='neoxena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='neoxena' OR species='neoxena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='neoxena' OR junior_species='neoxena')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='Hirundo' AND (species='neoxena' OR species='neoxena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='superciliosa' OR junior_species='superciliosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anas' AND (species='superciliosa' OR species='superciliosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='superciliosa' OR species='superciliosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='superciliosa' OR junior_species='superciliosa')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='Anas' AND (species='superciliosa' OR species='superciliosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pluvialis' AND (junior_species='squatarola' OR junior_species='squatarola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pluvialis' AND (species='squatarola' OR species='squatarola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pluvialis' AND (species='squatarola' OR species='squatarola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pluvialis' AND (junior_species='squatarola' OR junior_species='squatarola')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='Pluvialis' AND (species='squatarola' OR species='squatarola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='bicinctus' OR junior_species='bicinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charadrius' AND (species='bicinctus' OR species='bicinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charadrius' AND (species='bicinctus' OR species='bicinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='bicinctus' OR junior_species='bicinctus')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='Charadrius' AND (species='bicinctus' OR species='bicinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neophema' 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='Neophema' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neophema' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neophema' 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='Neophema' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycercus' 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='Platycercus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycercus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycercus' 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='Platycercus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rankinia' AND (junior_species='diemensis' OR junior_species='diemensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rankinia' AND (species='diemensis' OR species='diemensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rankinia' AND (species='diemensis' OR species='diemensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rankinia' AND (junior_species='diemensis' OR junior_species='diemensis')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='Rankinia' AND (species='diemensis' OR species='diemensis') 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 * FROM register WHERE sample_no=3995
The Ecological Register: Blanche Cave (Third Chamber)
Reference:A. C. Macken and E. H. Reed. 2014. Postglacial reorganization of a small-mammal paleocommunity in southern Australia reveals thresholds of change. Ecological Monographs84(4):563-577 [ER 3747]
Geography
Country: Australia
State: South Australia
Coordinate:37° 2' 0" S, 140° 47' 50" E
Coordinate basis: stated in text
Time interval: Late Pleistocene
Max Ma: 0.04326
Min Ma: 0.01247
Age basis: radiocarbon (uncalibrated)
Geography comments: "Blanche Cave is located within Naracoorte Caves National Park in southeast South Australia, 12 km southeast of the Naracoorte township. It is one of 26 caves in the Naracoorte Caves complex".
Radiocarbon dates for the third chamber range from 43,260 ± 1840 BP (St Pierre et al. 2012) to 12,470 ± 60 BP (Darrénougué et al. 2009).
Habitat comments: "Blanche Cave consists of over 200 m of large chambers and passages with sediment and debris cones located beneath three roof window entrances. Sediment deposits within the cave are typically deep and well stratified, having derived from surrounding surface soils and aeolian material".
"Excavation of deposits in the third chamber revealed abundant speleothem fragments, including straw stalactites and well preserved vertebrate faunal remains. Taphonomic analysis has revealed that vertebrate remains accumulated via multiple accumulating modes, most notably owl pellet deposition, as well as pitfall entrapment and natural deaths of cave dwelling species".
Methods
Life forms: rodents,other large mammals,other small mammals,birds,lizards
Sampling methods: quarry,screenwash
Sample size: 21713 specimens
Sampled by: T. Laslett, E. R. Reed
Years: 2006-2007
Sampling comments: "A 2 x 3 metre excavation of the third chamber deposit of Blanche Cave was conducted in 2006-2007".
The specimen counts below pertain to the faunal remains recovered from two 1 x 1 m grid squares: B2 and A3. Grid B2 had its sediment removed in "5 cm excavation units to a depth of approximately 1.1 m". Grid A3 was "excavated according to 27 discrete sedimentary layers ranging from 1 cm to 6 cm thick to a total depth of 1 m. The remains were sorted from bulk excavated material following wet-screening through 1–2 mm2 mesh sieves".
The NISP counts for the mammalian remains recovered from grid square A3 are provided by Macken and Reed (2014). The faunal remains from grid square B2, along with the avian remains from square A3, were obtained by the sample enterer during a collections visit to the South Australian Museum in September 2022.
Metadata
Sample number: 3995
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-09-20 16:00:50
Modified: 2022-09-21 00:05:06
Abundance distribution
57 species
8 singletons
total count 21713
extrapolated richness: 75.4
Fisher's α: 7.102
geometric series k: 0.8545
Hurlbert's PIE: 0.8240
Shannon's H: 2.1526
Good's u: 0.9996
Each square represents a species. Square sizes are proportional to counts.