Animalia > Arthropoda > Arachnida > Araneae > Thomisidae > Xysticus > Xysticus cristatus
 

Xysticus cristatus (Wandering Crab Spider)

Synonyms: Xysticus augur; Xysticus sexangulatus

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Border Mires, Kielder – Butterburn 29286 England, United Kingdom
Cadair Idris 9353 Wales, United Kingdom
Carmarthen Bay and Estuaries/ Bae Caerfyrddin ac Aberoedd 163340 Wales, United Kingdom
Clogwyni Pen Llyn/ Seacliffs of Lleyn 2591 Wales, United Kingdom
Coed y Cerrig 22 Wales, United Kingdom  
Coedydd Derw a Safleoedd Ystlumod Meirion/ Meirionnydd Oakwoods and Bat Sites 6953 Wales, United Kingdom
Cors Fochno 1613 Wales, United Kingdom
Corsydd Llyn/ Lleyn Fens 701 Wales, United Kingdom
Corsydd Môn/ Anglesey Fens 1154 Wales, United Kingdom  
Crymlyn Bog/ Cors Crymlyn 740 Wales, United Kingdom
Dam Wood 47 Scotland, United Kingdom
Dee Estuary/ Aber Dyfrdwy 39057 England/Wales, United Kingdom
Dorset Heaths 14161 England, United Kingdom
Drigg Coast 3453 England, United Kingdom
Elenydd 21274 Wales, United Kingdom
Eryri/ Snowdonia 48773 Wales, United Kingdom  
Fenland 1529 England, United Kingdom
Fenn`s, Whixall, Bettisfield, Wem and Cadney Mosses 2346 England/Wales, United Kingdom  
Glannau Ynys Gybi/ Holy Island Coast 1147 Wales, United Kingdom  
Gower Commons/ Tiroedd Comin Gwyr 4390 Wales, United Kingdom
Hoy 23474 Scotland, United Kingdom
Lake District High Fells 66717 England, United Kingdom
Limestone Coast of South West Wales/ Arfordir Calchfaen de Orllewin Cymru 3940 Wales, United Kingdom  
Loch Maree Complex 38882 Scotland, United Kingdom
Mendip Limestone Grasslands 1032 England, United Kingdom
Moor House – Upper Teesdale 95867 England, United Kingdom
Moray Firth 373987 Scotland, United Kingdom  
Morecambe Bay 151985 England, United Kingdom
Morecambe Bay Pavements 6449 England, United Kingdom
North Pembrokeshire Woodlands/ Coedydd Gogledd Sir Benfro 780 Wales, United Kingdom  
North Pennine Moors 254789 England, United Kingdom
North West Pembrokeshire Commons/ Comins Gogledd Orllewin Sir Benfro 615 Wales, United Kingdom  
North York Moors 108930 England, United Kingdom
Oak Mere 170 England, United Kingdom
Overstrand Cliffs 74 England, 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
Preseli 6686 Wales, United Kingdom  
Rhinog 7770 Wales, United Kingdom
Rhos Llawr-cwrt 114 Wales, United Kingdom  
Rooksmoor 152 England, United Kingdom
Salisbury Plain 52975 England, United Kingdom
Sefton Coast 11278 England, United Kingdom
Severn Estuary/ Môr Hafren 182155 England/Wales, United Kingdom
Simonside Hills 5146 England, United Kingdom  
South Solway Mosses 4849 England, United Kingdom
South Wight Maritime 49082 England, United Kingdom
St David`s / Ty Ddewi 2312 Wales, United Kingdom  
The Stiperstones and The Hollies 1486 England, United Kingdom  
Thursley, Ash, Pirbright and Chobham 12696 England, United Kingdom
Walton Moss 706 England, United Kingdom  
Witherslack Mosses 1202 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  

Ecosystems

Prey / Diet

