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=300 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=300SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=129SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=300 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelenopsis' AND (junior_species='utahana' OR junior_species='utahana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agelenopsis' AND (species='utahana' OR species='utahana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agelenopsis' AND (species='utahana' OR species='utahana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelenopsis' AND (junior_species='utahana' OR junior_species='utahana')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='Agelenopsis' AND (species='utahana' OR species='utahana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaurobius' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amaurobius' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amaurobius' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amaurobius' AND (junior_species='borealis' OR junior_species='borealis')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='Amaurobius' AND (species='borealis' OR species='borealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callobius' AND (junior_species='bennetti' OR junior_species='bennettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callobius' AND (species='bennetti' OR species='bennettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callobius' AND (species='bennetti' OR species='bennettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callobius' AND (junior_species='bennetti' OR junior_species='bennettii')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='Callobius' AND (species='bennetti' OR species='bennettii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybaeopsis' AND (junior_species='euopla' OR junior_species='euopla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cybaeopsis' AND (species='euopla' OR species='euopla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cybaeopsis' AND (species='euopla' OR species='euopla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybaeopsis' AND (junior_species='euopla' OR junior_species='euopla')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='Cybaeopsis' AND (species='euopla' OR species='euopla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybaeopsis' AND (junior_species='tibialis' OR junior_species='tibialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cybaeopsis' AND (species='tibialis' OR species='tibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cybaeopsis' AND (species='tibialis' OR species='tibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybaeopsis' AND (junior_species='tibialis' OR junior_species='tibialis')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='Cybaeopsis' AND (species='tibialis' OR species='tibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='canadensis' OR junior_species='canadensis')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='Clubiona' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='kulczynskii' OR junior_species='kulczynski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='kulczynskii' OR species='kulczynski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='kulczynskii' OR species='kulczynski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='kulczynskii' OR junior_species='kulczynski')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='Clubiona' AND (species='kulczynskii' OR species='kulczynski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='neglectus' OR junior_species='neglectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drassodes' AND (species='neglectus' OR species='neglectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drassodes' AND (species='neglectus' OR species='neglectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='neglectus' OR junior_species='neglectus')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='Drassodes' AND (species='neglectus' OR species='neglectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='brumalis' OR junior_species='brumalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnaphosa' AND (species='brumalis' OR species='brumalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnaphosa' AND (species='brumalis' OR species='brumalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='brumalis' OR junior_species='brumalis')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='Gnaphosa' AND (species='brumalis' OR species='brumalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='microps' OR junior_species='microps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnaphosa' AND (species='microps' OR species='microps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnaphosa' AND (species='microps' OR species='microps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='microps' OR junior_species='microps')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='Gnaphosa' AND (species='microps' OR species='microps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='muscorum' OR junior_species='muscorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnaphosa' AND (species='muscorum' OR species='muscorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnaphosa' AND (species='muscorum' OR species='muscorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='muscorum' OR junior_species='muscorum')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='Gnaphosa' AND (species='muscorum' OR species='muscorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='parvula' OR junior_species='parvula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnaphosa' AND (species='parvula' OR species='parvula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnaphosa' AND (species='parvula' OR species='parvula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnaphosa' AND (junior_species='parvula' OR junior_species='parvula')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='Gnaphosa' AND (species='parvula' OR species='parvula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='hiemalis' OR junior_species='hiemalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplodrassus' AND (species='hiemalis' OR species='hiemalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplodrassus' AND (species='hiemalis' OR species='hiemalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='hiemalis' OR junior_species='hiemalis')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='Haplodrassus' AND (species='hiemalis' OR species='hiemalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='signifier' OR junior_species='signifier')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplodrassus' AND (species='signifier' OR species='signifier') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplodrassus' AND (species='signifier' OR species='signifier')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='signifier' OR junior_species='signifier')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='Haplodrassus' AND (species='signifier' OR species='signifier') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaria' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micaria' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micaria' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaria' AND (junior_species='aenea' OR junior_species='aenea')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='Micaria' AND (species='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='fratris' OR junior_species='fratris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='fratris' OR species='fratris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='fratris' OR species='fratris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='fratris' OR junior_species='fratris')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='Zelotes' AND (species='fratris' OR species='fratris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='puritanus' OR junior_species='puritanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='puritanus' OR species='puritanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='puritanus' OR species='puritanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='puritanus' OR junior_species='puritanus')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='Zelotes' AND (species='puritanus' OR species='puritanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sula' OR junior_species='sula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sula' OR species='sula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sula' OR species='sula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sula' OR junior_species='sula')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='Zelotes' AND (species='sula' OR species='sula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicurina' AND (junior_species='brevis' OR junior_species='brevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cicurina' AND (species='brevis' OR species='brevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cicurina' AND (species='brevis' OR species='brevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cicurina' AND (junior_species='brevis' OR junior_species='brevis')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='Cicurina' AND (species='brevis' OR species='brevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antistea' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antistea' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antistea' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antistea' AND (junior_species='brunnea' OR junior_species='brunnea')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='Antistea' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hahnia' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hahnia' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hahnia' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hahnia' AND (junior_species='cinerea' OR junior_species='cinerea')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='Hahnia' AND (species='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoantistea' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoantistea' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoantistea' AND (species='agilis' OR species='agilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoantistea' AND (junior_species='agilis' OR junior_species='agilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neoantistea' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoantistea' AND (junior_species='magna' OR junior_species='magna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoantistea' AND (species='magna' OR species='magna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoantistea' AND (species='magna' OR species='magna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoantistea' AND (junior_species='magna' OR junior_species='magna')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='Neoantistea' AND (species='magna' OR species='magna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='allosubtilis' OR junior_species='allosubtilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agyneta' AND (species='allosubtilis' OR species='allosubtilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agyneta' AND (species='allosubtilis' OR species='allosubtilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='allosubtilis' OR junior_species='allosubtilis')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='Agyneta' AND (species='allosubtilis' OR species='allosubtilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agyneta' AND (species='olivacea' OR species='olivacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agyneta' AND (species='olivacea' OR species='olivacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='olivacea' OR junior_species='olivacea')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='Agyneta' AND (species='olivacea' OR species='olivacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agyneta' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agyneta' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agyneta' AND (junior_species='simplex' OR junior_species='simplex')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='Agyneta' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allomengea' AND (junior_species='dentisetis' OR junior_species='dentisetis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allomengea' AND (species='dentisetis' OR species='dentisetis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allomengea' AND (species='dentisetis' OR species='dentisetis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allomengea' AND (junior_species='dentisetis' OR junior_species='dentisetis')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='Allomengea' AND (species='dentisetis' OR species='dentisetis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphileta' AND (junior_species='misera' OR junior_species='misera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphileta' AND (species='misera' OR species='misera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphileta' AND (species='misera' OR species='misera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphileta' AND (junior_species='misera' OR junior_species='misera')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='Aphileta' AND (species='misera' OR species='misera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathyphantes' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bathyphantes' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bathyphantes' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathyphantes' AND (junior_species='pallidus' OR junior_species='pallidus')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='Bathyphantes' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathyphantes' AND (junior_species='simillimus' OR junior_species='simillimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bathyphantes' AND (species='simillimus' OR species='simillimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bathyphantes' AND (species='simillimus' OR species='simillimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathyphantes' AND (junior_species='simillimus' OR junior_species='simillimus')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='Bathyphantes' AND (species='simillimus' OR species='simillimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carorita' AND (junior_species='limnaea' OR junior_species='limnaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carorita' AND (species='limnaea' OR species='limnaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carorita' AND (species='limnaea' OR species='limnaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carorita' AND (junior_species='limnaea' OR junior_species='limnaea')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='Carorita' AND (species='limnaea' OR species='limnaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centromerus' AND (junior_species='longibulbus' OR junior_species='longibulbus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centromerus' AND (species='longibulbus' OR species='longibulbus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centromerus' AND (species='longibulbus' OR species='longibulbus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centromerus' AND (junior_species='longibulbus' OR junior_species='longibulbus')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='Centromerus' AND (species='longibulbus' OR species='longibulbus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='fissiceps' OR junior_species='fissiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceraticelus' AND (species='fissiceps' OR species='fissiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceraticelus' AND (species='fissiceps' OR species='fissiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='fissiceps' OR junior_species='fissiceps')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='Ceraticelus' AND (species='fissiceps' OR species='fissiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='laetabilis' OR junior_species='laetabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceraticelus' AND (species='laetabilis' OR species='laetabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceraticelus' AND (species='laetabilis' OR species='laetabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='laetabilis' OR junior_species='laetabilis')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='Ceraticelus' AND (species='laetabilis' OR species='laetabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='laetus' OR junior_species='laetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceraticelus' AND (species='laetus' OR species='laetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceraticelus' AND (species='laetus' OR species='laetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='laetus' OR junior_species='laetus')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='Ceraticelus' AND (species='laetus' OR species='laetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceraticelus' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceraticelus' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceraticelus' AND (junior_species='similis' OR junior_species='similis')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='Ceraticelus' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinella' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinella' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinella' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinella' AND (junior_species='brunnea' OR junior_species='brunnea')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='Ceratinella' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinella' AND (junior_species='buna' OR junior_species='buna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinella' AND (species='buna' OR species='buna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinella' AND (species='buna' OR species='buna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinella' AND (junior_species='buna' OR junior_species='buna')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='Ceratinella' AND (species='buna' OR species='buna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinops' AND (junior_species='annulipes' OR junior_species='annulipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinops' AND (species='annulipes' OR species='annulipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinops' AND (species='annulipes' OR species='annulipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinops' AND (junior_species='annulipes' OR junior_species='annulipes')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='Ceratinops' AND (species='annulipes' OR species='annulipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinopsis' AND (junior_species='auriculata' OR junior_species='auriculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinopsis' AND (species='auriculata' OR species='auriculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinopsis' AND (species='auriculata' OR species='auriculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinopsis' AND (junior_species='auriculata' OR junior_species='auriculata')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='Ceratinopsis' AND (species='auriculata' OR species='auriculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinopsis' AND (junior_species='labradorensis' OR junior_species='labradorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinopsis' AND (species='labradorensis' OR species='labradorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinopsis' AND (species='labradorensis' OR species='labradorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinopsis' AND (junior_species='labradorensis' OR junior_species='labradorensis')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='Ceratinopsis' AND (species='labradorensis' OR species='labradorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnephalocotes' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnephalocotes' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnephalocotes' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnephalocotes' AND (junior_species='obscurus' OR junior_species='obscurus')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='Cnephalocotes' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocentria' AND (junior_species='bidentata' OR junior_species='bidentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplocentria' AND (species='bidentata' OR species='bidentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplocentria' AND (species='bidentata' OR species='bidentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocentria' AND (junior_species='bidentata' OR junior_species='bidentata')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='Diplocentria' AND (species='bidentata' OR species='bidentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocentria' AND (junior_species='rectangulata' OR junior_species='rectangulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplocentria' AND (species='rectangulata' OR species='rectangulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplocentria' AND (species='rectangulata' OR species='rectangulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocentria' AND (junior_species='rectangulata' OR junior_species='rectangulata')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='Diplocentria' AND (species='rectangulata' OR species='rectangulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatium' AND (junior_species='crassipalpum' OR junior_species='crassipalpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonatium' AND (species='crassipalpum' OR species='crassipalpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonatium' AND (species='crassipalpum' OR species='crassipalpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonatium' AND (junior_species='crassipalpum' OR junior_species='crassipalpum')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='Gonatium' AND (species='crassipalpum' OR species='crassipalpum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='angusta' OR junior_species='angusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammonota' AND (species='angusta' OR species='angusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammonota' AND (species='angusta' OR species='angusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='angusta' OR junior_species='angusta')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='Grammonota' AND (species='angusta' OR species='angusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='gentilis' OR junior_species='gentilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammonota' AND (species='gentilis' OR species='gentilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammonota' AND (species='gentilis' OR species='gentilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='gentilis' OR junior_species='gentilis')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='Grammonota' AND (species='gentilis' OR species='gentilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='gigas' OR junior_species='gigas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammonota' AND (species='gigas' OR species='gigas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammonota' AND (species='gigas' OR species='gigas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammonota' AND (junior_species='gigas' OR junior_species='gigas')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='Grammonota' AND (species='gigas' OR species='gigas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helophora' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helophora' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helophora' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helophora' AND (junior_species='insignis' OR junior_species='insignis')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='Helophora' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hybauchenidium' AND (junior_species='cymbadentatum' OR junior_species='cymbadentatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hybauchenidium' AND (species='cymbadentatum' OR species='cymbadentatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hybauchenidium' AND (species='cymbadentatum' OR species='cymbadentatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hybauchenidium' AND (junior_species='cymbadentatum' OR junior_species='cymbadentatum')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='Hybauchenidium' AND (species='cymbadentatum' OR species='cymbadentatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Improphantes' AND (junior_species='complicatus' OR junior_species='complicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Improphantes' AND (species='complicatus' OR species='complicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Improphantes' AND (species='complicatus' OR species='complicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Improphantes' AND (junior_species='complicatus' OR junior_species='complicatus')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='Improphantes' AND (species='complicatus' OR species='complicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Incestophantes' AND (junior_species='washingtoni' OR junior_species='washingtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Incestophantes' AND (species='washingtoni' OR species='washingtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Incestophantes' AND (species='washingtoni' OR species='washingtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Incestophantes' AND (junior_species='washingtoni' OR junior_species='washingtonii')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='Incestophantes' AND (species='washingtoni' OR species='washingtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Islandiana' AND (junior_species='longisetosa' OR junior_species='longisetosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Islandiana' AND (species='longisetosa' OR species='longisetosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Islandiana' AND (species='longisetosa' OR species='longisetosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Islandiana' AND (junior_species='longisetosa' OR junior_species='longisetosa')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='Islandiana' AND (species='longisetosa' OR species='longisetosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepthyphantes' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepthyphantes' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepthyphantes' AND (species='alpinus' OR species='alpinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepthyphantes' AND (junior_species='alpinus' OR junior_species='alpinus')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='Lepthyphantes' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepthyphantes' AND (junior_species='intricatus' OR junior_species='intricatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepthyphantes' AND (species='intricatus' OR species='intricatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepthyphantes' AND (species='intricatus' OR species='intricatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepthyphantes' AND (junior_species='intricatus' OR junior_species='intricatus')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='Lepthyphantes' AND (species='intricatus' OR species='intricatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermessus' AND (junior_species='trilobatus' OR junior_species='trilobatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mermessus' AND (species='trilobatus' OR species='trilobatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mermessus' AND (species='trilobatus' OR species='trilobatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermessus' AND (junior_species='trilobatus' OR junior_species='trilobatus')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='Mermessus' AND (species='trilobatus' OR species='trilobatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermessus' AND (junior_species='undulates' OR junior_species='undulates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mermessus' AND (species='undulates' OR species='undulates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mermessus' AND (species='undulates' OR species='undulates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermessus' AND (junior_species='undulates' OR junior_species='undulates')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='Mermessus' AND (species='undulates' OR species='undulates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrargus' AND (junior_species='longitarsus' OR junior_species='longitarsus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrargus' AND (species='longitarsus' OR species='longitarsus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrargus' AND (species='longitarsus' OR species='longitarsus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrargus' AND (junior_species='longitarsus' OR junior_species='longitarsus')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='Micrargus' AND (species='longitarsus' OR species='longitarsus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microlinyphia' AND (junior_species='mandibulata' OR junior_species='mandibulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microlinyphia' AND (species='mandibulata' OR species='mandibulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microlinyphia' AND (species='mandibulata' OR species='mandibulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microlinyphia' AND (junior_species='mandibulata' OR junior_species='mandibulata')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='Microlinyphia' AND (species='mandibulata' OR species='mandibulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microneta' AND (junior_species='viaria' OR junior_species='viaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microneta' AND (species='viaria' OR species='viaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microneta' AND (species='viaria' OR species='viaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microneta' AND (junior_species='viaria' OR junior_species='viaria')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='Microneta' AND (species='viaria' OR species='viaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neriene' AND (junior_species='clathrata' OR junior_species='clathrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neriene' AND (species='clathrata' OR species='clathrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neriene' AND (species='clathrata' OR species='clathrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neriene' AND (junior_species='clathrata' OR junior_species='clathrata')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='Neriene' AND (species='clathrata' OR species='clathrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neriene' AND (junior_species='radiata' OR junior_species='radiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neriene' AND (species='radiata' OR species='radiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neriene' AND (species='radiata' OR species='radiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neriene' AND (junior_species='radiata' OR junior_species='radiata')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='Neriene' AND (species='radiata' OR species='radiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odeothorax' AND (junior_species='trilobatus' OR junior_species='trilobatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odeothorax' AND (species='trilobatus' OR species='trilobatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odeothorax' AND (species='trilobatus' OR species='trilobatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odeothorax' AND (junior_species='trilobatus' OR junior_species='trilobatus')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='Odeothorax' AND (species='trilobatus' OR species='trilobatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreonetides' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreonetides' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreonetides' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreonetides' AND (junior_species='flavescens' OR junior_species='flavescens')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='Oreonetides' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreonetides' AND (junior_species='vaginatus' OR junior_species='vaginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreonetides' AND (species='vaginatus' OR species='vaginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreonetides' AND (species='vaginatus' OR species='vaginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreonetides' AND (junior_species='vaginatus' OR junior_species='vaginatus')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='Oreonetides' AND (species='vaginatus' OR species='vaginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophantes' AND (junior_species='recurvatus' OR junior_species='recurvatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreophantes' AND (species='recurvatus' OR species='recurvatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreophantes' AND (species='recurvatus' OR species='recurvatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreophantes' AND (junior_species='recurvatus' OR junior_species='recurvatus')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='Oreophantes' AND (species='recurvatus' OR species='recurvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryphantes' AND (junior_species='aliquantulus' OR junior_species='aliquantulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryphantes' AND (species='aliquantulus' OR species='aliquantulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryphantes' AND (species='aliquantulus' OR species='aliquantulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryphantes' AND (junior_species='aliquantulus' OR junior_species='aliquantulus')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='Oryphantes' AND (species='aliquantulus' OR species='aliquantulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pocadicnemis' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pocadicnemis' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pocadicnemis' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pocadicnemis' AND (junior_species='americana' OR junior_species='americana')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='Pocadicnemis' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poeciloneta' AND (junior_species='theridiformis' OR junior_species='theridiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poeciloneta' AND (species='theridiformis' OR species='theridiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poeciloneta' AND (species='theridiformis' OR species='theridiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poeciloneta' AND (junior_species='theridiformis' OR junior_species='theridiformis')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='Poeciloneta' AND (species='theridiformis' OR species='theridiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciastes' AND (junior_species='truncatus' OR junior_species='truncatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciastes' AND (species='truncatus' OR species='truncatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciastes' AND (species='truncatus' OR species='truncatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciastes' AND (junior_species='truncatus' OR junior_species='truncatus')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='Sciastes' AND (species='truncatus' OR species='truncatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scironis' AND (junior_species='tarsalis' OR junior_species='tarsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scironis' AND (species='tarsalis' OR species='tarsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scironis' AND (species='tarsalis' OR species='tarsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scironis' AND (junior_species='tarsalis' OR junior_species='tarsalis')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='Scironis' AND (species='tarsalis' OR species='tarsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotinotylus' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotinotylus' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scotinotylus' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotinotylus' AND (junior_species='pallidus' OR junior_species='pallidus')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='Scotinotylus' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisicottus' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisicottus' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisicottus' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisicottus' AND (junior_species='montanus' OR junior_species='montanus')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='Sisicottus' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisicus' AND (junior_species='penifusifer' OR junior_species='penifusifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sisicus' AND (species='penifusifer' OR species='penifusifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sisicus' AND (species='penifusifer' OR species='penifusifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sisicus' AND (junior_species='penifusifer' OR junior_species='penifusifer')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='Sisicus' AND (species='penifusifer' OR species='penifusifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylotector' AND (junior_species='stativus' OR junior_species='stativus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylotector' AND (species='stativus' OR species='stativus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylotector' AND (species='stativus' OR species='stativus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylotector' AND (junior_species='stativus' OR junior_species='stativus')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='Stylotector' AND (species='stativus' OR species='stativus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinocyba' AND (junior_species='bicarinata' OR junior_species='bicarinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinocyba' AND (species='bicarinata' OR species='bicarinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinocyba' AND (species='bicarinata' OR species='bicarinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinocyba' AND (junior_species='bicarinata' OR junior_species='bicarinata')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='Tapinocyba' AND (species='bicarinata' OR species='bicarinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinocyba' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinocyba' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinocyba' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinocyba' AND (junior_species='simplex' OR junior_species='simplex')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='Tapinocyba' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tenuiphantes' AND (junior_species='zebra' OR junior_species='zebra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tenuiphantes' AND (species='zebra' OR species='zebra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tenuiphantes' AND (species='zebra' OR species='zebra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tenuiphantes' AND (junior_species='zebra' OR junior_species='zebra')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='Tenuiphantes' AND (species='zebra' OR species='zebra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tunagyna' AND (junior_species='debilis' OR junior_species='debilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tunagyna' AND (species='debilis' OR species='debilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tunagyna' AND (species='debilis' OR species='debilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tunagyna' AND (junior_species='debilis' OR junior_species='debilis')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='Tunagyna' AND (species='debilis' OR species='debilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermontia' AND (junior_species='thoracica' OR junior_species='thoracica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vermontia' AND (species='thoracica' OR species='thoracica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vermontia' AND (species='thoracica' OR species='thoracica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermontia' AND (junior_species='thoracica' OR junior_species='thoracica')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='Vermontia' AND (species='thoracica' OR species='thoracica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wabasso' AND (junior_species='cacuminatus' OR junior_species='cacuminatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wabasso' AND (species='cacuminatus' OR species='cacuminatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wabasso' AND (species='cacuminatus' OR species='cacuminatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wabasso' AND (junior_species='cacuminatus' OR junior_species='cacuminatus')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='Wabasso' AND (species='cacuminatus' OR species='cacuminatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='atrotibialis' OR junior_species='atrotibialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='atrotibialis' OR species='atrotibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='atrotibialis' OR species='atrotibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='atrotibialis' OR junior_species='atrotibialis')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='Walckenaeria' AND (species='atrotibialis' OR species='atrotibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='castanea' OR junior_species='castanea')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='Walckenaeria' AND (species='castanea' OR species='castanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='communis' OR junior_species='communis')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='Walckenaeria' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='digitata' OR junior_species='digitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='digitata' OR species='digitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='digitata' OR species='digitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='digitata' OR junior_species='digitata')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='Walckenaeria' AND (species='digitata' OR species='digitata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='directa' OR junior_species='directa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='directa' OR species='directa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='directa' OR species='directa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='directa' OR junior_species='directa')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='Walckenaeria' AND (species='directa' OR species='directa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='exigua' OR junior_species='exigua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='exigua' OR species='exigua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='exigua' OR species='exigua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='exigua' OR junior_species='exigua')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='Walckenaeria' AND (species='exigua' OR species='exigua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='fallax' OR junior_species='fallax')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='Walckenaeria' AND (species='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='tibialis' OR junior_species='tibialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='tibialis' OR species='tibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='tibialis' OR species='tibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='tibialis' OR junior_species='tibialis')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='Walckenaeria' AND (species='tibialis' OR species='tibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='tricornis' OR junior_species='tricornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Walckenaeria' AND (species='tricornis' OR species='tricornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Walckenaeria' AND (species='tricornis' OR species='tricornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Walckenaeria' AND (junior_species='tricornis' OR junior_species='tricornis')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='Walckenaeria' AND (species='tricornis' OR species='tricornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zornella' AND (junior_species='cultrigera' OR junior_species='cultrigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zornella' AND (species='cultrigera' OR species='cultrigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zornella' AND (species='cultrigera' OR species='cultrigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zornella' AND (junior_species='cultrigera' OR junior_species='cultrigera')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='Zornella' AND (species='cultrigera' OR species='cultrigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agroeca' 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='Agroeca' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agroeca' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agroeca' 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='Agroeca' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopecosa' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alopecosa' AND (species='aculeata' OR species='aculeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alopecosa' AND (species='aculeata' OR species='aculeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopecosa' AND (junior_species='aculeata' OR junior_species='aculeata')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='Alopecosa' AND (species='aculeata' OR species='aculeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctosa' AND (junior_species='raptor' OR junior_species='raptor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctosa' AND (species='raptor' OR species='raptor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctosa' AND (species='raptor' OR species='raptor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctosa' AND (junior_species='raptor' OR junior_species='raptor')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='Arctosa' AND (species='raptor' OR species='raptor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctosa' AND (junior_species='rubicunda' OR junior_species='rubicunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctosa' AND (species='rubicunda' OR species='rubicunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctosa' AND (species='rubicunda' OR species='rubicunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctosa' AND (junior_species='rubicunda' OR junior_species='rubicunda')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='Arctosa' AND (species='rubicunda' OR species='rubicunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hogna' AND (junior_species='frondicola' OR junior_species='frondicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hogna' AND (species='frondicola' OR species='frondicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hogna' AND (species='frondicola' OR species='frondicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hogna' AND (junior_species='frondicola' OR junior_species='frondicola')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='Hogna' AND (species='frondicola' OR species='frondicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='fuscula' OR junior_species='fuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='fuscula' OR species='fuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='fuscula' OR species='fuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='fuscula' OR junior_species='fuscula')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='Pardosa' AND (species='fuscula' OR species='fuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='hyperborea' OR junior_species='hyperborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='hyperborea' OR species='hyperborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='hyperborea' OR species='hyperborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='hyperborea' OR junior_species='hyperborea')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='Pardosa' AND (species='hyperborea' OR species='hyperborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='mackenziana' OR junior_species='mackenziana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='mackenziana' OR species='mackenziana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='mackenziana' OR species='mackenziana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='mackenziana' OR junior_species='mackenziana')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='Pardosa' AND (species='mackenziana' OR species='mackenziana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='milvina' OR junior_species='milvina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='milvina' OR species='milvina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='milvina' OR species='milvina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='milvina' OR junior_species='milvina')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='Pardosa' AND (species='milvina' OR species='milvina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='moesta' OR junior_species='moesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='moesta' OR species='moesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='moesta' OR species='moesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='moesta' OR junior_species='moesta')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='Pardosa' AND (species='moesta' OR species='moesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='uintana' OR junior_species='uintana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='uintana' OR species='uintana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='uintana' OR species='uintana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='uintana' OR junior_species='uintana')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='Pardosa' AND (species='uintana' OR species='uintana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='xerampelina' OR junior_species='xerampelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='xerampelina' OR species='xerampelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='xerampelina' OR species='xerampelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='xerampelina' OR junior_species='xerampelina')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='Pardosa' AND (species='xerampelina' OR species='xerampelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='bryantae' OR junior_species='bryantae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirata' AND (species='bryantae' OR species='bryantae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirata' AND (species='bryantae' OR species='bryantae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='bryantae' OR junior_species='bryantae')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='Pirata' AND (species='bryantae' OR species='bryantae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='cantralli' OR junior_species='cantrallii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirata' AND (species='cantralli' OR species='cantrallii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirata' AND (species='cantralli' OR species='cantrallii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='cantralli' OR junior_species='cantrallii')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='Pirata' AND (species='cantralli' OR species='cantrallii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirata' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirata' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='minutus' OR junior_species='minutus')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='Pirata' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirata' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirata' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='montanus' OR junior_species='montanus')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='Pirata' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='piraticus' OR junior_species='piraticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirata' AND (species='piraticus' OR species='piraticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirata' AND (species='piraticus' OR species='piraticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirata' AND (junior_species='piraticus' OR junior_species='piraticus')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='Pirata' AND (species='piraticus' OR species='piraticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochosa' AND (junior_species='terricola' OR junior_species='terricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trochosa' AND (species='terricola' OR species='terricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trochosa' AND (species='terricola' OR species='terricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochosa' AND (junior_species='terricola' OR junior_species='terricola')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='Trochosa' AND (species='terricola' OR species='terricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thanatus' AND (junior_species='formicinus' OR junior_species='formicinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thanatus' AND (species='formicinus' OR species='formicinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thanatus' AND (species='formicinus' OR species='formicinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thanatus' AND (junior_species='formicinus' OR junior_species='formicinus')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='Thanatus' AND (species='formicinus' OR species='formicinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tibellus' AND (junior_species='oblongus' OR junior_species='oblongus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tibellus' AND (species='oblongus' OR species='oblongus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tibellus' AND (species='oblongus' OR species='oblongus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tibellus' AND (junior_species='oblongus' OR junior_species='oblongus')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='Tibellus' AND (species='oblongus' OR species='oblongus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolomedes' 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='Dolomedes' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolomedes' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolomedes' 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='Dolomedes' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neon' AND (junior_species='nellii' OR junior_species='nelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neon' AND (species='nellii' OR species='nelli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neon' AND (species='nellii' OR species='nelli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neon' AND (junior_species='nellii' OR junior_species='nelli')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='Neon' AND (species='nellii' OR species='nelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelegrina' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelegrina' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelegrina' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelegrina' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pelegrina' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellenes' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellenes' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellenes' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellenes' AND (junior_species='montanus' OR junior_species='montanus')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='Pellenes' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phidippus' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phidippus' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='borealis' OR junior_species='borealis')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='Phidippus' AND (species='borealis' OR species='borealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitticus' AND (junior_species='finschii' OR junior_species='finschi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sitticus' AND (species='finschii' OR species='finschi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sitticus' AND (species='finschii' OR species='finschi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sitticus' AND (junior_species='finschii' OR junior_species='finschi')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='Sitticus' AND (species='finschii' OR species='finschi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theonoe' AND (junior_species='stridula' OR junior_species='stridula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theonoe' AND (species='stridula' OR species='stridula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theonoe' AND (species='stridula' OR species='stridula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theonoe' AND (junior_species='stridula' OR junior_species='stridula')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='Theonoe' AND (species='stridula' OR species='stridula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='differens' OR junior_species='differens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='differens' OR species='differens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='differens' OR species='differens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='differens' OR junior_species='differens')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='Theridion' AND (species='differens' OR species='differens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridula' AND (junior_species='emertoni' OR junior_species='emertonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridula' AND (species='emertoni' OR species='emertonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridula' AND (species='emertoni' OR species='emertonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridula' AND (junior_species='emertoni' OR junior_species='emertonii')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='Theridula' AND (species='emertoni' OR species='emertonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassaniana' AND (junior_species='utahensis' OR junior_species='utahensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassaniana' AND (species='utahensis' OR species='utahensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassaniana' AND (species='utahensis' OR species='utahensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassaniana' AND (junior_species='utahensis' OR junior_species='utahensis')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='Bassaniana' AND (species='utahensis' OR species='utahensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ozyptila' AND (junior_species='sincera' OR junior_species='sincera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ozyptila' AND (species='sincera' OR species='sincera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ozyptila' AND (species='sincera' OR species='sincera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ozyptila' AND (junior_species='sincera' OR junior_species='sincera')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='Ozyptila' AND (species='sincera' OR species='sincera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Xysticus' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='ellipticus' OR junior_species='ellipticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='ellipticus' OR species='ellipticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='ellipticus' OR species='ellipticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='ellipticus' OR junior_species='ellipticus')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='Xysticus' AND (species='ellipticus' OR species='ellipticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='emertoni' OR junior_species='emertonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='emertoni' OR species='emertonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='emertoni' OR species='emertonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='emertoni' OR junior_species='emertonii')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='Xysticus' AND (species='emertoni' OR species='emertonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='luctuosus' OR junior_species='luctuosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='luctuosus' OR species='luctuosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='luctuosus' OR species='luctuosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='luctuosus' OR junior_species='luctuosus')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='Xysticus' AND (species='luctuosus' OR species='luctuosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='obscurus' OR junior_species='obscurus')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='Xysticus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' 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='Xysticus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' 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='Xysticus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=300 The Ecological Register: Abitibi Claybelt
Abitibi Claybelt
Basic information
Sample name: Abitibi Claybelt

Reference: S. Paradis and T. T. Work. 2011. Partial cutting does not maintain spider assemblages within the observed range of natural variability in Eastern Canadian black spruce forests. Forest Ecology and Management 262:2079-1093 [ER 129]
Geography
Country: Canada

State: Quebec


Coordinate: 49° N, -79° W
Environment
Habitat: boreal forest/taiga

Substrate: ground surface

MAT: 0.7

MAP: 889.8

Habitat comments: black spruce-feather moss bioclimatic domain

Methods
Life forms: spiders

Sampling methods: pitfall traps

Sample size: 9450 captures or sightings

Years: 2007-2008

Metadata
Sample number: 300

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-04-10 16:09:23

Modified: 2013-04-10 06:09:23

Abundance distribution
128 species
24 singletons
total count 9450
extrapolated richness: 180.6
Fisher's α: 20.933
geometric series k: 0.9454
Hurlbert's PIE: 0.9447
Shannon's H: 3.3851
Good's u: 0.9975
Each square represents a species. Square sizes are proportional to counts.
Register
Agelenopsis utahana32
Amaurobius borealis121
Callobius bennetti10
Cybaeopsis euopla384
Cybaeopsis tibialis126
Clubiona canadensis3
Clubiona kulczynskii5
Drassodes neglectus6
Gnaphosa brumalis2
Gnaphosa microps882
Gnaphosa muscorum75
Gnaphosa parvula17
Haplodrassus hiemalis21
Haplodrassus signifier14
Micaria aenea30
Zelotes fratris21
Zelotes puritanus6
Zelotes sula1
Cicurina brevis73
Antistea brunnea88
Hahnia cinerea340
Neoantistea agilis8
Neoantistea magna46
Agyneta allosubtilis4
Agyneta olivacea98
Agyneta simplex6
Allomengea dentisetis1
Aphileta misera8
Bathyphantes pallidus15
Bathyphantes simillimus27
Carorita limnaea12
Centromerus longibulbus24
Ceraticelus fissiceps10
Ceraticelus laetabilis1
Ceraticelus laetus14
Ceraticelus similis1
Ceratinella brunnea6
Ceratinella buna109
Ceratinops annulipes6
Ceratinopsis auriculata1
Ceratinopsis labradorensis8
Cnephalocotes obscurus6
Diplocentria bidentata293
Diplocentria rectangulata17
Gonatium crassipalpum7
Grammonota angusta1
Grammonota gentilis2
Grammonota gigas22
Helophora insignis1
Hybauchenidium cymbadentatum6
Improphantes complicatus24
Incestophantes washingtoni2
Islandiana longisetosa1
Lepthyphantes alpinus13
Lepthyphantes intricatus5
Mermessus trilobatus9
Mermessus undulates1
Micrargus longitarsus6
Microlinyphia mandibulata2
Microneta viaria2
Neriene clathrata3
Neriene radiata1
Odeothorax trilobatus12
Oreonetides flavescens7
Oreonetides vaginatus11
Oreophantes recurvatus5
Oryphantes aliquantulus16
Pocadicnemis americana216
Poeciloneta theridiformis1
Sciastes truncatus263
Scironis tarsalis1
Scotinotylus pallidus16
Sisicottus montanus7
Sisicus penifusifer1
Stylotector stativus6
Tapinocyba bicarinata15
Tapinocyba simplex40
Tenuiphantes zebra2
Tunagyna debilis25
Vermontia thoracica17
Wabasso cacuminatus1
Walckenaeria atrotibialis75
Walckenaeria castanea16
Walckenaeria communis24
Walckenaeria digitata5
Walckenaeria directa32
Walckenaeria exigua10
Walckenaeria fallax5
Walckenaeria tibialis1
Walckenaeria tricornis27
Zornella cultrigera1
Agroeca ornata102
Alopecosa aculeata353
Arctosa raptor2
Arctosa rubicunda1
Hogna frondicola1
Pardosa fuscula42
Pardosa hyperborea809
Pardosa mackenziana429
Pardosa milvina2
Pardosa moesta1243
Pardosa uintana469
Pardosa xerampelina492
Pirata bryantae135
Pirata cantralli551
Pirata minutus1
Pirata montanus12
Pirata piraticus7
Trochosa terricola515
Thanatus formicinus10
Tibellus oblongus2
Dolomedes striatus10
Neon nellii28
Pelegrina flavipes1
Pellenes montanus1
Phidippus borealis3
Sitticus finschii2
Theonoe stridula22
Theridion differens1
Theridula emertoni1
Bassaniana utahensis1
Ozyptila sincera canadensis160
Xysticus canadensis6
Xysticus ellipticus2
Xysticus emertoni36
Xysticus luctuosus15
Xysticus obscurus36
Xysticus punctatus3