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=1787 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1787SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1298SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1787 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='carinatus' OR junior_species='carinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abax' AND (species='carinatus' OR species='carinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abax' AND (species='carinatus' OR species='carinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='carinatus' OR junior_species='carinatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abax' AND (species='carinatus' OR species='carinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='parallelepipedus' OR junior_species='parallelepipedus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abax' AND (species='parallelepipedus' OR species='parallelepipedus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abax' AND (species='parallelepipedus' OR species='parallelepipedus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='parallelepipedus' OR junior_species='parallelepipedus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abax' AND (species='parallelepipedus' OR species='parallelepipedus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abax' AND (species='parallelus' OR species='parallelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abax' AND (species='parallelus' OR species='parallelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abax' AND (species='parallelus' OR species='parallelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='aenea' OR junior_species='aenea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amara' AND (species='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aptinus' AND (junior_species='bombarda' OR junior_species='bombarda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aptinus' AND (species='bombarda' OR species='bombarda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aptinus' AND (species='bombarda' OR species='bombarda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aptinus' AND (junior_species='bombarda' OR junior_species='bombarda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aptinus' AND (species='bombarda' OR species='bombarda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='convexus' OR junior_species='convexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='convexus' OR species='convexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='convexus' OR species='convexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='convexus' OR junior_species='convexus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='convexus' OR species='convexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='coriaceus' OR junior_species='coriaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='coriaceus' OR species='coriaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='coriaceus' OR species='coriaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='coriaceus' OR junior_species='coriaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='coriaceus' OR species='coriaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='gigas' OR junior_species='gigas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='gigas' OR species='gigas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='gigas' OR species='gigas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='gigas' OR junior_species='gigas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='gigas' OR species='gigas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='intricatus' OR junior_species='intricatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='intricatus' OR species='intricatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='intricatus' OR species='intricatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='intricatus' OR junior_species='intricatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='intricatus' OR species='intricatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='nemoralis' OR junior_species='nemoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='nemoralis' OR species='nemoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='nemoralis' OR species='nemoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='nemoralis' OR junior_species='nemoralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='nemoralis' OR species='nemoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='praecellens' OR junior_species='praecellens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='praecellens' OR species='praecellens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='praecellens' OR species='praecellens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='praecellens' OR junior_species='praecellens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='praecellens' OR species='praecellens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='ulrichii' OR junior_species='ulrichi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='ulrichii' OR species='ulrichi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='ulrichii' OR species='ulrichi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='ulrichii' OR junior_species='ulrichi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='ulrichii' OR species='ulrichi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='violaceus' OR junior_species='violaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='violaceus' OR species='violaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='violaceus' OR species='violaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='violaceus' OR junior_species='violaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carabus' AND (species='violaceus' OR species='violaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='attenuatus' OR junior_species='attenuatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cychrus' AND (species='attenuatus' OR species='attenuatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cychrus' AND (species='attenuatus' OR species='attenuatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='attenuatus' OR junior_species='attenuatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cychrus' AND (species='attenuatus' OR species='attenuatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='rufomarginatus' OR junior_species='rufomarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leistus' AND (species='rufomarginatus' OR species='rufomarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leistus' AND (species='rufomarginatus' OR species='rufomarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='rufomarginatus' OR junior_species='rufomarginatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leistus' AND (species='rufomarginatus' OR species='rufomarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molops' AND (junior_species='piceus' OR junior_species='piceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molops' AND (species='piceus' OR species='piceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molops' AND (species='piceus' OR species='piceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molops' AND (junior_species='piceus' OR junior_species='piceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Molops' AND (species='piceus' OR species='piceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Notiophilus' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoophonus' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoophonus' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoophonus' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoophonus' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoophonus' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='subterranea' OR junior_species='subterranea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='subterranea' OR species='subterranea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='subterranea' OR species='subterranea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='subterranea' OR junior_species='subterranea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphaenogaster' AND (species='subterranea' OR species='subterranea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='fallax' OR junior_species='fallax')SELECT d.diet,d.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='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='schmidti' OR junior_species='schmidtii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='schmidti' OR species='schmidtii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='schmidti' OR species='schmidtii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='schmidti' OR junior_species='schmidtii')SELECT d.diet,d.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='schmidti' OR species='schmidtii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichoderus' AND (junior_species='quadripunctatus' OR junior_species='quadripunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichoderus' AND (species='quadripunctatus' OR species='quadripunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichoderus' AND (species='quadripunctatus' OR species='quadripunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichoderus' AND (junior_species='quadripunctatus' OR junior_species='quadripunctatus')SELECT d.diet,d.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='quadripunctatus' OR species='quadripunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formica' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='gagates' OR junior_species='gagates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='gagates' OR species='gagates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='gagates' OR species='gagates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='gagates' OR junior_species='gagates')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formica' AND (species='gagates' OR species='gagates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='brunneus' OR junior_species='brunneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='brunneus' OR species='brunneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='brunneus' OR species='brunneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='brunneus' OR junior_species='brunneus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasius' AND (species='brunneus' OR species='brunneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='emarginatus' OR junior_species='emarginatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='emarginatus' OR species='emarginatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='emarginatus' OR species='emarginatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='emarginatus' OR junior_species='emarginatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasius' AND (species='emarginatus' OR species='emarginatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='fuliginosus' OR species='fuliginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasius' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecina' AND (junior_species='graminicola' OR junior_species='graminicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmecina' AND (species='graminicola' OR species='graminicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmecina' AND (species='graminicola' OR species='graminicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecina' AND (junior_species='graminicola' OR junior_species='graminicola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmecina' AND (species='graminicola' OR species='graminicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='ruginodis' OR junior_species='ruginodis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmica' AND (species='ruginodis' OR species='ruginodis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmica' AND (species='ruginodis' OR species='ruginodis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='ruginodis' OR junior_species='ruginodis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmica' AND (species='ruginodis' OR species='ruginodis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prenolepis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prenolepis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prenolepis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prenolepis' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prenolepis' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='debile' OR junior_species='debile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenamma' AND (species='debile' OR species='debile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenamma' AND (species='debile' OR species='debile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenamma' AND (junior_species='debile' OR junior_species='debile')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stenamma' AND (species='debile' OR species='debile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnothorax' AND (junior_species='crassispinus' OR junior_species='crassispinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temnothorax' AND (species='crassispinus' OR species='crassispinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temnothorax' AND (species='crassispinus' OR species='crassispinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnothorax' AND (junior_species='crassispinus' OR junior_species='crassispinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Temnothorax' AND (species='crassispinus' OR species='crassispinus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1787 The Ecological Register: Mount Medvednica plot 1
Mount Medvednica plot 1
Basic information
Sample name: Mount Medvednica plot 1

Reference: L. Seric Jelaska, A. Jesovnik, S. D. Jelaska, A. Pirnat, M. Kucinic, and P. Durbesic. 2010. Variations of carabid beetle and ant assemblages, and their morpho-ecological traits within natural temperate forests in Medvednica Nature Park. Sumarski list 134:475-486 [ER 1298]
Geography
Country: Croatia


Coordinate: 45° 55' N, 15° 58' E
Coordinate basis: based on nearby landmark

Geography comments: "along the central profile of Mt. Medvednica"
coordinate based on Medvednica

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 6.9

MAP: 1262.0

Habitat comments: a "mature" stand of "Querco–Castaneetum sativae" forest
climate data are for Mount Medvednica and are from Vukovic et al. (2010, Acta Societatis Botanicorum Poloniae)

Methods
Life forms: ants,ground beetles

Sampling methods: quadrat,pitfall traps

Sample size: 5487 individuals

Years: 2001, 2002

Seasons: winter,spring,summer,autumn

Nets or traps: 16

Sampling comments: "16 pitfall traps... placed in a regular rectangular net with cell size of 10 x 10 meters placed five meters from the edges of the plot... Traps were filled with ethanol (96%), acetic acid (9%) and water in equal proportions and emptied every two to three weeks from March 2001 to April 2002"

Metadata
Sample number: 1787

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-10-25 08:52:42

Modified: 2016-01-17 06:28:26

Abundance distribution
32 species
2 singletons
total count 5487
extrapolated richness: 36.7
Fisher's α: 4.503
geometric series k: 0.7976
Hurlbert's PIE: 0.8906
Shannon's H: 2.4970
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
Abax carinatus156
Abax parallelepipedus654
Abax parallelus498
Amara aenea3
Aptinus bombarda1108
Carabus convexus445
Carabus coriaceus34
Carabus gigas16
Carabus intricatus132
Carabus nemoralis636
Carabus praecellens18
Carabus ulrichii548
Carabus violaceus23
Cychrus attenuatus43
Leistus rufomarginatus3
Molops piceus20
Notiophilus rufipes23
Pseudoophonus rufipes1
Aphaenogaster subterranea57
Camponotus fallax2
Crematogaster schmidti26
Dolichoderus quadripunctatus8
Formica fusca14
Formica gagates22
Lasius brunneus14
Lasius emarginatus629
Lasius fuliginosus1
Myrmecina graminicola28
Myrmica ruginodis50
Prenolepis nitens135
Stenamma debile6
Temnothorax crassispinus134