Animalia > Chordata > Aves > Columbiformes > Columbidae > Columba > Columba palumbus
 

Columba palumbus (Common Wood Pigeon)

Wikipedia Abstract

The common wood pigeon (Columba palumbus) is a large species in the dove and pigeon family. It belongs to the Columba genus and, like all pigeons and doves, belongs to the family Columbidae. It is locally known in southeast England as the "culver".
View Wikipedia Record: Columba palumbus

Infraspecies

Columba palumbus azorica (Azore's Wood Pigeon)
Columba palumbus casiotis (Asian wood pigeon)
Columba palumbus iranica (Iranian wood pigeon)
Columba palumbus maderensis (Madeira wood pigeon)
Columba palumbus palumbus (European wood pigeon)

EDGE Analysis

Uniqueness Scale: Similiar (0) 
6
 Unique (100)
Uniqueness & Vulnerability Scale: Similiar & Secure (0) 
22
 Unique & Vulnerable (100)
ED Score: 5.42111
EDGE Score: 1.85959

Attributes

Adult Weight [1]  1.08 lbs (490 g)
Birth Weight [2]  18.9 grams
Female Maturity [1]  1 year
Male Maturity [1]  1 year
Clutch Size [4]  2
Incubation [3]  17 days
Maximum Longevity [1]  16 years
Speed [5]  36.46 MPH (16.3 m/s)
Wing Span [5]  30 inches (.75 m)

Ecoregions

Name Countries Ecozone Biome Species Report Climate Land
Use
Aegean and Western Turkey sclerophyllous and mixed forests Greece, Turkey, Macedonia Palearctic Mediterranean Forests, Woodlands, and Scrub  
Al Hajar montane woodlands Oman Afrotropic Temperate Grasslands, Savannas, and Shrublands
Alai-Western Tian Shan steppe Kazahkstan, Uzbekistan, Tadjikistan Palearctic Temperate Grasslands, Savannas, and Shrublands
Alps conifer and mixed forests Italy, France, Switzerland, Slovenia Palearctic Temperate Coniferous Forests
Altai alpine meadow and tundra China, Kazakstan, Mongolia, Russia Palearctic Montane Grasslands and Shrublands
Altai steppe and semi-desert Kazahkstan Palearctic Temperate Grasslands, Savannas, and Shrublands
Anatolian conifer and deciduous mixed forests Turkey Palearctic Mediterranean Forests, Woodlands, and Scrub
Appenine deciduous montane forests Italy Palearctic Temperate Broadleaf and Mixed Forests
Arabian Desert and East Sahero-Arabian xeric shrublands Saudi Arabia, Oman, United Arab Emirates, Yemen, Egypt , Iraq, Jordan, Syria Palearctic Deserts and Xeric Shrublands
Atlantic mixed forests France, Belgium, Netherlands, Germany, Denmark Palearctic Temperate Broadleaf and Mixed Forests
Azerbaijan shrub desert and steppe Azerbaijan, Georgia, Iran Palearctic Deserts and Xeric Shrublands
Azores temperate mixed forests Portugal Palearctic Temperate Broadleaf and Mixed Forests  
Balkan mixed forests Turkey, Greece, Macedonia, Bulgaria, Romania, Serbia Palearctic Temperate Broadleaf and Mixed Forests
Baltic mixed forests Germany, Denmark, Sweden, Poland Palearctic Temperate Broadleaf and Mixed Forests
Baluchistan xeric woodlands Pakistan, Afghanistan Palearctic Deserts and Xeric Shrublands
Caledon conifer forests United Kingdom Palearctic Temperate Coniferous Forests
Cantabrian mixed forests Spain, Portugal Palearctic Temperate Broadleaf and Mixed Forests
Carpathian montane forests Czech Republic, Poland, Romania, Slovakia, Ukraine Palearctic Temperate Coniferous Forests
Caspian Hyrcanian mixed forests Iran, Azerbaijan Palearctic Temperate Broadleaf and Mixed Forests    
Caspian lowland desert Russia, Kazakhstan, Turkmenistan, Iran Palearctic Deserts and Xeric Shrublands  
Caucasus mixed forests Georgia, Russia, Azerbaijan, Turkey, Armenia Palearctic Temperate Broadleaf and Mixed Forests
Celtic broadleaf forests Ireland, United Kingdom Palearctic Temperate Broadleaf and Mixed Forests  
Central Anatolian deciduous forests Turkey Palearctic Temperate Broadleaf and Mixed Forests
Central Anatolian steppe Turkey Palearctic Temperate Grasslands, Savannas, and Shrublands
Central European mixed forests Austria, Belarus, Czech Republic, Germany, Lithuania, Moldovia, Poland, Romania, Russia, Ukraine Palearctic Temperate Broadleaf and Mixed Forests
Corsican montane broadleaf and mixed forests France Palearctic Mediterranean Forests, Woodlands, and Scrub
Crete Mediterranean forests Greece Palearctic Mediterranean Forests, Woodlands, and Scrub  
Crimean Submediterranean forest complex Russia, Ukraine Palearctic Temperate Broadleaf and Mixed Forests
Cyprus Mediterranean forests Cyprus Palearctic Mediterranean Forests, Woodlands, and Scrub
Dinaric Mountains mixed forests Albania, Bosnia & Herzegovina, Croatia, Italy, Slovenia, Yugoslavia Palearctic Temperate Broadleaf and Mixed Forests
East Afghan montane conifer forests Pakistan, Afghanistan Palearctic Temperate Coniferous Forests
East European forest steppe Bulgaria, Moldova, Romania, Russia, Ukraine Palearctic Temperate Broadleaf and Mixed Forests
Eastern Anatolian deciduous forests Turkey Palearctic Temperate Broadleaf and Mixed Forests
Eastern Anatolian montane steppe Iran, Turkey, Armenia Palearctic Temperate Grasslands, Savannas, and Shrublands
Eastern Mediterranean conifer-sclerophyllous-broadleaf forests Turkey, Jordan, Israel, Syria Palearctic Mediterranean Forests, Woodlands, and Scrub
Elburz Range forest steppe Iran Palearctic Temperate Coniferous Forests    
Emin Valley steppe China, Kazakstan Palearctic Temperate Grasslands, Savannas, and Shrublands
English Lowlands beech forests United Kingdom Palearctic Temperate Broadleaf and Mixed Forests    
Euxine-Colchic broadleaf forests Turkey Palearctic Temperate Broadleaf and Mixed Forests
Faroe Islands boreal grasslands Denmark Palearctic Temperate Grasslands, Savannas, and Shrublands  
Ghorat-Hazarajat alpine meadow Afghanistan Palearctic Montane Grasslands and Shrublands
Gissaro-Alai open woodlands Kyrgyzstan, Tajikistan, Uzbekistan Palearctic Temperate Grasslands, Savannas, and Shrublands
Great Lakes Basin desert steppe Mongolia, Russia Palearctic Deserts and Xeric Shrublands
Gulf of Oman desert and semi-desert Oman, United Arab Emirates Afrotropic Deserts and Xeric Shrublands
Hindu Kush alpine meadow Afghanistan, Pakistan Palearctic Montane Grasslands and Shrublands
Iberian conifer forests Spain Palearctic Mediterranean Forests, Woodlands, and Scrub
Iberian sclerophyllous and semi-deciduous forests Spain, Portugal Palearctic Mediterranean Forests, Woodlands, and Scrub
Illyrian deciduous forests Italy, Slovenia, Croatia, Bosnia & Herzegovina, Montenegro, Albania, Greece Palearctic Mediterranean Forests, Woodlands, and Scrub
Italian sclerophyllous and semi-deciduous forests Italy, France Palearctic Mediterranean Forests, Woodlands, and Scrub
Junggar Basin semi-desert China, Kazakstan, Mongolia Palearctic Deserts and Xeric Shrublands
Karakoram-West Tibetan Plateau alpine steppe Pakistan, China, Afghanistan, India Palearctic Montane Grasslands and Shrublands
Kazakh semi-desert Kazakhstan Palearctic Deserts and Xeric Shrublands
Kazakh steppe Russia, Kazakhstan Palearctic Temperate Grasslands, Savannas, and Shrublands
Madeira evergreen forests Portugal Palearctic Temperate Broadleaf and Mixed Forests  
Mediterranean acacia-argania dry woodlands and succulent thickets Morocco, Spain Palearctic Mediterranean Forests, Woodlands, and Scrub
Mediterranean conifer and mixed forests Algeria, Morocco, Tunisia Palearctic Temperate Coniferous Forests
Mediterranean dry woodlands and steppe Algeria, Egypt, Libya, Morocco, Tunisia Palearctic Mediterranean Forests, Woodlands, and Scrub
Mediterranean High Atlas juniper steppe Morocco Palearctic Montane Grasslands and Shrublands
Mediterranean woodlands and forests Morocco, Algeria, Tunisia Palearctic Mediterranean Forests, Woodlands, and Scrub
Mesopotamian shrub desert Iraq, Syria, Jordan Palearctic Deserts and Xeric Shrublands
Middle East steppe Syria, Iraq Palearctic Temperate Grasslands, Savannas, and Shrublands
North Atlantic moist mixed forests Ireland, United Kingdom Palearctic Temperate Broadleaf and Mixed Forests
North Tibetan Plateau-Kunlun Mountains alpine desert China Palearctic Montane Grasslands and Shrublands
Northeastern Spain and Southern France Mediterranean forests France, Spain Palearctic Mediterranean Forests, Woodlands, and Scrub
Northern Anatolian conifer and deciduous forests Turkey Palearctic Temperate Coniferous Forests
Northwest Iberian montane forests Portugal, Spain Palearctic Mediterranean Forests, Woodlands, and Scrub
Northwestern Himalayan alpine shrub and meadows China, Pakistan, India Palearctic Montane Grasslands and Shrublands
Pamir alpine desert and tundra China, Tajikistan, Kyrgyzstan Palearctic Montane Grasslands and Shrublands
Pannonian mixed forests Austria, Bosnia & Herzegovina, Croatia, Czech Republic, Hungary, Romania, Serbia, Slovakia, Slovenia, Ukraine Palearctic Temperate Broadleaf and Mixed Forests
Paropamisus xeric woodlands Afghanistan Palearctic Deserts and Xeric Shrublands
Pindus Mountains mixed forests Albania, Greece Palearctic Mediterranean Forests, Woodlands, and Scrub
Po Basin mixed forests Italy Palearctic Temperate Broadleaf and Mixed Forests
Pontic steppe Russia, Kazakhstan, Ukraine Palearctic Temperate Grasslands, Savannas, and Shrublands
Pyrenees conifer and mixed forests Spain, France, Andorra Palearctic Temperate Broadleaf and Mixed Forests
Qaidam Basin semi-desert China Palearctic Deserts and Xeric Shrublands
Rodope montane mixed forests Bulgaria, Greece, Macedonia Palearctic Temperate Broadleaf and Mixed Forests
Sarmatic mixed forests Belarus, Estonia, Finland, Latvia, Lithuania, Norway, Russia, Sweden Palearctic Temperate Broadleaf and Mixed Forests
Scandinavian and Russian taiga Norway, Sweden, Finland, Russia Palearctic Boreal Forests/Taiga
Scandinavian coastal conifer forests Norway Palearctic Temperate Coniferous Forests
Scandinavian Montane Birch forest and grasslands Norway, Sweden, Finland Palearctic Tundra
South Appenine mixed montane forests Italy Palearctic Mediterranean Forests, Woodlands, and Scrub
South Iran Nubo-Sindian desert and semi-desert Iran, Iraq, Pakistan Palearctic Deserts and Xeric Shrublands
Southeastern Iberian shrubs and woodlands Spain Palearctic Mediterranean Forests, Woodlands, and Scrub
Southern Anatolian montane conifer and deciduous forests Turkey, Syria, Lebanon, Israel Palearctic Mediterranean Forests, Woodlands, and Scrub
Southwest Iberian Mediterranean sclerophyllous and mixed forests Portugal, Spain, France, Italy, Morocco Palearctic Mediterranean Forests, Woodlands, and Scrub
Sulaiman Range alpine meadows Afghanistan, Pakistan Palearctic Montane Grasslands and Shrublands
Taklimakan desert China Palearctic Deserts and Xeric Shrublands
Tarim Basin deciduous forests and steppe China Palearctic Temperate Broadleaf and Mixed Forests
Tian Shan foothill arid steppe China, Kazakhstan, Kyrgyzstan Palearctic Temperate Grasslands, Savannas, and Shrublands
Tian Shan montane conifer forests China, Kazakhstan, Kyrgyzstan Palearctic Temperate Coniferous Forests
Tian Shan montane steppe and meadows China, Kazakhstan, Kyrgyzstan Palearctic Montane Grasslands and Shrublands
Tigris-Euphrates alluvial salt marsh Iran, Iraq Palearctic Flooded Grasslands and Savannas
Tyrrhenian-Adriatic sclerophyllous and mixed forests France, Italy Palearctic Mediterranean Forests, Woodlands, and Scrub    
Ural montane forests and tundra Russia Palearctic Boreal Forests/Taiga
West Siberian taiga Russia Palearctic Boreal Forests/Taiga
Western European broadleaf forests Austria, Czech Republic, France, Germany Palearctic Temperate Broadleaf and Mixed Forests
Western Himalayan alpine shrub and meadows India, Nepal Palearctic Montane Grasslands and Shrublands
Western Himalayan subalpine conifer forests India, Pakistan, Nepal Indo-Malayan Temperate Coniferous Forests
Western Siberian hemiboreal forests Russia Palearctic Temperate Broadleaf and Mixed Forests
Zagros Mountains forest steppe Iran Palearctic Temperate Broadleaf and Mixed Forests

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
ANTICHASIA ORI KAI METEORA 178032 Greece  
Alpi Marittime 83205 Italy  
Alsó-Tisza-völgy 88306 Hungary  
Alte Valli Stura e Maira 103806 Italy  
Appennino Lucano, Valle Agri, Monte Sirino, Monte Raparo 90310 Italy  
Astrakhanskiy Biosphere Reserve Zapovednik Ia 167827 Astrakhan, Russia
Badghyz Zapovednik State Nature Reserve Ia 215164 Turkmenistan  
Belovezhskaya Pushcha Biosphere Reserve National Park II 218515 Belarus
Berezinskiy Zapovednik State Nature Reserve Ia 209113 Belarus  
Bükk-hegység és peremterületei 164079 Hungary  
Camargue 546256 France  
Carpathian Biosphere Reserve 144772 Ukraine  
Chausey 203679 France  
Chumbi-Surla Wildlife Sanctuary IV 137833 Pakistan  
DEHESAS DE JEREZ 118651 Spain  
DELTA ACHELOOU, LIMNOTHALASSA MESOLONGIOU - AITOLIKOU KAI EKVOLES EVINOU, NISOI ECHINADES, NISOS PET 109185 Greece  
DELTA ACHELOOU, LIMNOTHALASSA MESOLONGIOU - AITOLIKOU, EKVOLES EVINOU, NISOI ECHINADES, NISOS PETALA 87747 Greece  
DELTA AXIOU - LOUDIA - ALIAKMONA - EVRYTERI PERIOCHI - AXIOUPOLI 83216 Greece  
DESFILADEROS DEL RÍO MARTÍN 110851 Spain  
DOÑANA 281453 Spain  
Darvinsky Zapovednik Ia 278421 Yaroslavl, Vologda, Russia
Estuário do Tejo 110634 Portugal  
Felsõ-kiskunsági szikes puszták és turjánvidék 103542 Hungary  
Flusslandschaft Elbe Biosphere Reserve 925242 Germany  
Fuentes del Narcea y del Ibias 126128 Spain  
Hevesi-sík 191445 Hungary  
Hortobágy National Park II 140004 Hungary  
Itäisen Suomenlahden saaristo ja vedet 236302 Finland    
KOILADA ACHELOOU KAI ORI VALTOU 115492 Greece  
KOILADA KAI EKVOLES SPERCHEIOU - MALIAKOS KOLPOS 117491 Greece  
KORYFES OROUS GRAMMOS 84898 Greece  
KORYFES OROUS VORA 99917 Greece  
Kavkazskiy Biosphere Reserve Ia 692723 Krasnodar, Karachay-Cherkessia, Adygea, Russia
Kiskunsági szikes tavak és az õrjegi turjánvidék 88335 Hungary  
Kopetdagh Zapovednik State Nature Reserve Ia 125705 Turkmenistan  
Krivoklatsko Protected Landscape Area V 155267 Czech Republic  
Krkonose National Park V 95995 Czech Republic  
Kugti Sanctuary IV 126362 Himachal Pradesh, India  
LA RETUERTA Y SALADAS DE SÁSTAGO 88970 Spain  
LA SERENA Y SIERRAS PERIFÉRICAS 379806 Spain  
LEFKA ORI KAI PARAKTIA ZONI 131864 Greece  
LIMNES KORONEIAS - VOLVIS, STENA RENTINAS KAI EVRYTERI PERIOCHI 399400 Greece  
LIMNI KERKINI - KROUSIA - KORYFES OROUS BELES, ANGISTRO - CHAROPO 193493 Greece  
LLANOS DE ALCANTARA Y BROZAS 126519 Spain  
LOS ALCORNOCALES 414561 Spain  
LOS VALLES 79029 Spain  
Lake Torne Area Biosphere Reserve 238457 Sweden  
Laplandskiy Biosphere Reserve 757114 Russia  
Luberon Regional Nature Park V 406572 France  
MATARRAÑA - AIGUABARREIX 90747 Spain  
MONFRAGÜE Y LAS DEHESAS DEL ENTORNO 287016 Spain  
MONTES UNIVERSALES - SIERRA DEL TREMEDAL 79316 Spain  
Marchesato e Fiume Neto 173480 Italy  
Mont Ventoux Biosphere Reserve 198594 France  
Monte Cervati e dintorni 91212 Italy  
Monti del Gennargentu 110493 Italy  
NOTIA MANI 78232 Greece  
Northern Karelian Biosphere Reserve 864869 Finland  
OREINOS EVROS - KOILADA DEREIOU 120853 Greece  
OROS CHELMOS (AROANIA) - FARANGI VOURAIKOU KAI PERIOCHI KALAVRYTON 79492 Greece  
OROS ERYMANTHOS 96330 Greece  
OROS MAVROVOUNI 91743 Greece  
OROS OCHI, PARAKTIA ZONI KAI NISIDES 82497 Greece  
OROS PARNASSOS 84965 Greece  
OROS PILIO 89437 Greece  
OROS VORAS 196334 Greece  
Okskiy Biosphere Reserve 190748 Russia  
POSETS - MALADETA 82205 Spain  
PUERTO PEÑA - LOS GOLONDRINOS 82543 Spain  
Parco Del Cilento e Vallo de Diano National Park 551095 Italy
Parco Nazionale dello Stelvio National Park V 333737 Italy
Pechoro-Ilychskiy Biosphere Reserve 3098091 Russia  
Picentini 157557 Italy  
Redes 93413 Spain  
Reserve de la Biosphere des Vosges du Nord Biosphere Reserve 301469 France  
Rila 200269 Bulgaria  
RÍO GUADALOPE - MAESTRAZGO 133800 Spain  
SIERRA DE ALCUBIERRE 103846 Spain  
SIERRA DE GRAZALEMA 131980 Spain  
SIERRA DE LAS VILLUERCAS Y VALLE DEL GUADARRANQUE 188630 Spain  
SIERRA NEVADA 424554 Spain  
SIERRA SUBBETICA 79212 Spain  
SIERRAS DE CAZORLA, SEGURA Y LAS VILLAS 519222 Spain  
SIERRAS DE SANTO DOMINGO Y CABALLERA Y RÍO ONSELLA 88167 Spain  
SIERRAS DE TEJEDA, ALMIJARA Y ALHAMA 100440 Spain  
Sayano-Shushenskiy Biosphere Reserve Ia 964620 Krasnoyarsk, Russia
Schorfheide-Chorin Biosphere Reserve 319164 Germany
South Pennine Moors 160577 England, United Kingdom  
Spreewald Biosphere Reserve 117355 Germany  
Sumava Biosphere Reserve 412955 Czech Republic  
Trebon Basin Protected Landscape Area V 173393 Czech Republic  
Tzentralen Balkan 177099 Bulgaria  
Ubiña-La Mesa 97094 Spain  
Ubsunurskaya Kotlovina (Ubsunur Depression) Zapovednik Ia 798640 Tuva, Russia
VOREIA CHIOS 80479 Greece  
VOUNA EVROU 104705 Greece  
Voronezhskiy Biosphere Reserve 95835 Russia  
Waddensea of Lower Saxony Biosphere Reserve 539522 Germany  
Waddensea of Schleswig-Holstein Biosphere Reserve 724639 Germany
Zempléni-hegység a Szerencsi-dombsággal és a Hernád-völggyel 284651 Hungary  

Ecosystems

Important Bird Areas

BirdLife Species Factsheet: View Factsheet
Name Location  IBA Criteria   Website   Climate   Land Use 
Buzulukski forest Russia (European) A1, B2, B3
Cabeço do Fogo Portugal B3, C2, C6  
Krivoklatsko (Krivoklatsko region) Czech Republic B2, B3, C6
Lomba Grande Portugal C2, C6  
Mountains of Barcelona Spain B1i, B2, B3, C2, C3, C6
Pico da Vara Portugal A1, A2, B3, C1, C2, C6  
Zona Central do Pico Portugal B3, C2, C6

Biodiversity Hotspots

Name Location Endemic Species Website
Caucasus Armenia, Azerbaijan, Georgia, Iran, Russia, Turkey No
Himalaya Bhutan, China, India, Myanmar, Nepal, Pakistan No
Irano-Anatolian Armenia, Azerbaijan, Georgia, Iran, Iraq, Turkey, Turkmenistan No
Mediterranean Basin Algeria, Egypt, France, Greece, Israel, Jordan, Lebanon, Libya, Portugal, Spain, Syria, Tunisia, Turkey No
Mountains of Central Asia Afghanistan, China, Kazakhstan, Kyrgyzstan, Tajikistan, Uzbekistan No

Prey / Diet

Chenopodium album (lambsquarters goosefoot)[6]
Corylus avellana (common filbert)[6]
Fagus sylvatica[6]
Ilex aquifolium (English holly)[6]
Malva moschata (musk mallow)[6]
Plantago cornuti (rippleseed plantain)[6]
Poa pratensis (Kentucky bluegrass)[6]
Quercus robur (Pedunculate Oak)[6]
Ranunculus acris (meadow buttercup)[6]
Rosa canina (Dog Rose)[7]
Rumex oblongifolius (bluntleaf dock)[6]
Sambucus nigra (European black elderberry)[6]
Sambucus racemosa (red elderberry)[6]
Sorbus aucuparia (Mountain Ash)[6]
Stellaria holostea (addersmeat)[6]
Taraxacum campylodes (Dandelion)[6]
Trifolium pratense (Red Clover)[6]
Urtica dioica (California nettle)[6]
Viburnum opulus (European cranberrybush)[6]
Viola arvensis (European field pansy)[6]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Acanthis flammea (Common Redpoll)6
Acronicta alni (Alder Moth)4
Acronicta psi (Grey Dagger Moth)3
Apis mellifera (honey bee)3
Apodemus sylvaticus (Old World wood and field mouse)3
Attelabus nitens3
Autographa gamma (Silver Y Moth)4
Bison bonasus (European bison)5
Cabera pusaria (Common White Wave Moth)3
Capreolus capreolus (western roe deer)3
Carduelis carduelis (European Goldfinch)7
Chloris chloris (European Greenfinch)7
Coenonympha pamphilus (Small Heath Butterfly)3
Colocasia coryli (Nut-tree Tussock)4
Columba oenas (Stock Dove)8
Cosmia trapezina (Dun-bar)5
Episyrphus balteatus (Marmelade Fly)4
Erithacus rubecula (European Robin)3
Eupeodes luniger3
Fringilla coelebs (Common Chaffinch)7
Garrulus glandarius (Eurasian Jay)3
Geometra papilionaria (Large Emerald)3
Glis glis (fat dormouse)4
Gortyna flavago3
Linaria cannabina (Common Linnet)5
Meles meles (European Badger)4
Noctua fimbriata (Broad-bordered Yellow Underwing)4
Orthosia gothica (Hebrew Character)3
Parus major (Great Tit)3
Passer domesticus (House Sparrow)9
Passer montanus (Eurasian Tree Sparrow)4
Pieris napi (Green-veined White Butterfly)3
Pogonocherus hispidulus3
Prunella modularis (Dunnock)3
Pyrrhula pyrrhula (Eurasian Bullfinch)3
Saturnia pavonia (Emperor moth)3
Sciurus vulgaris (Eurasian red squirrel)3
Spilosoma lubricipeda (White Ermine Moth)3
Stauropus fagi (Lobster Moth)4
Streptopelia decaocto (Eurasian Collared-Dove)3
Streptopelia turtur (European Turtle-Dove)6
Sturnus vulgaris (European Starling)3
Sylvia atricapilla (Eurasian Blackcap)3
Turdus merula (Eurasian Blackbird)5
Turdus philomelos (Song Thrush)4
Turdus pilaris (Fieldfare)3
Turdus viscivorus (Mistle Thrush)3

Predators

Accipiter gentilis (Northern Goshawk)[6]
Felis chaus furax (Jungle cat)[8]
Ixodes ricinus (Deer tick)[6]
Martes martes (European Pine Marten)[6]

Providers

Shelter 
Betula pendula (European white birch)[6]
Fagus sylvatica (European beech)[6]
Picea abies (Norway spruce)[6]

Consumers

Parasitized by 
Baruscapillaria obsignata <Unverified Name>[9]
Brachylaima fuscatus[9]
Capillaria caudinflata <Unverified Name>[9]
Ceratophyllus farreni farreni[10]
Ceratophyllus rusticus[10]
Ceratophyllus sciurorum sciurorum <Unverified Name>[10]
Cotugnia iraqensis <Unverified Name>[9]
Davainea columbae <Unverified Name>[9]
Hymenolepis columbae <Unverified Name>[9]

Institutions (Zoos, etc.)

    Maps
Institution Infraspecies / Breed 
Assiniboine Park Zoopalumbus
Kharkiv Zoo
Miejski Ogrod Zoologiczny w Lodz
Miejski Ogrod Zoologiczny Warsaw
Moscow Zoological Park
Parc Animalier de Sainte Croix
Permskii Zoologicheskii Sad
Podkrusnohorsky Zoopark Chomutov
San Antonio Zoological Gardens & Aquar
Szeged Zoo
Taipei Zooazorica
Zoo de Santillana y Parque Cuaternario
Zoologicka Zahrada Bratislava

Range Map

Audio

Play / PauseVolume
Provided by Xeno-canto under a Creative Commons BY-NC-ND 2.5 License Author: Patrik Åberg

Photos

Citations

Attributes / relations provided by 1de Magalhaes, J. P., and Costa, J. (2009) A database of vertebrate longevity records and their relation to other life-history traits. Journal of Evolutionary Biology 22(8):1770-1774 2Terje Lislevand, Jordi Figuerola, and Tamás Székely. 2007. Avian body sizes in relation to fecundity, mating system, display behavior, and resource sharing. Ecology 88:1605 3British Trust for Ornithology 4Jetz W, Sekercioglu CH, Böhning-Gaese K (2008) The Worldwide Variation in Avian Clutch Size across Species and Space PLoS Biol 6(12): e303. doi:10.1371/journal.pbio.0060303 5Alerstam T, Rosén M, Bäckman J, Ericson PGP, Hellgren O (2007) Flight Speeds among Bird Species: Allometric and Phylogenetic Effects. PLoS Biol 5(8): e197. doi:10.1371/journal.pbio.0050197 6Ecology of Commanster 7Birds and berries: a study of an ecological interaction. Calton, Great Britain, Snow B.K., Snow D.W., 1988, T & AD Poyser. 268 p. 8THE PARASITIC FAUNA AND THE FOOD HABITS OF THE WILD JUNGLE CAT FELIS CHAUS FURAX DE WINTON, 1898 IN IRAQ, Mohammad K. Mohammad, Bull. Iraq nat. Hist. Mus. (2008) 10(2): 65-78 9Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London 10International Flea Database
Ecoregions provided by World Wide Fund For Nature (WWF). WildFinder: Online database of species distributions, ver. 01.06 WWF WildFINDER
Protected Areas provided by Natura 2000, UK data: © Crown copyright and database right [2010] All rights reserved. Ordnance Survey Licence number 100017955 Biological Inventories of the World's Protected Areas in cooperation between the Information Center for the Environment at the University of California, Davis and numerous collaborators. GBIF Global Biodiversity Information Facility
Biodiversity Hotspots provided by Critical Ecosystem Partnership Fund
Images provided by Google Image Search
Abstract provided by DBpedia licensed under a Creative Commons License
Weather provided by NOAA METAR Data Access
Audio software provided by SoundManager 2
(default) 51 queries took 77 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Edge`.`namecode_id`, `Edge`.`description`, `Edge`.`ED`, `Edge`.`EDGE`, `Edge`.`EDGEsp`, `Edge`.`EDPct`, `Edge`.`EDGEPct`, `Edge`.`id_num`, `Edge`.`edtype`, `Audio`.`namecode_id`, `Audio`.`dbid`, `Audio`.`author`, `Audio`.`url`, `Audio`.`name`, `Sabstract`.`id`, `Sabstract`.`abstract`, `Sabstract`.`wikipage`, `Sabstract`.`database_id`, `Sabstract`.`valid`, `TaxaBreadcrumb`.`id`, `TaxaBreadcrumb`.`trail`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `edges` AS `Edge` ON (`Taxa`.`namecode_id` = `Edge`.`namecode_id`) LEFT JOIN `audios` AS `Audio` ON (`Taxa`.`namecode_id` = `Audio`.`namecode_id`) LEFT JOIN `abstracts` AS `Sabstract` ON (`Taxa`.`namecode_id` = `Sabstract`.`id` AND `Sabstract`.`valid` = 'Y') LEFT JOIN `breadcrumbs` AS `TaxaBreadcrumb` ON (`Taxa`.`parent_id` = `TaxaBreadcrumb`.`id`) LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` = 831096 LIMIT 1111
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (831096) 111
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (831096) 990
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (831096) ORDER BY `Taxalink`.`location` DESC 000
5SELECT `Webcam`.`id`, `Webcam`.`name`, `Webcam`.`camtype`, `Webcam`.`camurl`, `Webcam`.`location_type`, `Webcam`.`location_id`, `Webcam`.`namecode_id`, `Webcam`.`display`, `Webcam`.`last_update`, `Webcam`.`webpageurl`, `Webcam`.`start_hour`, `Webcam`.`end_hour`, `Webcam`.`gmt`, `Webcam`.`feedings`, `Webcam`.`joystick` FROM `webcams` AS `Webcam` WHERE `Webcam`.`namecode_id` = (831096) ORDER BY `Webcam`.`name` ASC 000
6SELECT `Missingrel`.`id`, `Missingrel`.`consumer`, `Missingrel`.`provider`, `Missingrel`.`reltype`, `Missingrel`.`dbid`, `Missingrel`.`trophic`, `Missingrel`.`namecode_id`, `Missingrel`.`namecode_type`, `Missingrel`.`missing_id` FROM `missingrel` AS `Missingrel` WHERE `Missingrel`.`namecode_id` = (831096) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 660
7SELECT `TaxaEcoregions`.`id`, `TaxaEcoregions`.`name`, `TaxaEcoregions`.`biome_id`, `TaxaEcoregions`.`geo_id`, `TaxaEcoregions`.`country`, `TaxaEcoregions`.`area_h`, `TaxaEcoregions`.`abstract`, `TaxaEcoregions`.`supressnglink`, `TaxaEcoregions`.`er_type`, `EcoregionTaxa`.`taxa_id`, `EcoregionTaxa`.`ecoregion_id` FROM `ecoregions` AS `TaxaEcoregions` JOIN `ecoregion_taxa` AS `EcoregionTaxa` ON (`EcoregionTaxa`.`taxa_id` = 831096 AND `EcoregionTaxa`.`ecoregion_id` = `TaxaEcoregions`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcoregions`.`name` ASC 1001003
8SELECT `TaxaEmblems`.`id`, `TaxaEmblems`.`abbrev2`, `TaxaEmblems`.`abbrev3`, `TaxaEmblems`.`name`, `TaxaEmblems`.`poltype`, `TaxaEmblems`.`region`, `Emblem`.`id`, `Emblem`.`political_id`, `Emblem`.`namecode_id`, `Emblem`.`etype`, `Emblem`.`sortorder` FROM `politicals` AS `TaxaEmblems` JOIN `emblems` AS `Emblem` ON (`Emblem`.`namecode_id` = 831096 AND `Emblem`.`political_id` = `TaxaEmblems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEmblems`.`name` ASC 001
9SELECT `TaxaEcosystems`.`id`, `TaxaEcosystems`.`name`, `TaxaEcosystems`.`database_id`, `TaxaEcosystems`.`notes`, `EcosysSpecy`.`id`, `EcosysSpecy`.`ecosystem_id`, `EcosysSpecy`.`species_id`, `EcosysSpecy`.`top_consumer`, `EcosysSpecy`.`trophic_level` FROM `ecosystems` AS `TaxaEcosystems` JOIN `ecosys_species` AS `EcosysSpecy` ON (`EcosysSpecy`.`species_id` = 831096 AND `EcosysSpecy`.`ecosystem_id` = `TaxaEcosystems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcosystems`.`name` ASC 111
10SELECT `TaxaHotspots`.`id`, `TaxaHotspots`.`name`, `TaxaHotspots`.`country`, `TaxaHotspots`.`abstract`, `TaxaHotspots`.`link`, `TaxaHotspots`.`geo_id`, `HotspotTaxa`.`hotspot_id`, `HotspotTaxa`.`taxa_id`, `HotspotTaxa`.`endemic` FROM `hotspots` AS `TaxaHotspots` JOIN `hotspot_taxa` AS `HotspotTaxa` ON (`HotspotTaxa`.`taxa_id` = 831096 AND `HotspotTaxa`.`hotspot_id` = `TaxaHotspots`.`id`) WHERE 1 = 1 ORDER BY `TaxaHotspots`.`name` ASC 551
11SELECT `TaxaAzesites`.`id`, `TaxaAzesites`.`name`, `TaxaAzesites`.`country`, `TaxaAzesites`.`mapid`, `TaxaAzesites`.`lat`, `TaxaAzesites`.`lon`, `TaxaAzesites`.`zone`, `TaxaAzesites`.`geo_id`, `AzeTaxa`.`azesite_id`, `AzeTaxa`.`taxa_id` FROM `azesites` AS `TaxaAzesites` JOIN `aze_taxa` AS `AzeTaxa` ON (`AzeTaxa`.`taxa_id` = 831096 AND `AzeTaxa`.`azesite_id` = `TaxaAzesites`.`id`) WHERE 1 = 1 ORDER BY `TaxaAzesites`.`name` ASC 001
12SELECT `TaxaBirdareas`.`id`, `TaxaBirdareas`.`name`, `TaxaBirdareas`.`country`, `TaxaBirdareas`.`zone`, `TaxaBirdareas`.`finalcode`, `TaxaBirdareas`.`area`, `TaxaBirdareas`.`lat`, `TaxaBirdareas`.`lon`, `TaxaBirdareas`.`criteria`, `TaxaBirdareas`.`geo_id`, `TaxaBirdareas`.`kml`, `BirdareaTaxa`.`birdarea_id`, `BirdareaTaxa`.`taxa_id`, `BirdareaTaxa`.`criteria`, `BirdareaTaxa`.`species_id` FROM `birdareas` AS `TaxaBirdareas` JOIN `birdarea_taxa` AS `BirdareaTaxa` ON (`BirdareaTaxa`.`taxa_id` = 831096 AND `BirdareaTaxa`.`birdarea_id` = `TaxaBirdareas`.`id`) WHERE 1 = 1 ORDER BY `TaxaBirdareas`.`name` ASC 771
13SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`parent_id` = 11910549 ORDER BY `Taxa`.`name` ASC 551
14SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (845075, 968265, 968266, 968267, 845074) 551
15SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (845075, 968265, 968266, 968267, 845074) 000
16SELECT `Zooinst`.`id`, `Zooinst`.`abbrev`, `Zooinst`.`name`, `Zooinst`.`city`, `Zooinst`.`state`, `Zooinst`.`country`, `Zooinst`.`species_cnt`, `Zooinst`.`specimen_cnt`, `Zooinst`.`url`, `Zooinst`.`lat`, `Zooinst`.`lon`, `Zooinst`.`continent_id`, `Zooinst`.`gmt`, `ZooSpecie`.`id`, `ZooSpecie`.`zooinst_id`, `ZooSpecie`.`taxa_id`, `ZooSpecie`.`infraspecies`, `ZooSpecie`.`males`, `ZooSpecie`.`females`, `ZooSpecie`.`unknown`, `ZooSpecie`.`births`, `ZooSpecie`.`database_id` FROM `zooinsts` AS `Zooinst` LEFT JOIN `zoo_species` AS `ZooSpecie` ON (`ZooSpecie`.`zooinst_id` = `Zooinst`.`id`) WHERE `ZooSpecie`.`taxa_id` = 831096 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 13131
17SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 831096 AND d.group_id = dg.id ORDER BY dg.distribution52752723
18SELECT s.name FROM synonyms s WHERE s.namecode_id = 831096 ORDER BY s.name001
19SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 831096 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language001
20SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 831096111
21SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 831096 AND pa.geo_id = g.id ORDER BY pa.gis_area_h desc LIMIT 1001001006
22SELECT pa.name FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 831096 ORDER BY pa.gis_area_h desc LIMIT 100,4223223223
23SELECT e.id, g.gridx, g.gridy, g.climate, g.landuse FROM ecoregions e, geographics g WHERE e.geo_id = g.id AND e.id IN ('PA1201','AT0801','PA0801','PA0501','PA1001','PA0802','PA1202','PA0401','PA1303','PA0402','PA1305','PA0403','PA0404','PA0405','PA1307','PA0503','PA0406','PA0504','PA0407','PA1308','PA0408','PA0409','PA0410','PA0803','PA0412','PA1204','PA1205','PA0416','PA1206','PA0418','PA0506','PA0419','PA0420','PA0805','PA1207','PA0507','PA0806','PA0421','PA0422','PA0807','PA1004','PA0808','PA1316','AT1306','PA1005','PA1208','PA1209','PA1210','PA1211','PA1317','PA1006','PA1318','PA0810','PA0425','PA1212','PA0513','PA1213','PA1010','PA1214','PA1320','PA0812','PA0429','PA1011','PA1215','PA0515','PA1216','PA1012','PA1014','PA0431','PA1322','PA1217','PA0432','PA0814','PA0433','PA1324','PA0435','PA0436','PA0608','PA0520','PA1110','PA1218','PA1328','PA1219','PA1220','PA1221','PA1018','PA1330','PA0442','PA0818','PA0521','PA1019','PA0906','PA1222','PA0610','PA0611','PA0445','PA1021','IM0502','PA0444','PA0446')1001002
24SELECT e.id, g.gridx, g.gridy, g.climate, g.landuse FROM birdareas e, geographics g WHERE e.geo_id = g.id AND e.id IN (1454,19695,2940,19694,1792,19717,19712)771
25SELECT `Relation`.`id`, `Relation`.`consumer_id`, `Relation`.`provider_id`, `Relation`.`reltype`, `Relation`.`notes`, `Relation`.`database_id`, `Relation`.`trophic`, `Consumer`.`record_id`, `Consumer`.`lsid`, `Consumer`.`name`, `Consumer`.`taxon`, `Consumer`.`parent_id`, `Consumer`.`database_id`, `Consumer`.`namecode_id`, `Consumer`.`english_name_cnt`, `Consumer`.`longevity_cnt`, `Consumer`.`species_cnt`, `Consumer`.`endanger_cnt`, `Consumer`.`link`, `Consumer`.`invasive_cnt`, `Consumer`.`kingdom`, `Consumer`.`image_cnt`, `Consumer`.`relation_cnt`, `Consumer`.`range_dbid`, `Consumer`.`tphylum`, `Consumer`.`tclass`, `Consumer`.`torder`, `Consumer`.`tfamily`, `Consumer`.`scrutiny_date`, `Consumer`.`specialist_id` FROM `relations` AS `Relation` LEFT JOIN `taxa` AS `Consumer` ON (`Relation`.`consumer_id` = `Consumer`.`namecode_id`) WHERE `Relation`.`provider_id` = 831096 ORDER BY `Consumer`.`name` ASC 771
26SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (829502, 2689842, 696085, 696128, 1000774, 1890255, 949941) 771
27SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (696085, 696128, 829502, 949941, 1000774, 1890255, 2689842) 10101
28SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (696085, 696128, 829502, 949941, 1000774, 1890255, 2689842) 22221
29SELECT `Relation`.`id`, `Relation`.`consumer_id`, `Relation`.`provider_id`, `Relation`.`reltype`, `Relation`.`notes`, `Relation`.`database_id`, `Relation`.`trophic`, `Provider`.`record_id`, `Provider`.`lsid`, `Provider`.`name`, `Provider`.`taxon`, `Provider`.`parent_id`, `Provider`.`database_id`, `Provider`.`namecode_id`, `Provider`.`english_name_cnt`, `Provider`.`longevity_cnt`, `Provider`.`species_cnt`, `Provider`.`endanger_cnt`, `Provider`.`link`, `Provider`.`invasive_cnt`, `Provider`.`kingdom`, `Provider`.`image_cnt`, `Provider`.`relation_cnt`, `Provider`.`range_dbid`, `Provider`.`tphylum`, `Provider`.`tclass`, `Provider`.`torder`, `Provider`.`tfamily`, `Provider`.`scrutiny_date`, `Provider`.`specialist_id` FROM `relations` AS `Relation` LEFT JOIN `taxa` AS `Provider` ON (`Relation`.`provider_id` = `Provider`.`namecode_id`) WHERE `Relation`.`consumer_id` = 831096 ORDER BY `Provider`.`name` ASC 23231
30SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (1148906, 847455, 1268557, 1297156, 867486, 850585, 387849, 857293, 863059, 1122768, 836748, 2175970, 849830, 859165, 859167, 2175908, 844955, 2204460, 769505, 838657, 859115, 850744) 22221
31SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (387849, 769505, 836748, 838657, 844955, 847455, 849830, 850585, 850744, 857293, 859115, 859165, 859167, 863059, 867486, 1122768, 1148906, 1268557, 1297156, 2175908, 2175970, 2204460) 49491
32SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (387849, 769505, 836748, 838657, 844955, 847455, 849830, 850585, 850744, 857293, 859115, 859165, 859167, 863059, 867486, 1122768, 1148906, 1268557, 1297156, 2175908, 2175970, 2204460) 5765762
33SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000016793, 1000017064, 1000030094, 1000008775, 1000008851, 1000009654) 661
34SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 831096 ORDER BY name2232231
35SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 831096 AND do.total > 1 ORDER BY name1021021
36SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 831096 AND do.total > 2 ORDER BY name47471
37SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `Endangered`.`record_id`, `Endangered`.`status`, `Endangered`.`species_id`, `Endangered`.`name`, `Invasive`.`record_id`, `Invasive`.`description`, `Invasive`.`species_id`, `Invasive`.`name` FROM `taxa` AS `Taxa` LEFT JOIN `endangered` AS `Endangered` ON (`Endangered`.`record_id` = `Taxa`.`namecode_id`) LEFT JOIN `invasives` AS `Invasive` ON (`Invasive`.`record_id` = `Taxa`.`namecode_id`) WHERE `Taxa`.`namecode_id` IN (832978, 1456187, 1456527, 825979, 926118, 1943356, 1475113, 835337, 1426791, 951320, 832973, 906394, 1345064, 1474810, 831090, 1459562, 490991, 907353, 490194, 832918, 907617, 1404576, 926071, 1460961, 906393, 949919, 1446719, 1451717, 909352, 833349, 833352, 713321, 151059, 910011, 832929, 1524411, 953123, 1502365, 1518186, 831132, 831143, 833356, 910729, 833459, 911175, 833469, 911190) 47472
38SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (151059, 490194, 490991, 713321, 825979, 831090, 831132, 831143, 832918, 832929, 832973, 832978, 833349, 833352, 833356, 833459, 833469, 835337, 906393, 906394, 907353, 907617, 909352, 910011, 910729, 911175, 911190, 926071, 926118, 949919, 951320, 953123, 1345064, 1404576, 1426791, 1446719, 1451717, 1456187, 1456527, 1459562, 1460961, 1474810, 1475113, 1502365, 1518186, 1524411, 1943356) 50502
39SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (151059, 490194, 490991, 713321, 825979, 831090, 831132, 831143, 832918, 832929, 832973, 832978, 833349, 833352, 833356, 833459, 833469, 835337, 906393, 906394, 907353, 907617, 909352, 910011, 910729, 911175, 911190, 926071, 926118, 949919, 951320, 953123, 1345064, 1404576, 1426791, 1446719, 1451717, 1456187, 1456527, 1459562, 1460961, 1474810, 1475113, 1502365, 1518186, 1524411, 1943356) 2652652
40SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id` FROM `taxa` AS `Taxa` WHERE `Taxa`.`record_id` IN (26922039, 26922040, 26922041, 26922766, 26922768, 26972601) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922041,26922766,26922768,26972601) ASC 662
41SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 114858, 114863, 2356345, 2356452, 111622) 661
42SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 114863, 2356345, 2356452, 111622) 001
43SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
44SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (2478) 111
45SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (1442, 2347, 4670, 1446, 1445, 1026, 1209, 3703, 1029, 1031) 10101
46SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (2258, 1019, 3998) 330
47SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (2262) 110
48SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
49SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1007) 110
50SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110
51SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (2479) 111