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=2023 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2023SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2080SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2023 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictis' 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='Aenictis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aenictis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictis' 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='Aenictis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' AND (junior_species='1' OR junior_species='1')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Technomyrmex' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Technomyrmex' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' AND (junior_species='1' OR junior_species='1')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Technomyrmex' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Technomyrmex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Technomyrmex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Technomyrmex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Technomyrmex' 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='Technomyrmex' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='emeryi' OR junior_species='emeryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='emeryi' OR species='emeryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='emeryi' OR species='emeryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='emeryi' OR junior_species='emeryii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dorylus' AND (species='emeryi' OR species='emeryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='kohli' OR junior_species='kohlii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='kohli' OR species='kohlii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='kohli' OR species='kohlii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='kohli' OR junior_species='kohlii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dorylus' AND (species='kohli' OR species='kohlii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='sjoestedti' OR junior_species='sjoestedtii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='sjoestedti' OR species='sjoestedtii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='sjoestedti' OR species='sjoestedtii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='sjoestedti' OR junior_species='sjoestedtii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dorylus' AND (species='sjoestedti' OR species='sjoestedtii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='wilverthi' OR junior_species='wilverthii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='wilverthi' OR species='wilverthii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='wilverthi' OR species='wilverthii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='wilverthi' OR junior_species='wilverthii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dorylus' AND (species='wilverthi' OR species='wilverthii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplolepis' AND (junior_species='tenella' OR junior_species='tenella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoplolepis' AND (species='tenella' OR species='tenella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anoplolepis' AND (species='tenella' OR species='tenella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplolepis' AND (junior_species='tenella' OR junior_species='tenella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anoplolepis' AND (species='tenella' OR species='tenella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='acvapimensis' OR junior_species='acvapimensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='acvapimensis' OR species='acvapimensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='acvapimensis' OR species='acvapimensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='acvapimensis' OR junior_species='acvapimensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='acvapimensis' OR species='acvapimensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='brutus' OR junior_species='brutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='brutus' OR species='brutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='brutus' OR species='brutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='brutus' OR junior_species='brutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='brutus' OR species='brutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='4' OR junior_species='4')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='4' OR species='4') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='4' OR species='4')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='4' OR junior_species='4')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='4' OR species='4') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='8' OR junior_species='8')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='8' OR species='8') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='8' OR species='8')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='8' OR junior_species='8')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='8' OR species='8') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' 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='Paratrechina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratrechina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratrechina' 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='Paratrechina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='militaris' OR junior_species='militaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='militaris' OR species='militaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='militaris' OR species='militaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='militaris' OR junior_species='militaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyrhachis' AND (species='militaris' OR species='militaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='weissi' OR junior_species='weissii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='weissi' OR species='weissii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='weissi' OR species='weissii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='weissi' OR junior_species='weissii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyrhachis' AND (species='weissi' OR species='weissii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalaucus' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catalaucus' AND (species='guineensis' OR species='guineensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catalaucus' AND (species='guineensis' OR species='guineensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalaucus' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catalaucus' AND (species='guineensis' OR species='guineensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalaucus' AND (junior_species='2' OR junior_species='2')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catalaucus' AND (species='2' OR species='2') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catalaucus' AND (species='2' OR species='2')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalaucus' AND (junior_species='2' OR junior_species='2')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catalaucus' AND (species='2' OR species='2') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='concava' OR junior_species='concava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='concava' OR species='concava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='concava' OR species='concava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='concava' OR junior_species='concava')SELECT d.diet,d.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='concava' OR species='concava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='striatula' OR junior_species='striatula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='striatula' OR species='striatula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='striatula' OR species='striatula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='striatula' OR junior_species='striatula')SELECT d.diet,d.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='striatula' OR species='striatula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' 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='Crematogaster' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='13' OR junior_species='13')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='13' OR species='13') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='13' OR species='13')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='13' OR junior_species='13')SELECT d.diet,d.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='13' OR species='13') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='15' OR junior_species='15')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='15' OR species='15') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='15' OR species='15')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='15' OR junior_species='15')SELECT d.diet,d.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='15' OR species='15') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decamorium' 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='Decamorium' AND (species='decem' OR species='decem') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Decamorium' AND (species='decem' OR species='decem')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decamorium' 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='Decamorium' AND (species='decem' OR species='decem') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='2' OR junior_species='2')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligomyrmex' AND (species='2' OR species='2') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligomyrmex' AND (species='2' OR species='2')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' AND (junior_species='2' OR junior_species='2')SELECT d.diet,d.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='2' OR species='2') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nimba' OR junior_species='nimba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='nimba' OR species='nimba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='nimba' OR species='nimba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='nimba' OR junior_species='nimba')SELECT d.diet,d.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='nimba' OR species='nimba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='pulchella' OR species='pulchella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='pulchella' OR species='pulchella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='pulchella' OR species='pulchella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='speculifera' OR junior_species='speculifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='speculifera' OR species='speculifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='speculifera' OR species='speculifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='speculifera' OR junior_species='speculifera')SELECT d.diet,d.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='speculifera' OR species='speculifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='2' OR junior_species='2')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='2' OR species='2') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='2' OR species='2')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='2' OR junior_species='2')SELECT d.diet,d.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='2' OR species='2') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='4' OR junior_species='4')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='4' OR species='4') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='4' OR species='4')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='4' OR junior_species='4')SELECT d.diet,d.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='4' OR species='4') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='8' OR junior_species='8')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='8' OR species='8') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='8' OR species='8')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='8' OR junior_species='8')SELECT d.diet,d.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='8' OR species='8') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' 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='Pheidole' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='coloreum' OR junior_species='coloreum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='coloreum' OR species='coloreum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='coloreum' OR species='coloreum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='coloreum' OR junior_species='coloreum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='coloreum' OR species='coloreum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='gabonense' OR junior_species='gabonense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='gabonense' OR species='gabonense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='gabonense' OR species='gabonense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='gabonense' OR junior_species='gabonense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='gabonense' OR species='gabonense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='guineense' OR junior_species='guineense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='guineense' OR species='guineense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='guineense' OR species='guineense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='guineense' OR junior_species='guineense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='guineense' OR species='guineense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='7' OR junior_species='7')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='7' OR species='7') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='7' OR species='7')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='7' OR junior_species='7')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='7' OR species='7') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='9' OR junior_species='9')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='9' OR species='9') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='9' OR species='9')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='9' OR junior_species='9')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='9' OR species='9') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='11' OR junior_species='11')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='11' OR species='11') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='11' OR species='11')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='11' OR junior_species='11')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='11' OR species='11') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='12' OR junior_species='12')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='12' OR species='12') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='12' OR species='12')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='12' OR junior_species='12')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='12' OR species='12') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='15' OR junior_species='15')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='15' OR species='15') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='15' OR species='15')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='15' OR junior_species='15')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetramorium' AND (species='15' OR species='15') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' 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='Anochetus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anochetus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' 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='Anochetus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centromyrmex' AND (junior_species='1' OR junior_species='1')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centromyrmex' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centromyrmex' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centromyrmex' AND (junior_species='1' OR junior_species='1')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centromyrmex' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' 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='Hypoponera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' 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='Hypoponera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' 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='Leptogenys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' 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='Leptogenys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='assiniensis' OR junior_species='assiniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='assiniensis' OR species='assiniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='assiniensis' OR species='assiniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='assiniensis' OR junior_species='assiniensis')SELECT d.diet,d.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='assiniensis' OR species='assiniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='analis' OR junior_species='analis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='brunoi' OR junior_species='brunoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='brunoi' OR species='brunoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='brunoi' OR species='brunoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='brunoi' OR junior_species='brunoii')SELECT d.diet,d.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='brunoi' OR species='brunoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='subiridescens' OR junior_species='subiridescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='subiridescens' OR species='subiridescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='subiridescens' OR species='subiridescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='subiridescens' OR junior_species='subiridescens')SELECT d.diet,d.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='subiridescens' OR species='subiridescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='tarsata' OR junior_species='tarsata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='tarsata' OR species='tarsata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='tarsata' OR species='tarsata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='tarsata' OR junior_species='tarsata')SELECT d.diet,d.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='tarsata' OR species='tarsata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='1' OR junior_species='1')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='1' OR junior_species='1')SELECT d.diet,d.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='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynoponera' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynoponera' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynoponera' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynoponera' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phrynoponera' AND (species='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plathythyrea' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plathythyrea' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plathythyrea' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plathythyrea' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plathythyrea' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plathythyrea' AND (junior_species='1' OR junior_species='1')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plathythyrea' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plathythyrea' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plathythyrea' AND (junior_species='1' OR junior_species='1')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plathythyrea' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' 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='Discothyrea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discothyrea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discothyrea' 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='Discothyrea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2023 The Ecological Register: La Belqique (very old secondary forest)
La Belqique (very old secondary forest)
Basic information
Sample name: La Belqique (very old secondary forest)

