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=2022 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2022SELECT 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=2022 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='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='mayri' OR junior_species='mayrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='mayri' OR species='mayrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='mayri' OR species='mayrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='mayri' OR junior_species='mayrii')SELECT d.diet,d.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='mayri' OR species='mayrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='opacus' OR junior_species='opacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorylus' AND (species='opacus' OR species='opacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='opacus' OR species='opacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' AND (junior_species='opacus' OR junior_species='opacus')SELECT d.diet,d.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='opacus' OR species='opacus') 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='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='Dorylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorylus' 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='Dorylus' AND (species='sp.' OR species='sp.') 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='3' OR junior_species='3')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='3' OR species='3') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='3' OR species='3')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='3' OR junior_species='3')SELECT d.diet,d.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='3' OR species='3') 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='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='Camponotus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' 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='Camponotus' AND (species='sp.' OR species='sp.') 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='Lepisiota' 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='Lepisiota' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepisiota' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisiota' 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='Lepisiota' AND (species='1' OR species='1') 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='curta' OR junior_species='curta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='curta' OR species='curta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='curta' OR species='curta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='curta' OR junior_species='curta')SELECT d.diet,d.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='curta' OR species='curta') 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='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='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='Catalaucus' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catalaucus' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catalaucus' 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='Catalaucus' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='claviventris' OR junior_species='claviventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='claviventris' OR species='claviventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='claviventris' OR species='claviventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='claviventris' OR junior_species='claviventris')SELECT d.diet,d.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='claviventris' OR species='claviventris') 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='6' OR junior_species='6')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='6' OR species='6') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='6' OR species='6')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='6' OR junior_species='6')SELECT d.diet,d.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='6' OR species='6') 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='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='Oligomyrmex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligomyrmex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligomyrmex' 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='Oligomyrmex' 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='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='Pyramica' 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='Pyramica' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' 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='Pyramica' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' 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='Solenopsis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solenopsis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solenopsis' 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='Solenopsis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' 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='Strumigenys' AND (species='1' OR species='1') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='1' OR species='1')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' 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='Strumigenys' AND (species='1' OR species='1') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='aculeatum' OR junior_species='aculeatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='aculeatum' OR species='aculeatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='aculeatum' OR species='aculeatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='aculeatum' OR junior_species='aculeatum')SELECT d.diet,d.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='aculeatum' OR species='aculeatum') 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='diomandei' OR junior_species='diomandeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='diomandei' OR species='diomandeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='diomandei' OR species='diomandeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='diomandei' OR junior_species='diomandeii')SELECT d.diet,d.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='diomandei' OR species='diomandeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='flavithorax' OR junior_species='flavithorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='flavithorax' OR species='flavithorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='flavithorax' OR species='flavithorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='flavithorax' OR junior_species='flavithorax')SELECT d.diet,d.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='flavithorax' OR species='flavithorax') 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='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='Tetramorium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' 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='Tetramorium' 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='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='Tetramorium' AND (species='4' OR species='4') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='4' OR species='4')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' 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='Tetramorium' AND (species='4' OR species='4') 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='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='Tetramorium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' 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='Tetramorium' 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='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='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='Tetramorium' AND (junior_species='18' OR junior_species='18')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='18' OR species='18') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='18' OR species='18')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='18' OR junior_species='18')SELECT d.diet,d.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='18' OR species='18') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='19' OR junior_species='19')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='19' OR species='19') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='19' OR species='19')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='19' OR junior_species='19')SELECT d.diet,d.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='19' OR species='19') 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='Leptogenys' 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='Leptogenys' AND (species='2' OR species='2') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='2' OR species='2')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' 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='Leptogenys' AND (species='2' OR species='2') 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='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='Pachycondyla' 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='Pachycondyla' AND (species='2' OR species='2') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='2' OR species='2')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' 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='Pachycondyla' AND (species='2' OR species='2') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' 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='Pachycondyla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' 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='Pachycondyla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraponera' AND (junior_species='mocquerysi' OR junior_species='mocquerysii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetraponera' AND (species='mocquerysi' OR species='mocquerysii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetraponera' AND (species='mocquerysi' OR species='mocquerysii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraponera' AND (junior_species='mocquerysi' OR junior_species='mocquerysii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tetraponera' AND (species='mocquerysi' OR species='mocquerysii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2022 The Ecological Register: La Belqique (near primary forest)
La Belqique (near primary forest)
Basic information
Sample name: La Belqique (near primary 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

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: 46357 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: 2022

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-05-31 20:58:16

Modified: 2016-05-31 10:58:16

Abundance distribution
63 species
19 singletons
total count 46357
extrapolated richness: 104.0
Fisher's α: 7.181
geometric series k: 0.8497
Hurlbert's PIE: 0.6192
Shannon's H: 1.2598
Good's u: 0.9996
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)30
Technomyrmex sp. 22
Technomyrmex sp. 31
Dorylus (Anomma) emeryi24293
Dorylus (Anomma) mayri14048
Dorylus (Anomma) opacus6
Dorylus (Anomma) sjoestedti5506
Dorylus (Dorylus) sp.9
Camponotus brutus239
Camponotus (sp.) 3 (vividus)1
Camponotus (sp.) 4 (langi)316
Camponotus sp. 6 (maculatus group)6
Camponotus (sp.) 8 (pompeius)18
Lepisiota (sp.) 1 (silvicola)98
Paratrechina sp. 21
Polyrhachis curta1
Polyrhachis militaris16
Catalaucus guineensis1
Catalaucus (sp.) 1 (brevisetosus)1
Crematogaster claviventris1
Crematogaster striatula9
Crematogaster (sp.) 6 (kneri)1
Decamorium decem5
Oligomyrmex sp. 3 (nicotiana group)495
Pheidole nimba6
Pheidole pulchella120
Pheidole speculifera21
Pheidole sp. 1109
Pheidole (sp.) 2 (megacephala)301
Pheidole (sp.) 4 (minima)125
Pheidole sp. 527
Pheidole sp. 65
Pheidole sp. 7134
Pheidole (sp.) 8 (crassinoda)5
Pheidole sp. 109
Pheidole sp. 1241
Pyramica (sp.) 1 (concolor)1
Solenopsis sp. 11
Strumigenys (sp.) 1 (bernardi)1
Tetramorium aculeatum8
Tetramorium coloreum9
Tetramorium diomandei1
Tetramorium flavithorax3
Tetramorium gabonense173
Tetramorium guineense12
Tetramorium sp. 11
Tetramorium (sp.) 4 (brevispinosum)1
Tetramorium (sp.) 9 (furtivum)3
Tetramorium sp. 101
Tetramorium (sp.) 11 (lucayanum)8
Tetramorium (sp.) 15 (osiris)4
Tetramorium (sp.) 18 (sitefrum)6
Tetramorium (sp.) 19 (weitzeckeri)2
Anochetus sp. 22
Leptogenys (sp.) 2 (occidentalis)1
Pachycondyla analis1
Pachycondyla brunoi6
Pachycondyla tarsata90
Pachycondyla (sp.) 1 (lammottei)7
Pachycondyla (sp.) 2 (caffraria)2
Pachycondyla sp. 44
Tetraponera mocquerysi1