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=2366 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2366SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2270SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2366 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araneus' AND (junior_species='inustus' OR junior_species='inustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Araneus' AND (species='inustus' OR species='inustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araneus' AND (species='inustus' OR species='inustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araneus' AND (junior_species='inustus' OR junior_species='inustus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Araneus' AND (species='inustus' OR species='inustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='catenulate' OR junior_species='catenulate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argiope' AND (species='catenulate' OR species='catenulate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argiope' AND (species='catenulate' OR species='catenulate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='catenulate' OR junior_species='catenulate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argiope' AND (species='catenulate' OR species='catenulate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argiope' AND (species='pulchella' OR species='pulchella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argiope' AND (species='pulchella' OR species='pulchella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiope' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argiope' AND (species='pulchella' OR species='pulchella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodes' AND (junior_species='argentatus' OR junior_species='argentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyrodes' AND (species='argentatus' OR species='argentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyrodes' AND (species='argentatus' OR species='argentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodes' AND (junior_species='argentatus' OR junior_species='argentatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argyrodes' AND (species='argentatus' OR species='argentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodes' AND (junior_species='gazingensis' OR junior_species='gazingensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyrodes' AND (species='gazingensis' OR species='gazingensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyrodes' AND (species='gazingensis' OR species='gazingensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyrodes' AND (junior_species='gazingensis' OR junior_species='gazingensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argyrodes' AND (species='gazingensis' OR species='gazingensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artema' AND (junior_species='altanta' OR junior_species='altanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artema' AND (species='altanta' OR species='altanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artema' AND (species='altanta' OR species='altanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artema' AND (junior_species='altanta' OR junior_species='altanta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artema' AND (species='altanta' OR species='altanta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bianor' AND (junior_species='hotingchieh' OR junior_species='hotingchieh')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bianor' AND (species='hotingchieh' OR species='hotingchieh') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bianor' AND (species='hotingchieh' OR species='hotingchieh')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bianor' AND (junior_species='hotingchieh' OR junior_species='hotingchieh')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bianor' AND (species='hotingchieh' OR species='hotingchieh') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bomis' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bomis' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bomis' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bomis' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bomis' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='tagorei' OR junior_species='tagoreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cheiracanthium' AND (species='tagorei' OR species='tagoreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cheiracanthium' AND (species='tagorei' OR species='tagoreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cheiracanthium' AND (junior_species='tagorei' OR junior_species='tagoreii')SELECT d.diet,d.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='tagorei' OR species='tagoreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysilla' AND (junior_species='lauta' OR junior_species='lauta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysilla' AND (species='lauta' OR species='lauta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysilla' AND (species='lauta' OR species='lauta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysilla' AND (junior_species='lauta' OR junior_species='lauta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysilla' AND (species='lauta' OR species='lauta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='analis' OR junior_species='analis')SELECT d.diet,d.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='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='drassodes' OR junior_species='drassodes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='drassodes' OR species='drassodes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='drassodes' OR species='drassodes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='drassodes' OR junior_species='drassodes')SELECT d.diet,d.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='drassodes' OR species='drassodes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='filicata' OR junior_species='filicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='filicata' OR species='filicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='filicata' OR species='filicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='filicata' OR junior_species='filicata')SELECT d.diet,d.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='filicata' OR species='filicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='mujibari' OR junior_species='mujibarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clubiona' AND (species='mujibari' OR species='mujibarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clubiona' AND (species='mujibari' OR species='mujibarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clubiona' AND (junior_species='mujibari' OR junior_species='mujibarii')SELECT d.diet,d.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='mujibari' OR species='mujibarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleosoma' AND (junior_species='blandum' OR junior_species='blandum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coleosoma' AND (species='blandum' OR species='blandum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coleosoma' AND (species='blandum' OR species='blandum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleosoma' AND (junior_species='blandum' OR junior_species='blandum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coleosoma' AND (species='blandum' OR species='blandum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='bifida' OR junior_species='bifida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclosa' AND (species='bifida' OR species='bifida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclosa' AND (species='bifida' OR species='bifida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='bifida' OR junior_species='bifida')SELECT d.diet,d.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='bifida' OR species='bifida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='elongate' OR junior_species='elongate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclosa' AND (species='elongate' OR species='elongate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclosa' AND (species='elongate' OR species='elongate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='elongate' OR junior_species='elongate')SELECT d.diet,d.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='elongate' OR species='elongate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='parangtarugoa' OR junior_species='parangtarugoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclosa' AND (species='parangtarugoa' OR species='parangtarugoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclosa' AND (species='parangtarugoa' OR species='parangtarugoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclosa' AND (junior_species='parangtarugoa' OR junior_species='parangtarugoa')SELECT d.diet,d.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='parangtarugoa' OR species='parangtarugoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtophora' AND (junior_species='nareshi' OR junior_species='nareshii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrtophora' AND (species='nareshi' OR species='nareshii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrtophora' AND (species='nareshi' OR species='nareshii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrtophora' AND (junior_species='nareshi' OR junior_species='nareshii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyrtophora' AND (species='nareshi' OR species='nareshii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaea' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaea' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaea' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaea' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaea' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriovixia' AND (junior_species='laglazei' OR junior_species='laglazeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriovixia' AND (species='laglazei' OR species='laglazeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriovixia' AND (species='laglazei' OR species='laglazeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriovixia' AND (junior_species='laglazei' OR junior_species='laglazeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eriovixia' AND (species='laglazei' OR species='laglazeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gasteracantha' AND (junior_species='hasselti' OR junior_species='hasseltii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gasteracantha' AND (species='hasselti' OR species='hasseltii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gasteracantha' AND (species='hasselti' OR species='hasseltii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gasteracantha' AND (junior_species='hasselti' OR junior_species='hasseltii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gasteracantha' AND (species='hasselti' OR species='hasseltii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hasarius' AND (junior_species='adansoni' OR junior_species='adansonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hasarius' AND (species='adansoni' OR species='adansonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hasarius' AND (species='adansoni' OR species='adansonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hasarius' AND (junior_species='adansoni' OR junior_species='adansonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hasarius' AND (species='adansoni' OR species='adansonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropoda' AND (junior_species='buxa' OR junior_species='buxa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropoda' AND (species='buxa' OR species='buxa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropoda' AND (species='buxa' OR species='buxa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropoda' AND (junior_species='buxa' OR junior_species='buxa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropoda' AND (species='buxa' OR species='buxa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucauge' AND (junior_species='decorate' OR junior_species='decorate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucauge' AND (species='decorate' OR species='decorate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucauge' AND (species='decorate' OR species='decorate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucauge' AND (junior_species='decorate' OR junior_species='decorate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leucauge' AND (species='decorate' OR species='decorate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='pseudoannulata' OR junior_species='pseudoannulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycosa' AND (species='pseudoannulata' OR species='pseudoannulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycosa' AND (species='pseudoannulata' OR species='pseudoannulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycosa' AND (junior_species='pseudoannulata' OR junior_species='pseudoannulata')SELECT d.diet,d.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='pseudoannulata' OR species='pseudoannulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='andamanensis' OR species='andamanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='andamanensis' OR species='andamanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='andamanensis' OR species='andamanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='bijoni' OR junior_species='bijonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='bijoni' OR species='bijonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='bijoni' OR species='bijonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='bijoni' OR junior_species='bijonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='bijoni' OR species='bijonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='calcuttaensis' OR junior_species='calcuttaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='calcuttaensis' OR species='calcuttaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='calcuttaensis' OR species='calcuttaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='calcuttaensis' OR junior_species='calcuttaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='calcuttaensis' OR species='calcuttaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='decorate' OR junior_species='decorate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='decorate' OR species='decorate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='decorate' OR species='decorate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='decorate' OR junior_species='decorate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='decorate' OR species='decorate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='dhakuriensis' OR junior_species='dhakuriensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='dhakuriensis' OR species='dhakuriensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='dhakuriensis' OR species='dhakuriensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='dhakuriensis' OR junior_species='dhakuriensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='dhakuriensis' OR species='dhakuriensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='gajebo' OR junior_species='gajebo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='gajebo' OR species='gajebo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='gajebo' OR species='gajebo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='gajebo' OR junior_species='gajebo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='gajebo' OR species='gajebo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='ludhianaensis' OR junior_species='ludhianaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='ludhianaensis' OR species='ludhianaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='ludhianaensis' OR species='ludhianaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='ludhianaensis' OR junior_species='ludhianaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='ludhianaensis' OR species='ludhianaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='majumderi' OR junior_species='majumderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='majumderi' OR species='majumderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='majumderi' OR species='majumderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='majumderi' OR junior_species='majumderii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='majumderi' OR species='majumderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='minutus' OR junior_species='minutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='mondali' OR junior_species='mondalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='mondali' OR species='mondalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='mondali' OR species='mondalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='mondali' OR junior_species='mondalii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='mondali' OR species='mondalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='sannyali' OR junior_species='sannyalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpissa' AND (species='sannyali' OR species='sannyalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpissa' AND (species='sannyali' OR species='sannyalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpissa' AND (junior_species='sannyali' OR junior_species='sannyalii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Marpissa' AND (species='sannyali' OR species='sannyalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menemerus' AND (junior_species='bivittatus' OR junior_species='bivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menemerus' AND (species='bivittatus' OR species='bivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menemerus' AND (species='bivittatus' OR species='bivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menemerus' AND (junior_species='bivittatus' OR junior_species='bivittatus')SELECT d.diet,d.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='bivittatus' OR species='bivittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mossuria' AND (junior_species='laterotuberculate' OR junior_species='laterotuberculate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mossuria' AND (species='laterotuberculate' OR species='laterotuberculate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mossuria' AND (species='laterotuberculate' OR species='laterotuberculate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mossuria' AND (junior_species='laterotuberculate' OR junior_species='laterotuberculate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mossuria' AND (species='laterotuberculate' OR species='laterotuberculate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='elongate' OR junior_species='elongate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='elongate' OR species='elongate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='elongate' OR species='elongate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='elongate' OR junior_species='elongate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='elongate' OR species='elongate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='legon' OR junior_species='legon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='legon' OR species='legon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='legon' OR species='legon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='legon' OR junior_species='legon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='legon' OR species='legon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='pictocephalis' OR junior_species='pictocephalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='pictocephalis' OR species='pictocephalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='pictocephalis' OR species='pictocephalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='pictocephalis' OR junior_species='pictocephalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='pictocephalis' OR species='pictocephalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='poonaensis' OR junior_species='poonaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='poonaensis' OR species='poonaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='poonaensis' OR species='poonaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='poonaensis' OR junior_species='poonaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='poonaensis' OR species='poonaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='radhamadhabi' OR junior_species='radhamadhabii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmarachne' AND (species='radhamadhabi' OR species='radhamadhabii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmarachne' AND (species='radhamadhabi' OR species='radhamadhabii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmarachne' AND (junior_species='radhamadhabi' OR junior_species='radhamadhabii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmarachne' AND (species='radhamadhabi' OR species='radhamadhabii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='brownius' OR junior_species='brownius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='brownius' OR species='brownius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='brownius' OR species='brownius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='brownius' OR junior_species='brownius')SELECT d.diet,d.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='brownius' OR species='brownius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='dorsonigra' OR junior_species='dorsonigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='dorsonigra' OR species='dorsonigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='dorsonigra' OR species='dorsonigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='dorsonigra' OR junior_species='dorsonigra')SELECT d.diet,d.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='dorsonigra' OR species='dorsonigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='dostinikea' OR junior_species='dostinikea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='dostinikea' OR species='dostinikea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='dostinikea' OR species='dostinikea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='dostinikea' OR junior_species='dostinikea')SELECT d.diet,d.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='dostinikea' OR species='dostinikea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='elliptica' OR junior_species='elliptica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='elliptica' OR species='elliptica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='elliptica' OR species='elliptica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='elliptica' OR junior_species='elliptica')SELECT d.diet,d.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='elliptica' OR species='elliptica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='molemensis' OR junior_species='molemensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='molemensis' OR species='molemensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='molemensis' OR species='molemensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='molemensis' OR junior_species='molemensis')SELECT d.diet,d.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='molemensis' OR species='molemensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='nautical' OR junior_species='nautical')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='nautical' OR species='nautical') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='nautical' OR species='nautical')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='nautical' OR junior_species='nautical')SELECT d.diet,d.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='nautical' OR species='nautical') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='oriemindoroana' OR junior_species='oriemindoroana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='oriemindoroana' OR species='oriemindoroana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='oriemindoroana' OR species='oriemindoroana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='oriemindoroana' OR junior_species='oriemindoroana')SELECT d.diet,d.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='oriemindoroana' OR species='oriemindoroana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='ovate' OR junior_species='ovate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoscona' AND (species='ovate' OR species='ovate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoscona' AND (species='ovate' OR species='ovate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoscona' AND (junior_species='ovate' OR junior_species='ovate')SELECT d.diet,d.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='ovate' OR species='ovate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olios' AND (junior_species='gravelyi' OR junior_species='gravelyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olios' AND (species='gravelyi' OR species='gravelyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olios' AND (species='gravelyi' OR species='gravelyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olios' AND (junior_species='gravelyi' OR junior_species='gravelyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Olios' AND (species='gravelyi' OR species='gravelyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='birmanicus' OR junior_species='birmanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='birmanicus' OR species='birmanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='birmanicus' OR species='birmanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='birmanicus' OR junior_species='birmanicus')SELECT d.diet,d.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='birmanicus' OR species='birmanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='javanus' OR junior_species='javanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='javanus' OR species='javanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='javanus' OR species='javanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='javanus' OR junior_species='javanus')SELECT d.diet,d.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='javanus' OR species='javanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='salticus' OR junior_species='salticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyopes' AND (species='salticus' OR species='salticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyopes' AND (species='salticus' OR species='salticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyopes' AND (junior_species='salticus' OR junior_species='salticus')SELECT d.diet,d.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='salticus' OR species='salticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pancorius' AND (junior_species='magnus' OR junior_species='magnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pancorius' AND (species='magnus' OR species='magnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pancorius' AND (species='magnus' OR species='magnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pancorius' AND (junior_species='magnus' OR junior_species='magnus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pancorius' AND (species='magnus' OR species='magnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parawixia' AND (junior_species='dehaani' OR junior_species='dehaanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parawixia' AND (species='dehaani' OR species='dehaanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parawixia' AND (species='dehaani' OR species='dehaanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parawixia' AND (junior_species='dehaani' OR junior_species='dehaanii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parawixia' AND (species='dehaani' OR species='dehaanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peucetia' AND (junior_species='viridans' OR junior_species='viridans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peucetia' AND (species='viridans' OR species='viridans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peucetia' AND (species='viridans' OR species='viridans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peucetia' AND (junior_species='viridans' OR junior_species='viridans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peucetia' AND (species='viridans' OR species='viridans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phidippus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phidippus' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phidippus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='majumderi' OR junior_species='majumderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phidippus' AND (species='majumderi' OR species='majumderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phidippus' AND (species='majumderi' OR species='majumderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='majumderi' OR junior_species='majumderii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phidippus' AND (species='majumderi' OR species='majumderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='pateli' OR junior_species='patelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phidippus' AND (species='pateli' OR species='patelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phidippus' AND (species='pateli' OR species='patelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phidippus' AND (junior_species='pateli' OR junior_species='patelii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phidippus' AND (species='pateli' OR species='patelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phintella' AND (junior_species='rampalensis' OR junior_species='rampalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phintella' AND (species='rampalensis' OR species='rampalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phintella' AND (species='rampalensis' OR species='rampalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phintella' AND (junior_species='rampalensis' OR junior_species='rampalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phintella' AND (species='rampalensis' OR species='rampalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phintella' AND (junior_species='vittata' OR junior_species='vittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phintella' AND (species='vittata' OR species='vittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phintella' AND (species='vittata' OR species='vittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phintella' AND (junior_species='vittata' OR junior_species='vittata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phintella' AND (species='vittata' OR species='vittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='petersi' OR junior_species='petersii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plexippus' AND (species='petersi' OR species='petersii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plexippus' AND (species='petersi' OR species='petersii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='petersi' OR junior_species='petersii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plexippus' AND (species='petersi' OR species='petersii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='wesolowski' OR junior_species='wesolowskii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plexippus' AND (species='wesolowski' OR species='wesolowskii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plexippus' AND (species='wesolowski' OR species='wesolowskii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='wesolowski' OR junior_species='wesolowskii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plexippus' AND (species='wesolowski' OR species='wesolowskii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='zabkai' OR junior_species='zabkaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plexippus' AND (species='zabkai' OR species='zabkaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plexippus' AND (species='zabkai' OR species='zabkaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plexippus' AND (junior_species='zabkai' OR junior_species='zabkaii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plexippus' AND (species='zabkai' OR species='zabkaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhene' AND (junior_species='kustiaensis' OR junior_species='kustiaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhene' AND (species='kustiaensis' OR species='kustiaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhene' AND (species='kustiaensis' OR species='kustiaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhene' AND (junior_species='kustiaensis' OR junior_species='kustiaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhene' AND (species='kustiaensis' OR species='kustiaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salticus' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salticus' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salticus' AND (junior_species='minutus' OR junior_species='minutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salticus' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telamonia' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telamonia' AND (species='dimidiata' OR species='dimidiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telamonia' AND (species='dimidiata' OR species='dimidiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telamonia' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Telamonia' AND (species='dimidiata' OR species='dimidiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='andamanensis' OR species='andamanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='andamanensis' OR species='andamanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='andamanensis' OR junior_species='andamanensis')SELECT d.diet,d.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='andamanensis' OR species='andamanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='fletcheri' OR junior_species='fletcherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='fletcheri' OR species='fletcherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='fletcheri' OR species='fletcherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='fletcheri' OR junior_species='fletcherii')SELECT d.diet,d.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='fletcheri' OR species='fletcherii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='javana' OR junior_species='javana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='javana' OR species='javana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='javana' OR species='javana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='javana' OR junior_species='javana')SELECT d.diet,d.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='javana' OR species='javana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='mandibulata' OR junior_species='mandibulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='mandibulata' OR species='mandibulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='mandibulata' OR species='mandibulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='mandibulata' OR junior_species='mandibulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetragnatha' AND (species='mandibulata' OR species='mandibulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.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='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='vermiformes' OR junior_species='vermiformes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragnatha' AND (species='vermiformes' OR species='vermiformes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragnatha' AND (species='vermiformes' OR species='vermiformes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragnatha' AND (junior_species='vermiformes' OR junior_species='vermiformes')SELECT d.diet,d.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='vermiformes' OR species='vermiformes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thiania' AND (junior_species='bhamoensis' OR junior_species='bhamoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thiania' AND (species='bhamoensis' OR species='bhamoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thiania' AND (species='bhamoensis' OR species='bhamoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thiania' AND (junior_species='bhamoensis' OR junior_species='bhamoensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thiania' AND (species='bhamoensis' OR species='bhamoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomsius' AND (junior_species='projectus' OR junior_species='projectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomsius' AND (species='projectus' OR species='projectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thomsius' AND (species='projectus' OR species='projectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomsius' AND (junior_species='projectus' OR junior_species='projectus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thomsius' AND (species='projectus' OR species='projectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomsius' AND (junior_species='pugilis' OR junior_species='pugilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomsius' AND (species='pugilis' OR species='pugilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thomsius' AND (species='pugilis' OR species='pugilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomsius' AND (junior_species='pugilis' OR junior_species='pugilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thomsius' AND (species='pugilis' OR species='pugilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uloborus' AND (junior_species='danolius' OR junior_species='danolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uloborus' AND (species='danolius' OR species='danolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uloborus' AND (species='danolius' OR species='danolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uloborus' AND (junior_species='danolius' OR junior_species='danolius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uloborus' AND (species='danolius' OR species='danolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygiella' AND (junior_species='muriae' OR junior_species='muriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygiella' AND (species='muriae' OR species='muriae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygiella' AND (species='muriae' OR species='muriae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygiella' AND (junior_species='muriae' OR junior_species='muriae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zygiella' AND (species='muriae' OR species='muriae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygoballus' AND (junior_species='narmadaensis' OR junior_species='narmadaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygoballus' AND (species='narmadaensis' OR species='narmadaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygoballus' AND (species='narmadaensis' OR species='narmadaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygoballus' AND (junior_species='narmadaensis' OR junior_species='narmadaensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zygoballus' AND (species='narmadaensis' OR species='narmadaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygoballus' AND (junior_species='pashanensis' OR junior_species='pashanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygoballus' AND (species='pashanensis' OR species='pashanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygoballus' AND (species='pashanensis' OR species='pashanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygoballus' AND (junior_species='pashanensis' OR junior_species='pashanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zygoballus' AND (species='pashanensis' OR species='pashanensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2366 The Ecological Register: Jahangirnagar University (Insect Rearing and Experimental Stations)
Jahangirnagar University (Insect Rearing and Experimental Stations)
Basic information
Sample name: Jahangirnagar University (Insect Rearing and Experimental Stations)

Reference: F. F. Rain, A. J. Howlader, and K. Bashar. 2016. Diversity and abundance of spider fauna at different habitats of Jahangirnagar University Campus, Bangladesh. Journal of Entomology and Zoology Studies 4(5):87-93 [ER 2270]
Geography
Country: Bangladesh


Coordinate: 23° 52' 32" N, 90° 16' 0" E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: "This area has a good composition of vegetables, fruits, and ornamental trees... Three side of this area is enclosed by water body... the climate is tropical monsoon"

Methods
Life forms: spiders

Sites: 1

Sampling methods: no design,hand capture

Sample size: 492 individuals

Years: 2013, 2014

Sampling comments: "The study was carried out from March, 2013 to February, 2014. All surveys were conducted in the morning hours between 7.00 am to 9.00 am. Spiders were collected four times from four sites per week in each month" and the data here pertain to one site

Metadata
Sample number: 2366

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-11-27 18:09:09

Modified: 2016-11-27 07:09:09

Abundance distribution
85 species
35 singletons
total count 492
extrapolated richness: 198.4
Fisher's α: 29.638
geometric series k: 0.9515
Hurlbert's PIE: 0.9473
Shannon's H: 3.5561
Good's u: 0.9290
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Araneus inustus2
Argiope catenulate3
Argiope pulchella56
Argyrodes argentatus27
Argyrodes gazingensis1
Artema altanta5
Bianor hotingchieh7
Bomis bengalensis2
Cheiracanthium tagorei5
Chrysilla lauta39
Clubiona analis7
Clubiona drassodes3
Clubiona filicata1
Clubiona mujibari1
Coleosoma blandum3
Cyclosa bifida1
Cyclosa elongate1
Cyclosa parangtarugoa5
Cyrtophora nareshi1
Diaea variabilis1
Eriovixia laglazei1
Gasteracantha hasselti15
Hasarius adansoni6
Heteropoda buxa1
Leucauge decorate65
Lycosa pseudoannulata2
Marpissa andamanensis1
Marpissa bengalensis7
Marpissa bijoni2
Marpissa calcuttaensis2
Marpissa decorate1
Marpissa dhakuriensis2
Marpissa gajebo3
Marpissa ludhianaensis2
Marpissa majumderi5
Marpissa minutus22
Marpissa mondali7
Marpissa sannyali11
Menemerus bivittatus30
Mossuria laterotuberculate2
Myrmarachne elongate3
Myrmarachne legon4
Myrmarachne orientalis1
Myrmarachne pictocephalis3
Myrmarachne poonaensis1
Myrmarachne radhamadhabi4
Neoscona brownius12
Neoscona dorsonigra2
Neoscona dostinikea1
Neoscona elliptica2
Neoscona molemensis6
Neoscona nautical3
Neoscona oriemindoroana1
Neoscona ovate1
Olios gravelyi11
Oxyopes birmanicus3
Oxyopes javanus11
Oxyopes salticus1
Pancorius magnus1
Parawixia dehaani2
Peucetia viridans1
Phidippus bengalensis2
Phidippus majumderi1
Phidippus pateli1
Phintella rampalensis1
Phintella vittata9
Plexippus petersi1
Plexippus wesolowski4
Plexippus zabkai1
Rhene kustiaensis1
Salticus minutus1
Telamonia dimidiata2
Tetragnatha andamanensis1
Tetragnatha fletcheri1
Tetragnatha javana5
Tetragnatha mandibulata1
Tetragnatha nitens1
Tetragnatha vermiformes1
Thiania bhamoensis18
Thomsius projectus1
Thomsius pugilis1
Uloborus danolius2
Zygiella muriae1
Zygoballus narmadaensis2
Zygoballus pashanensis1