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=868 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=868SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=501SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=868 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerapachys' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerapachys' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cerapachys' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eciton' AND (junior_species='lucanoides' OR junior_species='lucanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eciton' AND (species='lucanoides' OR species='lucanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eciton' AND (species='lucanoides' OR species='lucanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eciton' AND (junior_species='lucanoides' OR junior_species='lucanoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eciton' AND (species='lucanoides' OR species='lucanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labidus' AND (junior_species='coecus' OR junior_species='coecus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Labidus' AND (species='coecus' OR species='coecus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Labidus' AND (species='coecus' OR species='coecus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labidus' AND (junior_species='coecus' OR junior_species='coecus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Labidus' AND (species='coecus' OR species='coecus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acropyga' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acropyga' AND (species='JTL-002' OR species='JTL-002') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acropyga' AND (species='JTL-002' OR species='JTL-002')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acropyga' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acropyga' AND (species='JTL-002' OR species='JTL-002') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='heeri' OR junior_species='heerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachymyrmex' AND (species='heeri' OR species='heerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachymyrmex' AND (species='heeri' OR species='heerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='heeri' OR junior_species='heerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brachymyrmex' AND (species='heeri' OR species='heerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='guatemalensis' OR species='guatemalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='guatemalensis' OR junior_species='guatemalensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paratrechina' AND (species='guatemalensis' OR species='guatemalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='JTL-009' OR junior_species='JTL-009')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='JTL-009' OR species='JTL-009') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='JTL-009' OR species='JTL-009')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='JTL-009' OR junior_species='JTL-009')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paratrechina' AND (species='JTL-009' OR species='JTL-009') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='JTL-010' OR species='JTL-010') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='JTL-010' OR species='JTL-010')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paratrechina' AND (species='JTL-010' OR species='JTL-010') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='steinheili' OR junior_species='steinheilii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratrechina' AND (species='steinheili' OR species='steinheilii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='steinheili' OR species='steinheilii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' AND (junior_species='steinheili' OR junior_species='steinheilii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paratrechina' AND (species='steinheili' OR species='steinheilii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthognathus' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthognathus' AND (species='ocellatus' OR species='ocellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthognathus' AND (species='ocellatus' OR species='ocellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthognathus' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acanthognathus' AND (species='ocellatus' OR species='ocellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthognathus' AND (junior_species='teledectus' OR junior_species='teledectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthognathus' AND (species='teledectus' OR species='teledectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthognathus' AND (species='teledectus' OR species='teledectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthognathus' AND (junior_species='teledectus' OR junior_species='teledectus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acanthognathus' AND (species='teledectus' OR species='teledectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acromyrmex' AND (junior_species='octospinosus' OR junior_species='octospinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acromyrmex' AND (species='octospinosus' OR species='octospinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acromyrmex' AND (species='octospinosus' OR species='octospinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acromyrmex' AND (junior_species='octospinosus' OR junior_species='octospinosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acromyrmex' AND (species='octospinosus' OR species='octospinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyrmex' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelomyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyrmex' AND (species='JTL-004' OR species='JTL-004')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='myops' OR junior_species='myops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyrmex' AND (species='myops' OR species='myops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyrmex' AND (species='myops' OR species='myops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='myops' OR junior_species='myops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelomyrmex' AND (species='myops' OR species='myops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='silvestrii' OR junior_species='silvestri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyrmex' AND (species='silvestrii' OR species='silvestri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyrmex' AND (species='silvestrii' OR species='silvestri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyrmex' AND (junior_species='silvestrii' OR junior_species='silvestri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelomyrmex' AND (species='silvestrii' OR species='silvestri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='araneoides' OR junior_species='araneoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='araneoides' OR species='araneoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='araneoides' OR species='araneoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='araneoides' OR junior_species='araneoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphaenogaster' AND (species='araneoides' OR species='araneoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='chocoensis' OR junior_species='chocoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='chocoensis' OR species='chocoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='chocoensis' OR species='chocoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='chocoensis' OR junior_species='chocoensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='chocoensis' OR species='chocoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='collare' OR junior_species='collare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='collare' OR species='collare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='collare' OR species='collare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='collare' OR junior_species='collare')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='collare' OR species='collare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='dentigerum' OR junior_species='dentigerum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='dentigerum' OR species='dentigerum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='dentigerum' OR species='dentigerum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='dentigerum' OR junior_species='dentigerum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='dentigerum' OR species='dentigerum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='goniodes' OR junior_species='goniodes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='goniodes' OR species='goniodes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='goniodes' OR species='goniodes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='goniodes' OR junior_species='goniodes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='goniodes' OR species='goniodes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='JTL-008' OR species='JTL-008') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='JTL-008' OR species='JTL-008')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='JTL-008' OR species='JTL-008') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='JTL-010' OR species='JTL-010') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='JTL-010' OR species='JTL-010')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='JTL-010' OR species='JTL-010') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='robustum' OR junior_species='robustum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apterostigma' AND (species='robustum' OR species='robustum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apterostigma' AND (species='robustum' OR species='robustum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apterostigma' AND (junior_species='robustum' OR junior_species='robustum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apterostigma' AND (species='robustum' OR species='robustum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atta' AND (junior_species='cephalotes' OR junior_species='cephalotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atta' AND (species='cephalotes' OR species='cephalotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atta' AND (species='cephalotes' OR species='cephalotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atta' AND (junior_species='cephalotes' OR junior_species='cephalotes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atta' AND (species='cephalotes' OR species='cephalotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basiceros' AND (junior_species='manni' OR junior_species='mannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basiceros' AND (species='manni' OR species='mannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basiceros' AND (species='manni' OR species='mannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basiceros' AND (junior_species='manni' OR junior_species='mannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basiceros' AND (species='manni' OR species='mannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carebarella' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carebarella' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carebarella' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carebarella' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carebarella' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='carinata' OR junior_species='carinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='carinata' OR species='carinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='carinata' OR species='carinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='carinata' OR junior_species='carinata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='carinata' OR species='carinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='curvispinosa' OR junior_species='curvispinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='curvispinosa' OR species='curvispinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='curvispinosa' OR species='curvispinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='curvispinosa' OR junior_species='curvispinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='curvispinosa' OR species='curvispinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='JTL-006' OR species='JTL-006') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='JTL-006' OR species='JTL-006')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='JTL-006' OR species='JTL-006') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='JTL-013' OR junior_species='JTL-013')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='JTL-013' OR species='JTL-013') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='JTL-013' OR species='JTL-013')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='JTL-013' OR junior_species='JTL-013')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='JTL-013' OR species='JTL-013') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='limata' OR junior_species='limata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='limata' OR species='limata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='limata' OR species='limata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='limata' OR junior_species='limata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='limata' OR species='limata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='nigropilosa' OR junior_species='nigropilosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='nigropilosa' OR species='nigropilosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='nigropilosa' OR species='nigropilosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='nigropilosa' OR junior_species='nigropilosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='nigropilosa' OR species='nigropilosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='cornutus' OR junior_species='cornutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='cornutus' OR species='cornutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='cornutus' OR species='cornutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='cornutus' OR junior_species='cornutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='cornutus' OR species='cornutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='costatus' OR junior_species='costatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='costatus' OR species='costatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='costatus' OR species='costatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='costatus' OR junior_species='costatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='costatus' OR species='costatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='JTL-004' OR species='JTL-004')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='JTL-006' OR species='JTL-006') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='JTL-006' OR species='JTL-006')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='JTL-006' OR species='JTL-006') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='JTL-007' OR species='JTL-007') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='JTL-007' OR species='JTL-007')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='JTL-007' OR species='JTL-007') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='rimosus' OR junior_species='rimosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='rimosus' OR species='rimosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='rimosus' OR species='rimosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='rimosus' OR junior_species='rimosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphomyrmex' AND (species='rimosus' OR species='rimosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurhopalothrix' AND (junior_species='gravis' OR junior_species='gravis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurhopalothrix' AND (species='gravis' OR species='gravis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurhopalothrix' AND (species='gravis' OR species='gravis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurhopalothrix' AND (junior_species='gravis' OR junior_species='gravis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurhopalothrix' AND (species='gravis' OR species='gravis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurhopalothrix' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurhopalothrix' AND (species='JTL-006' OR species='JTL-006') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurhopalothrix' AND (species='JTL-006' OR species='JTL-006')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurhopalothrix' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurhopalothrix' AND (species='JTL-006' OR species='JTL-006') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylomyrma' AND (junior_species='dentiloba' OR junior_species='dentiloba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylomyrma' AND (species='dentiloba' OR species='dentiloba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylomyrma' AND (species='dentiloba' OR species='dentiloba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylomyrma' AND (junior_species='dentiloba' OR junior_species='dentiloba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylomyrma' AND (species='dentiloba' OR species='dentiloba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylomyrma' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylomyrma' AND (species='JTL-002' OR species='JTL-002') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylomyrma' AND (species='JTL-002' OR species='JTL-002')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylomyrma' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylomyrma' AND (species='JTL-002' OR species='JTL-002') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='haskinsi' OR junior_species='haskinsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnomyrmex' AND (species='haskinsi' OR species='haskinsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnomyrmex' AND (species='haskinsi' OR species='haskinsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='haskinsi' OR junior_species='haskinsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnomyrmex' AND (species='haskinsi' OR species='haskinsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnomyrmex' AND (species='JTL-004' OR species='JTL-004')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnomyrmex' AND (species='JTL-004' OR species='JTL-004') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='plaumanni' OR junior_species='plaumannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnomyrmex' AND (species='plaumanni' OR species='plaumannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnomyrmex' AND (species='plaumanni' OR species='plaumannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='plaumanni' OR junior_species='plaumannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnomyrmex' AND (species='plaumanni' OR species='plaumannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='scrobiculatus' OR junior_species='scrobiculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnomyrmex' AND (species='scrobiculatus' OR species='scrobiculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnomyrmex' AND (species='scrobiculatus' OR species='scrobiculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnomyrmex' AND (junior_species='scrobiculatus' OR junior_species='scrobiculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnomyrmex' AND (species='scrobiculatus' OR species='scrobiculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='drifti' OR junior_species='driftii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalomyrmex' AND (species='drifti' OR species='driftii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalomyrmex' AND (species='drifti' OR species='driftii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='drifti' OR junior_species='driftii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megalomyrmex' AND (species='drifti' OR species='driftii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalomyrmex' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalomyrmex' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='modestus' OR junior_species='modestus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megalomyrmex' AND (species='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='silvestrii' OR junior_species='silvestri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalomyrmex' AND (species='silvestrii' OR species='silvestri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalomyrmex' AND (species='silvestrii' OR species='silvestri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalomyrmex' AND (junior_species='silvestrii' OR junior_species='silvestri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megalomyrmex' AND (species='silvestrii' OR species='silvestri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmicocrypta' 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='Myrmicocrypta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmicocrypta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmicocrypta' 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='Myrmicocrypta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='iheringi' OR junior_species='iheringii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octostruma' AND (species='iheringi' OR species='iheringii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octostruma' AND (species='iheringi' OR species='iheringii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='iheringi' OR junior_species='iheringii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Octostruma' AND (species='iheringi' OR species='iheringii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octostruma' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octostruma' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Octostruma' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-003' OR junior_species='JTL-003')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octostruma' AND (species='JTL-003' OR species='JTL-003') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octostruma' AND (species='JTL-003' OR species='JTL-003')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-003' OR junior_species='JTL-003')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Octostruma' AND (species='JTL-003' OR species='JTL-003') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octostruma' AND (species='JTL-004' OR species='JTL-004') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octostruma' AND (species='JTL-004' OR species='JTL-004')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Octostruma' AND (species='JTL-004' OR species='JTL-004') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-005' OR junior_species='JTL-005')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octostruma' AND (species='JTL-005' OR species='JTL-005') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octostruma' AND (species='JTL-005' OR species='JTL-005')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octostruma' AND (junior_species='JTL-005' OR junior_species='JTL-005')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Octostruma' AND (species='JTL-005' OR species='JTL-005') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='eidmanni' OR junior_species='eidmannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligomyrmex' AND (species='eidmanni' OR species='eidmannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligomyrmex' AND (species='eidmanni' OR species='eidmannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='eidmanni' OR junior_species='eidmannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oligomyrmex' AND (species='eidmanni' OR species='eidmannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligomyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligomyrmex' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oligomyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='nevermanni' OR junior_species='nevermannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligomyrmex' AND (species='nevermanni' OR species='nevermannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligomyrmex' AND (species='nevermanni' OR species='nevermannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='nevermanni' OR junior_species='nevermannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oligomyrmex' AND (species='nevermanni' OR species='nevermannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='anastasii' OR junior_species='anastasi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='anastasii' OR species='anastasi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='anastasii' OR species='anastasi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='anastasii' OR junior_species='anastasi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='anastasii' OR species='anastasi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='arachnion' OR junior_species='arachnion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='arachnion' OR species='arachnion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='arachnion' OR species='arachnion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='arachnion' OR junior_species='arachnion')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='arachnion' OR species='arachnion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='arietans' OR junior_species='arietans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='arietans' OR species='arietans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='arietans' OR species='arietans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='arietans' OR junior_species='arietans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='arietans' OR species='arietans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='boruca' OR junior_species='boruca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='boruca' OR species='boruca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='boruca' OR species='boruca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='boruca' OR junior_species='boruca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='boruca' OR species='boruca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='browni' OR junior_species='brownii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='browni' OR species='brownii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='browni' OR species='brownii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='browni' OR junior_species='brownii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='browni' OR species='brownii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='campanae' OR junior_species='campanae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='campanae' OR species='campanae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='campanae' OR species='campanae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='campanae' OR junior_species='campanae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='campanae' OR species='campanae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='celaena' OR junior_species='celaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='celaena' OR species='celaena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='celaena' OR species='celaena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='celaena' OR junior_species='celaena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='celaena' OR species='celaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='citrina' OR junior_species='citrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='citrina' OR species='citrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='citrina' OR species='citrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='citrina' OR junior_species='citrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='citrina' OR species='citrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='decem' OR junior_species='decem')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='decem' OR species='decem') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='decem' OR species='decem')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='decem' OR junior_species='decem')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='decem' OR species='decem') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fimbriata' OR junior_species='fimbriata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='fimbriata' OR species='fimbriata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='fimbriata' OR species='fimbriata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fimbriata' OR junior_species='fimbriata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='fimbriata' OR species='fimbriata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fiorii' OR junior_species='fiori')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='fiorii' OR species='fiori') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='fiorii' OR species='fiori')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fiorii' OR junior_species='fiori')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='fiorii' OR species='fiori') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='flavens' OR junior_species='flavens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='flavens' OR species='flavens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='flavens' OR species='flavens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='flavens' OR junior_species='flavens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='flavens' OR species='flavens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='hirsuta' OR junior_species='hirsuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='hirsuta' OR species='hirsuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='hirsuta' OR species='hirsuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='hirsuta' OR junior_species='hirsuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='hirsuta' OR species='hirsuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='indagatrix' OR junior_species='indagatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='indagatrix' OR species='indagatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='indagatrix' OR species='indagatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='indagatrix' OR junior_species='indagatrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='indagatrix' OR species='indagatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='indistincta' OR junior_species='indistincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='indistincta' OR species='indistincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='indistincta' OR species='indistincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='indistincta' OR junior_species='indistincta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='indistincta' OR species='indistincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-081' OR junior_species='JTL-081')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-081' OR species='JTL-081') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-081' OR species='JTL-081')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-081' OR junior_species='JTL-081')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-081' OR species='JTL-081') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-102' OR junior_species='JTL-102')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-102' OR species='JTL-102') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-102' OR species='JTL-102')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-102' OR junior_species='JTL-102')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-102' OR species='JTL-102') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-103' OR junior_species='JTL-103')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-103' OR species='JTL-103') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-103' OR species='JTL-103')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-103' OR junior_species='JTL-103')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-103' OR species='JTL-103') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-104' OR junior_species='JTL-104')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-104' OR species='JTL-104') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-104' OR species='JTL-104')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-104' OR junior_species='JTL-104')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-104' OR species='JTL-104') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-111' OR junior_species='JTL-111')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-111' OR species='JTL-111') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-111' OR species='JTL-111')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-111' OR junior_species='JTL-111')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-111' OR species='JTL-111') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-112' OR junior_species='JTL-112')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-112' OR species='JTL-112') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-112' OR species='JTL-112')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-112' OR junior_species='JTL-112')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-112' OR species='JTL-112') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-127' OR junior_species='JTL-127')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='JTL-127' OR species='JTL-127') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='JTL-127' OR species='JTL-127')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='JTL-127' OR junior_species='JTL-127')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='JTL-127' OR species='JTL-127') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='laselva' OR junior_species='laselva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='laselva' OR species='laselva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='laselva' OR species='laselva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='laselva' OR junior_species='laselva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='laselva' OR species='laselva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nebulosa' OR junior_species='nebulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='nebulosa' OR species='nebulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='nebulosa' OR species='nebulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nebulosa' OR junior_species='nebulosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='nebulosa' OR species='nebulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nigricula' OR junior_species='nigricula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='nigricula' OR species='nigricula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='nigricula' OR species='nigricula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nigricula' OR junior_species='nigricula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='nigricula' OR species='nigricula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nitella' OR junior_species='nitella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='nitella' OR species='nitella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='nitella' OR species='nitella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nitella' OR junior_species='nitella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='nitella' OR species='nitella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='otisi' OR junior_species='otisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='otisi' OR species='otisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='otisi' OR species='otisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='otisi' OR junior_species='otisii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='otisi' OR species='otisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='praetorum' OR junior_species='praetorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='praetorum' OR species='praetorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='praetorum' OR species='praetorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='praetorum' OR junior_species='praetorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='praetorum' OR species='praetorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='prostrata' OR junior_species='prostrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='prostrata' OR species='prostrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='prostrata' OR species='prostrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='prostrata' OR junior_species='prostrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='prostrata' OR species='prostrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='psilogaster' OR junior_species='psilogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='psilogaster' OR species='psilogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='psilogaster' OR species='psilogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='psilogaster' OR junior_species='psilogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='psilogaster' OR species='psilogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rectispina' OR junior_species='rectispina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='rectispina' OR species='rectispina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='rectispina' OR species='rectispina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rectispina' OR junior_species='rectispina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='rectispina' OR species='rectispina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='rogeri' OR species='rogerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='rogeri' OR species='rogerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='rogeri' OR species='rogerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rugiceps' OR junior_species='rugiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='rugiceps' OR species='rugiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='rugiceps' OR species='rugiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='rugiceps' OR junior_species='rugiceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='rugiceps' OR species='rugiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='ruida' OR junior_species='ruida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='ruida' OR species='ruida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='ruida' OR species='ruida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='ruida' OR junior_species='ruida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='ruida' OR species='ruida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='scalaris' OR junior_species='scalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='scalaris' OR species='scalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='scalaris' OR species='scalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='scalaris' OR junior_species='scalaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='scalaris' OR species='scalaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='sensitiva' OR junior_species='sensitiva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='sensitiva' OR species='sensitiva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sensitiva' OR species='sensitiva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='sensitiva' OR junior_species='sensitiva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='sensitiva' OR species='sensitiva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='simonsi' OR junior_species='simonsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='simonsi' OR species='simonsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='simonsi' OR species='simonsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='simonsi' OR junior_species='simonsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='simonsi' OR species='simonsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='specularis' OR junior_species='specularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='specularis' OR species='specularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='specularis' OR species='specularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='specularis' OR junior_species='specularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='specularis' OR species='specularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='tanyscapa' OR junior_species='tanyscapa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='tanyscapa' OR species='tanyscapa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='tanyscapa' OR species='tanyscapa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='tanyscapa' OR junior_species='tanyscapa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='tanyscapa' OR species='tanyscapa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='vestita' OR junior_species='vestita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='vestita' OR species='vestita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='vestita' OR species='vestita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='vestita' OR junior_species='vestita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='vestita' OR species='vestita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='alberti' OR junior_species='albertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='alberti' OR species='albertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='alberti' OR species='albertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='alberti' OR junior_species='albertii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='alberti' OR species='albertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='brevicornis' OR junior_species='brevicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='brevicornis' OR species='brevicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='brevicornis' OR species='brevicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='brevicornis' OR junior_species='brevicornis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='brevicornis' OR species='brevicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='cassicuspis' OR junior_species='cassicuspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='cassicuspis' OR species='cassicuspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='cassicuspis' OR species='cassicuspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='cassicuspis' OR junior_species='cassicuspis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='cassicuspis' OR species='cassicuspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='crementa' OR junior_species='crementa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='crementa' OR species='crementa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='crementa' OR species='crementa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='crementa' OR junior_species='crementa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='crementa' OR species='crementa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='depressiceps' OR junior_species='depressiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='depressiceps' OR species='depressiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='depressiceps' OR species='depressiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='depressiceps' OR junior_species='depressiceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='depressiceps' OR species='depressiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='eggersi' OR junior_species='eggersii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='eggersi' OR species='eggersii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='eggersi' OR species='eggersii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='eggersi' OR junior_species='eggersii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='eggersi' OR species='eggersii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='excisus' OR junior_species='excisus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='excisus' OR species='excisus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='excisus' OR species='excisus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='excisus' OR junior_species='excisus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='excisus' OR species='excisus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='gundlachi' OR junior_species='gundlachii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='gundlachi' OR species='gundlachii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='gundlachi' OR species='gundlachii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='gundlachi' OR junior_species='gundlachii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='gundlachi' OR species='gundlachii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='lalassa' OR junior_species='lalassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='lalassa' OR species='lalassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='lalassa' OR species='lalassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='lalassa' OR junior_species='lalassa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='lalassa' OR species='lalassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='microthrix' OR junior_species='microthrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='microthrix' OR species='microthrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='microthrix' OR species='microthrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='microthrix' OR junior_species='microthrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='microthrix' OR species='microthrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='myllorhapha' OR junior_species='myllorhapha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='myllorhapha' OR species='myllorhapha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='myllorhapha' OR species='myllorhapha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='myllorhapha' OR junior_species='myllorhapha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='myllorhapha' OR species='myllorhapha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='nigrescens' OR species='nigrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='nigrescens' OR species='nigrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='nigrescens' OR species='nigrescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='probatrix' OR junior_species='probatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='probatrix' OR species='probatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='probatrix' OR species='probatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='probatrix' OR junior_species='probatrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='probatrix' OR species='probatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='schulzi' OR junior_species='schulzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='schulzi' OR species='schulzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='schulzi' OR species='schulzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='schulzi' OR junior_species='schulzii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='schulzi' OR species='schulzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='stauroma' OR junior_species='stauroma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='stauroma' OR species='stauroma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='stauroma' OR species='stauroma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='stauroma' OR junior_species='stauroma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='stauroma' OR species='stauroma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='subedentata' OR junior_species='subedentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='subedentata' OR species='subedentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='subedentata' OR species='subedentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='subedentata' OR junior_species='subedentata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='subedentata' OR species='subedentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='trieces' OR junior_species='trieces')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='trieces' OR species='trieces') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='trieces' OR species='trieces')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='trieces' OR junior_species='trieces')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='trieces' OR species='trieces') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='wheeleri' OR species='wheelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='wheeleri' OR species='wheelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='wheeleri' OR species='wheelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='zeteki' OR junior_species='zetekii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyramica' AND (species='zeteki' OR species='zetekii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='zeteki' OR species='zetekii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' AND (junior_species='zeteki' OR junior_species='zetekii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyramica' AND (species='zeteki' OR species='zetekii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhopalothrix' AND (junior_species='weberi' OR junior_species='weberii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhopalothrix' AND (species='weberi' OR species='weberii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhopalothrix' AND (species='weberi' OR species='weberii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhopalothrix' AND (junior_species='weberi' OR junior_species='weberii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhopalothrix' AND (species='weberi' OR species='weberii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='blanda' OR junior_species='blanda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='blanda' OR species='blanda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='blanda' OR species='blanda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='blanda' OR junior_species='blanda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='blanda' OR species='blanda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='creightoni' OR junior_species='creightonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='creightoni' OR species='creightonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='creightoni' OR species='creightonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='creightoni' OR junior_species='creightonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='creightoni' OR species='creightonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='cuneola' OR junior_species='cuneola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='cuneola' OR species='cuneola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='cuneola' OR species='cuneola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='cuneola' OR junior_species='cuneola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='cuneola' OR species='cuneola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='inermis' OR junior_species='inermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='inermis' OR junior_species='inermis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='JTL-004' OR species='JTL-004') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='JTL-004' OR species='JTL-004')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='JTL-004' OR junior_species='JTL-004')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='JTL-004' OR species='JTL-004') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='tonduzi' OR junior_species='tonduzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rogeria' AND (species='tonduzi' OR species='tonduzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rogeria' AND (species='tonduzi' OR species='tonduzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rogeria' AND (junior_species='tonduzi' OR junior_species='tonduzii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rogeria' AND (species='tonduzi' OR species='tonduzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericomyrmex' AND (junior_species='amabilis' OR junior_species='amabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericomyrmex' AND (species='amabilis' OR species='amabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericomyrmex' AND (species='amabilis' OR species='amabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericomyrmex' AND (junior_species='amabilis' OR junior_species='amabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericomyrmex' AND (species='amabilis' OR species='amabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='geminata' OR junior_species='geminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='geminata' OR species='geminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='geminata' OR species='geminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='geminata' OR junior_species='geminata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='geminata' OR species='geminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-005' OR junior_species='JTL-005')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-005' OR species='JTL-005') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-005' OR species='JTL-005')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-005' OR junior_species='JTL-005')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-005' OR species='JTL-005') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-006' OR species='JTL-006') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-006' OR species='JTL-006')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-006' OR species='JTL-006') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-007' OR species='JTL-007') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-007' OR species='JTL-007')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-007' OR species='JTL-007') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-008' OR species='JTL-008') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-008' OR species='JTL-008')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-008' OR species='JTL-008') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-015' OR junior_species='JTL-015')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-015' OR species='JTL-015') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-015' OR species='JTL-015')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-015' OR junior_species='JTL-015')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-015' OR species='JTL-015') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-019' OR junior_species='JTL-019')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-019' OR species='JTL-019') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-019' OR species='JTL-019')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-019' OR junior_species='JTL-019')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-019' OR species='JTL-019') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-021' OR junior_species='JTL-021')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='JTL-021' OR species='JTL-021') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='JTL-021' OR species='JTL-021')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='JTL-021' OR junior_species='JTL-021')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='JTL-021' OR species='JTL-021') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='picea' OR junior_species='picea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solenopsis' AND (species='picea' OR species='picea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='picea' OR species='picea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' AND (junior_species='picea' OR junior_species='picea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Solenopsis' AND (species='picea' OR species='picea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stegomyrmex' AND (junior_species='manni' OR junior_species='mannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stegomyrmex' AND (species='manni' OR species='mannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stegomyrmex' AND (species='manni' OR species='mannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stegomyrmex' AND (junior_species='manni' OR junior_species='mannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stegomyrmex' AND (species='manni' OR species='mannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='felixi' OR junior_species='felixii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='felixi' OR species='felixii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='felixi' OR species='felixii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='felixi' OR junior_species='felixii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenamma' AND (species='felixi' OR species='felixii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='JTL-007' OR species='JTL-007') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='JTL-007' OR species='JTL-007')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenamma' AND (species='JTL-007' OR species='JTL-007') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='JTL-010' OR species='JTL-010') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='JTL-010' OR species='JTL-010')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenamma' AND (species='JTL-010' OR species='JTL-010') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='biolleyi' OR junior_species='biolleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='biolleyi' OR species='biolleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='biolleyi' OR species='biolleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='biolleyi' OR junior_species='biolleyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='biolleyi' OR species='biolleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='borgmeieri' OR junior_species='borgmeierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='borgmeieri' OR species='borgmeierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='borgmeieri' OR species='borgmeierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='borgmeieri' OR junior_species='borgmeierii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='borgmeieri' OR species='borgmeierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='calamita' OR junior_species='calamita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='calamita' OR species='calamita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='calamita' OR species='calamita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='calamita' OR junior_species='calamita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='calamita' OR species='calamita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='cordovensis' OR junior_species='cordovensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='cordovensis' OR species='cordovensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='cordovensis' OR species='cordovensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='cordovensis' OR junior_species='cordovensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='cordovensis' OR species='cordovensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='elongata' OR junior_species='elongata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='elongata' OR species='elongata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='elongata' OR species='elongata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='elongata' OR junior_species='elongata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='elongata' OR species='elongata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='lanuginosa' OR species='lanuginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='ludia' OR junior_species='ludia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='ludia' OR species='ludia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='ludia' OR species='ludia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='ludia' OR junior_species='ludia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='ludia' OR species='ludia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='micretes' OR junior_species='micretes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='micretes' OR species='micretes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='micretes' OR species='micretes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='micretes' OR junior_species='micretes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='micretes' OR species='micretes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='pariensis' OR junior_species='pariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='pariensis' OR species='pariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='pariensis' OR species='pariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='pariensis' OR junior_species='pariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='pariensis' OR species='pariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='rogeri' OR species='rogerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='rogeri' OR species='rogerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='rogeri' OR species='rogerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='smithii' OR junior_species='smithi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tatuidris' AND (junior_species='tatusia' OR junior_species='tatusia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tatuidris' AND (species='tatusia' OR species='tatusia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tatuidris' AND (species='tatusia' OR species='tatusia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tatuidris' AND (junior_species='tatusia' OR junior_species='tatusia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tatuidris' AND (species='tatusia' OR species='tatusia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='cornetzi' OR junior_species='cornetzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachymyrmex' AND (species='cornetzi' OR species='cornetzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachymyrmex' AND (species='cornetzi' OR species='cornetzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='cornetzi' OR junior_species='cornetzii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachymyrmex' AND (species='cornetzi' OR species='cornetzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachymyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachymyrmex' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachymyrmex' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='zeteki' OR junior_species='zetekii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachymyrmex' AND (species='zeteki' OR species='zetekii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachymyrmex' AND (species='zeteki' OR species='zetekii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachymyrmex' AND (junior_species='zeteki' OR junior_species='zetekii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachymyrmex' AND (species='zeteki' OR species='zetekii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tranopelta' AND (junior_species='gilva' OR junior_species='gilva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tranopelta' AND (species='gilva' OR species='gilva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tranopelta' AND (species='gilva' OR species='gilva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tranopelta' AND (junior_species='gilva' OR junior_species='gilva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tranopelta' AND (species='gilva' OR species='gilva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='auropunctata' OR junior_species='auropunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wasmannia' AND (species='auropunctata' OR species='auropunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wasmannia' AND (species='auropunctata' OR species='auropunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='auropunctata' OR junior_species='auropunctata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wasmannia' AND (species='auropunctata' OR species='auropunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wasmannia' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wasmannia' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wasmannia' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='scrobifera' OR junior_species='scrobifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wasmannia' AND (species='scrobifera' OR species='scrobifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wasmannia' AND (species='scrobifera' OR species='scrobifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wasmannia' AND (junior_species='scrobifera' OR junior_species='scrobifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wasmannia' AND (species='scrobifera' OR species='scrobifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anochetus' AND (species='JTL-001' OR species='JTL-001') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anochetus' AND (species='JTL-001' OR species='JTL-001')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='JTL-001' OR junior_species='JTL-001')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anochetus' AND (species='JTL-001' OR species='JTL-001') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anochetus' AND (species='JTL-002' OR species='JTL-002') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anochetus' AND (species='JTL-002' OR species='JTL-002')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anochetus' AND (species='JTL-002' OR species='JTL-002') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' AND (junior_species='horni' OR junior_species='hornii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discothyrea' AND (species='horni' OR species='hornii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discothyrea' AND (species='horni' OR species='hornii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' AND (junior_species='horni' OR junior_species='hornii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discothyrea' AND (species='horni' OR species='hornii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' AND (junior_species='testacea' OR junior_species='testacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discothyrea' AND (species='testacea' OR species='testacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discothyrea' AND (species='testacea' OR species='testacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' AND (junior_species='testacea' OR junior_species='testacea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discothyrea' AND (species='testacea' OR species='testacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='gibbum' OR junior_species='gibbum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectatomma' AND (species='gibbum' OR species='gibbum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectatomma' AND (species='gibbum' OR species='gibbum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='gibbum' OR junior_species='gibbum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectatomma' AND (species='gibbum' OR species='gibbum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='ruidum' OR junior_species='ruidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectatomma' AND (species='ruidum' OR species='ruidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectatomma' AND (species='ruidum' OR species='ruidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='ruidum' OR junior_species='ruidum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectatomma' AND (species='ruidum' OR species='ruidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='tuberculatum' OR junior_species='tuberculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectatomma' AND (species='tuberculatum' OR species='tuberculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectatomma' AND (species='tuberculatum' OR species='tuberculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectatomma' AND (junior_species='tuberculatum' OR junior_species='tuberculatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectatomma' AND (species='tuberculatum' OR species='tuberculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='hartmani' OR junior_species='hartmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnamptogenys' AND (species='hartmani' OR species='hartmanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnamptogenys' AND (species='hartmani' OR species='hartmanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='hartmani' OR junior_species='hartmanii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnamptogenys' AND (species='hartmani' OR species='hartmanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='mecotyle' OR junior_species='mecotyle')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnamptogenys' AND (species='mecotyle' OR species='mecotyle') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnamptogenys' AND (species='mecotyle' OR species='mecotyle')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='mecotyle' OR junior_species='mecotyle')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnamptogenys' AND (species='mecotyle' OR species='mecotyle') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='minuta' OR junior_species='minuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnamptogenys' AND (species='minuta' OR species='minuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnamptogenys' AND (species='minuta' OR species='minuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnamptogenys' AND (junior_species='minuta' OR junior_species='minuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnamptogenys' AND (species='minuta' OR species='minuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='distinguenda' OR junior_species='distinguenda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='distinguenda' OR species='distinguenda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='distinguenda' OR species='distinguenda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='distinguenda' OR junior_species='distinguenda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='distinguenda' OR species='distinguenda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='JTL-007' OR species='JTL-007') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='JTL-007' OR species='JTL-007')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-007' OR junior_species='JTL-007')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='JTL-007' OR species='JTL-007') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='JTL-008' OR species='JTL-008') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='JTL-008' OR species='JTL-008')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-008' OR junior_species='JTL-008')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='JTL-008' OR species='JTL-008') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='JTL-010' OR species='JTL-010') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='JTL-010' OR species='JTL-010')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-010' OR junior_species='JTL-010')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='JTL-010' OR species='JTL-010') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-013' OR junior_species='JTL-013')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='JTL-013' OR species='JTL-013') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='JTL-013' OR species='JTL-013')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='JTL-013' OR junior_species='JTL-013')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='JTL-013' OR species='JTL-013') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='nitidula' OR junior_species='nitidula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='nitidula' OR species='nitidula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='nitidula' OR species='nitidula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='nitidula' OR junior_species='nitidula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='nitidula' OR species='nitidula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='opacior' OR junior_species='opacior')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='opacior' OR species='opacior') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='opacior' OR species='opacior')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='opacior' OR junior_species='opacior')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='opacior' OR species='opacior') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='parva' OR junior_species='parva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='parva' OR species='parva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='parva' OR species='parva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='parva' OR junior_species='parva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='parva' OR species='parva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogenys' AND (species='ambigua' OR species='ambigua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='ambigua' OR species='ambigua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptogenys' AND (species='ambigua' OR species='ambigua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogenys' AND (species='JTL-002' OR species='JTL-002') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='JTL-002' OR species='JTL-002')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='JTL-002' OR junior_species='JTL-002')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptogenys' AND (species='JTL-002' OR species='JTL-002') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogenys' AND (species='JTL-006' OR species='JTL-006') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='JTL-006' OR species='JTL-006')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='JTL-006' OR junior_species='JTL-006')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptogenys' AND (species='JTL-006' OR species='JTL-006') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogenys' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptogenys' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='bauri' OR junior_species='baurii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='bauri' OR species='baurii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='bauri' OR species='baurii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='bauri' OR junior_species='baurii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontomachus' AND (species='bauri' OR species='baurii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='chelifer' OR junior_species='chelifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='chelifer' OR species='chelifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='chelifer' OR species='chelifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='chelifer' OR junior_species='chelifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontomachus' AND (species='chelifer' OR species='chelifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='erythrocephalus' OR junior_species='erythrocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='erythrocephalus' OR species='erythrocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='erythrocephalus' OR species='erythrocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='erythrocephalus' OR junior_species='erythrocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontomachus' AND (species='erythrocephalus' OR species='erythrocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='laticeps' OR species='laticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='laticeps' OR species='laticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontomachus' AND (species='laticeps' OR species='laticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='meinerti' OR junior_species='meinertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='meinerti' OR species='meinertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='meinerti' OR species='meinertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='meinerti' OR junior_species='meinertii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontomachus' AND (species='meinerti' OR species='meinertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='arhuaca' OR junior_species='arhuaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='arhuaca' OR species='arhuaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='arhuaca' OR species='arhuaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='arhuaca' OR junior_species='arhuaca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='arhuaca' OR species='arhuaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='cognata' OR junior_species='cognata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='cognata' OR species='cognata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='cognata' OR species='cognata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='cognata' OR junior_species='cognata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='cognata' OR species='cognata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='constricta' OR junior_species='constricta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='constricta' OR species='constricta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='constricta' OR species='constricta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='constricta' OR junior_species='constricta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='constricta' OR species='constricta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='crenata' OR junior_species='crenata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='crenata' OR species='crenata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='crenata' OR species='crenata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='crenata' OR junior_species='crenata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='crenata' OR species='crenata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='harpax' OR junior_species='harpax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='harpax' OR species='harpax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='harpax' OR species='harpax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='harpax' OR junior_species='harpax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='harpax' OR species='harpax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='stigma' OR junior_species='stigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='stigma' OR species='stigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='stigma' OR species='stigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='stigma' OR junior_species='stigma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='stigma' OR species='stigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='succedanea' OR junior_species='succedanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='succedanea' OR species='succedanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='succedanea' OR species='succedanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='succedanea' OR junior_species='succedanea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='succedanea' OR species='succedanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platythyrea' AND (junior_species='sinuata' OR junior_species='sinuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platythyrea' AND (species='sinuata' OR species='sinuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platythyrea' AND (species='sinuata' OR species='sinuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platythyrea' AND (junior_species='sinuata' OR junior_species='sinuata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platythyrea' AND (species='sinuata' OR species='sinuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionopelta' AND (junior_species='amabilis' OR junior_species='amabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionopelta' AND (species='amabilis' OR species='amabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prionopelta' AND (species='amabilis' OR species='amabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionopelta' AND (junior_species='amabilis' OR junior_species='amabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prionopelta' AND (species='amabilis' OR species='amabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratium' AND (junior_species='silaceum' OR junior_species='silaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proceratium' AND (species='silaceum' OR species='silaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proceratium' AND (species='silaceum' OR species='silaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratium' AND (junior_species='silaceum' OR junior_species='silaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Proceratium' AND (species='silaceum' OR species='silaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratium' AND (junior_species='micrommatum' OR junior_species='micrommatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proceratium' AND (species='micrommatum' OR species='micrommatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proceratium' AND (species='micrommatum' OR species='micrommatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proceratium' AND (junior_species='micrommatum' OR junior_species='micrommatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Proceratium' AND (species='micrommatum' OR species='micrommatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumatomyrmex' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumatomyrmex' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumatomyrmex' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumatomyrmex' AND (junior_species='ferox' OR junior_species='ferox')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thaumatomyrmex' AND (species='ferox' OR species='ferox') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=868 The Ecological Register: La Selva Biological Station (Winkler samples)
La Selva Biological Station (Winkler samples)
Basic information
Sample name: La Selva Biological Station (Winkler samples)

Reference: J. T. Longino, J. Coddington, and R. K. Colwell. 2002. The ant fauna of a tropical rain forest: estimating species richness three different ways. Ecology 83:689-702 [ER 501]
Geography
Country: Costa Rica


Coordinate: 10° 25' 19" N, 84° 0' 54" W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on La Selva Biological Station
elevation 50 to 150 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: leaf litter

MAT: 26.0

MAP: 4260.0

Habitat comments: "a mosaic of mature lowland rain forest, second growth forest of various ages, and abandoned pastures"
climate data based on Kennedy and Horn (2008)

Methods
Life forms: ants

Sampling methods: Winkler apparatus

Sample size: 1415 individuals

Nets or traps: 41

Sampling comments: 41 "sites" collected using the Winkler method

Metadata
Sample number: 868

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-22 14:05:46

Modified: 2014-04-26 01:22:13

Abundance distribution
197 species
50 singletons
total count 1415
extrapolated richness: 341.0
Fisher's α: 62.190
geometric series k: 0.9817
Hurlbert's PIE: 0.9886
Shannon's H: 4.7627
Good's u: 0.9647
Each square represents a species. Square sizes are proportional to counts.
Register
Cerapachys JTL-00110
Eciton lucanoides conquistador1
Labidus coecus1
Acropyga JTL-0023
Brachymyrmex heeri1
Paratrechina guatemalensis1
Paratrechina JTL-0091
Paratrechina JTL-0101
Paratrechina steinheili13
Acanthognathus ocellatus3
Acanthognathus teledectus11
Acromyrmex octospinosus1
Adelomyrmex JTL-0013
Adelomyrmex JTL-0042
Adelomyrmex myops3
Adelomyrmex silvestrii6
Aphaenogaster araneoides6
Apterostigma chocoensis2
Apterostigma collare2
Apterostigma dentigerum10
Apterostigma goniodes3
Apterostigma JTL-00814
Apterostigma JTL-0103
Apterostigma robustum1
Atta cephalotes1
Basiceros manni4
Carebarella 'bicolor'22
Crematogaster carinata1
Crematogaster curvispinosa1
Crematogaster JTL-00613
Crematogaster JTL-0132
Crematogaster limata4
Crematogaster nigropilosa1
Cyphomyrmex cornutus2
Cyphomyrmex costatus6
Cyphomyrmex JTL-00416
Cyphomyrmex JTL-00620
Cyphomyrmex JTL-0071
Cyphomyrmex rimosus s.l.15
Eurhopalothrix gravis2
Eurhopalothrix JTL-0062
Hylomyrma dentiloba26
Hylomyrma JTL-00213
Lachnomyrmex haskinsi6
Lachnomyrmex JTL-0041
Lachnomyrmex plaumanni10
Lachnomyrmex scrobiculatus23
Megalomyrmex drifti3
Megalomyrmex modestus3
Megalomyrmex silvestrii2
Myrmicocrypta sp.1
Octostruma iheringi7
Octostruma JTL-0011
Octostruma JTL-0034
Octostruma JTL-0041
Octostruma JTL-0051
Oligomyrmex eidmanni1
Oligomyrmex JTL-0013
Oligomyrmex nevermanni14
Pheidole anastasii4
Pheidole arachnion2
Pheidole arietans1
Pheidole boruca14
Pheidole browni3
Pheidole campanae18
Pheidole celaena3
Pheidole citrina20
Pheidole decem2
Pheidole fimbriata4
Pheidole fiorii3
Pheidole flavens19
Pheidole hirsuta3
Pheidole indagatrix3
Pheidole indistincta13
Pheidole JTL-0811
Pheidole JTL-1028
Pheidole JTL-10310
Pheidole JTL-10423
Pheidole JTL-1112
Pheidole JTL-1121
Pheidole JTL-1271
Pheidole laselva11
Pheidole nebulosa24
Pheidole nigricula21
Pheidole nitella5
Pheidole otisi1
Pheidole praetorum2
Pheidole prostrata1
Pheidole psilogaster2
Pheidole rectispina12
Pheidole rogeri1
Pheidole rugiceps35
Pheidole ruida28
Pheidole scalaris3
Pheidole sensitiva6
Pheidole simonsi3
Pheidole specularis14
Pheidole tanyscapa2
Pheidole vestita4
Pyramica alberti26
Pyramica brevicornis29
Pyramica cassicuspis5
Pyramica crementa3
Pyramica depressiceps1
Pyramica eggersi3
Pyramica excisus1
Pyramica gundlachi26
Pyramica lalassa2
Pyramica microthrix3
Pyramica myllorhapha16
Pyramica nigrescens4
Pyramica probatrix2
Pyramica schulzi1
Pyramica stauroma1
Pyramica subedentata11
Pyramica trieces19
Pyramica wheeleri1
Pyramica zeteki2
Rhopalothrix weberi1
Rogeria blanda1
Rogeria creightoni6
Rogeria cuneola6
Rogeria inermis8
Rogeria JTL-0042
Rogeria tonduzi4
Sericomyrmex amabilis18
Solenopsis geminata2
Solenopsis JTL-00537
Solenopsis JTL-00625
Solenopsis JTL-00726
Solenopsis JTL-00813
Solenopsis JTL-0155
Solenopsis JTL-0193
Solenopsis JTL-0211
Solenopsis picea11
Stegomyrmex manni1
Stenamma felixi1
Stenamma JTL-0074
Stenamma JTL-0102
Strumigenys biolleyi1
Strumigenys borgmeieri1
Strumigenys calamita2
Strumigenys cordovensis1
Strumigenys elongata20
Strumigenys lanuginosa2
Strumigenys ludia1
Strumigenys micretes11
Strumigenys pariensis3
Strumigenys rogeri14
Strumigenys smithii1
Tatuidris tatusia2
Trachymyrmex cornetzi2
Trachymyrmex JTL-0018
Trachymyrmex zeteki2
Tranopelta gilva9
Wasmannia auropunctata34
Wasmannia JTL-0011
Wasmannia scrobifera3
Anochetus JTL-00120
Anochetus JTL-0026
Discothyrea horni17
Discothyrea testacea7
Ectatomma gibbum4
Ectatomma ruidum12
Ectatomma tuberculatum1
Gnamptogenys hartmani2
Gnamptogenys mecotyle1
Gnamptogenys minuta5
Hypoponera distinguenda10
Hypoponera JTL-00720
Hypoponera JTL-0084
Hypoponera JTL-0103
Hypoponera JTL-0132
Hypoponera nitidula23
Hypoponera opacior5
Hypoponera parva8
Leptogenys ambigua1
Leptogenys JTL-0022
Leptogenys JTL-0064
Leptogenys pusilla10
Odontomachus bauri1
Odontomachus chelifer1
Odontomachus erythrocephalus3
Odontomachus laticeps7
Odontomachus meinerti13
Pachycondyla arhuaca6
Pachycondyla cognata10
Pachycondyla constricta19
Pachycondyla crenata1
Pachycondyla harpax27
Pachycondyla stigma4
Pachycondyla succedanea5
Platythyrea sinuata2
Prionopelta amabilis17
Proceratium cf. silaceum1
Proceratium micrommatum1
Thaumatomyrmex ferox11