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=2905 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2905SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2733SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2905 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' 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='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' 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='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')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='Zosterops' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthorhynchus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthorhynchus' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthorhynchus' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthorhynchus' AND (junior_species='superciliosus' OR junior_species='superciliosus')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='Acanthorhynchus' AND (species='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='carunculata' OR junior_species='carunculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthochaera' AND (species='carunculata' OR species='carunculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthochaera' AND (species='carunculata' OR species='carunculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='carunculata' OR junior_species='carunculata')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='Anthochaera' AND (species='carunculata' OR species='carunculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='frontalis' OR junior_species='frontalis')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='Sericornis' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' 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='Pachycephala' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' 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='Pachycephala' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardalotus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardalotus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='punctatus' OR junior_species='punctatus')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='Pardalotus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichmera' AND (junior_species='indistincta' OR junior_species='indistincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lichmera' AND (species='indistincta' OR species='indistincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lichmera' AND (species='indistincta' OR species='indistincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichmera' AND (junior_species='indistincta' OR junior_species='indistincta')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='Lichmera' AND (species='indistincta' OR species='indistincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')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='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malurus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malurus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='elegans' OR junior_species='elegans')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='Malurus' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthiza' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthiza' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='apicalis' OR junior_species='apicalis')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='Acanthiza' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardalotus' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardalotus' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='striatus' OR junior_species='striatus')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='Pardalotus' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strepera' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strepera' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strepera' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strepera' AND (junior_species='versicolor' OR junior_species='versicolor')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='Strepera' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacelo' AND (junior_species='novaeguineae' OR junior_species='novaeguineae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacelo' AND (species='novaeguineae' OR species='novaeguineae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacelo' AND (species='novaeguineae' OR species='novaeguineae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacelo' AND (junior_species='novaeguineae' OR junior_species='novaeguineae')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='Dacelo' AND (species='novaeguineae' OR species='novaeguineae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stagonopleura' AND (junior_species='oculata' OR junior_species='oculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stagonopleura' AND (species='oculata' OR species='oculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stagonopleura' AND (species='oculata' OR species='oculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stagonopleura' AND (junior_species='oculata' OR junior_species='oculata')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='Stagonopleura' AND (species='oculata' OR species='oculata') 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='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='Melithreptus' AND (junior_species='lunatus' OR junior_species='lunatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melithreptus' AND (species='lunatus' OR species='lunatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melithreptus' AND (species='lunatus' OR species='lunatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melithreptus' AND (junior_species='lunatus' OR junior_species='lunatus')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='Melithreptus' AND (species='lunatus' OR species='lunatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='chrysoptera' OR junior_species='chrysoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthochaera' AND (species='chrysoptera' OR species='chrysoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthochaera' AND (species='chrysoptera' OR species='chrysoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='chrysoptera' OR junior_species='chrysoptera')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='Anthochaera' AND (species='chrysoptera' OR species='chrysoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='chrysorrhoa' OR junior_species='chrysorrhoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthiza' AND (species='chrysorrhoa' OR species='chrysorrhoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthiza' AND (species='chrysorrhoa' OR species='chrysorrhoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='chrysorrhoa' OR junior_species='chrysorrhoa')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='Acanthiza' AND (species='chrysorrhoa' OR species='chrysorrhoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaps' AND (junior_species='chalcoptera' OR junior_species='chalcoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaps' AND (species='chalcoptera' OR species='chalcoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaps' AND (species='chalcoptera' OR species='chalcoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaps' AND (junior_species='chalcoptera' OR junior_species='chalcoptera')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='Phaps' AND (species='chalcoptera' OR species='chalcoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='flabelliformis' OR junior_species='flabelliformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacomantis' AND (species='flabelliformis' OR species='flabelliformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacomantis' AND (species='flabelliformis' OR species='flabelliformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='flabelliformis' OR junior_species='flabelliformis')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='Cacomantis' AND (species='flabelliformis' OR species='flabelliformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='georgiana' OR junior_species='georgiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eopsaltria' AND (species='georgiana' OR species='georgiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eopsaltria' AND (species='georgiana' OR species='georgiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='georgiana' OR junior_species='georgiana')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='Eopsaltria' AND (species='georgiana' OR species='georgiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycercus' AND (junior_species='icterotis' OR junior_species='icterotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycercus' AND (species='icterotis' OR species='icterotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycercus' AND (species='icterotis' OR species='icterotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycercus' AND (junior_species='icterotis' OR junior_species='icterotis')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='icterotis' OR species='icterotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthiza' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthiza' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='inornata' OR junior_species='inornata')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='Acanthiza' AND (species='inornata' OR species='inornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='harmonica' OR junior_species='harmonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colluricincla' AND (species='harmonica' OR species='harmonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colluricincla' AND (species='harmonica' OR species='harmonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='harmonica' OR junior_species='harmonica')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='Colluricincla' AND (species='harmonica' OR species='harmonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')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='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='lucidus' OR junior_species='lucidus')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='Chrysococcyx' AND (species='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' 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='Cracticus' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cracticus' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' 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='Cracticus' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='splendens' OR junior_species='splendens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malurus' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malurus' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='splendens' OR junior_species='splendens')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='Malurus' AND (species='splendens' OR species='splendens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaps' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaps' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaps' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaps' AND (junior_species='elegans' OR junior_species='elegans')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='Phaps' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='cirrocephalus' OR junior_species='cirrocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='cirrocephalus' OR species='cirrocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='cirrocephalus' OR species='cirrocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='cirrocephalus' OR junior_species='cirrocephalus')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='Accipiter' AND (species='cirrocephalus' OR species='cirrocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Purpureicephalus' AND (junior_species='spurius' OR junior_species='spurius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Purpureicephalus' AND (species='spurius' OR species='spurius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Purpureicephalus' AND (species='spurius' OR species='spurius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Purpureicephalus' AND (junior_species='spurius' OR junior_species='spurius')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='Purpureicephalus' AND (species='spurius' OR species='spurius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='leucophrys' OR junior_species='leucophrys')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='Rhipidura' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerygone' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerygone' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='fusca' OR junior_species='fusca')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='Gerygone' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stipiturus' AND (junior_species='malachurus' OR junior_species='malachurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stipiturus' AND (species='malachurus' OR species='malachurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stipiturus' AND (species='malachurus' OR species='malachurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stipiturus' AND (junior_species='malachurus' OR junior_species='malachurus')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='Stipiturus' AND (species='malachurus' OR species='malachurus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2905 The Ecological Register: Goode Beach
Goode Beach
Basic information
Sample name: Goode Beach

Reference: V. W. Smith. 2002. Avian population changes in a developing urban area in Western Australia over an eighteen year period. Corella 26(3):79-84 [ER 2733]
Geography
Country: Australia

State: Western Australia


Coordinate: 35° 5' S, 117° 56' E
Coordinate basis: stated in text

Geography comments: "an isolated residential enclave... on the southern short of King George Sound and contiguous with the central northern boundary of the Torndirrup National Park"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

WMT: 19.6

CMT: 11.7

MAP: 796.0

Habitat comments: "thickets of Peppermint Agonis reflexus, mallee-type" Eucalyptus forest "and low- to medium-height heath interspersed with nectar-producing plants... A major part of this study was conducted in the author's garden... in one of the subdivisions"
climate data are for Alabany Airport at 34.94º S 117.80º E and are from Archibald et al. (2011, Forest Ecology and Management)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 1285 individuals

Years: 1982 - 1987, 1992 - 2000

Days: 549

Net or trap nights: 919

Sampling comments: "one 13 metre four shelf mist net (30 sq. m.)" was used from 1982 to 1991 and "three new sites were selected, all within 30 metres of the house, using nets of length either 9 metres (20 sq. m.) or 13 metres"
a detailed breakdown of the number of nets used per year and the number of days open is given
nets were also "operated sporadically" at Hilltop and Roadside from 1992 to 2000, but only counts of birds found only at those sites are given, so the counts entered are only for Goode Beach

Metadata
Sample number: 2905

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-04-22 11:55:13

Modified: 2020-01-14 05:38:16

Abundance distribution
36 species
7 singletons
total count 1285
extrapolated richness: 52.6
Fisher's α: 6.876
geometric series k: 0.8367
Hurlbert's PIE: 0.7755
Shannon's H: 2.1011
Good's u: 0.9946
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Phylidonyris novaehollandiae512 nectarivore
Zosterops lateralis2911.9 g frugivore-omnivore
Acanthorhynchus superciliosus106 nectarivore
Anthochaera carunculata69 nectarivore
Sericornis frontalis561.8 g insectivore
Pachycephala pectoralis451.6 g insectivore
Pardalotus punctatus198.7 g insectivore
Lichmera indistincta18 nectarivore
Rhipidura fuliginosa162.7 g insectivore
Malurus elegans169.9 g insectivore
Acanthiza apicalis157.5 g insectivore
Pardalotus striatus141.9 g insectivore-nectarivore
Strepera versicolor14 omnivore
Dacelo novaeguineae13313 g carnivore-insectivore
Stagonopleura oculata1212.9 g
Gymnorhina tibicen7 insectivore-omnivore
Podargus strigoides618.8 g carnivore
Melithreptus lunatus6 nectarivore
Anthochaera chrysoptera6 nectarivore
"Acanthochaera chrysoptera"
Acanthiza chrysorrhoa52.0 g insectivore
Phaps chalcoptera5344 g granivore
Cacomantis flabelliformis549.8 g insectivore
Eopsaltria georgiana520.8 g insectivore
Platycercus icterotis465.4 g granivore
Acanthiza inornata37.0 g insectivore
Colluricincla harmonica32.8 g carnivore-insectivore
Grallina cyanoleuca3 insectivore
Chrysococcyx lucidus24.9 g insectivore
Cracticus torquatus2 carnivore-insectivore
Malurus splendens13.0 g insectivore
Phaps elegans1219 g granivore
Accipiter cirrocephalus1126 g
Purpureicephalus spurius1116 g granivore
Rhipidura leucophrys13.3 g insectivore
Gerygone fusca15.4 g insectivore
Stipiturus malachurus17.3 g