Reference: I. Deblauwe and W. Dekoninck. 2007. Diversity and distribution of ground-dwelling ants in a lowland rainforest in southeast Cameroon. Insectes Sociaux 54:334-342 [ER 2080]
Geography
Country: Cameroon


Coordinate: 3° 25' N, 13° 9' E
Coordinate basis: stated in text as range

Geography comments: "in southeast Cameroon on the northern periphery of the Dja Biosphere Reserve... in one of the many logging concessions surrounding the DBR"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 23.3

MAP: 1570.0

Habitat comments: "part of the transition zone of the Atlantic coastal rainforests of southern Nigeria and southwest Cameroon, and the evergreen forests of Equatorial Guinea and the Congo Basin"

Methods
Life forms: ants

Site length: 70

Sampling methods: line transect,pitfall traps

Sample size: 31616 individuals

Years: 2003 - 2005

Days: 60

Nets or traps: 56

Net or trap nights: 3360

Sampling comments: "Collection took place from June to August 2003 and from September 2004 to May 2005... pitfall traps were placed at least one week before the start of sampling to avoid 'digging-in' effects... One sampling event per month took place (12 sampling events in total)... a line transect of 70 m was established. Eight pitfalls were spaced at 10 m intervals along the transect. Each group of pitfalls (56 traps in total) was located at least 230 m from another group... All traps were left open for five days per sampling event"

