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=2239 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2239SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2204SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2239 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='ovalis' OR junior_species='ovalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abax' AND (species='ovalis' OR species='ovalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abax' AND (species='ovalis' OR species='ovalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abax' AND (junior_species='ovalis' OR junior_species='ovalis')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='ovalis' OR species='ovalis') 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='Agonum' AND (junior_species='emarginatum' OR junior_species='emarginatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='emarginatum' OR species='emarginatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='emarginatum' OR species='emarginatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='emarginatum' OR junior_species='emarginatum')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='Agonum' AND (species='emarginatum' OR species='emarginatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='viduum' OR junior_species='viduum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='viduum' OR species='viduum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='viduum' OR species='viduum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='viduum' OR junior_species='viduum')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='Agonum' AND (species='viduum' OR species='viduum') 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='Amara' AND (junior_species='convexior' OR junior_species='convexior')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='convexior' OR species='convexior') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='convexior' OR species='convexior')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='convexior' OR junior_species='convexior')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='convexior' OR species='convexior') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='equestris' OR junior_species='equestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='equestris' OR species='equestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='equestris' OR species='equestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='equestris' OR junior_species='equestris')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='equestris' OR species='equestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='eurynota' OR junior_species='eurynota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='eurynota' OR species='eurynota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='eurynota' OR species='eurynota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='eurynota' OR junior_species='eurynota')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='eurynota' OR species='eurynota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='familiaris' OR junior_species='familiaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='familiaris' OR species='familiaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='familiaris' OR species='familiaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='familiaris' OR junior_species='familiaris')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='familiaris' OR species='familiaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='lunicollis' OR junior_species='lunicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='lunicollis' OR species='lunicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='lunicollis' OR species='lunicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='lunicollis' OR junior_species='lunicollis')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='lunicollis' OR species='lunicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='nitida' OR junior_species='nitida')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='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='ovata' OR junior_species='ovata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='ovata' OR species='ovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='ovata' OR species='ovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='ovata' OR junior_species='ovata')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='ovata' OR species='ovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='plebeja' OR species='plebeja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='plebeja' OR species='plebeja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='plebeja' OR junior_species='plebeja')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='plebeja' OR species='plebeja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='similata' OR junior_species='similata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='similata' OR species='similata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='similata' OR species='similata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='similata' OR junior_species='similata')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='similata' OR species='similata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='tibialis' OR junior_species='tibialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='tibialis' OR species='tibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='tibialis' OR species='tibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='tibialis' OR junior_species='tibialis')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='tibialis' OR species='tibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asaphidion' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asaphidion' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asaphidion' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asaphidion' AND (junior_species='flavipes' OR junior_species='flavipes')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='Asaphidion' AND (species='flavipes' OR species='flavipes') 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='Bembidion' AND (junior_species='mannerheimii' OR junior_species='mannerheimi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='mannerheimii' OR species='mannerheimi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='mannerheimii' OR species='mannerheimi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='mannerheimii' OR junior_species='mannerheimi')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='mannerheimii' OR species='mannerheimi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradycellus' AND (junior_species='caucasicus' OR junior_species='caucasicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradycellus' AND (species='caucasicus' OR species='caucasicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradycellus' AND (species='caucasicus' OR species='caucasicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradycellus' AND (junior_species='caucasicus' OR junior_species='caucasicus')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='Bradycellus' AND (species='caucasicus' OR species='caucasicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='cinctus' OR junior_species='cinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='cinctus' OR species='cinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='cinctus' OR species='cinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='cinctus' OR junior_species='cinctus')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='cinctus' OR species='cinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='fuscipes' OR species='fuscipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='fuscipes' OR species='fuscipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='fuscipes' OR junior_species='fuscipes')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='fuscipes' OR species='fuscipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='melanocephalus' OR species='melanocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='melanocephalus' OR species='melanocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')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='melanocephalus' OR species='melanocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='auronitens' OR junior_species='auronitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='auronitens' OR species='auronitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='auronitens' OR species='auronitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='auronitens' OR junior_species='auronitens')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='auronitens' OR species='auronitens') 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='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='hortensis' OR junior_species='hortensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='hortensis' OR species='hortensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='hortensis' OR species='hortensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='hortensis' OR junior_species='hortensis')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='hortensis' OR species='hortensis') 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='scheidleri' OR junior_species='scheidlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='scheidleri' OR species='scheidlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='scheidleri' OR species='scheidlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='scheidleri' OR junior_species='scheidlerii')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='scheidleri' OR species='scheidlerii') 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='Dyschirius' AND (junior_species='globosus' OR junior_species='globosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyschirius' AND (species='globosus' OR species='globosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dyschirius' AND (species='globosus' OR species='globosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyschirius' AND (junior_species='globosus' OR junior_species='globosus')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='Dyschirius' AND (species='globosus' OR species='globosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epaphius' 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='Epaphius' AND (species='secalis' OR species='secalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epaphius' AND (species='secalis' OR species='secalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epaphius' 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='Epaphius' AND (species='secalis' OR species='secalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='griseus' OR junior_species='griseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='griseus' OR species='griseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='griseus' OR species='griseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='griseus' OR junior_species='griseus')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='griseus' OR species='griseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='luteicornis' OR junior_species='luteicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='luteicornis' OR species='luteicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='luteicornis' OR species='luteicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='luteicornis' OR junior_species='luteicornis')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='luteicornis' OR species='luteicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='pumilus' OR junior_species='pumilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='pumilus' OR species='pumilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='pumilus' OR species='pumilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='pumilus' OR junior_species='pumilus')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='pumilus' OR species='pumilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rubripes' OR species='rubripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')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='rubripes' OR species='rubripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rufipalpis' OR junior_species='rufipalpis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='rufipalpis' OR species='rufipalpis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rufipalpis' OR species='rufipalpis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rufipalpis' OR junior_species='rufipalpis')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='rufipalpis' OR species='rufipalpis') 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='signaticornis' OR junior_species='signaticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='signaticornis' OR species='signaticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='signaticornis' OR species='signaticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='signaticornis' OR junior_species='signaticornis')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='signaticornis' OR species='signaticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='tardus' OR junior_species='tardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='tardus' OR species='tardus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='tardus' OR species='tardus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='tardus' OR junior_species='tardus')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='tardus' OR species='tardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leistus' AND (species='ferrugineus' OR species='ferrugineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leistus' AND (species='ferrugineus' OR species='ferrugineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leistus' AND (junior_species='ferrugineus' OR junior_species='ferrugineus')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='ferrugineus' OR species='ferrugineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microlestes' AND (junior_species='minutulus' OR junior_species='minutulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microlestes' AND (species='minutulus' OR species='minutulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microlestes' AND (species='minutulus' OR species='minutulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microlestes' AND (junior_species='minutulus' OR junior_species='minutulus')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='Microlestes' AND (species='minutulus' OR species='minutulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molops' AND (junior_species='elatus' OR junior_species='elatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molops' AND (species='elatus' OR species='elatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molops' AND (species='elatus' OR species='elatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molops' AND (junior_species='elatus' OR junior_species='elatus')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='elatus' OR species='elatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='brevicollis' OR junior_species='brevicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebria' AND (species='brevicollis' OR species='brevicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebria' AND (species='brevicollis' OR species='brevicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='brevicollis' OR junior_species='brevicollis')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='Nebria' AND (species='brevicollis' OR species='brevicollis') 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='Olisthopus' AND (junior_species='sturmii' OR junior_species='sturmi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olisthopus' AND (species='sturmii' OR species='sturmi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olisthopus' AND (species='sturmii' OR species='sturmi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olisthopus' AND (junior_species='sturmii' OR junior_species='sturmi')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='Olisthopus' AND (species='sturmii' OR species='sturmi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='azureus' OR junior_species='azureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophonus' AND (species='azureus' OR species='azureus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophonus' AND (species='azureus' OR species='azureus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='azureus' OR junior_species='azureus')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='Ophonus' AND (species='azureus' OR species='azureus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='laticollis' OR junior_species='laticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophonus' AND (species='laticollis' OR species='laticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophonus' AND (species='laticollis' OR species='laticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophonus' AND (junior_species='laticollis' OR junior_species='laticollis')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='Ophonus' AND (species='laticollis' OR species='laticollis') 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='Panagaeus' AND (junior_species='bipustulatus' OR junior_species='bipustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panagaeus' AND (species='bipustulatus' OR species='bipustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panagaeus' AND (species='bipustulatus' OR species='bipustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panagaeus' AND (junior_species='bipustulatus' OR junior_species='bipustulatus')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='Panagaeus' AND (species='bipustulatus' OR species='bipustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='maculicornis' OR junior_species='maculicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parophonus' AND (species='maculicornis' OR species='maculicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parophonus' AND (species='maculicornis' OR species='maculicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parophonus' AND (junior_species='maculicornis' OR junior_species='maculicornis')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='Parophonus' AND (species='maculicornis' OR species='maculicornis') 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='Philorhizus' AND (junior_species='crucifer' OR junior_species='crucifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philorhizus' AND (species='crucifer' OR species='crucifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philorhizus' AND (species='crucifer' OR species='crucifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philorhizus' AND (junior_species='crucifer' OR junior_species='crucifer')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='Philorhizus' AND (species='crucifer' OR species='crucifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilus' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilus' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='cupreus' OR junior_species='cupreus')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='Poecilus' AND (species='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='lepidus' OR junior_species='lepidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilus' AND (species='lepidus' OR species='lepidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilus' AND (species='lepidus' OR species='lepidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilus' AND (junior_species='lepidus' OR junior_species='lepidus')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='Poecilus' AND (species='lepidus' OR species='lepidus') 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='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='ovoideus' OR junior_species='ovoideus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='ovoideus' OR species='ovoideus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='ovoideus' OR species='ovoideus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='ovoideus' OR junior_species='ovoideus')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='ovoideus' OR species='ovoideus') 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='vernalis' OR junior_species='vernalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='vernalis' OR species='vernalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='vernalis' OR species='vernalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='vernalis' OR junior_species='vernalis')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='vernalis' OR species='vernalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='foveatus' OR junior_species='foveatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syntomus' AND (species='foveatus' OR species='foveatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syntomus' AND (species='foveatus' OR species='foveatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='foveatus' OR junior_species='foveatus')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='Syntomus' AND (species='foveatus' OR species='foveatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='pallipes' OR junior_species='pallipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syntomus' AND (species='pallipes' OR species='pallipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syntomus' AND (species='pallipes' OR species='pallipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='pallipes' OR junior_species='pallipes')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='Syntomus' AND (species='pallipes' OR species='pallipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='truncatellus' OR junior_species='truncatellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syntomus' AND (species='truncatellus' OR species='truncatellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syntomus' AND (species='truncatellus' OR species='truncatellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syntomus' AND (junior_species='truncatellus' OR junior_species='truncatellus')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='Syntomus' AND (species='truncatellus' OR species='truncatellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='vivalis' OR junior_species='vivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='vivalis' OR species='vivalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='vivalis' OR species='vivalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='vivalis' OR junior_species='vivalis')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='Synuchus' AND (species='vivalis' OR species='vivalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyta' AND (junior_species='nana' OR junior_species='nana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyta' AND (species='nana' OR species='nana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyta' AND (species='nana' OR species='nana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyta' AND (junior_species='nana' OR junior_species='nana')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='Tachyta' AND (species='nana' OR species='nana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2239 The Ecological Register: Thaya Valley
Thaya Valley
Basic information
Sample name: Thaya Valley

Sample aka: Inter-National Park Thayatal-Podvjí

Reference: T. Markut. 2013. Carabid beetles (Coleoptera, Carabidae) in the Thaya valley. Conference Volume, 5th Symposium for Research in Protected Areas 497-501 [ER 2204]
Geography
Country: Austria


Coordinate: 48° 51' N, 15° 52' E
Coordinate basis: based on nearby landmark

Geography comments: "in the Austrian part" of the Inter-National Park Thayatal-Podvjí "near Hardegg... With a size of 1330 hectares" (coordinate based on Hardegg)

•
Environment
Habitat: temperate savanna

Altered habitat: fragment

Protection: national/state park

Substrate: ground surface

Habitat comments: "The selected sampling sites were dry grasslands (DG) and meadows (ME)"
a large fragment based on satellite photos

Methods
Life forms: ground beetles

Sites: 20

Sampling methods: no design,pitfall traps

Sample size: 584 individuals

Years: 2010

Seasons: spring,summer,autumn

Nets or traps: 60

Sampling comments: "From April to October 2010, 20 sites were sampled (Table 1) using 3 pitfall traps on each site"

Metadata
Sample number: 2239

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-28 14:39:57

Modified: 2020-06-05 09:08:34

Abundance distribution
66 species
11 singletons
total count 584
extrapolated richness: 113.5
Fisher's α: 19.124
geometric series k: 0.9268
Hurlbert's PIE: 0.9138
Shannon's H: 3.1974
Good's u: 0.9813
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Abax ovalis2
Abax parallelepipedus11
Abax parallelus2
Agonum emarginatum2
Agonum viduum2
Amara aenea2
Amara convexior7
Amara equestris2
Amara eurynota1
Amara familiaris4
Amara lunicollis37
Amara nitida3
Amara ovata2
Amara plebeja2
Amara similata2
Amara tibialis2
Asaphidion flavipes2
Badister bullatus1
Bembidion mannerheimii5
Bradycellus caucasicus1
Calathus cinctus3
Calathus fuscipes25
Calathus melanocephalus14
Carabus auronitens2
Carabus cancellatus2
Carabus convexus2
Carabus coriaceus1
Carabus hortensis3
Carabus intricatus6
Carabus scheidleri140
Carabus violaceus11
Dyschirius globosus21
Epaphius secalis12
Harpalus griseus1
Harpalus luteicornis2
Harpalus pumilus6
Harpalus rubripes8
Harpalus rufipalpis5
Harpalus rufipes13
Harpalus signaticornis2
Harpalus tardus18
Leistus ferrugineus2
Microlestes minutulus2
Molops elatus13
Nebria brevicollis1
Notiophilus rufipes2
Olisthopus sturmii3
Ophonus azureus1
Ophonus laticollis1
Oxypselaphus obscurus2
Panagaeus bipustulatus2
Parophonus maculicornis1
Patrobus atrorufus2
Philorhizus crucifer1
Poecilus cupreus52
Poecilus lepidus2
Pterostichus melanarius45
Pterostichus niger27
Pterostichus ovoideus4
Pterostichus strenuus5
Pterostichus vernalis2
Syntomus foveatus3
Syntomus pallipes4
Syntomus truncatellus7
Synuchus vivalis10
Tachyta nana1