Coordinate: 35° 17' S, 148° 34' E
climate data based on station 94926 (Canberra International Airport)
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=433 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=433SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=209SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=433 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='guichenoti' OR junior_species='guichenotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropholis' AND (species='guichenoti' OR species='guichenotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropholis' AND (species='guichenoti' OR species='guichenotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='guichenoti' OR junior_species='guichenotii')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='Lampropholis' AND (species='guichenoti' OR species='guichenotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niveoscincus' AND (junior_species='coventryi' OR junior_species='coventryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niveoscincus' AND (species='coventryi' OR species='coventryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niveoscincus' AND (species='coventryi' OR species='coventryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niveoscincus' AND (junior_species='coventryi' OR junior_species='coventryii')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='Niveoscincus' AND (species='coventryi' OR species='coventryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannoscincus' AND (junior_species='maccoyi' OR junior_species='maccoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nannoscincus' AND (species='maccoyi' OR species='maccoyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nannoscincus' AND (species='maccoyi' OR species='maccoyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannoscincus' AND (junior_species='maccoyi' OR junior_species='maccoyii')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='Nannoscincus' AND (species='maccoyi' OR species='maccoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='delicata' OR junior_species='delicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropholis' AND (species='delicata' OR species='delicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropholis' AND (species='delicata' OR species='delicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='delicata' OR junior_species='delicata')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='Lampropholis' AND (species='delicata' OR species='delicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='heatwolei' OR junior_species='heatwoleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulamprus' AND (species='heatwolei' OR species='heatwoleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulamprus' AND (species='heatwolei' OR species='heatwoleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='heatwolei' OR junior_species='heatwoleii')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='Eulamprus' AND (species='heatwolei' OR species='heatwoleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='decresiensis' OR junior_species='decresiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiergis' AND (species='decresiensis' OR species='decresiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiergis' AND (species='decresiensis' OR species='decresiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='decresiensis' OR junior_species='decresiensis')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='Hemiergis' AND (species='decresiensis' OR species='decresiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassiana' AND (junior_species='platynota' OR junior_species='platynota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassiana' AND (species='platynota' OR species='platynota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassiana' AND (species='platynota' OR species='platynota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassiana' AND (junior_species='platynota' OR junior_species='platynota')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='Bassiana' AND (species='platynota' OR species='platynota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='entrecasteauxii' OR junior_species='entrecasteauxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='entrecasteauxii' OR junior_species='entrecasteauxi')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='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassiana' AND (junior_species='duperreyi' OR junior_species='duperreyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassiana' AND (species='duperreyi' OR species='duperreyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassiana' AND (species='duperreyi' OR species='duperreyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassiana' AND (junior_species='duperreyi' OR junior_species='duperreyii')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='Bassiana' AND (species='duperreyi' OR species='duperreyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='saxatilis' OR junior_species='saxatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='saxatilis' OR species='saxatilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='saxatilis' OR species='saxatilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='saxatilis' OR junior_species='saxatilis')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='Egernia' AND (species='saxatilis' OR species='saxatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='tympanum' OR junior_species='tympanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulamprus' AND (species='tympanum' OR species='tympanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulamprus' AND (species='tympanum' OR species='tympanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='tympanum' OR junior_species='tympanum')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='Eulamprus' AND (species='tympanum' OR species='tympanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='whitii' OR junior_species='whiti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='whitii' OR species='whiti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='whitii' OR species='whiti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='whitii' OR junior_species='whiti')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='Egernia' AND (species='whitii' OR species='whiti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='spenceri' OR junior_species='spencerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudemoia' AND (species='spenceri' OR species='spencerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudemoia' AND (species='spenceri' OR species='spencerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='spenceri' OR junior_species='spencerii')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='Pseudemoia' AND (species='spenceri' OR species='spencerii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=433