Metadata
Sample number: 2023

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-05-31 21:09:21

Modified: 2016-05-31 11:09:21

Abundance distribution
62 species
22 singletons
total count 31616
extrapolated richness: 111.9
Fisher's α: 7.418
geometric series k: 0.8463
Hurlbert's PIE: 0.3019
Shannon's H: 0.8292
Good's u: 0.9993
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aenictis sp. 11
Technomyrmex (sp.) 1 (wolfi)61
Technomyrmex sp. 21
Technomyrmex sp. 31
Technomyrmex sp. 41
Dorylus (Anomma) emeryi58
Dorylus (Anomma) kohli13
Dorylus (Anomma) sjoestedti26315
Dorylus (Anomma) wilverthi878
Anoplolepis tenella713
Camponotus acvapimensis90
Camponotus brutus1913
Camponotus (sp.) 4 (langi)6
Camponotus (sp.) 8 (pompeius)32
Paratrechina sp. 11
Polyrhachis militaris4
Polyrhachis weissi1
Catalaucus guineensis2
Catalaucus (sp.) 2 (erinaceus)1
Crematogaster concava147
Crematogaster striatula80
Crematogaster sp. 512
Crematogaster sp. 81
Crematogaster sp. 102
Crematogaster (sp.) 13 (depressa)40
Crematogaster (sp.) 15 (gambiensis)1
Decamorium decem5
Oligomyrmex (sp.) 2 (silvestri)1
Pheidole nimba28
Pheidole pulchella1
Pheidole speculifera8
Pheidole sp. 170
Pheidole (sp.) 2 (megacephala)174
Pheidole (sp.) 4 (minima)68
Pheidole sp. 535
Pheidole sp. 6355
Pheidole sp. 749
Pheidole (sp.) 8 (crassinoda)1
Pheidole sp. 1014
Pheidole sp. 122
Tetramorium coloreum1
Tetramorium gabonense310
Tetramorium guineense8
Tetramorium (sp.) 7 (dumezi)1
Tetramorium (sp.) 9 (furtivum)4
Tetramorium (sp.) 11 (lucayanum)7
Tetramorium (sp.) 12 (pylacum)1
Tetramorium (sp.) 15 (osiris)5
Anochetus sp. 42
Centromyrmex (sp.) 1 (sellaris)1
Hypoponera sp. 21
Leptogenys sp. 11
Odontomachus assiniensis7
Pachycondyla analis2
Pachycondyla brunoi1
Pachycondyla subiridescens2
Pachycondyla tarsata41
Pachycondyla (sp.) 1 (lamottei)30
Phrynoponera gabonensis2
Plathythyrea occidentalis1
Plathythyrea (sp.) 1 (schultzei)1
Discothyrea sp. 11