Animalia > Arthropoda > Insecta > Diptera > Asilidae > Philonicus > Philonicus albiceps
 

Philonicus albiceps

Synonyms: Asilus canescens; Asilus nudus; Cerdistus marinus; Cerdistus pulcher; Philonicus domesticus; Philonicus orientalis

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Afon Teifi/ River Teifi 1768 Wales, United Kingdom  
Berwickshire and North Northumberland Coast 160731 England/Scotland, United Kingdom  
Braunton Burrows 3328 England, United Kingdom
Carmarthen Bay and Estuaries/ Bae Caerfyrddin ac Aberoedd 163340 Wales, United Kingdom
Carmarthen Bay Dunes/ Twyni Bae Caerfyrddin 2981 Wales, United Kingdom
Clogwyni Pen Llyn/ Seacliffs of Lleyn 2591 Wales, United Kingdom
Coedydd Derw a Safleoedd Ystlumod Meirion/ Meirionnydd Oakwoods and Bat Sites 6953 Wales, United Kingdom
Dawlish Warren 145 England, United Kingdom
Dee Estuary/ Aber Dyfrdwy 39057 England/Wales, United Kingdom
Dorset Heaths (Purbeck and Wareham) and Studland Dunes 5491 England, United Kingdom
Drigg Coast 3453 England, United Kingdom
Dungeness 7966 England, United Kingdom
Fal and Helford 15785 England, United Kingdom    
Firth of Tay & Eden Estuary 38085 Scotland, United Kingdom
Glan-traeth 35 Wales, United Kingdom  
Glannau Môn: Cors heli / Anglesey Coast: Saltmarsh 2614 Wales, United Kingdom  
Gower Ash Woods/ Coedydd Ynn Gwyr 576 Wales, United Kingdom
Gower Commons/ Tiroedd Comin Gwyr 4390 Wales, United Kingdom
Humber Estuary 90582 England, United Kingdom
Isles of Scilly Complex 66350 England, United Kingdom    
Kenfig/ Cynffig 2945 Wales, United Kingdom
Limestone Coast of South West Wales/ Arfordir Calchfaen de Orllewin Cymru 3940 Wales, United Kingdom  
Luce Bay and Sands 120487 Scotland, United Kingdom
Morecambe Bay 151985 England, United Kingdom
Morfa Harlech a Morfa Dyffryn 2626 Wales, United Kingdom
North Norfolk Coast 7926 England, United Kingdom  
North Northumberland Dunes 2836 England, United Kingdom  
Pembrokeshire Bat Sites and Bosherston Lakes/ Safleoedd Ystlum Sir Benfro a Llynnoedd Bosherston 303 Wales, United Kingdom  
Pembrokeshire Marine/ Sir Benfro Forol 341177 Wales, United Kingdom  
Pen Llyn a`r Sarnau/ Lleyn Peninsula and the Sarnau 360832 Wales, United Kingdom
Penhale Dunes 1535 England, United Kingdom    
Saltfleetby–Theddlethorpe Dunes and Gibraltar Point 2373 England, United Kingdom  
Sandwich Bay 2812 England, United Kingdom
Sefton Coast 11278 England, United Kingdom
Solent Maritime 27985 England, United Kingdom
Solway Firth 107829 England/Scotland, United Kingdom
The New Forest 72309 England, United Kingdom
The Wash and North Norfolk Coast 266284 England, United Kingdom
Winterton – Horsey Dunes 1053 England, United Kingdom  
Y Fenai a Bae Conwy/ Menai Strait and Conwy Bay 65440 Wales, United Kingdom  
Y Twyni o Abermenai i Aberffraw/ Abermenai to Aberffraw Dunes 4623 Wales, United Kingdom  

Prey / Diet

Acrotylus insubricus[1]
Aiolopus thalassius <Unverified Name>[1]
Anomala vanenea <Unverified Name>[1]
Anomalia dubia <Unverified Name>[1]
Antipalus varipes <Unverified Name>[1]
Archips xylosteanus <Unverified Name>[1]
Aspistes berolinensis[1]
Athalia glabricollis <Unverified Name>[1]
Athalia rosae <Unverified Name>[1]
Batrachotetrix granulata (Slender Grouse Locust)[1]
Bombylius fulvescens <Unverified Name>[1]
Carpocoris fuscispinus <Unverified Name>[1]
Ceratinostoma ostiorum[1]
Chilosia intonsa <Unverified Name>[1]
Chorthippus bigutulus <Unverified Name>[1]
Chorthippus brunneus (Common Field Grasshopper)[1]
Cicindela hybrida (northern dune tiger beetle)[1]
Coelopa pilipes[1]
Coenosia tigrina[1]
Cynomyia mortuorum <Unverified Name>[1]
Dolerus germanicus <Unverified Name>[1]
Emmelia trabealis <Unverified Name>[1]
Enallagma cyathigerum (Common Blue Damselfly)[1]
Episyrphus balteatus (Marmelade Fly)[1]
Epitriptus cingulatus[1]
Eupeodes corollae[1]
Formica fusca (silky ant)[1]
Formica rufibarbis (Red-barbed ant)[1]
Fucellia maritima <Unverified Name>[1]
Heringia virens <Unverified Name>[1]
Hybomitra ciureai[1]
Hydrotaea dentipes[1]
Lasius fuliginosus[1]
Lasius niger (Black garden ant)[1]
Lathyrophthalmus aenues <Unverified Name>[1]
Lucilia caesar (Greenbottle Blow Fly)[1]
Lucilia sericata (Green blowfly)[1]
Machimus cingulatus <Unverified Name>[1]
Mesembrius peregrinus[1]
Musca domestica (house fly)[1]
Myrmeleotettix maculatus (Mottled Grasshopper)[1]
Neomochtherus pallipes[1]
Neophrotoma scalaris <Unverified Name>[1]
Odontoscelis dorsalis <Unverified Name>[1]
Omocestus haemorrhoidalis[1]
Omocestus rufipes (Woodland Grasshopper)[1]
Orientus ishidae[1]
Orygma luctuosum[1]
Paratettix meridionalis[1]
Phaonia basalis <Unverified Name>[1]
Phaonia errans[1]
Phaonia signata <Unverified Name>[1]
Philonicus albiceps[1]
Podalonia viatica <Unverified Name>[1]
Pollenia rudis (cluster fly)[1]
Polyommatus icarus (Common Blue Butterfly)[1]
Pteronidea pavida <Unverified Name>[1]
Pyrausta sticticalis <Unverified Name>[1]
Rhadiurgus variabilis[1]
Sarcophaga carnaria (Camouflaged Flesh Fly)[1]
Sarcophaga lehmanni[1]
Sarcophaga teretirostris[1]
Scathophaga litorea[1]
Scathophaga merdaria <Unverified Name>[1]
Scathophaga stercoraria (Common Yellow Dung Fly)[1]
Selandria serva <Unverified Name>[1]
Sphaerophoria menthastri[1]
Stenobothrus festivus[1]
Syritta pipiens (thick-legged hoverfly)[1]
Syrphus ribesii (Summer Fly)[1]
Tetanops myopinus <Unverified Name>[1]
Tetrix bolivari[1]
Tetrix depressa[1]
Tetrix tenuicornis (Long-horned Groundhopper)[1]
Thereva annulata <Unverified Name>[1]
Tipula helvola[1]
Tipula orientalis[1]
Tipula paludosa (European crane fly)[1]
Xya variegata (Le Tridactyle panaché)[1]

Predators

Dioctria rufipes[1]
Dysmachus trigonus[1]
Machimus annulipes[1]
Philonicus albiceps[1]
Stenopogon callosus[1]
Trichomachimus paludicola[1]

Distribution

Europe: Asia: Turkey, Iran, Mongolia;

Photos

Citations

Attributes / relations provided by 1Predator-Prey Database for the family Asilidae (Hexapoda: Diptera) Prepared by Dr. Robert Lavigne, Professor Emeritus, University of Wyoming, USA and Dr. Jason Londt (Natal Museum, Pietermaritzburg)
Protected Areas provided by GBIF Global Biodiversity Information Facility
Images provided by Google Image Search
Weather provided by NOAA METAR Data Access
(default) 37 queries took 38 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` = 446912 LIMIT 1112
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (446912) 001
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (446912) 001
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (446912) ORDER BY `Taxalink`.`location` DESC 001
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` = (446912) ORDER BY `Webcam`.`name` ASC 001
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` = (446912) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 29291
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` = 446912 AND `EcoregionTaxa`.`ecoregion_id` = `TaxaEcoregions`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcoregions`.`name` ASC 001
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` = 446912 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` = 446912 AND `EcosysSpecy`.`ecosystem_id` = `TaxaEcosystems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcosystems`.`name` ASC 002
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` = 446912 AND `HotspotTaxa`.`hotspot_id` = `TaxaHotspots`.`id`) WHERE 1 = 1 ORDER BY `TaxaHotspots`.`name` ASC 001
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` = 446912 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` = 446912 AND `BirdareaTaxa`.`birdarea_id` = `TaxaBirdareas`.`id`) WHERE 1 = 1 ORDER BY `TaxaBirdareas`.`name` ASC 001
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` = 8743439 ORDER BY `Taxa`.`name` ASC 001
14SELECT `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` = 446912 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 446912 AND d.group_id = dg.id ORDER BY dg.distribution42423
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 446912 ORDER BY s.name661
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 446912 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language001
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 446912111
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 446912 AND pa.geo_id = g.id ORDER BY pa.name41412
20SELECT `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` = 446912 ORDER BY `Consumer`.`name` ASC 661
21SELECT `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 (445775, 446587, 446698, 446912, 446098, 446990) 662
22SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (445775, 446098, 446587, 446698, 446912, 446990) 001
23SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (445775, 446098, 446587, 446698, 446912, 446990) 001
24SELECT `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` = 446912 ORDER BY `Provider`.`name` ASC 50502
25SELECT `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 (1630788, 2498805, 1633628, 473723, 1629647, 2871052, 518485, 507888, 1611157, 490991, 446599, 491508, 825913, 918125, 434955, 480743, 918229, 918259, 437962, 483726, 492696, 508454, 1629450, 446861, 1628829, 1628839, 2456784, 506180, 1633703, 508391, 446912, 508525, 1401025, 496777, 458637, 458644, 458528, 507515, 507527, 491548, 1628782, 490810, 490162, 1633645, 1633861, 1633627, 138895, 139717, 139764, 2181099) 50501
26SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (138895, 139717, 139764, 434955, 437962, 446599, 446861, 446912, 458528, 458637, 458644, 473723, 480743, 483726, 490162, 490810, 490991, 491508, 491548, 492696, 496777, 506180, 507515, 507527, 507888, 508391, 508454, 508525, 518485, 825913, 918125, 918229, 918259, 1401025, 1611157, 1628782, 1628829, 1628839, 1629450, 1629647, 1630788, 1633627, 1633628, 1633645, 1633703, 1633861, 2181099, 2456784, 2498805, 2871052) 23231
27SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (138895, 139717, 139764, 434955, 437962, 446599, 446861, 446912, 458528, 458637, 458644, 473723, 480743, 483726, 490162, 490810, 490991, 491508, 491548, 492696, 496777, 506180, 507515, 507527, 507888, 508391, 508454, 508525, 518485, 825913, 918125, 918229, 918259, 1401025, 1611157, 1628782, 1628829, 1628839, 1629450, 1629647, 1630788, 1633627, 1633628, 1633645, 1633703, 1633861, 2181099, 2456784, 2498805, 2871052) 441
28SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000006980, 1000006962, 1000006963, 1000006101, 1000006979, 1000006468, 1000006690, 1000006839, 1000006715, 1000006972, 1000006981, 1000006967, 1000006977, 1000006455, 1000006964, 1000006973, 1000006974, 1000006965, 1000006975, 1000006491, 1000006968, 1000006969, 1000006976, 1000006453, 1000006978, 1000006971, 1000004235, 1000006970, 1000006475) 29291
29SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 446912 ORDER BY name000
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` FROM `taxa` AS `Taxa` WHERE `Taxa`.`record_id` IN (26922039, 26922052, 26922219, 26922260, 26927118, 27013457) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922052,26922219,26922260,26927118,27013457) ASC 661
31SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 110076, 112095, 112604, 115866, 2053497) 551
32SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 110076, 112095, 112604, 115866, 2053497) 000
33SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
34SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1028) 111
35SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (3998) 110
36SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
37SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110