Aporia crataegi (Black-veined White Butterfly)[1]
Atolmis rubricollis (Red-necked Footman Moth)[1]
Mesembrina meridiana (Mid-day Fly)[1]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Acrocephalus palustris (Marsh Warbler)1
Amaurobius similis (Lace webbed spider)1
Anthus pratensis (Meadow Pipit)1
Anthus spinoletta (Water Pipit)1
Anthus trivialis (Tree Pipit)1
Apechthis compunctor1
Apus apus (Common Swift)1
Araneus diadematus (Cross garden spider)1
Araneus quadratus (Spider)1
Argiope bruennichi (Bruennich's garden spider)1
Certhia familiaris (Eurasian Treecreeper)1
Coloeus monedula (Western Jackdaw)1
Corvus corone (Carrion Crow)1
Cyanistes caeruleus (Blue Tit)1
Delichon urbicum (Common house-martin and northern house-martin)1
Diphyus palliatorius1
Emberiza citrinella (Yellowhammer)1
Emberiza schoeniclus (Reed Bunting)1
Ficedula hypoleuca (European Pied Flycatcher)1
Fringilla coelebs (Common Chaffinch)1
Haplodrassus dalmatensis1
Hirundo rustica (Barn Swallow)1
Lanius collurio (Red-backed Shrike)1
Larinioides cornutus (Furrow Orbweaver)1
Locustella naevia (Common Grasshopper Warbler)1
Lophophanes cristatus (European Crested Tit)1
Motacilla flava (Western Yellow Wagtail)1
Muscicapa striata (Spotted Flycatcher)1
Oenanthe oenanthe (Northern Wheatear)1
Parus major (Great Tit)1
Passer montanus (Eurasian Tree Sparrow)1
Phoenicurus ochruros (Black Redstart)1
Phoenicurus phoenicurus (Common Redstart)1
Pholcus phalangioides (Long-bodied cellar spider)1
Phylloscopus collybita (Common Chiffchaff)1
Phylloscopus sibillatrix (Wood Warbler)1
Phylloscopus trochilus (Willow Warbler)1
Pisaura mirabilis (Tent Spider)1
Prunella modularis (Dunnock)1
Pyrrhula pyrrhula (Eurasian Bullfinch)1
Rana temporaria (European frog)1
Sitta europaea (Eurasian Nuthatch)1
Sylvia atricapilla (Eurasian Blackcap)1
Sylvia borin (Garden Warbler)1
Trachyzelotes pedestris1
Troglodytes troglodytes (Winter Wren)1
Turdus torquatus (Ring Ouzel)1
Turdus viscivorus (Mistle Thrush)1
Vanellus vanellus (Northern Lapwing)1
Vespa crabro (European hornet)1
Xysticus erraticus1
Zelotes latreillei1

Distribution

Palearctic;

Photos

Citations

Attributes / relations provided by 1Ecology of Commanster
Protected Areas provided by GBIF Global Biodiversity Information Facility
Images provided by Google Image Search
Weather provided by NOAA METAR Data Access
(default) 36 queries took 46 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` = 93765 LIMIT 1112
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (93765) 111
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (93765) 001
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (93765) 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` = (93765) 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` = (93765) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 001
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` = 93765 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` = 93765 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` = 93765 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` = 93765 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` = 93765 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` = 93765 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` = 26200139 ORDER BY `Taxa`.`name` ASC 002
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` = 93765 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 002
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 93765 AND d.group_id = dg.id ORDER BY dg.distribution55554
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 93765 ORDER BY s.name221
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 93765 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 = 93765111
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 93765 AND pa.geo_id = g.id ORDER BY pa.name54543
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` = 93765 ORDER BY `Consumer`.`name` ASC 002
21SELECT `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` = 93765 ORDER BY `Provider`.`name` ASC 331
22SELECT `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 (712540, 1498678, 432107) 331
23SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (432107, 712540, 1498678) 331
24SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (432107, 712540, 1498678) 001
25SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 93765 ORDER BY name52521
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 (905738, 84915, 832300, 832291, 832303, 2244710, 831909, 77397, 77701, 77908, 832567, 833451, 906865, 906987, 1000577, 2243354, 833285, 833291, 907477, 832918, 89384, 832253, 908150, 78831, 908277, 908313, 832286, 908713, 833516, 909352, 833352, 909533, 909534, 66576, 909630, 833543, 833537, 82130, 910011, 832929, 828372, 910554, 910729, 910731, 90062, 832339, 911188, 911190, 830530, 1912933, 93788, 90282) 52522
27SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (66576, 77397, 77701, 77908, 78831, 82130, 84915, 89384, 90062, 90282, 93788, 828372, 830530, 831909, 832253, 832286, 832291, 832300, 832303, 832339, 832567, 832918, 832929, 833285, 833291, 833352, 833451, 833516, 833537, 833543, 905738, 906865, 906987, 907477, 908150, 908277, 908313, 908713, 909352, 909533, 909534, 909630, 910011, 910554, 910729, 910731, 911188, 911190, 1000577, 1912933, 2243354, 2244710) 53532
28SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (66576, 77397, 77701, 77908, 78831, 82130, 84915, 89384, 90062, 90282, 93788, 828372, 830530, 831909, 832253, 832286, 832291, 832300, 832303, 832339, 832567, 832918, 832929, 833285, 833291, 833352, 833451, 833516, 833537, 833543, 905738, 906865, 906987, 907477, 908150, 908277, 908313, 908713, 909352, 909533, 909534, 909630, 910011, 910554, 910729, 910731, 911188, 911190, 1000577, 1912933, 2243354, 2244710) 3553553
29SELECT `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, 26922107, 26922108, 26922111, 27048000) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922052,26922107,26922108,26922111,27048000) ASC 662
30SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 110076, 110082, 110089, 110102, 2021347) 661
31SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 110076, 110082, 110089, 110102, 2021347) 001
32SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
33SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1026) 111
34SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (3998) 110
35SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
36SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110