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=889 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=889SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=519SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=889 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='javanus' OR junior_species='javanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aenictus' AND (species='javanus' OR species='javanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aenictus' AND (species='javanus' OR species='javanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='javanus' OR junior_species='javanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aenictus' AND (species='javanus' OR species='javanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='camposi' OR junior_species='camposii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aenictus' AND (species='camposi' OR species='camposii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aenictus' AND (species='camposi' OR species='camposii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='camposi' OR junior_species='camposii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aenictus' AND (species='camposi' OR species='camposii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='dentatus' OR junior_species='dentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aenictus' AND (species='dentatus' OR species='dentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aenictus' AND (species='dentatus' OR species='dentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' AND (junior_species='dentatus' OR junior_species='dentatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aenictus' AND (species='dentatus' OR species='dentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' 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='Aenictus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aenictus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aenictus' 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='Aenictus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' 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='Cerapachys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerapachys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerapachys' 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='Cerapachys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichoderus' AND (junior_species='thoracicus' OR junior_species='thoracicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichoderus' AND (species='thoracicus' OR species='thoracicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichoderus' AND (species='thoracicus' OR species='thoracicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichoderus' AND (junior_species='thoracicus' OR junior_species='thoracicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dolichoderus' AND (species='thoracicus' OR species='thoracicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochetellus' 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='Ochetellus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochetellus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochetellus' 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='Ochetellus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='indicum' OR junior_species='indicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinoma' AND (species='indicum' OR species='indicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinoma' AND (species='indicum' OR species='indicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='indicum' OR junior_species='indicum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tapinoma' AND (species='indicum' OR species='indicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='melanochepalum' OR junior_species='melanochepalum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapinoma' AND (species='melanochepalum' OR species='melanochepalum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapinoma' AND (species='melanochepalum' OR species='melanochepalum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapinoma' AND (junior_species='melanochepalum' OR junior_species='melanochepalum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tapinoma' AND (species='melanochepalum' OR species='melanochepalum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='reticulatus' OR junior_species='reticulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='reticulatus' OR species='reticulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='reticulatus' OR species='reticulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='reticulatus' OR junior_species='reticulatus')SELECT d.diet,d.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='reticulatus' OR species='reticulatus') 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='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='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='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='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='Polyrhachis' AND (junior_species='dives' OR junior_species='dives')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='dives' OR species='dives') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='dives' OR species='dives')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='dives' OR junior_species='dives')SELECT d.diet,d.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='dives' OR species='dives') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='proxima' OR junior_species='proxima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyrhachis' AND (species='proxima' OR species='proxima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='proxima' OR species='proxima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' AND (junior_species='proxima' OR junior_species='proxima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyrhachis' AND (species='proxima' OR species='proxima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' 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='Polyrhachis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyrhachis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyrhachis' 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='Polyrhachis' AND (species='sp.' OR species='sp.') 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='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='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='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='Oechophylla' AND (junior_species='smaradigna' OR junior_species='smaradigna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oechophylla' AND (species='smaradigna' OR species='smaradigna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oechophylla' AND (species='smaradigna' OR species='smaradigna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oechophylla' AND (junior_species='smaradigna' OR junior_species='smaradigna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oechophylla' AND (species='smaradigna' OR species='smaradigna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplolepis' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoplolepis' AND (species='gracilipes' OR species='gracilipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anoplolepis' AND (species='gracilipes' OR species='gracilipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplolepis' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT d.diet,d.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='gracilipes' OR species='gracilipes') 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='difformis' OR junior_species='difformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='difformis' OR species='difformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='difformis' OR species='difformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='difformis' OR junior_species='difformis')SELECT d.diet,d.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='difformis' OR species='difformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' 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='Pyramica' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyramica' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyramica' 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='Pyramica' 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='kraepelini' OR junior_species='kraepelinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='kraepelini' OR species='kraepelinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='kraepelini' OR species='kraepelinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='kraepelini' OR junior_species='kraepelinii')SELECT d.diet,d.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='kraepelini' OR species='kraepelinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='rogeri' OR species='rogerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='rogeri' OR species='rogerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='rogeri' OR junior_species='rogerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='rogeri' OR species='rogerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='emmae' OR junior_species='emmae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='emmae' OR species='emmae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='emmae' OR species='emmae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='emmae' OR junior_species='emmae')SELECT d.diet,d.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='emmae' OR species='emmae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardiocondyla' 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='Cardiocondyla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardiocondyla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardiocondyla' 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='Cardiocondyla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meranoplus' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meranoplus' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meranoplus' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meranoplus' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meranoplus' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophomyrmex' AND (junior_species='opaciceps' OR junior_species='opaciceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophomyrmex' AND (species='opaciceps' OR species='opaciceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophomyrmex' AND (species='opaciceps' OR species='opaciceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophomyrmex' AND (junior_species='opaciceps' OR junior_species='opaciceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophomyrmex' AND (species='opaciceps' OR species='opaciceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidologeton' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidologeton' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidologeton' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidologeton' AND (junior_species='affinis' OR junior_species='affinis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidologeton' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidologeton' 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='Pheidologeton' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidologeton' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidologeton' 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='Pheidologeton' 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='plagiaria' OR junior_species='plagiaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='plagiaria' OR species='plagiaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='plagiaria' OR species='plagiaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='plagiaria' OR junior_species='plagiaria')SELECT d.diet,d.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='plagiaria' OR species='plagiaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='butteli' OR junior_species='buttelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='butteli' OR species='buttelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='butteli' OR species='buttelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='butteli' OR junior_species='buttelii')SELECT d.diet,d.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='butteli' OR species='buttelii') 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='Trichomyrmex' AND (junior_species='destructor' OR junior_species='destructor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichomyrmex' AND (species='destructor' OR species='destructor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichomyrmex' AND (species='destructor' OR species='destructor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichomyrmex' AND (junior_species='destructor' OR junior_species='destructor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichomyrmex' AND (species='destructor' OR species='destructor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='floricola' OR junior_species='floricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='floricola' OR species='floricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='floricola' OR species='floricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='floricola' OR junior_species='floricola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monomorium' AND (species='floricola' OR species='floricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='pharaonis' OR junior_species='pharaonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monomorium' AND (species='pharaonis' OR species='pharaonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monomorium' AND (species='pharaonis' OR species='pharaonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monomorium' AND (junior_species='pharaonis' OR junior_species='pharaonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monomorium' AND (species='pharaonis' OR species='pharaonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='pacificum' OR junior_species='pacificum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='pacificum' OR species='pacificum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='pacificum' OR species='pacificum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='pacificum' OR junior_species='pacificum')SELECT d.diet,d.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='pacificum' OR species='pacificum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='similinum' OR junior_species='similinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='similinum' OR species='similinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='similinum' OR species='similinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='similinum' OR junior_species='similinum')SELECT d.diet,d.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='similinum' OR species='similinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='graefferi' OR junior_species='graefferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anochetus' AND (species='graefferi' OR species='graefferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anochetus' AND (species='graefferi' OR species='graefferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anochetus' AND (junior_species='graefferi' OR junior_species='graefferii')SELECT d.diet,d.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='graefferi' OR species='graefferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='rixosus' OR junior_species='rixosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='rixosus' OR species='rixosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='rixosus' OR species='rixosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='rixosus' OR junior_species='rixosus')SELECT d.diet,d.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='rixosus' OR species='rixosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='simillimus' OR junior_species='simillimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontomachus' AND (species='simillimus' OR species='simillimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontomachus' AND (species='simillimus' OR species='simillimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontomachus' AND (junior_species='simillimus' OR junior_species='simillimus')SELECT d.diet,d.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='simillimus' OR species='simillimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacamma' AND (junior_species='rugosum' OR junior_species='rugosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diacamma' AND (species='rugosum' OR species='rugosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diacamma' AND (species='rugosum' OR species='rugosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diacamma' AND (junior_species='rugosum' OR junior_species='rugosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diacamma' AND (species='rugosum' OR species='rugosum') 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='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='mutabilis' OR junior_species='mutabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptogenys' AND (species='mutabilis' OR species='mutabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptogenys' AND (species='mutabilis' OR species='mutabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptogenys' AND (junior_species='mutabilis' OR junior_species='mutabilis')SELECT d.diet,d.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='mutabilis' OR species='mutabilis') 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='Odontoponera' AND (junior_species='denticulata' OR junior_species='denticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontoponera' AND (species='denticulata' OR species='denticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontoponera' AND (species='denticulata' OR species='denticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontoponera' AND (junior_species='denticulata' OR junior_species='denticulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontoponera' AND (species='denticulata' OR species='denticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='sharpi' OR junior_species='sharpii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='sharpi' OR species='sharpii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='sharpi' OR species='sharpii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='sharpi' OR junior_species='sharpii')SELECT d.diet,d.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='sharpi' OR species='sharpii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT d.diet,d.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='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='javana' OR junior_species='javana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='javana' OR species='javana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='javana' OR species='javana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='javana' OR junior_species='javana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='javana' OR species='javana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=889 The Ecological Register: Bogor Botanic Garden
Bogor Botanic Garden
Basic information
Sample name: Bogor Botanic Garden

Reference: H. Herwina and K. Nakamura. 2007. Ant species diversity study using pitfall traps in a small yard in Bogor Botanic Garden, West Java, Indonesia. Treubia 35:99-116 [ER 519]
Geography
Country: Indonesia

State: West Java


Coordinate: 6° 37' S, 106° 47' E
Coordinate basis: stated in text

Geography comments: "a small yard ground (15 x 20 m2)" in the botanic garden

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

WMT: 28.0

CMT: 25.0

MAP: 3850.0

Habitat comments: "Monthly temperature ranged from about 25 to 28 o C" (assumed to mean CMT and WMT)

Methods
Life forms: ants

Sampling methods: no design,pitfall traps

Sample size: 29406 individuals

Years: 2000 - 2003

Sampling comments: "115 sampling times" with each trap being left open for a week; the number of traps is not indicated

Metadata
Sample number: 889

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-30 20:12:29

Modified: 2020-01-14 04:45:41

Abundance distribution
55 species
3 singletons
total count 29406
extrapolated richness: 65.5
Fisher's α: 6.539
geometric series k: 0.8362
Hurlbert's PIE: 0.6920
Shannon's H: 1.9715
Good's u: 0.9999
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aenictus javanus173
Aenictus camposi235
Aenictus dentatus46
Aenictus sp. 11244
Cerapachys sp.2
Dolichoderus thoracicus761
Ochetellus sp. 18
Tapinoma indicum20
Tapinoma melanochepalum43
Camponotus (Myrmanblys) reticulatus bedoti8
Camponotus (Myrmanblys) sp. 113
Camponotus (Tanaemyrmex) sp. 255
Camponotus sp. 34
Camponotus sp. 42
Camponotus (Tanaemyrmex) sp. 51
Polyrhachis (Myrmhopla) dives3
Polyrhachis (Myrma) proxima1
Polyrhachis (Myrma) sp. 33
Paratrechina sp. 1758
Paratrechina sp. 225
Paratrechina sp. 75
Paratrechina sp. 91
Oechophylla smaradigna5
Anoplolepis gracilipes3586
Crematogaster sp. 15
Crematogaster difformis3
Pyramica sp. 138
Strumigenys ? kraepelini87
Strumigenys rogeri5
Strumigenys emmae6
Cardiocondyla sp. 53
Meranoplus 'bicolor'5
Lophomyrmex opaciceps872
Pheidologeton affinis733
Pheidologeton sp. 1835
Pheidole plagiaria15703
Pheidole butteli34
Pheidole sp. 17
Trichomyrmex destructor624
"Monomorium destructor"
Monomorium floricola39
Monomorium pharaonis54
Tetramorium pacificum247
Tetramorium similinum224
Anochetus graefferi98
Odontomachus rixosus3
Odontomachus simillimus559
Diacamma rugosum160
Hypoponera sp. 1359
Hypoponera sp. 34
Leptogenys mutabilis564
Leptogenys sp. 1112
Odontoponera denticulata851
Pachycondyla sharpi162
Pachycondyla chinensis6
Pachycondyla ? javana2