Coordinate: 45° 39' 31" N, 9° 36' 24" 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=2374 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2374SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2274SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2374 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='meshniggi' OR junior_species='meshniggii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleochara' AND (species='meshniggi' OR species='meshniggii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleochara' AND (species='meshniggi' OR species='meshniggii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='meshniggi' OR junior_species='meshniggii')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='Aleochara' AND (species='meshniggi' OR species='meshniggii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amarochara' AND (junior_species='forticornis' OR junior_species='forticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amarochara' AND (species='forticornis' OR species='forticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amarochara' AND (species='forticornis' OR species='forticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amarochara' AND (junior_species='forticornis' OR junior_species='forticornis')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='Amarochara' AND (species='forticornis' OR species='forticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='aneicollis' OR junior_species='aneicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='aneicollis' OR species='aneicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='aneicollis' OR species='aneicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='aneicollis' OR junior_species='aneicollis')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='Atheta' AND (species='aneicollis' OR species='aneicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='triangulum' OR junior_species='triangulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='triangulum' OR species='triangulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='triangulum' OR species='triangulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='triangulum' OR junior_species='triangulum')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='Atheta' AND (species='triangulum' OR species='triangulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='coriaria' OR junior_species='coriaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='coriaria' OR species='coriaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='coriaria' OR species='coriaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='coriaria' OR junior_species='coriaria')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='Atheta' AND (species='coriaria' OR species='coriaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='crassicornis' OR junior_species='crassicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='crassicornis' OR species='crassicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='crassicornis' OR species='crassicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='crassicornis' OR junior_species='crassicornis')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='Atheta' AND (species='crassicornis' OR species='crassicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='oblita' OR junior_species='oblita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='oblita' OR species='oblita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='oblita' OR species='oblita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='oblita' OR junior_species='oblita')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='Atheta' AND (species='oblita' OR species='oblita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='trinotrata' OR junior_species='trinotrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='trinotrata' OR species='trinotrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='trinotrata' OR species='trinotrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='trinotrata' OR junior_species='trinotrata')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='Atheta' AND (species='trinotrata' OR species='trinotrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atheta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicerus' 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='Callicerus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicerus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicerus' 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='Callicerus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinaraea' AND (junior_species='angustula' OR junior_species='angustula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinaraea' AND (species='angustula' OR species='angustula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinaraea' AND (species='angustula' OR species='angustula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinaraea' AND (junior_species='angustula' OR junior_species='angustula')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='Dinaraea' AND (species='angustula' OR species='angustula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drusilla' AND (junior_species='canaliculata' OR junior_species='canaliculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drusilla' AND (species='canaliculata' OR species='canaliculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drusilla' AND (species='canaliculata' OR species='canaliculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drusilla' AND (junior_species='canaliculata' OR junior_species='canaliculata')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='Drusilla' AND (species='canaliculata' OR species='canaliculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagrioma' AND (junior_species='thoracica' OR junior_species='thoracica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falagrioma' AND (species='thoracica' OR species='thoracica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falagrioma' AND (species='thoracica' OR species='thoracica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagrioma' AND (junior_species='thoracica' OR junior_species='thoracica')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='Falagrioma' AND (species='thoracica' OR species='thoracica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligota' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligota' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligota' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligota' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oligota' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypoda' AND (junior_species='brevicornis' OR junior_species='brevicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxypoda' AND (species='brevicornis' OR species='brevicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxypoda' AND (species='brevicornis' OR species='brevicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypoda' AND (junior_species='brevicornis' OR junior_species='brevicornis')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='Oxypoda' AND (species='brevicornis' OR species='brevicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropeplus' AND (junior_species='marietti' OR junior_species='mariettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropeplus' AND (species='marietti' OR species='mariettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropeplus' AND (species='marietti' OR species='mariettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropeplus' AND (junior_species='marietti' OR junior_species='mariettii')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='Micropeplus' AND (species='marietti' OR species='mariettii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='caesum' OR junior_species='caesum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omalium' AND (species='caesum' OR species='caesum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omalium' AND (species='caesum' OR species='caesum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='caesum' OR junior_species='caesum')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='Omalium' AND (species='caesum' OR species='caesum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='rivulare' OR junior_species='rivulare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omalium' AND (species='rivulare' OR species='rivulare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omalium' AND (species='rivulare' OR species='rivulare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='rivulare' OR junior_species='rivulare')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='Omalium' AND (species='rivulare' OR species='rivulare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraphloeostiba' AND (junior_species='gayndahensis' OR junior_species='gayndahensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraphloeostiba' AND (junior_species='gayndahensis' OR junior_species='gayndahensis')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='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='inustus' OR junior_species='inustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anotylus' AND (species='inustus' OR species='inustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anotylus' AND (species='inustus' OR species='inustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='inustus' OR junior_species='inustus')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='Anotylus' AND (species='inustus' OR species='inustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='sculpturatus' OR junior_species='sculpturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anotylus' AND (species='sculpturatus' OR species='sculpturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anotylus' AND (species='sculpturatus' OR species='sculpturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='sculpturatus' OR junior_species='sculpturatus')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='Anotylus' AND (species='sculpturatus' OR species='sculpturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='tetracarinatus' OR junior_species='tetracarinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anotylus' AND (species='tetracarinatus' OR species='tetracarinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anotylus' AND (species='tetracarinatus' OR species='tetracarinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='tetracarinatus' OR junior_species='tetracarinatus')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='Anotylus' AND (species='tetracarinatus' OR species='tetracarinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bledius' AND (junior_species='gallicus' OR junior_species='gallicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bledius' AND (species='gallicus' OR species='gallicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bledius' AND (species='gallicus' OR species='gallicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bledius' AND (junior_species='gallicus' OR junior_species='gallicus')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='Bledius' AND (species='gallicus' OR species='gallicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='cornutus' OR junior_species='cornutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platystethus' AND (species='cornutus' OR species='cornutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platystethus' AND (species='cornutus' OR species='cornutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='cornutus' OR junior_species='cornutus')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='Platystethus' AND (species='cornutus' OR species='cornutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platystethus' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platystethus' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platystethus' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='immaculatus' OR junior_species='immaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astenus' AND (species='immaculatus' OR species='immaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astenus' AND (species='immaculatus' OR species='immaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='immaculatus' OR junior_species='immaculatus')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='Astenus' AND (species='immaculatus' OR species='immaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='lyonessius' OR junior_species='lyonessius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astenus' AND (species='lyonessius' OR species='lyonessius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astenus' AND (species='lyonessius' OR species='lyonessius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='lyonessius' OR junior_species='lyonessius')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='Astenus' AND (species='lyonessius' OR species='lyonessius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rugilus' AND (junior_species='orbiculatus' OR junior_species='orbiculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rugilus' AND (species='orbiculatus' OR species='orbiculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rugilus' AND (species='orbiculatus' OR species='orbiculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rugilus' AND (junior_species='orbiculatus' OR junior_species='orbiculatus')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='Rugilus' AND (species='orbiculatus' OR species='orbiculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megarthrus' AND (junior_species='bellevoyei' OR junior_species='bellevoyeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megarthrus' AND (species='bellevoyei' OR species='bellevoyeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megarthrus' AND (species='bellevoyei' OR species='bellevoyeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megarthrus' AND (junior_species='bellevoyei' OR junior_species='bellevoyeii')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='Megarthrus' AND (species='bellevoyei' OR species='bellevoyeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteinus' 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='Proteinus' AND (species='ovalis' OR species='ovalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proteinus' AND (species='ovalis' OR species='ovalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteinus' 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='Proteinus' AND (species='ovalis' OR species='ovalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocypus' AND (junior_species='olens' OR junior_species='olens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocypus' AND (species='olens' OR species='olens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocypus' AND (species='olens' OR species='olens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocypus' AND (junior_species='olens' OR junior_species='olens')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='Ocypus' AND (species='olens' OR species='olens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platydracus' AND (junior_species='stercorarius' OR junior_species='stercorarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platydracus' AND (species='stercorarius' OR species='stercorarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platydracus' AND (species='stercorarius' OR species='stercorarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platydracus' AND (junior_species='stercorarius' OR junior_species='stercorarius')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='Platydracus' AND (species='stercorarius' OR species='stercorarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='meridiocarpathicus' OR junior_species='meridiocarpathicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='meridiocarpathicus' OR junior_species='meridiocarpathicus')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='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tasgius' AND (junior_species='winkleri' OR junior_species='winklerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tasgius' AND (species='winkleri' OR species='winklerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tasgius' AND (species='winkleri' OR species='winklerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tasgius' AND (junior_species='winkleri' OR junior_species='winklerii')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='Tasgius' AND (species='winkleri' OR species='winklerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xantholinus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xantholinus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='elegans' OR junior_species='elegans')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='Xantholinus' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='linearis' OR junior_species='linearis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xantholinus' AND (species='linearis' OR species='linearis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xantholinus' AND (species='linearis' OR species='linearis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='linearis' OR junior_species='linearis')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='Xantholinus' AND (species='linearis' OR species='linearis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycetoporus' AND (junior_species='longulus' OR junior_species='longulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycetoporus' AND (species='longulus' OR species='longulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycetoporus' AND (species='longulus' OR species='longulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycetoporus' AND (junior_species='longulus' OR junior_species='longulus')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='Mycetoporus' AND (species='longulus' OR species='longulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachinus' AND (junior_species='subterraneus' OR junior_species='subterraneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachinus' AND (species='subterraneus' OR species='subterraneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachinus' AND (species='subterraneus' OR species='subterraneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachinus' AND (junior_species='subterraneus' OR junior_species='subterraneus')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='Tachinus' AND (species='subterraneus' OR species='subterraneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='atriceps' OR junior_species='atriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyporus' AND (species='atriceps' OR species='atriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyporus' AND (species='atriceps' OR species='atriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='atriceps' OR junior_species='atriceps')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='Tachyporus' AND (species='atriceps' OR species='atriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='nitidulus' OR junior_species='nitidulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyporus' AND (species='nitidulus' OR species='nitidulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyporus' AND (species='nitidulus' OR species='nitidulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='nitidulus' OR junior_species='nitidulus')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='Tachyporus' AND (species='nitidulus' OR species='nitidulus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2374