Coordinate: 30° 26' S, 136° 57' E
precip was measured "8 km west of the study site"
CMT and WMT based on climate station 94659 (Woomera), which has similar MAP
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=501 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=501SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=247SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=501 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')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='Diplodactylus' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='damaeus' OR junior_species='damaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='damaeus' OR species='damaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='damaeus' OR species='damaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='damaeus' OR junior_species='damaeus')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='Diplodactylus' AND (species='damaeus' OR species='damaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='stenodactylus' OR junior_species='stenodactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='stenodactylus' OR junior_species='stenodactylus')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='Diplodactylus' AND (species='stenodactylus' OR species='stenodactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='tessellatus' OR junior_species='tessellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='tessellatus' OR species='tessellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='tessellatus' OR species='tessellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='tessellatus' OR junior_species='tessellatus')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='Diplodactylus' AND (species='tessellatus' OR species='tessellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteronotia' AND (junior_species='binoei' OR junior_species='binoeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteronotia' AND (species='binoei' OR species='binoeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteronotia' AND (species='binoei' OR species='binoeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteronotia' AND (junior_species='binoei' OR junior_species='binoeii')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='Heteronotia' AND (species='binoei' OR species='binoeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephrurus' AND (junior_species='levis' OR junior_species='levis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nephrurus' AND (species='levis' OR species='levis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nephrurus' AND (species='levis' OR species='levis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nephrurus' AND (junior_species='levis' OR junior_species='levis')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='Nephrurus' AND (species='levis' OR species='levis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchoedura' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')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='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='fordi' OR junior_species='fordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='fordi' OR species='fordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='fordi' OR species='fordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='fordi' OR junior_species='fordii')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='Ctenophorus' AND (species='fordi' OR species='fordii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='nuchalis' OR junior_species='nuchalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='nuchalis' OR species='nuchalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='nuchalis' OR species='nuchalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='nuchalis' OR junior_species='nuchalis')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='Ctenophorus' AND (species='nuchalis' OR species='nuchalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='pictus' OR junior_species='pictus')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='Ctenophorus' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='vitticeps' OR junior_species='vitticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogona' AND (species='vitticeps' OR species='vitticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogona' AND (species='vitticeps' OR species='vitticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='vitticeps' OR junior_species='vitticeps')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='Pogona' AND (species='vitticeps' OR species='vitticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='brooksi' OR junior_species='brooksii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='brooksi' OR species='brooksii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='brooksi' OR species='brooksii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='brooksi' OR junior_species='brooksii')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='Ctenotus' AND (species='brooksi' OR species='brooksii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='regius' OR junior_species='regius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='regius' OR species='regius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='regius' OR species='regius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='regius' OR junior_species='regius')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='Ctenotus' AND (species='regius' OR species='regius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')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='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='strauchii' OR junior_species='strauchi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='strauchii' OR species='strauchi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='strauchii' OR species='strauchi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='strauchii' OR junior_species='strauchi')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='Ctenotus' AND (species='strauchii' OR species='strauchi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='labialis' OR junior_species='labialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='labialis' OR species='labialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='labialis' OR species='labialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='labialis' OR junior_species='labialis')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='Lerista' AND (species='labialis' OR species='labialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='muelleri' OR species='muellerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='muelleri' OR junior_species='muellerii')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='Lerista' AND (species='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menetia' AND (species='greyii' OR species='greyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menetia' AND (species='greyii' OR species='greyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')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='Menetia' AND (species='greyii' OR species='greyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morethia' AND (junior_species='adelaidensis' OR junior_species='adelaidensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morethia' AND (species='adelaidensis' OR species='adelaidensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morethia' AND (species='adelaidensis' OR species='adelaidensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morethia' AND (junior_species='adelaidensis' OR junior_species='adelaidensis')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='Morethia' AND (species='adelaidensis' OR species='adelaidensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachydosaurus' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachydosaurus' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachydosaurus' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachydosaurus' AND (junior_species='rugosus' OR junior_species='rugosus')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='Trachydosaurus' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='bituberculatus' OR junior_species='bituberculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='bituberculatus' OR species='bituberculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='bituberculatus' OR species='bituberculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='bituberculatus' OR junior_species='bituberculatus')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='Ramphotyphlops' AND (species='bituberculatus' OR species='bituberculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='endoterus' OR junior_species='endoterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='endoterus' OR species='endoterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='endoterus' OR species='endoterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='endoterus' OR junior_species='endoterus')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='Ramphotyphlops' AND (species='endoterus' OR species='endoterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudonaja' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudonaja' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='modesta' OR junior_species='modesta')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='Pseudonaja' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='bertholdi' OR junior_species='bertholdii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simoselaps' AND (species='bertholdi' OR species='bertholdii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simoselaps' AND (species='bertholdi' OR species='bertholdii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='bertholdi' OR junior_species='bertholdii')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='Simoselaps' AND (species='bertholdi' OR species='bertholdii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='fasciolatus' OR junior_species='fasciolatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simoselaps' AND (species='fasciolatus' OR species='fasciolatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simoselaps' AND (species='fasciolatus' OR species='fasciolatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simoselaps' AND (junior_species='fasciolatus' OR junior_species='fasciolatus')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='Simoselaps' AND (species='fasciolatus' OR species='fasciolatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suta' AND (junior_species='suta' OR junior_species='suta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Suta' AND (species='suta' OR species='suta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Suta' AND (species='suta' OR species='suta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suta' AND (junior_species='suta' OR junior_species='suta')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='Suta' AND (species='suta' OR species='suta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=501