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=1970 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1970SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1766SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1970 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='hemionus' OR species='hemionus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hemionus' OR junior_species='hemionus')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='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')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='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='subgutturosa' OR junior_species='subgutturosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='subgutturosa' OR species='subgutturosa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='subgutturosa' OR junior_species='subgutturosa')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='Gazella' AND (species='subgutturosa' OR species='subgutturosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='ammon' OR junior_species='ammon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='ammon' OR species='ammon') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='ammon' OR junior_species='ammon')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='Ovis' AND (species='ammon' OR species='ammon') 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='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='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='Lepus' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='capensis' OR junior_species='capensis')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='capensis' OR species='capensis') 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='Aquila' AND (junior_species='nipalensis' OR junior_species='nipalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquila' AND (species='nipalensis' OR species='nipalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquila' AND (species='nipalensis' OR species='nipalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquila' AND (junior_species='nipalensis' OR junior_species='nipalensis')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='nipalensis' OR species='nipalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hieraaetus' AND (junior_species='pennatus' OR junior_species='pennatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hieraaetus' AND (species='pennatus' OR species='pennatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hieraaetus' AND (species='pennatus' OR species='pennatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hieraaetus' AND (junior_species='pennatus' OR junior_species='pennatus')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='Hieraaetus' AND (species='pennatus' OR species='pennatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='rufinus' OR junior_species='rufinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='rufinus' OR species='rufinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='rufinus' OR species='rufinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='rufinus' OR junior_species='rufinus')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='Buteo' AND (species='rufinus' OR species='rufinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='lagopus' OR junior_species='lagopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='lagopus' OR species='lagopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='lagopus' OR species='lagopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='lagopus' OR junior_species='lagopus')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='Buteo' AND (species='lagopus' OR species='lagopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='japonicus' OR species='japonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='japonicus' OR species='japonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='japonicus' OR junior_species='japonicus')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='Buteo' AND (species='japonicus' OR species='japonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='hemilasius' OR junior_species='hemilasius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='hemilasius' OR species='hemilasius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='hemilasius' OR species='hemilasius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='hemilasius' OR junior_species='hemilasius')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='Buteo' AND (species='hemilasius' OR species='hemilasius') 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='Motacilla' AND (junior_species='citreola' OR junior_species='citreola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='citreola' OR species='citreola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='citreola' OR species='citreola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='citreola' OR junior_species='citreola')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='citreola' OR species='citreola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='tschutschensis' OR junior_species='tschutschensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='tschutschensis' OR species='tschutschensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='tschutschensis' OR species='tschutschensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='tschutschensis' OR junior_species='tschutschensis')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='tschutschensis' OR species='tschutschensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Motacilla' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Motacilla' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Motacilla' AND (junior_species='cinerea' OR junior_species='cinerea')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='cinerea' OR species='cinerea') 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='Anthus' AND (junior_species='rufulus' OR junior_species='rufulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthus' AND (species='rufulus' OR species='rufulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthus' AND (species='rufulus' OR species='rufulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthus' AND (junior_species='rufulus' OR junior_species='rufulus')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='Anthus' AND (species='rufulus' OR species='rufulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='excubitor' OR junior_species='excubitor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='excubitor' OR species='excubitor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='excubitor' OR species='excubitor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='excubitor' OR junior_species='excubitor')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='Lanius' AND (species='excubitor' OR species='excubitor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='phoenicuroides' OR junior_species='phoenicuroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='phoenicuroides' OR species='phoenicuroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='phoenicuroides' OR species='phoenicuroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='phoenicuroides' OR junior_species='phoenicuroides')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='Lanius' AND (species='phoenicuroides' OR species='phoenicuroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodopechys' AND (junior_species='mongolica' OR junior_species='mongolica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodopechys' AND (species='mongolica' OR species='mongolica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodopechys' AND (species='mongolica' OR species='mongolica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodopechys' AND (junior_species='mongolica' OR junior_species='mongolica')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='Rhodopechys' AND (species='mongolica' OR species='mongolica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' 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='Carduelis' AND (species='flavirostris' OR species='flavirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='flavirostris' OR species='flavirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' 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='Carduelis' AND (species='flavirostris' OR species='flavirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passer' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passer' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passer' AND (junior_species='montanus' OR junior_species='montanus')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='Passer' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='isabellina' OR junior_species='isabellina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenanthe' AND (species='isabellina' OR species='isabellina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenanthe' AND (species='isabellina' OR species='isabellina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='isabellina' OR junior_species='isabellina')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='Oenanthe' AND (species='isabellina' OR species='isabellina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='deserti' OR junior_species='desertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenanthe' AND (species='deserti' OR species='desertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenanthe' AND (species='deserti' OR species='desertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='deserti' OR junior_species='desertii')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='Oenanthe' AND (species='deserti' OR species='desertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='pleschanka' OR junior_species='pleschanka')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenanthe' AND (species='pleschanka' OR species='pleschanka') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenanthe' AND (species='pleschanka' OR species='pleschanka')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenanthe' AND (junior_species='pleschanka' OR junior_species='pleschanka')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='Oenanthe' AND (species='pleschanka' OR species='pleschanka') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erithacus' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erithacus' AND (species='rubecula' OR species='rubecula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erithacus' AND (species='rubecula' OR species='rubecula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erithacus' AND (junior_species='rubecula' OR junior_species='rubecula')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='Erithacus' AND (species='rubecula' OR species='rubecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='phoenicurus' OR species='phoenicurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='phoenicurus' OR species='phoenicurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='phoenicurus' OR junior_species='phoenicurus')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='phoenicurus' OR species='phoenicurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='atrogularis' OR junior_species='atrogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='atrogularis' OR species='atrogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='atrogularis' OR species='atrogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='atrogularis' OR junior_species='atrogularis')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='Turdus' AND (species='atrogularis' OR species='atrogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='roseus' OR junior_species='roseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnus' AND (species='roseus' OR species='roseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnus' AND (species='roseus' OR species='roseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='roseus' OR junior_species='roseus')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='Sturnus' AND (species='roseus' OR species='roseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prunella' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunella' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunella' AND (junior_species='collaris' OR junior_species='collaris')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='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delichon' AND (junior_species='urbicum' OR junior_species='urbicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delichon' AND (species='urbicum' OR species='urbicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delichon' AND (species='urbicum' OR species='urbicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delichon' AND (junior_species='urbicum' OR junior_species='urbicum')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='Delichon' AND (species='urbicum' OR species='urbicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremophila' AND (junior_species='alpestris' OR junior_species='alpestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eremophila' AND (species='alpestris' OR species='alpestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eremophila' AND (species='alpestris' OR species='alpestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremophila' AND (junior_species='alpestris' OR junior_species='alpestris')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='Eremophila' AND (species='alpestris' OR species='alpestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='totanus' OR junior_species='totanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='totanus' OR species='totanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='totanus' OR species='totanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='totanus' OR junior_species='totanus')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='Tringa' AND (species='totanus' OR species='totanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='ochropus' OR junior_species='ochropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='ochropus' OR species='ochropus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='ochropus' OR species='ochropus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='ochropus' OR junior_species='ochropus')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='Tringa' AND (species='ochropus' OR species='ochropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='dubius' OR junior_species='dubius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charadrius' AND (species='dubius' OR species='dubius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charadrius' AND (species='dubius' OR species='dubius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charadrius' AND (junior_species='dubius' OR junior_species='dubius')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='Charadrius' AND (species='dubius' OR species='dubius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Childonias' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Childonias' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Childonias' AND (species='niger' OR species='niger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Childonias' AND (junior_species='niger' OR junior_species='niger')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Childonias' AND (species='niger' OR species='niger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrrhaptes' AND (junior_species='paradoxus' OR junior_species='paradoxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syrrhaptes' AND (species='paradoxus' OR species='paradoxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syrrhaptes' AND (species='paradoxus' OR species='paradoxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrrhaptes' AND (junior_species='paradoxus' OR junior_species='paradoxus')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='Syrrhaptes' AND (species='paradoxus' OR species='paradoxus') 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='Crex' AND (junior_species='crex' OR junior_species='crex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crex' AND (species='crex' OR species='crex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crex' AND (species='crex' OR species='crex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crex' AND (junior_species='crex' OR junior_species='crex')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='Crex' AND (species='crex' OR species='crex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadorna' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tadorna' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tadorna' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tadorna' AND (junior_species='ferruginea' OR junior_species='ferruginea')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='Tadorna' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1970 The Ecological Register: Mount Kalamaili Ungulate Nature Reserve
Mount Kalamaili Ungulate Nature Reserve
Basic information
Sample name: Mount Kalamaili Ungulate Nature Reserve

Reference: T. Dong, H. Chu, H. Wu, Y. Wang, Y. Ge, and L. Bu. 2014. Monitoring birds and mammals through camera traps in Mount Kalamaili Ungulate Nature Reserve, Xinjiang. Biodiversity Science 22(6):804-807 [ER 1766]
Geography
Country: China

State: Xinjiang


Coordinate: 45° 18' N, 89° 15' E
Coordinate basis: stated in text as range

Geography comments: "in Changji, Xinjiang Junggar Basin and the eastern part of the territory of Altay region"

•
Environment
Habitat: desert/xeric shrubland

Protection: nature reserve

Substrate: ground surface

MAT: 2.0

WMT: 20.5

CMT: -24.3

MAP: 187.0

Habitat comments: "arid desert"
climate data are for the reserve and are from Xia et al. (2011, J Ethol)

Methods
Life forms: carnivores,ungulates,other small mammals,birds

Sites: 12

Sampling methods: no design,automatic cameras

Sample size: 4317 captures or sightings

Years: 2013

Nets or traps: 26

Net or trap nights: 2006

Camera type: digital

Cameras paired: no

Sampling comments: sampling was from April to November 2013 at 12 "water sources" using "26 units (Ltl 5210 and Scout Guard)" (apparently not facing each other)

Metadata
Sample number: 1970

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-25 21:07:19

Modified: 2016-12-16 06:18:54

Abundance distribution
44 species
8 singletons
total count 4317
extrapolated richness: 64.0
Fisher's α: 6.819
geometric series k: 0.8318
Hurlbert's PIE: 0.5670
Shannon's H: 1.5186
Good's u: 0.9981
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Equus hemionus2752 grazer
Equus ferus przewalskii659422 kg
"Equus przewalskii"
Gazella subgutturosa9517 kg grazer
Ovis ammon1376 kg browser-grazer
Canis lupus3143 kg carnivore
Vulpes vulpes615.3 kg carnivore-insectivore
Lynx lynx316 kg carnivore
Lepus capensis134
Aquila chrysaetos63.9 kg carnivore
Aquila nipalensis12.3 kg
Hieraaetus pennatus2701 g carnivore
Buteo rufinus41.0 kg
Buteo lagopus13847 g
Buteo japonicus74
Buteo hemilasius31.2 kg
Aegypius monachus4
Motacilla citreola434.2 g insectivore
Motacilla tschutschensis4714.9 g
Motacilla cinerea74.0 g carnivore
Motacilla alba251.9 g insectivore
Anthus rufulus1 insectivore
Lanius excubitor14
Lanius phoenicuroides12
Rhodopechys mongolica2621.5 g
Carduelis flavirostris215.4 g
Passer montanus34.6 g granivore
Oenanthe isabellina1229.4 g insectivore
Oenanthe deserti119.6 g
Oenanthe pleschanka118.2 g
Erithacus rubecula117.7 g insectivore-frugivore
Phoenicurus phoenicurus214.7 g
Turdus atrogularis11
Sturnus roseus11 omnivore
Prunella collaris15.5 g insectivore
Delichon urbicum314.5 g insectivore
Eremophila alpestris12.4 g insectivore-granivore
Tringa totanus2129 g
Tringa ochropus571.4 g insectivore
Charadrius dubius7738.7 g carnivore
Childonias niger2
Syrrhaptes paradoxus51274 g
Alectoris chukar15541 g omnivore
Crex crex1169 g
Tadorna ferruginea851.4 kg