Coordinate: 26° 24' N, 103° 51' W
climate data differ from those reported for sample 867
"bees were captured with 15 9 20 cm plastic bags or directly with the aid of lethal chambers containing ethyl acetate"
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=1521 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1521SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1026SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1521 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdita' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdita' 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='Perdita' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apis' AND (species='mellifera' OR species='mellifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apis' AND (junior_species='mellifera' OR junior_species='mellifera')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='Apis' AND (species='mellifera' OR species='mellifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='rhodopus' OR junior_species='rhodopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centris' AND (species='rhodopus' OR species='rhodopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centris' AND (species='rhodopus' OR species='rhodopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centris' AND (junior_species='rhodopus' OR junior_species='rhodopus')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='Centris' AND (species='rhodopus' OR species='rhodopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='sphaeracearum' OR junior_species='sphaeracearum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diadasia' AND (species='sphaeracearum' OR species='sphaeracearum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diadasia' AND (species='sphaeracearum' OR species='sphaeracearum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadasia' AND (junior_species='sphaeracearum' OR junior_species='sphaeracearum')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='Diadasia' AND (species='sphaeracearum' OR species='sphaeracearum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='mesillae' OR junior_species='mesillae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epeolus' AND (species='mesillae' OR species='mesillae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epeolus' AND (species='mesillae' OR species='mesillae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' AND (junior_species='mesillae' OR junior_species='mesillae')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='Epeolus' AND (species='mesillae' OR species='mesillae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' 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='Epeolus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epeolus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' 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='Epeolus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' 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='Epeolus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epeolus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epeolus' 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='Epeolus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tristis' OR junior_species='tristis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissodes' AND (species='tristis' OR species='tristis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissodes' AND (species='tristis' OR species='tristis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissodes' AND (junior_species='tristis' OR junior_species='tristis')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='Melissodes' AND (species='tristis' OR species='tristis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' 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='Nomada' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomada' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomada' 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='Nomada' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zacosmia' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zacosmia' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zacosmia' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zacosmia' AND (junior_species='maculata' OR junior_species='maculata')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='Zacosmia' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='perileucus' OR junior_species='perileucus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='perileucus' OR species='perileucus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='perileucus' OR species='perileucus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='perileucus' OR junior_species='perileucus')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='Colletes' AND (species='perileucus' OR species='perileucus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='algarobiae' OR junior_species='algarobiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='algarobiae' OR species='algarobiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='algarobiae' OR species='algarobiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='algarobiae' OR junior_species='algarobiae')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='Colletes' AND (species='algarobiae' OR species='algarobiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='deserticola' OR junior_species='deserticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='deserticola' OR species='deserticola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='deserticola' OR species='deserticola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='deserticola' OR junior_species='deserticola')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='Colletes' AND (species='deserticola' OR species='deserticola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='louisae' OR junior_species='louisae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='louisae' OR species='louisae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='louisae' OR species='louisae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='louisae' OR junior_species='louisae')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='Colletes' AND (species='louisae' OR species='louisae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='prosopidis' OR junior_species='prosopidis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='prosopidis' OR species='prosopidis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='prosopidis' OR species='prosopidis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='prosopidis' OR junior_species='prosopidis')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='Colletes' AND (species='prosopidis' OR species='prosopidis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='salicicola' OR junior_species='salicicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='salicicola' OR species='salicicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='salicicola' OR species='salicicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='salicicola' OR junior_species='salicicola')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='Colletes' AND (species='salicicola' OR species='salicicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='wickhami' OR junior_species='wickhamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colletes' AND (species='wickhami' OR species='wickhamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colletes' AND (species='wickhami' OR species='wickhamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colletes' AND (junior_species='wickhami' OR junior_species='wickhamii')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='Colletes' AND (species='wickhami' OR species='wickhamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='asininus' OR junior_species='asininus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeus' AND (species='asininus' OR species='asininus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylaeus' AND (species='asininus' OR species='asininus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' AND (junior_species='asininus' OR junior_species='asininus')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='Hylaeus' AND (species='asininus' OR species='asininus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' 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='Hylaeus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylaeus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeus' 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='Hylaeus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='cockerelli' OR junior_species='cockerellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agapostemon' AND (species='cockerelli' OR species='cockerellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='cockerelli' OR species='cockerellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' AND (junior_species='cockerelli' OR junior_species='cockerellii')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='Agapostemon' AND (species='cockerelli' OR species='cockerellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agapostemon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agapostemon' 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='Agapostemon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasioglossum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasioglossum' 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='Lasioglossum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='cochimi' OR junior_species='cochimii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthidium' AND (species='cochimi' OR species='cochimii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthidium' AND (species='cochimi' OR species='cochimii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='cochimi' OR junior_species='cochimii')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='Anthidium' AND (species='cochimi' OR species='cochimii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='cockerelli' OR junior_species='cockerellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthidium' AND (species='cockerelli' OR species='cockerellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthidium' AND (species='cockerelli' OR species='cockerellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='cockerelli' OR junior_species='cockerellii')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='Anthidium' AND (species='cockerelli' OR species='cockerellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='paroselae' OR junior_species='paroselae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthidium' AND (species='paroselae' OR species='paroselae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthidium' AND (species='paroselae' OR species='paroselae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthidium' AND (junior_species='paroselae' OR junior_species='paroselae')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='Anthidium' AND (species='paroselae' OR species='paroselae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='bigeloviae' OR junior_species='bigeloviae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='bigeloviae' OR species='bigeloviae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='bigeloviae' OR species='bigeloviae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='bigeloviae' OR junior_species='bigeloviae')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='Ashmeadiella' AND (species='bigeloviae' OR species='bigeloviae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' 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='Ashmeadiella' AND (species='breviceps' OR species='breviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='breviceps' OR species='breviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' 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='Ashmeadiella' AND (species='breviceps' OR species='breviceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='clypeodentata' OR junior_species='clypeodentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='clypeodentata' OR species='clypeodentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='clypeodentata' OR species='clypeodentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='clypeodentata' OR junior_species='clypeodentata')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='Ashmeadiella' AND (species='clypeodentata' OR species='clypeodentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='gillettei' OR junior_species='gilletteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='gillettei' OR species='gilletteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='gillettei' OR species='gilletteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='gillettei' OR junior_species='gilletteii')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='Ashmeadiella' AND (species='gillettei' OR species='gilletteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='leucozona' OR junior_species='leucozona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='leucozona' OR species='leucozona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='leucozona' OR species='leucozona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='leucozona' OR junior_species='leucozona')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='Ashmeadiella' AND (species='leucozona' OR species='leucozona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='meliloti' OR junior_species='melilotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='meliloti' OR species='melilotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='meliloti' OR species='melilotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='meliloti' OR junior_species='melilotii')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='Ashmeadiella' AND (species='meliloti' OR species='melilotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='prosopidis' OR junior_species='prosopidis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='prosopidis' OR species='prosopidis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='prosopidis' OR species='prosopidis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='prosopidis' OR junior_species='prosopidis')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='Ashmeadiella' AND (species='prosopidis' OR species='prosopidis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='rhodognatha' OR junior_species='rhodognatha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ashmeadiella' AND (species='rhodognatha' OR species='rhodognatha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ashmeadiella' AND (species='rhodognatha' OR species='rhodognatha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ashmeadiella' AND (junior_species='rhodognatha' OR junior_species='rhodognatha')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='Ashmeadiella' AND (species='rhodognatha' OR species='rhodognatha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='hunteri' OR junior_species='hunterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelioxys' AND (species='hunteri' OR species='hunterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelioxys' AND (species='hunteri' OR species='hunterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelioxys' AND (junior_species='hunteri' OR junior_species='hunterii')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='Coelioxys' AND (species='hunteri' OR species='hunterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dioxys' AND (junior_species='productus' OR junior_species='productus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dioxys' AND (species='productus' OR species='productus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dioxys' AND (species='productus' OR species='productus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dioxys' AND (junior_species='productus' OR junior_species='productus')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='Dioxys' AND (species='productus' OR species='productus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichostelis' AND (junior_species='perpulchra' OR junior_species='perpulchra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichostelis' AND (species='perpulchra' OR species='perpulchra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichostelis' AND (species='perpulchra' OR species='perpulchra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichostelis' AND (junior_species='perpulchra' OR junior_species='perpulchra')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='Dolichostelis' AND (species='perpulchra' OR species='perpulchra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='chilopsidis' OR junior_species='chilopsidis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='chilopsidis' OR species='chilopsidis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='chilopsidis' OR species='chilopsidis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='chilopsidis' OR junior_species='chilopsidis')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='Megachile' AND (species='chilopsidis' OR species='chilopsidis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='discorhina' OR junior_species='discorhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='discorhina' OR species='discorhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='discorhina' OR species='discorhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='discorhina' OR junior_species='discorhina')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='Megachile' AND (species='discorhina' OR species='discorhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='lippiae' OR junior_species='lippiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='lippiae' OR species='lippiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='lippiae' OR species='lippiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='lippiae' OR junior_species='lippiae')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='Megachile' AND (species='lippiae' OR species='lippiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='newberryae' OR junior_species='newberryae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='newberryae' OR species='newberryae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='newberryae' OR species='newberryae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='newberryae' OR junior_species='newberryae')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='Megachile' AND (species='newberryae' OR species='newberryae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='odontostoma' OR junior_species='odontostoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='odontostoma' OR species='odontostoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='odontostoma' OR species='odontostoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='odontostoma' OR junior_species='odontostoma')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='Megachile' AND (species='odontostoma' OR species='odontostoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='sidalceae' OR junior_species='sidalceae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='sidalceae' OR species='sidalceae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='sidalceae' OR species='sidalceae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='sidalceae' OR junior_species='sidalceae')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='Megachile' AND (species='sidalceae' OR species='sidalceae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='spinotulata' OR junior_species='spinotulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megachile' AND (species='spinotulata' OR species='spinotulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megachile' AND (species='spinotulata' OR species='spinotulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megachile' AND (junior_species='spinotulata' OR junior_species='spinotulata')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='Megachile' AND (species='spinotulata' OR species='spinotulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='subfasciata' OR junior_species='subfasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osmia' AND (species='subfasciata' OR species='subfasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osmia' AND (species='subfasciata' OR species='subfasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osmia' AND (junior_species='subfasciata' OR junior_species='subfasciata')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='Osmia' AND (species='subfasciata' OR species='subfasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelis' AND (junior_species='elongativentris' OR junior_species='elongativentris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stelis' AND (species='elongativentris' OR species='elongativentris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stelis' AND (species='elongativentris' OR species='elongativentris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelis' AND (junior_species='elongativentris' OR junior_species='elongativentris')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='Stelis' AND (species='elongativentris' OR species='elongativentris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelis' AND (junior_species='xerophila' OR junior_species='xerophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stelis' AND (species='xerophila' OR species='xerophila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stelis' AND (species='xerophila' OR species='xerophila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelis' AND (junior_species='xerophila' OR junior_species='xerophila')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='Stelis' AND (species='xerophila' OR species='xerophila') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1521