Coordinate: 32° 43' N, 34° 58' E
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=2125 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2125SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2137SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2125 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oulema' AND (junior_species='melanopa' OR junior_species='melanopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oulema' AND (species='melanopa' OR species='melanopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oulema' AND (species='melanopa' OR species='melanopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oulema' AND (junior_species='melanopa' OR junior_species='melanopa')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='Oulema' AND (species='melanopa' OR species='melanopa') 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='dahdah' OR junior_species='dahdah')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='dahdah' OR species='dahdah') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='dahdah' OR species='dahdah')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='dahdah' OR junior_species='dahdah')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='dahdah' OR species='dahdah') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='peyroni' OR junior_species='peyronii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='peyroni' OR species='peyronii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='peyroni' OR species='peyronii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='peyroni' OR junior_species='peyronii')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='peyroni' OR species='peyronii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='bidorsalis' OR junior_species='bidorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='bidorsalis' OR species='bidorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='bidorsalis' OR species='bidorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='bidorsalis' OR junior_species='bidorsalis')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='bidorsalis' OR species='bidorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='egerickxi' OR junior_species='egerickxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocephalus' AND (species='egerickxi' OR species='egerickxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocephalus' AND (species='egerickxi' OR species='egerickxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocephalus' AND (junior_species='egerickxi' OR junior_species='egerickxii')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='egerickxi' OR species='egerickxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachybrachis' AND (junior_species='jordanicus' OR junior_species='jordanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachybrachis' AND (species='jordanicus' OR species='jordanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachybrachis' AND (species='jordanicus' OR species='jordanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachybrachis' AND (junior_species='jordanicus' OR junior_species='jordanicus')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='Pachybrachis' AND (species='jordanicus' OR species='jordanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachnephorus' AND (junior_species='villosus' OR junior_species='villosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachnephorus' AND (species='villosus' OR species='villosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachnephorus' AND (species='villosus' OR species='villosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachnephorus' AND (junior_species='villosus' OR junior_species='villosus')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='Pachnephorus' AND (species='villosus' OR species='villosus') 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='Marseulia' AND (junior_species='dilativentris' OR junior_species='dilativentris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marseulia' AND (species='dilativentris' OR species='dilativentris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marseulia' AND (species='dilativentris' OR species='dilativentris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marseulia' AND (junior_species='dilativentris' OR junior_species='dilativentris')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='Marseulia' AND (species='dilativentris' OR species='dilativentris') 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='Longitarsus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='aeneus' OR junior_species='aeneus')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='aeneus' OR species='aeneus') 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='pellucidus' OR junior_species='pellucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='pellucidus' OR species='pellucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='pellucidus' OR species='pellucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='pellucidus' OR junior_species='pellucidus')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='pellucidus' OR species='pellucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='strangulatus' OR junior_species='strangulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='strangulatus' OR species='strangulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='strangulatus' OR species='strangulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='strangulatus' OR junior_species='strangulatus')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='strangulatus' OR species='strangulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='angusta' OR junior_species='angusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Longitarsus' AND (species='angusta' OR species='angusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Longitarsus' AND (species='angusta' OR species='angusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Longitarsus' AND (junior_species='angusta' OR junior_species='angusta')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='angusta' OR species='angusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='marcida' OR junior_species='marcida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='marcida' OR species='marcida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='marcida' OR species='marcida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='marcida' OR junior_species='marcida')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='marcida' OR species='marcida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='cuprea' OR junior_species='cuprea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='cuprea' OR species='cuprea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='cuprea' OR species='cuprea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='cuprea' OR junior_species='cuprea')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='cuprea' OR species='cuprea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='hyoscyami' OR junior_species='hyoscyamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psylliodes' AND (species='hyoscyami' OR species='hyoscyamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psylliodes' AND (species='hyoscyami' OR species='hyoscyamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psylliodes' AND (junior_species='hyoscyami' OR junior_species='hyoscyamii')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='hyoscyami' OR species='hyoscyamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrosis' AND (junior_species='ventralis' OR junior_species='ventralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochrosis' AND (species='ventralis' OR species='ventralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochrosis' AND (species='ventralis' OR species='ventralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochrosis' AND (junior_species='ventralis' OR junior_species='ventralis')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='Ochrosis' AND (species='ventralis' OR species='ventralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='fuscicornis' OR junior_species='fuscicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podagrica' AND (species='fuscicornis' OR species='fuscicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podagrica' AND (species='fuscicornis' OR species='fuscicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='fuscicornis' OR junior_species='fuscicornis')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='Podagrica' AND (species='fuscicornis' OR species='fuscicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='malvae' OR junior_species='malvae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podagrica' AND (species='malvae' OR species='malvae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podagrica' AND (species='malvae' OR species='malvae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podagrica' AND (junior_species='malvae' OR junior_species='malvae')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='Podagrica' AND (species='malvae' OR species='malvae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocassida' 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='Hypocassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocassida' AND (species='subferruginea' OR species='subferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocassida' 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='Hypocassida' AND (species='subferruginea' OR species='subferruginea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2125