Coordinate: 38° 51' 30" N, 96° 16' 0" E
elevation 3184 to 4207 m
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=3237 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3237SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3008SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3237 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='himalayana' OR junior_species='himalayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='himalayana' OR species='himalayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmota' AND (species='himalayana' OR species='himalayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='himalayana' OR junior_species='himalayana')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='Marmota' AND (species='himalayana' OR species='himalayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipodidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dipodidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodidae' AND (junior_species='indet.' OR junior_species='indet.')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='Dipodidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' 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='Ochotona' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' 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='Ochotona' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='oiostolus' OR junior_species='oiostolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='oiostolus' OR species='oiostolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='oiostolus' OR junior_species='oiostolus')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='Lepus' AND (species='oiostolus' OR species='oiostolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocolobus' AND (junior_species='manul' OR junior_species='manul')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otocolobus' AND (species='manul' OR species='manul') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otocolobus' AND (junior_species='manul' OR junior_species='manul')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Otocolobus' AND (species='manul' OR species='manul') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='lynx' OR species='lynx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')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='Lynx' AND (species='lynx' OR species='lynx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='uncia' OR junior_species='uncia')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='uncia' OR species='uncia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='uncia' OR junior_species='uncia')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Panthera' AND (species='uncia' OR species='uncia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')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='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='ferrilata' OR junior_species='ferrilata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='ferrilata' OR species='ferrilata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='ferrilata' OR junior_species='ferrilata')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='Vulpes' AND (species='ferrilata' OR species='ferrilata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')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='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='Ursus' AND (species='arctos' OR species='arctos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='foina' OR junior_species='foina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='foina' OR species='foina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='foina' OR junior_species='foina')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='Martes' AND (species='foina' OR species='foina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='altaica' OR junior_species='altaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='altaica' OR species='altaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustela' AND (species='altaica' OR species='altaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='altaica' OR junior_species='altaica')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='Mustela' AND (species='altaica' OR species='altaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='kiang' OR junior_species='kiang')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='kiang' OR species='kiang') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='kiang' OR species='kiang')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='kiang' OR junior_species='kiang')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='Equus' AND (species='kiang' OR species='kiang') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='albirostris' OR species='albirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervus' AND (species='albirostris' OR species='albirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cervus' AND (species='albirostris' OR species='albirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudois' AND (junior_species='nayaur' OR junior_species='nayaur')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='Pseudois' AND (species='nayaur' OR species='nayaur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraogallus' AND (junior_species='tibetanus' OR junior_species='tibetanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetraogallus' AND (species='tibetanus' OR species='tibetanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetraogallus' AND (species='tibetanus' OR species='tibetanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraogallus' AND (junior_species='tibetanus' OR junior_species='tibetanus')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='Tetraogallus' AND (species='tibetanus' OR species='tibetanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraogallus' AND (junior_species='himalayensis' OR junior_species='himalayensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetraogallus' AND (species='himalayensis' OR species='himalayensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetraogallus' AND (species='himalayensis' OR species='himalayensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetraogallus' AND (junior_species='himalayensis' OR junior_species='himalayensis')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='Tetraogallus' AND (species='himalayensis' OR species='himalayensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alectoris' AND (junior_species='chukar' OR junior_species='chukar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alectoris' AND (species='chukar' OR species='chukar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alectoris' AND (species='chukar' OR species='chukar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alectoris' AND (junior_species='chukar' OR junior_species='chukar')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='Alectoris' AND (species='chukar' OR species='chukar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdix' AND (junior_species='hodgsoniae' OR junior_species='hodgsoniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perdix' AND (species='hodgsoniae' OR species='hodgsoniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perdix' AND (species='hodgsoniae' OR species='hodgsoniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perdix' AND (junior_species='hodgsoniae' OR junior_species='hodgsoniae')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='Perdix' AND (species='hodgsoniae' OR species='hodgsoniae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='rupestris' OR junior_species='rupestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columba' AND (species='rupestris' OR species='rupestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columba' AND (species='rupestris' OR species='rupestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='rupestris' OR junior_species='rupestris')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='Columba' AND (species='rupestris' OR species='rupestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyps' AND (junior_species='himalayensis' OR junior_species='himalayensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gyps' AND (species='himalayensis' OR species='himalayensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gyps' AND (species='himalayensis' OR species='himalayensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyps' AND (junior_species='himalayensis' OR junior_species='himalayensis')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='Gyps' AND (species='himalayensis' OR species='himalayensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegypius' AND (junior_species='monachus' OR junior_species='monachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aegypius' AND (species='monachus' OR species='monachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aegypius' AND (species='monachus' OR species='monachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aegypius' AND (junior_species='monachus' OR junior_species='monachus')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='Aegypius' AND (species='monachus' OR species='monachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquila' AND (junior_species='chrysaetos' OR junior_species='chrysaetos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquila' AND (species='chrysaetos' OR species='chrysaetos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquila' AND (species='chrysaetos' OR species='chrysaetos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquila' AND (junior_species='chrysaetos' OR junior_species='chrysaetos')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='Aquila' AND (species='chrysaetos' OR species='chrysaetos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopodoces' AND (junior_species='humilis' OR junior_species='humilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopodoces' AND (species='humilis' OR species='humilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopodoces' AND (species='humilis' OR species='humilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopodoces' AND (junior_species='humilis' OR junior_species='humilis')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='Pseudopodoces' AND (species='humilis' OR species='humilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhocorax' AND (junior_species='pyrrhocorax' OR junior_species='pyrrhocorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhocorax' AND (species='pyrrhocorax' OR species='pyrrhocorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhocorax' AND (species='pyrrhocorax' OR species='pyrrhocorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhocorax' AND (junior_species='pyrrhocorax' OR junior_species='pyrrhocorax')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='Pyrrhocorax' AND (species='pyrrhocorax' OR species='pyrrhocorax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhocorax' AND (junior_species='graculus' OR junior_species='graculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhocorax' AND (species='graculus' OR species='graculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhocorax' AND (species='graculus' OR species='graculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhocorax' AND (junior_species='graculus' OR junior_species='graculus')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='Pyrrhocorax' AND (species='graculus' OR species='graculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='ochruros' OR junior_species='ochruros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='ochruros' OR species='ochruros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='ochruros' OR species='ochruros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='ochruros' OR junior_species='ochruros')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='Phoenicurus' AND (species='ochruros' OR species='ochruros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='erythrogaster' OR species='erythrogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')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='Phoenicurus' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopoecile' AND (junior_species='sophiae' OR junior_species='sophiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptopoecile' AND (species='sophiae' OR species='sophiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptopoecile' AND (species='sophiae' OR species='sophiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopoecile' AND (junior_species='sophiae' OR junior_species='sophiae')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='Leptopoecile' AND (species='sophiae' OR species='sophiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='fuscatus' OR junior_species='fuscatus')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='Phylloscopus' AND (species='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Montifringilla' AND (junior_species='adamsi' OR junior_species='adamsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Montifringilla' AND (species='adamsi' OR species='adamsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Montifringilla' AND (species='adamsi' OR species='adamsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Montifringilla' AND (junior_species='adamsi' OR junior_species='adamsii')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='Montifringilla' AND (species='adamsi' OR species='adamsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='alba' OR junior_species='alba')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='Motacilla' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='fulvescens' OR junior_species='fulvescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunella' AND (species='fulvescens' OR species='fulvescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunella' AND (species='fulvescens' OR species='fulvescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='fulvescens' OR junior_species='fulvescens')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='Prunella' AND (species='fulvescens' OR species='fulvescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linaria' AND (junior_species='flavirostris' OR junior_species='flavirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Linaria' AND (species='flavirostris' OR species='flavirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Linaria' AND (species='flavirostris' OR species='flavirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Linaria' AND (junior_species='flavirostris' OR junior_species='flavirostris')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='Linaria' AND (species='flavirostris' OR species='flavirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpodacus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpodacus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='spp.' OR junior_species='spp.')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='Carpodacus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3237