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=3105 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3105SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2896SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3105 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelena' AND (junior_species='labyrinthica' OR junior_species='labyrinthica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agelena' AND (species='labyrinthica' OR species='labyrinthica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agelena' AND (species='labyrinthica' OR species='labyrinthica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelena' AND (junior_species='labyrinthica' OR junior_species='labyrinthica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agelena' AND (species='labyrinthica' OR species='labyrinthica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegenaria' AND (junior_species='feminea' OR junior_species='feminea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegenaria' AND (species='feminea' OR species='feminea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegenaria' AND (species='feminea' OR species='feminea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegenaria' AND (junior_species='feminea' OR junior_species='feminea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tegenaria' AND (species='feminea' OR species='feminea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aculepeira' AND (junior_species='armida' OR junior_species='armida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aculepeira' AND (species='armida' OR species='armida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aculepeira' AND (species='armida' OR species='armida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aculepeira' AND (junior_species='armida' OR junior_species='armida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aculepeira' AND (species='armida' OR species='armida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agalenatea' AND (junior_species='redii' OR junior_species='redi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agalenatea' AND (species='redii' OR species='redi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agalenatea' AND (species='redii' OR species='redi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agalenatea' AND (junior_species='redii' OR junior_species='redi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agalenatea' AND (species='redii' OR species='redi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='insulana' OR junior_species='insulana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclosa' AND (species='insulana' OR species='insulana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclosa' AND (species='insulana' OR species='insulana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='insulana' OR junior_species='insulana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclosa' AND (species='insulana' OR species='insulana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsosinga' AND (junior_species='albovittata' OR junior_species='albovittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsosinga' AND (species='albovittata' OR species='albovittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsosinga' AND (species='albovittata' OR species='albovittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsosinga' AND (junior_species='albovittata' OR junior_species='albovittata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypsosinga' AND (species='albovittata' OR species='albovittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangora' AND (junior_species='acalypha' OR junior_species='acalypha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangora' AND (species='acalypha' OR species='acalypha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangora' AND (species='acalypha' OR species='acalypha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangora' AND (junior_species='acalypha' OR junior_species='acalypha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mangora' AND (species='acalypha' OR species='acalypha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='adianta' OR junior_species='adianta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='adianta' OR species='adianta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='adianta' OR species='adianta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='adianta' OR junior_species='adianta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neoscona' AND (species='adianta' OR species='adianta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Singa' AND (junior_species='neta' OR junior_species='neta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Singa' AND (species='neta' OR species='neta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Singa' AND (species='neta' OR species='neta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Singa' AND (junior_species='neta' OR junior_species='neta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Singa' AND (species='neta' OR species='neta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='genevensis' OR junior_species='genevensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='genevensis' OR species='genevensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='genevensis' OR species='genevensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='genevensis' OR junior_species='genevensis')SELECT d.diet,d.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='genevensis' OR species='genevensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clubiona' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeodictyna' AND (junior_species='consecuta' OR junior_species='consecuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeodictyna' AND (species='consecuta' OR species='consecuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeodictyna' AND (species='consecuta' OR species='consecuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeodictyna' AND (junior_species='consecuta' OR junior_species='consecuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeodictyna' AND (species='consecuta' OR species='consecuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dictyna' AND (junior_species='civica' OR junior_species='civica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dictyna' AND (species='civica' OR species='civica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dictyna' AND (species='civica' OR species='civica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dictyna' AND (junior_species='civica' OR junior_species='civica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dictyna' AND (species='civica' OR species='civica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathys' 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='Lathys' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lathys' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathys' 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='Lathys' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysdera' AND (junior_species='alentejana' OR junior_species='alentejana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysdera' AND (species='alentejana' OR species='alentejana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysdera' AND (species='alentejana' OR species='alentejana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysdera' AND (junior_species='alentejana' OR junior_species='alentejana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dysdera' AND (species='alentejana' OR species='alentejana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpactea' AND (junior_species='minoccii' OR junior_species='minocci')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpactea' AND (species='minoccii' OR species='minocci') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpactea' AND (species='minoccii' OR species='minocci')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpactea' AND (junior_species='minoccii' OR junior_species='minocci')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpactea' AND (species='minoccii' OR species='minocci') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pritha' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pritha' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pritha' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pritha' AND (junior_species='pallida' OR junior_species='pallida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pritha' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='lapidosus' OR junior_species='lapidosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drassodes' AND (species='lapidosus' OR species='lapidosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drassodes' AND (species='lapidosus' OR species='lapidosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='lapidosus' OR junior_species='lapidosus')SELECT d.diet,d.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='lapidosus' OR species='lapidosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drassodes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drassodes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drassodes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drassodes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='macellinus' OR junior_species='macellinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplodrassus' AND (species='macellinus' OR species='macellinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplodrassus' AND (species='macellinus' OR species='macellinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='macellinus' OR junior_species='macellinus')SELECT d.diet,d.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='macellinus' OR species='macellinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplodrassus' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplodrassus' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplodrassus' AND (junior_species='minor' OR junior_species='minor')SELECT d.diet,d.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='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodrassus' AND (junior_species='albidus' OR junior_species='albidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodrassus' AND (species='albidus' OR species='albidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodrassus' AND (species='albidus' OR species='albidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodrassus' AND (junior_species='albidus' OR junior_species='albidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodrassus' AND (species='albidus' OR species='albidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodrassus' AND (junior_species='simoni' OR junior_species='simonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodrassus' AND (species='simoni' OR species='simonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodrassus' AND (species='simoni' OR species='simonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodrassus' AND (junior_species='simoni' OR junior_species='simonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodrassus' AND (species='simoni' OR species='simonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaria' AND (junior_species='coarctata' OR junior_species='coarctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micaria' AND (species='coarctata' OR species='coarctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micaria' AND (species='coarctata' OR species='coarctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaria' AND (junior_species='coarctata' OR junior_species='coarctata')SELECT d.diet,d.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='coarctata' OR species='coarctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomisia' AND (junior_species='excerpta' OR junior_species='excerpta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomisia' AND (species='excerpta' OR species='excerpta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomisia' AND (species='excerpta' OR species='excerpta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomisia' AND (junior_species='excerpta' OR junior_species='excerpta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nomisia' AND (species='excerpta' OR species='excerpta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomisia' AND (junior_species='exornata' OR junior_species='exornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nomisia' AND (species='exornata' OR species='exornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nomisia' AND (species='exornata' OR species='exornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nomisia' AND (junior_species='exornata' OR junior_species='exornata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nomisia' AND (species='exornata' OR species='exornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterotricha' AND (junior_species='simoni' OR junior_species='simonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterotricha' AND (species='simoni' OR species='simonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterotricha' AND (species='simoni' OR species='simonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterotricha' AND (junior_species='simoni' OR junior_species='simonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterotricha' AND (species='simoni' OR species='simonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='bardiae' OR junior_species='bardiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyzelote' AND (species='bardiae' OR species='bardiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyzelote' AND (species='bardiae' OR species='bardiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='bardiae' OR junior_species='bardiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachyzelote' AND (species='bardiae' OR species='bardiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyzelote' AND (species='fuscipes' OR species='fuscipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyzelote' AND (species='fuscipes' OR species='fuscipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachyzelote' AND (species='fuscipes' OR species='fuscipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='holosericeus' OR junior_species='holosericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyzelote' AND (species='holosericeus' OR species='holosericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyzelote' AND (species='holosericeus' OR species='holosericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyzelote' AND (junior_species='holosericeus' OR junior_species='holosericeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachyzelote' AND (species='holosericeus' OR species='holosericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelominor' AND (junior_species='algarvensis' OR junior_species='algarvensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelominor' AND (species='algarvensis' OR species='algarvensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelominor' AND (species='algarvensis' OR species='algarvensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelominor' AND (junior_species='algarvensis' OR junior_species='algarvensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelominor' AND (species='algarvensis' OR species='algarvensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='gallicus' OR junior_species='gallicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='gallicus' OR species='gallicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='gallicus' OR species='gallicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='gallicus' OR junior_species='gallicus')SELECT d.diet,d.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='gallicus' OR species='gallicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='denisi' OR junior_species='denisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='denisi' OR species='denisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='denisi' OR species='denisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='denisi' OR junior_species='denisii')SELECT d.diet,d.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='denisi' OR species='denisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zelotes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zelotes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zelotes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hahnia' AND (junior_species='nava' OR junior_species='nava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hahnia' AND (species='nava' OR species='nava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hahnia' AND (species='nava' OR species='nava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hahnia' AND (junior_species='nava' OR junior_species='nava')SELECT d.diet,d.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='nava' OR species='nava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didectoprocnemis' AND (junior_species='cirtensis' OR junior_species='cirtensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didectoprocnemis' AND (species='cirtensis' OR species='cirtensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Didectoprocnemis' AND (species='cirtensis' OR species='cirtensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didectoprocnemis' AND (junior_species='cirtensis' OR junior_species='cirtensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Didectoprocnemis' AND (species='cirtensis' OR species='cirtensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocephalus' AND (junior_species='graecus' OR junior_species='graecus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplocephalus' AND (species='graecus' OR species='graecus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplocephalus' AND (species='graecus' OR species='graecus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocephalus' AND (junior_species='graecus' OR junior_species='graecus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diplocephalus' AND (species='graecus' OR species='graecus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erigone' AND (junior_species='dentipalpis' OR junior_species='dentipalpis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erigone' AND (species='dentipalpis' OR species='dentipalpis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erigone' AND (species='dentipalpis' OR species='dentipalpis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erigone' AND (junior_species='dentipalpis' OR junior_species='dentipalpis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erigone' AND (species='dentipalpis' OR species='dentipalpis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meioneta' AND (junior_species='pseudorurestris' OR junior_species='pseudorurestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meioneta' AND (species='pseudorurestris' OR species='pseudorurestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meioneta' AND (species='pseudorurestris' OR species='pseudorurestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meioneta' AND (junior_species='pseudorurestris' OR junior_species='pseudorurestris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meioneta' AND (species='pseudorurestris' OR species='pseudorurestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrargus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrargus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrargus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrargus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrargus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecopsis' AND (junior_species='bucephala' OR junior_species='bucephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelecopsis' AND (species='bucephala' OR species='bucephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelecopsis' AND (species='bucephala' OR species='bucephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecopsis' AND (junior_species='bucephala' OR junior_species='bucephala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pelecopsis' AND (species='bucephala' OR species='bucephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecopsis' AND (junior_species='inedita' OR junior_species='inedita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelecopsis' AND (species='inedita' OR species='inedita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelecopsis' AND (species='inedita' OR species='inedita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecopsis' AND (junior_species='inedita' OR junior_species='inedita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pelecopsis' AND (species='inedita' OR species='inedita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinerigone' AND (junior_species='vagans' OR junior_species='vagans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinerigone' AND (species='vagans' OR species='vagans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinerigone' AND (species='vagans' OR species='vagans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinerigone' AND (junior_species='vagans' OR junior_species='vagans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prinerigone' AND (species='vagans' OR species='vagans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styloctetor' AND (junior_species='romanus' OR junior_species='romanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styloctetor' AND (species='romanus' OR species='romanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styloctetor' AND (species='romanus' OR species='romanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styloctetor' AND (junior_species='romanus' OR junior_species='romanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Styloctetor' AND (species='romanus' OR species='romanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tenuiphantes' AND (junior_species='tenuis' OR junior_species='tenuis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tenuiphantes' AND (species='tenuis' OR species='tenuis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tenuiphantes' AND (species='tenuis' OR species='tenuis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tenuiphantes' AND (junior_species='tenuis' OR junior_species='tenuis')SELECT d.diet,d.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='tenuis' OR species='tenuis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesiotelus' AND (junior_species='mauritanicus' OR junior_species='mauritanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesiotelus' AND (species='mauritanicus' OR species='mauritanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesiotelus' AND (species='mauritanicus' OR species='mauritanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesiotelus' AND (junior_species='mauritanicus' OR junior_species='mauritanicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesiotelus' AND (species='mauritanicus' OR species='mauritanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopecosa' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alopecosa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alopecosa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alopecosa' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alopecosa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='tarantula' OR junior_species='tarantula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycosa' AND (species='tarantula' OR species='tarantula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycosa' AND (species='tarantula' OR species='tarantula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='tarantula' OR junior_species='tarantula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lycosa' AND (species='tarantula' OR species='tarantula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='proxima' OR junior_species='proxima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardosa' AND (species='proxima' OR species='proxima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardosa' AND (species='proxima' OR species='proxima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardosa' AND (junior_species='proxima' OR junior_species='proxima')SELECT d.diet,d.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='proxima' OR species='proxima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ero' AND (junior_species='aphana' OR junior_species='aphana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ero' AND (species='aphana' OR species='aphana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ero' AND (species='aphana' OR species='aphana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ero' AND (junior_species='aphana' OR junior_species='aphana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ero' AND (species='aphana' OR species='aphana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheiracanthium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheiracanthium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cheiracanthium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='striolatum' OR junior_species='striolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheiracanthium' AND (species='striolatum' OR species='striolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheiracanthium' AND (species='striolatum' OR species='striolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='striolatum' OR junior_species='striolatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cheiracanthium' AND (species='striolatum' OR species='striolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecobius' AND (junior_species='machadoi' OR junior_species='machadoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecobius' AND (species='machadoi' OR species='machadoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oecobius' AND (species='machadoi' OR species='machadoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecobius' AND (junior_species='machadoi' OR junior_species='machadoii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oecobius' AND (species='machadoi' OR species='machadoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oonops' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oonops' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oonops' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oonops' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oonops' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silhouettella' AND (junior_species='loricatula' OR junior_species='loricatula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Silhouettella' AND (species='loricatula' OR species='loricatula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Silhouettella' AND (species='loricatula' OR species='loricatula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silhouettella' AND (junior_species='loricatula' OR junior_species='loricatula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Silhouettella' AND (species='loricatula' OR species='loricatula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='heterophthalmus' OR junior_species='heterophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='heterophthalmus' OR junior_species='heterophthalmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxyopes' AND (species='heterophthalmus' OR species='heterophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxyopes' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpimanus' AND (junior_species='gibbulus' OR junior_species='gibbulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palpimanus' AND (species='gibbulus' OR species='gibbulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palpimanus' AND (species='gibbulus' OR species='gibbulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpimanus' AND (junior_species='gibbulus' OR junior_species='gibbulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palpimanus' AND (species='gibbulus' OR species='gibbulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='cespitum' OR junior_species='cespitum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodromus' AND (species='cespitum' OR species='cespitum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodromus' AND (species='cespitum' OR species='cespitum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='cespitum' OR junior_species='cespitum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philodromus' AND (species='cespitum' OR species='cespitum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philodromus' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philodromus' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philodromus' AND (junior_species='rufus' OR junior_species='rufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philodromus' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thanatus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thanatus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thanatus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thanatus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT d.diet,d.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='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holocnemus' AND (junior_species='hispanicus' OR junior_species='hispanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holocnemus' AND (species='hispanicus' OR species='hispanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holocnemus' AND (species='hispanicus' OR species='hispanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holocnemus' AND (junior_species='hispanicus' OR junior_species='hispanicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Holocnemus' AND (species='hispanicus' OR species='hispanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisaura' AND (junior_species='mirabilis' OR junior_species='mirabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pisaura' AND (species='mirabilis' OR species='mirabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pisaura' AND (species='mirabilis' OR species='mirabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisaura' AND (junior_species='mirabilis' OR junior_species='mirabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pisaura' AND (species='mirabilis' OR species='mirabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodidomus' AND (junior_species='amaranthinus' OR junior_species='amaranthinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodidomus' AND (species='amaranthinus' OR species='amaranthinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodidomus' AND (species='amaranthinus' OR species='amaranthinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodidomus' AND (junior_species='amaranthinus' OR junior_species='amaranthinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prodidomus' AND (species='amaranthinus' OR species='amaranthinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aelurillus' 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='Aelurillus' AND (species='luctuosus' OR species='luctuosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aelurillus' AND (species='luctuosus' OR species='luctuosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aelurillus' 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='Aelurillus' AND (species='luctuosus' OR species='luctuosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcoscirtus' AND (junior_species='infimus' OR junior_species='infimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcoscirtus' AND (species='infimus' OR species='infimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcoscirtus' AND (species='infimus' OR species='infimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcoscirtus' AND (junior_species='infimus' OR junior_species='infimus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chalcoscirtus' AND (species='infimus' OR species='infimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrba' AND (junior_species='algerina' OR junior_species='algerina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrba' AND (species='algerina' OR species='algerina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrba' AND (species='algerina' OR species='algerina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrba' AND (junior_species='algerina' OR junior_species='algerina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyrba' AND (species='algerina' OR species='algerina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euophrys' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euophrys' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euophrys' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euophrys' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euophrys' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euophrys' AND (junior_species='sulphurea' OR junior_species='sulphurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euophrys' AND (species='sulphurea' OR species='sulphurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euophrys' AND (species='sulphurea' OR species='sulphurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euophrys' AND (junior_species='sulphurea' OR junior_species='sulphurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euophrys' AND (species='sulphurea' OR species='sulphurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evarcha' AND (junior_species='jucunda' OR junior_species='jucunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evarcha' AND (species='jucunda' OR species='jucunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evarcha' AND (species='jucunda' OR species='jucunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evarcha' AND (junior_species='jucunda' OR junior_species='jucunda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Evarcha' AND (species='jucunda' OR species='jucunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophanus' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliophanus' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliophanus' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophanus' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliophanus' AND (species='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophanus' AND (junior_species='lineiventris' OR junior_species='lineiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliophanus' AND (species='lineiventris' OR species='lineiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliophanus' AND (species='lineiventris' OR species='lineiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophanus' AND (junior_species='lineiventris' OR junior_species='lineiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliophanus' AND (species='lineiventris' OR species='lineiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptorchestes' AND (junior_species='mutilloides' OR junior_species='mutilloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptorchestes' AND (species='mutilloides' OR species='mutilloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptorchestes' AND (species='mutilloides' OR species='mutilloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptorchestes' AND (junior_species='mutilloides' OR junior_species='mutilloides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptorchestes' AND (species='mutilloides' OR species='mutilloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menemerus' AND (junior_species='semilimbatus' OR junior_species='semilimbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menemerus' AND (species='semilimbatus' OR species='semilimbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menemerus' AND (species='semilimbatus' OR species='semilimbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menemerus' AND (junior_species='semilimbatus' OR junior_species='semilimbatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Menemerus' AND (species='semilimbatus' OR species='semilimbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellenes' AND (junior_species='nigrociliatus' OR junior_species='nigrociliatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellenes' AND (species='nigrociliatus' OR species='nigrociliatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellenes' AND (species='nigrociliatus' OR species='nigrociliatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellenes' AND (junior_species='nigrociliatus' OR junior_species='nigrociliatus')SELECT d.diet,d.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='nigrociliatus' OR species='nigrociliatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='propinquus' OR junior_species='propinquus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salticus' AND (species='propinquus' OR species='propinquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salticus' AND (species='propinquus' OR species='propinquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='propinquus' OR junior_species='propinquus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salticus' AND (species='propinquus' OR species='propinquus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='scenicus' OR junior_species='scenicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salticus' AND (species='scenicus' OR species='scenicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salticus' AND (species='scenicus' OR species='scenicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='scenicus' OR junior_species='scenicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salticus' AND (species='scenicus' OR species='scenicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyene' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyene' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyene' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyene' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thyene' AND (species='imperialis' OR species='imperialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytodes' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scytodes' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scytodes' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytodes' AND (junior_species='velutina' OR junior_species='velutina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scytodes' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadna' AND (junior_species='insidiatrix' OR junior_species='insidiatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ariadna' AND (species='insidiatrix' OR species='insidiatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ariadna' AND (species='insidiatrix' OR species='insidiatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadna' AND (junior_species='insidiatrix' OR junior_species='insidiatrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ariadna' AND (species='insidiatrix' OR species='insidiatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxosceles' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxosceles' AND (species='rufescens' OR species='rufescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxosceles' AND (species='rufescens' OR species='rufescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxosceles' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loxosceles' AND (species='rufescens' OR species='rufescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eusparassus' AND (junior_species='dufouri' OR junior_species='dufourii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eusparassus' AND (species='dufouri' OR species='dufourii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eusparassus' AND (species='dufouri' OR species='dufourii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eusparassus' AND (junior_species='dufouri' OR junior_species='dufourii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eusparassus' AND (species='dufouri' OR species='dufourii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetragnatha' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episinus' AND (junior_species='maculipes' OR junior_species='maculipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episinus' AND (species='maculipes' OR species='maculipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episinus' AND (species='maculipes' OR species='maculipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episinus' AND (junior_species='maculipes' OR junior_species='maculipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Episinus' AND (species='maculipes' OR species='maculipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episinus' 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='Episinus' AND (species='truncatus' OR species='truncatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episinus' AND (species='truncatus' OR species='truncatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episinus' 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='Episinus' AND (species='truncatus' OR species='truncatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryopis' AND (junior_species='episinoides' OR junior_species='episinoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euryopis' AND (species='episinoides' OR species='episinoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euryopis' AND (species='episinoides' OR species='episinoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryopis' AND (junior_species='episinoides' OR junior_species='episinoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euryopis' AND (species='episinoides' OR species='episinoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kochiura' AND (junior_species='aulica' OR junior_species='aulica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kochiura' AND (species='aulica' OR species='aulica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kochiura' AND (species='aulica' OR species='aulica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kochiura' AND (junior_species='aulica' OR junior_species='aulica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kochiura' AND (species='aulica' OR species='aulica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasaeola' AND (junior_species='testaceomarginata' OR junior_species='testaceomarginata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasaeola' AND (species='testaceomarginata' OR species='testaceomarginata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasaeola' AND (species='testaceomarginata' OR species='testaceomarginata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasaeola' AND (junior_species='testaceomarginata' OR junior_species='testaceomarginata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasaeola' AND (species='testaceomarginata' OR species='testaceomarginata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Robertus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Robertus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Robertus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Robertus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Robertus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simitidion' AND (junior_species='simile' OR junior_species='simile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simitidion' AND (species='simile' OR species='simile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simitidion' AND (species='simile' OR species='simile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simitidion' AND (junior_species='simile' OR junior_species='simile')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Simitidion' AND (species='simile' OR species='simile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatoda' AND (junior_species='triangulosa' OR junior_species='triangulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steatoda' AND (species='triangulosa' OR species='triangulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steatoda' AND (species='triangulosa' OR species='triangulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatoda' AND (junior_species='triangulosa' OR junior_species='triangulosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Steatoda' AND (species='triangulosa' OR species='triangulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridiidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridiidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridiidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridiidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridiidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theridiidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theridion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='impressum' OR junior_species='impressum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='impressum' OR species='impressum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='impressum' OR species='impressum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='impressum' OR junior_species='impressum')SELECT d.diet,d.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='impressum' OR species='impressum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='nigropunctatum' OR junior_species='nigropunctatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theridion' AND (species='nigropunctatum' OR species='nigropunctatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridion' AND (species='nigropunctatum' OR species='nigropunctatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridion' AND (junior_species='nigropunctatum' OR junior_species='nigropunctatum')SELECT d.diet,d.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='nigropunctatum' OR species='nigropunctatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monaeses' AND (junior_species='paradoxus' OR junior_species='paradoxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monaeses' AND (species='paradoxus' OR species='paradoxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monaeses' AND (species='paradoxus' OR species='paradoxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monaeses' AND (junior_species='paradoxus' OR junior_species='paradoxus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monaeses' AND (species='paradoxus' OR species='paradoxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runcinia' AND (junior_species='grammica' OR junior_species='grammica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Runcinia' AND (species='grammica' OR species='grammica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Runcinia' AND (species='grammica' OR species='grammica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runcinia' AND (junior_species='grammica' OR junior_species='grammica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Runcinia' AND (species='grammica' OR species='grammica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synema' AND (junior_species='globosum' OR junior_species='globosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synema' AND (species='globosum' OR species='globosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synema' AND (species='globosum' OR species='globosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synema' AND (junior_species='globosum' OR junior_species='globosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synema' AND (species='globosum' OR species='globosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='onustus' OR junior_species='onustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomisus' AND (species='onustus' OR species='onustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thomisus' AND (species='onustus' OR species='onustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomisus' AND (junior_species='onustus' OR junior_species='onustus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thomisus' AND (species='onustus' OR species='onustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmarus' AND (junior_species='staintoni' OR junior_species='staintonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tmarus' AND (species='staintoni' OR species='staintonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tmarus' AND (species='staintoni' OR species='staintonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmarus' AND (junior_species='staintoni' OR junior_species='staintonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tmarus' AND (species='staintoni' OR species='staintonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='bliteus' OR junior_species='bliteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='bliteus' OR species='bliteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='bliteus' OR species='bliteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='bliteus' OR junior_species='bliteus')SELECT d.diet,d.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='bliteus' OR species='bliteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='bufo' OR junior_species='bufo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='bufo' OR species='bufo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='bufo' OR species='bufo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='bufo' OR junior_species='bufo')SELECT d.diet,d.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='bufo' OR species='bufo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='cribratus' OR junior_species='cribratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='cribratus' OR species='cribratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='cribratus' OR species='cribratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='cribratus' OR junior_species='cribratus')SELECT d.diet,d.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='cribratus' OR species='cribratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xysticus' AND (species='ferrugineus' OR species='ferrugineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xysticus' AND (species='ferrugineus' OR species='ferrugineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xysticus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')SELECT d.diet,d.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='ferrugineus' OR species='ferrugineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='jozefienae' OR junior_species='jozefienae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zodarion' AND (species='jozefienae' OR species='jozefienae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zodarion' AND (species='jozefienae' OR species='jozefienae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='jozefienae' OR junior_species='jozefienae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zodarion' AND (species='jozefienae' OR species='jozefienae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='merlijni' OR junior_species='merlijnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zodarion' AND (species='merlijni' OR species='merlijnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zodarion' AND (species='merlijni' OR species='merlijnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='merlijni' OR junior_species='merlijnii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zodarion' AND (species='merlijni' OR species='merlijnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='styliferum' OR junior_species='styliferum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zodarion' AND (species='styliferum' OR species='styliferum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zodarion' AND (species='styliferum' OR species='styliferum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zodarion' AND (junior_species='styliferum' OR junior_species='styliferum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zodarion' AND (species='styliferum' OR species='styliferum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zora' AND (junior_species='spinimana' OR junior_species='spinimana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zora' AND (species='spinimana' OR species='spinimana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zora' AND (species='spinimana' OR species='spinimana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zora' AND (junior_species='spinimana' OR junior_species='spinimana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zora' AND (species='spinimana' OR species='spinimana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3105 The Ecological Register: Vale do Guadiana Nature Park
Vale do Guadiana Nature Park
Basic information
Sample name: Vale do Guadiana Nature Park

Reference: P. Cardoso, S. S. Henriques, C. Gaspar, L. C. Crespo, R. Carvalho, J. B. Schmidt, P. Sousa, and T. Szüts. 2009. Species richness and composition assessment of spiders in a Mediterranean scrubland. Journal of Insect Conservation 13:45-55 [ER 2896]
Geography
Country: Portugal


Coordinate: 37° 34' 30" N, 7° 32' 6" W
Coordinate basis: stated in text

Geography comments: "in Pomaräo, Vale do Guadiana Nature Park"

Environment
Habitat: temperate savanna

Protection: nature reserve

Substrate: ground surface

MAT: 17.0

MAP: 500.0

Habitat comments: "The site was dominated by a variety of sclerophilous plants, including rockrose (Cistus sp.), lavender (Lavandula sp.), gorse (Ulex sp.) and plants that remained from the former agricultural use of the site or from surrounding areas, mainly oat (Avena sativa L.)"

Methods
Life forms: spiders

Sites: 1

Site length: 100

Site width: 100

Sampling methods: quadrat,sweep nets,hand capture

Sample size: 3049 individuals

Years: 2006

Seasons: spring

Sampling comments: "a square sampling plot 100 m wide... Additional effort was made around the sampling plot, up to a distance of about 100 m and an overall sampling area of about 10 ha. Sampling was made from May 9 to 23 of 2006... 224 samples were taken. Each sample consisted of one person-hour of work... 128 samples were made inside the delimited plot over 4 days... by eight collectors... specimens were captured with hand, forceps, pooter or brush" at ground level and with "a round sweep net, with a diameter 40 cm"
counts are of adults only

Metadata
Sample number: 3105

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-09-19 21:46:52

Modified: 2018-09-19 11:46:52

Abundance distribution
115 species
33 singletons
total count 3049
extrapolated richness: 191.8
Fisher's α: 23.623
geometric series k: 0.9451
Hurlbert's PIE: 0.9185
Shannon's H: 3.2827
Good's u: 0.9892
Each square represents a species. Square sizes are proportional to counts.
Register
Agelena labyrinthica1
Tegenaria feminea3
Aculepeira armida5
Agalenatea redii3
Cyclosa insulana1
Hypsosinga albovittata5
Mangora acalypha34
Neoscona adianta20
Singa neta4
Clubiona genevensis1
Clubiona sp.1
Archaeodictyna consecuta2
Dictyna civica7
Lathys simplex5
Dysdera alentejana17
Harpactea minoccii9
Pritha cf. pallida6
Drassodes lapidosus1
Drassodes sp.4
Haplodrassus macellinus16
Haplodrassus minor8
Leptodrassus albidus4
Leptodrassus simoni18
Micaria coarctata1
Nomisia excerpta20
Nomisia exornata24
Pterotricha simoni18
Trachyzelote bardiae21
Trachyzelote fuscipes23
Trachyzelote holosericeus7
Zelominor algarvensis2
Zelotes cf. gallicus10
Zelotes denisi1
Zelotes sp. 11
Zelotes sp. 242
Zelotes sp. 31
Zelotes sp. 42
Zelotes sp. 511
Hahnia nava1
Didectoprocnemis cirtensis1
Diplocephalus graecus463
Erigone dentipalpis1
Meioneta pseudorurestris77
Micrargus sp.15
Pelecopsis bucephala7
Pelecopsis inedita622
Prinerigone vagans27
Styloctetor romanus7
Tenuiphantes tenuis1
Mesiotelus mauritanicus1
Alopecosa sp.6
Lycosa tarantula1
Pardosa proxima1
Ero aphana1
Cheiracanthium sp.10
Cheiracanthium striolatum3
Oecobius machadoi125
Oonops sp.22
Silhouettella loricatula14
Oxyopes heterophthalmus5
Oxyopes lineatus74
Palpimanus gibbulus10
Philodromus cespitum9
Philodromus rufus1
Thanatus vulgaris81
Holocnemus hispanicus27
Pisaura mirabilis3
Prodidomus amaranthinus14
Aelurillus luctuosus2
Chalcoscirtus infimus8
Cyrba algerina100
Euophrys frontalis2
Euophrys sulphurea103
Evarcha jucunda1
Heliophanus cupreus2
Heliophanus lineiventris1
Leptorchestes mutilloides1
Menemerus semilimbatus1
Pellenes nigrociliatus6
Salticus propinquus10
Salticus scenicus2
Thyene imperialis11
Scytodes velutina41
Ariadna insidiatrix13
Loxosceles rufescens28
Eusparassus dufouri1
Tetragnatha sp.3
Episinus maculipes1
Episinus truncatus2
Euryopis episinoides4
Kochiura aulica195
Lasaeola testaceomarginata5
Robertus sp.1
Simitidion simile52
Steatoda triangulosa1
Theridiidae indet. 11
Theridiidae indet. 21
Theridiidae indet. 31
Theridiidae indet. 44
Theridion sp.159
Theridion impressum5
Theridion nigropunctatum2
Monaeses paradoxus1
Runcinia grammica119
Synema globosum15
Thomisus onustus84
Tmarus staintoni2
Xysticus bliteus1
Xysticus bufo1
Xysticus cf. cribratus3
Xysticus ferrugineus9
Zodarion jozefienae20
Zodarion merlijni11
Zodarion styliferum23
Zora spinimana1