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=2121 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2121SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2134SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2121 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytra' AND (junior_species='atraphaxidis' OR junior_species='atraphaxidis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clytra' AND (species='atraphaxidis' OR species='atraphaxidis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clytra' AND (species='atraphaxidis' OR species='atraphaxidis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytra' AND (junior_species='atraphaxidis' OR junior_species='atraphaxidis')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='Clytra' AND (species='atraphaxidis' OR species='atraphaxidis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytra' AND (junior_species='binominata' OR junior_species='binominata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clytra' AND (species='binominata' OR species='binominata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clytra' AND (species='binominata' OR species='binominata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytra' AND (junior_species='binominata' OR junior_species='binominata')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='Clytra' AND (species='binominata' OR species='binominata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptocephala' AND (junior_species='unifasciata' OR junior_species='unifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coptocephala' AND (species='unifasciata' OR species='unifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coptocephala' AND (species='unifasciata' OR species='unifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptocephala' AND (junior_species='unifasciata' OR junior_species='unifasciata')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='Coptocephala' AND (species='unifasciata' OR species='unifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='connexus' OR junior_species='connexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='connexus' OR species='connexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='connexus' OR species='connexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='connexus' OR junior_species='connexus')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='Cryptocephalus' AND (species='connexus' OR species='connexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='duplicatus' OR junior_species='duplicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='duplicatus' OR species='duplicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='duplicatus' OR species='duplicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='duplicatus' OR junior_species='duplicatus')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='Cryptocephalus' AND (species='duplicatus' OR species='duplicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocoma' AND (junior_species='korbi' OR junior_species='korbii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrocoma' AND (species='korbi' OR species='korbii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrocoma' AND (species='korbi' OR species='korbii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocoma' AND (junior_species='korbi' OR junior_species='korbii')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='Macrocoma' AND (species='korbi' OR species='korbii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocoma' 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='Macrocoma' AND (species='rubripes' OR species='rubripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrocoma' AND (species='rubripes' OR species='rubripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocoma' 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='Macrocoma' AND (species='rubripes' OR species='rubripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='chalcites' OR junior_species='chalcites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysolina' AND (species='chalcites' OR species='chalcites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysolina' AND (species='chalcites' OR species='chalcites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='chalcites' OR junior_species='chalcites')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='Chrysolina' AND (species='chalcites' OR species='chalcites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='sahlbergi' OR junior_species='sahlbergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolina' AND (junior_species='sahlbergi' OR junior_species='sahlbergii')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='Chrysolina' AND (species='sahlbergi' OR species='sahlbergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonioctena' AND (junior_species='fornicata' OR junior_species='fornicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonioctena' AND (species='fornicata' OR species='fornicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonioctena' AND (species='fornicata' OR species='fornicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonioctena' AND (junior_species='fornicata' OR junior_species='fornicata')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='Gonioctena' AND (species='fornicata' OR species='fornicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galeruca' AND (junior_species='interrupta' OR junior_species='interrupta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galeruca' AND (species='interrupta' OR species='interrupta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galeruca' AND (species='interrupta' OR species='interrupta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galeruca' AND (junior_species='interrupta' OR junior_species='interrupta')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='Galeruca' AND (species='interrupta' OR species='interrupta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galeruca' AND (junior_species='tanaceti' OR junior_species='tanacetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galeruca' AND (species='tanaceti' OR species='tanacetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galeruca' AND (species='tanaceti' OR species='tanacetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galeruca' AND (junior_species='tanaceti' OR junior_species='tanacetii')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='Galeruca' AND (species='tanaceti' OR species='tanacetii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassida' AND (junior_species='vibex' OR junior_species='vibex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cassida' AND (species='vibex' OR species='vibex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cassida' AND (species='vibex' OR species='vibex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassida' AND (junior_species='vibex' OR junior_species='vibex')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='Cassida' AND (species='vibex' OR species='vibex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposassida' AND (junior_species='subferruginea' OR junior_species='subferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyposassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyposassida' AND (species='subferruginea' OR species='subferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposassida' AND (junior_species='subferruginea' OR junior_species='subferruginea')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='Hyposassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altica' AND (junior_species='lythri' OR junior_species='lythrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Altica' AND (species='lythri' OR species='lythrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Altica' AND (species='lythri' OR species='lythrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altica' AND (junior_species='lythri' OR junior_species='lythrii')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='Altica' AND (species='lythri' OR species='lythrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphthona' AND (junior_species='nigriceps' OR junior_species='nigriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphthona' AND (species='nigriceps' OR species='nigriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphthona' AND (species='nigriceps' OR species='nigriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphthona' AND (junior_species='nigriceps' OR junior_species='nigriceps')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='Aphthona' AND (species='nigriceps' OR species='nigriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='coyei' OR junior_species='coyeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetocnema' AND (species='coyei' OR species='coyeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocnema' AND (species='coyei' OR species='coyeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='coyei' OR junior_species='coyeii')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='Chaetocnema' AND (species='coyei' OR species='coyeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetocnema' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocnema' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='major' OR junior_species='major')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='Chaetocnema' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' 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='Chaetocnema' AND (species='mannerheimii' OR species='mannerheimi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocnema' AND (species='mannerheimii' OR species='mannerheimi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' 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='Chaetocnema' AND (species='mannerheimii' OR species='mannerheimi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='scheffleri' OR junior_species='schefflerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetocnema' AND (species='scheffleri' OR species='schefflerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocnema' AND (species='scheffleri' OR species='schefflerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' AND (junior_species='scheffleri' OR junior_species='schefflerii')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='Chaetocnema' AND (species='scheffleri' OR species='schefflerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' 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='Chaetocnema' AND (species='tibialis' OR species='tibialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocnema' AND (species='tibialis' OR species='tibialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocnema' 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='Chaetocnema' AND (species='tibialis' OR species='tibialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='aeneicollis' OR junior_species='aeneicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='aeneicollis' OR species='aeneicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='aeneicollis' OR species='aeneicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='aeneicollis' OR junior_species='aeneicollis')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='Longitarsus' AND (species='aeneicollis' OR species='aeneicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='albineus' OR junior_species='albineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='albineus' OR species='albineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='albineus' OR species='albineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='albineus' OR junior_species='albineus')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='Longitarsus' AND (species='albineus' OR species='albineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='bertii' OR junior_species='berti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='bertii' OR species='berti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='bertii' OR species='berti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='bertii' OR junior_species='berti')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='Longitarsus' AND (species='bertii' OR species='berti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='helvolus' OR junior_species='helvolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='helvolus' OR species='helvolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='helvolus' OR species='helvolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='helvolus' OR junior_species='helvolus')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='Longitarsus' AND (species='helvolus' OR species='helvolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='nigrofasciatus' OR junior_species='nigrofasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='nigrofasciatus' OR species='nigrofasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='nigrofasciatus' OR species='nigrofasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='nigrofasciatus' OR junior_species='nigrofasciatus')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='Longitarsus' AND (species='nigrofasciatus' OR species='nigrofasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='picicollis' OR junior_species='picicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='picicollis' OR species='picicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='picicollis' OR species='picicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='picicollis' OR junior_species='picicollis')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='Longitarsus' AND (species='picicollis' OR species='picicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='pratensis' OR junior_species='pratensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='pratensis' OR species='pratensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='pratensis' OR species='pratensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='pratensis' OR junior_species='pratensis')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='Longitarsus' AND (species='pratensis' OR species='pratensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantura' AND (junior_species='mathewsii' OR junior_species='mathewsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantura' AND (species='mathewsii' OR species='mathewsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantura' AND (species='mathewsii' OR species='mathewsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantura' AND (junior_species='mathewsii' OR junior_species='mathewsi')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='Mantura' AND (species='mathewsii' OR species='mathewsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='bulgarica' OR junior_species='bulgarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllotreta' AND (species='bulgarica' OR species='bulgarica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllotreta' AND (species='bulgarica' OR species='bulgarica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='bulgarica' OR junior_species='bulgarica')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='Phyllotreta' AND (species='bulgarica' OR species='bulgarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='cruciferae' OR junior_species='cruciferae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllotreta' AND (species='cruciferae' OR species='cruciferae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllotreta' AND (species='cruciferae' OR species='cruciferae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='cruciferae' OR junior_species='cruciferae')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='Phyllotreta' AND (species='cruciferae' OR species='cruciferae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='nigripes' OR junior_species='nigripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllotreta' AND (species='nigripes' OR species='nigripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllotreta' AND (species='nigripes' OR species='nigripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='nigripes' OR junior_species='nigripes')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='Phyllotreta' AND (species='nigripes' OR species='nigripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='vittula' OR junior_species='vittula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllotreta' AND (species='vittula' OR species='vittula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllotreta' AND (species='vittula' OR species='vittula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllotreta' AND (junior_species='vittula' OR junior_species='vittula')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='Phyllotreta' AND (species='vittula' OR species='vittula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='chalcomerus' OR junior_species='chalcomerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='chalcomerus' OR species='chalcomerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='chalcomerus' OR species='chalcomerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='chalcomerus' OR junior_species='chalcomerus')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='Psylliodes' AND (species='chalcomerus' OR species='chalcomerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='circumdatus' OR junior_species='circumdatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='circumdatus' OR species='circumdatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='circumdatus' OR species='circumdatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='circumdatus' OR junior_species='circumdatus')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='Psylliodes' AND (species='circumdatus' OR species='circumdatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='instabilis' OR junior_species='instabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='instabilis' OR species='instabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='instabilis' OR species='instabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='instabilis' OR junior_species='instabilis')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='Psylliodes' AND (species='instabilis' OR species='instabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='kiesenwetteri' OR junior_species='kiesenwetterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='kiesenwetteri' OR species='kiesenwetterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='kiesenwetteri' OR species='kiesenwetterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='kiesenwetteri' OR junior_species='kiesenwetterii')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='Psylliodes' AND (species='kiesenwetteri' OR species='kiesenwetterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='napi' OR junior_species='napii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='napi' OR species='napii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='napi' OR species='napii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='napi' OR junior_species='napii')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='Psylliodes' AND (species='napi' OR species='napii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2121 The Ecological Register: Kovada Lake (KLH1)
Kovada Lake (KLH1)
Basic information
Sample name: Kovada Lake (KLH1)

Reference: S. Sen and A. Gök. 2014. Leaf beetle (Coleoptera: Chrysomelidae) communities of Kovada Lake and Kizildag national parks (Isparta, Turkey): assessing the effects of habitat types. Entomological Research 44:176-190 [ER 2134]
Geography
Country: Turkey

State: Isparta


Coordinate: 37° 39' N, 30° 53' E
Coordinate basis: stated in text as range

Geography comments: elevation range 908 to 1564 m (reported figure is not the median)

•
Environment
Habitat: temperate savanna

Substrate: branches or trunks

MAT: 12.5

Habitat comments: "herbaceous open area (H)... dominated by grass or grasslike vegetation"

Methods
Life forms: leaf beetles

Sampling methods: no design,sweep nets,hand capture

Sample size: 549 individuals

Years: 2009, 2010

Seasons: spring,summer,autumn

Sampling comments: "The study was carried out during April–October in 2009– 2010... Leaf beetles were collected from the herb and shrub layers by sweep-netting and from the tree layer (up to 2.5 m) by beating branches over an umbrella"

Metadata
Sample number: 2121

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-22 20:44:41

Modified: 2016-07-23 00:57:03

Abundance distribution
38 species
11 singletons
total count 549
extrapolated richness: 64.8
Fisher's α: 9.274
geometric series k: 0.8682
Hurlbert's PIE: 0.8423
Shannon's H: 2.5141
Good's u: 0.9800
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Clytra atraphaxidis7
Clytra binominata1
Coptocephala unifasciata6
Cryptocephalus connexus12
Cryptocephalus duplicatus11
Macrocoma korbi1
Macrocoma rubripes2
Chrysolina chalcites1
Chrysolina sahlbergi1
Gonioctena fornicata26
Galeruca interrupta10
Galeruca tanaceti12
Cassida vibex2
Hyposassida subferruginea11
Altica lythri3
Aphthona nigriceps1
Chaetocnema coyei3
Chaetocnema major1
Chaetocnema mannerheimii32
Chaetocnema scheffleri5
Chaetocnema tibialis3
Longitarsus aeneicollis2
Longitarsus albineus6
Longitarsus bertii1
Longitarsus helvolus1
Longitarsus nigrofasciatus67
Longitarsus picicollis69
Longitarsus pratensis187
Mantura mathewsii1
Phyllotreta bulgarica12
Phyllotreta cruciferae6
Phyllotreta nigripes9
Phyllotreta vittula18
Psylliodes chalcomerus8
Psylliodes circumdatus1
Psylliodes instabilis4
Psylliodes kiesenwetteri5
Psylliodes napi1