Coordinate: 57° 46' N, 40° 56' E
coordinate based on the town of Kostroma in Sudislavsky District, about 15 km west of Lazarevo
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=3108 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3108SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2899SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3108 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='niger' OR species='niger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='niger' OR junior_species='niger')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='niger' OR species='niger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='oblongopunctatus' OR junior_species='oblongopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='oblongopunctatus' OR species='oblongopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='oblongopunctatus' OR species='oblongopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='oblongopunctatus' OR junior_species='oblongopunctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='oblongopunctatus' OR species='oblongopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='strenuus' OR junior_species='strenuus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='strenuus' OR species='strenuus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='strenuus' OR species='strenuus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='strenuus' OR junior_species='strenuus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='strenuus' OR species='strenuus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='melanarius' OR species='melanarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='melanarius' OR species='melanarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='melanarius' OR species='melanarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='nigrita' OR species='nigrita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='nigrita' OR species='nigrita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='nigrita' OR junior_species='nigrita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='nigrita' OR species='nigrita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='minor' OR junior_species='minor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='aethiops' OR junior_species='aethiops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='aethiops' OR species='aethiops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='aethiops' OR species='aethiops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='aethiops' OR junior_species='aethiops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostichus' AND (species='aethiops' OR species='aethiops') 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='granulatus' OR junior_species='granulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='granulatus' OR species='granulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='granulatus' OR species='granulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='granulatus' OR junior_species='granulatus')SELECT d.diet,d.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='granulatus' OR species='granulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='cancellatus' OR junior_species='cancellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='cancellatus' OR species='cancellatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='cancellatus' OR species='cancellatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='cancellatus' OR junior_species='cancellatus')SELECT d.diet,d.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='cancellatus' OR species='cancellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='lampros' OR species='lampros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='lampros' OR species='lampros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bembidion' AND (species='lampros' OR species='lampros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='laevipes' OR junior_species='laevipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='laevipes' OR species='laevipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='laevipes' OR species='laevipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='laevipes' OR junior_species='laevipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harpalus' AND (species='laevipes' OR species='laevipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' 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='Harpalus' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' 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='Harpalus' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' 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='Harpalus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' 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='Harpalus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='palustris' OR junior_species='palustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='palustris' OR species='palustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='palustris' OR junior_species='palustris')SELECT d.diet,d.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='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platynus' AND (species='assimilis' OR species='assimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platynus' AND (species='assimilis' OR species='assimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platynus' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platynus' AND (species='assimilis' OR species='assimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='micropterus' OR junior_species='micropterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='micropterus' OR species='micropterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='micropterus' OR species='micropterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='micropterus' OR junior_species='micropterus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Calathus' AND (species='micropterus' OR species='micropterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='bullatus' OR junior_species='bullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Badister' AND (species='bullatus' OR species='bullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Badister' AND (species='bullatus' OR species='bullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Badister' AND (junior_species='bullatus' OR junior_species='bullatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Badister' AND (species='bullatus' OR species='bullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')SELECT d.diet,d.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='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT d.diet,d.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='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='caraboides' OR junior_species='caraboides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cychrus' AND (species='caraboides' OR species='caraboides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cychrus' AND (species='caraboides' OR species='caraboides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cychrus' AND (junior_species='caraboides' OR junior_species='caraboides')SELECT d.diet,d.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='caraboides' OR species='caraboides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypselaphus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxypselaphus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxypselaphus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypselaphus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxypselaphus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loricera' AND (junior_species='pilicornis' OR junior_species='pilicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loricera' AND (species='pilicornis' OR species='pilicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loricera' AND (species='pilicornis' OR species='pilicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loricera' AND (junior_species='pilicornis' OR junior_species='pilicornis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loricera' AND (species='pilicornis' OR species='pilicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stomis' AND (junior_species='pumicatus' OR junior_species='pumicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stomis' AND (species='pumicatus' OR species='pumicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stomis' AND (species='pumicatus' OR species='pumicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stomis' AND (junior_species='pumicatus' OR junior_species='pumicatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stomis' AND (species='pumicatus' OR species='pumicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='terminatus' OR junior_species='terminatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leistus' AND (species='terminatus' OR species='terminatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leistus' AND (species='terminatus' OR species='terminatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='terminatus' OR junior_species='terminatus')SELECT d.diet,d.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='terminatus' OR species='terminatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patrobus' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patrobus' AND (species='assimilis' OR species='assimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patrobus' AND (species='assimilis' OR species='assimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patrobus' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Patrobus' AND (species='assimilis' OR species='assimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patrobus' AND (junior_species='atrorufus' OR junior_species='atrorufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patrobus' AND (species='atrorufus' OR species='atrorufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patrobus' AND (species='atrorufus' OR species='atrorufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patrobus' AND (junior_species='atrorufus' OR junior_species='atrorufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Patrobus' AND (species='atrorufus' OR species='atrorufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechus' AND (junior_species='secalis' OR junior_species='secalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trechus' AND (species='secalis' OR species='secalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trechus' AND (species='secalis' OR species='secalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechus' AND (junior_species='secalis' OR junior_species='secalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trechus' AND (species='secalis' OR species='secalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3108