Animalia > Chordata > Reptilia > Squamata > Varanidae > Varanus > Varanus gouldii
 

Varanus gouldii (Sand Monitor, Gould's Goanna; Sand monitor)

Wikipedia Abstract

The sand goanna (Varanus gouldii ) is a species of large Australian monitor lizard, also known as Gould's monitor, the sand monitor, or racehorse goanna.In some Aboriginal languages, the sand goanna is called bungarra, a term commonly used by nonaboriginal people in Western Australia, too.The name "sand monitor" can be used to describe various other species.
View Wikipedia Record: Varanus gouldii

Infraspecies

Varanus gouldii flavirufus (Sand monitor)
Varanus gouldii gouldii (Gould's monitor)

Attributes

Adult Weight [1]  1.81 lbs (821 g)
Litter Size [2]  6
Maximum Longevity [3]  18 years

Ecoregions

Name Countries Ecozone Biome Species Report Climate Land
Use
Arnhem Land tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Brigalow tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Cape York Peninsula tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Carnarvon xeric shrublands Australia Australasia Deserts and Xeric Shrublands
Carpentaria tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Central Ranges xeric scrub Australia Australasia Deserts and Xeric Shrublands
Coolgardie woodlands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Eastern Australia mulga shrublands Australia Australasia Temperate Grasslands, Savannas, and Shrublands
Eastern Australian temperate forests Australia Australasia Temperate Broadleaf and Mixed Forests
Einasleigh upland savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Esperance mallee Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Eyre and York mallee Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Gibson desert Australia Australasia Deserts and Xeric Shrublands
Great Sandy-Tanami desert Australia Australasia Deserts and Xeric Shrublands
Great Victoria desert Australia Australasia Deserts and Xeric Shrublands
Jarrah-Karri forest and shrublands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Kimberly tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Mitchell grass downs Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Mount Lofty woodlands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Murray-Darling woodlands and mallee Australia Australasia Mediterranean Forests, Woodlands, and Scrub  
Naracoorte woodlands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Nullarbor Plains xeric shrublands Australia Australasia Deserts and Xeric Shrublands
Pilbara shrublands Australia Australasia Deserts and Xeric Shrublands
Queensland tropical rain forests Australia Australasia Tropical and Subtropical Moist Broadleaf Forests  
Simpson desert Australia Australasia Deserts and Xeric Shrublands
Southeast Australia temperate forests Australia Australasia Temperate Broadleaf and Mixed Forests
Southeast Australia temperate savanna Australia Australasia Temperate Grasslands, Savannas, and Shrublands
Southwest Australia savanna Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Southwest Australia woodlands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Swan Coastal Plain Scrub and Woodlands Australia Australasia Mediterranean Forests, Woodlands, and Scrub
Tirari-Sturt stony desert Australia Australasia Deserts and Xeric Shrublands
Victoria Plains tropical savanna Australia Australasia Tropical and Subtropical Grasslands, Savannas, and Shrublands
Western Australian Mulga shrublands Australia Australasia Deserts and Xeric Shrublands

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Coorong National Park II 121235 South Australia, Australia
Girraween National Park II 28978 Queensland, Australia
Hattah-Kulkyne NP and Murray-Kulkyne Park National Park II 122831 Victoria, Australia
Kakadu National Park II 4744348 Northern Territory, Australia
Prince Regent River Nature Reserve Ia 1428602 Western Australia, Australia  
Purnululu National Park II 604999 Western Australia, Australia
Riverland Biosphere Reserve Ia 1490891 South Australia, Australia
Shoalwater and Corio Bays Area Ramsar Site   Queensland, Australia
Uluru - Kata Tjuta National Park II 332429 Northern Territory, Australia
Yathong Nature Reserve Ia 270264 New South Wales, Australia

Ecosystems

Biodiversity Hotspots

Name Location Endemic Species Website
Southwest Australia Australia No

Prey / Diet

Ctenophorus isolepis (Military Sand-dragon, Military Dragon)[2]
Ctenophorus nuchalis (Central Netted Ground-dragon, Central Netted Dragon)[2]
Ctenotus ariadnae (Ariadna's Ctenotus)[2]
Ctenotus atlas (Porcupine Grass Ctenotus)[2]
Ctenotus colletti (Collett's skink)[2]
Ctenotus grandis (Grand ctenotus)[2]
Ctenotus helenae (Helena's Ctenotus)[2]
Ctenotus leonhardii (Leonhard's Ctenotus)[2]
Ctenotus quattuordecimlineatus (14-lined Ctenotus)[2]
Ctenotus schomburgkii (Variable Ctenotus)[2]
Diplodactylus conspicillatus (Burrow-plug Gecko, Fat-tailed Gecko)[2]
Diplodactylus pulcher (Fine-faced Gecko)[2]
Lerista bipes (North-western Sandslider)[2]
Lerista muelleri (Müller's Lerista)[2]
Lialis burtonis (Burton's Snake-lizard, Burton's Legless Lizard)[2]
Lucasium stenodactylum (Pale-snouted Ground Gecko, Crowned Gecko)[2]
Menetia greyii (Common Dwarf Skink)[2]
Moloch horridus (Thorny Devil, Mountain Devil)[2]
Nephrurus laevissimus (Spinifex knob-tailed gecko)[2]
Pogona minor (Western Bearded Dragon, Dwarf Bearded Dragon)[2]
Rhynchoedura ornata (Beaked Gecko)[2]
Varanus brevicauda (Short-tailed Pygmy Monitor)[2]
Varanus caudolineatus (Line-tailed Pygmy Monitor)[2]
Varanus gilleni (Pygmy Mulga Monitor)[2]
Varanus gouldii (Sand Monitor, Gould's Goanna)[2]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Cryptophis boschmai (Carpentaria whip snake)1
Ctenotus grandis (Grand ctenotus)1
Parasuta flagellum (Whip Hooded Snake, Little Whip Snake)1
Parasuta gouldii (Gould's Hooded Snake, Black-headed Snake)4
Parasuta monachus (Monk Snake, Hooded Snake)4
Parasuta nigriceps (Mallee Black-backed Snake)2
Parasuta spectabilis spectabilis (Spectacled Hooded Snake, Bush’s Hooded Snake)2
Simoselaps bertholdi (Southern Desert Banded Snake, Desert Banded Snake)1
Suta suta (Curl Snake, Myal Snake)6
Varanus caudolineatus (Line-tailed Pygmy Monitor)1
Varanus eremius (Rusty Desert Monitor)6
Varanus tristis orientalis (Black-tailed Monitor, Black-headed Monitor)8

Predators

Varanus giganteus (Perentie)[2]
Varanus gouldii (Sand Monitor, Gould's Goanna)[2]

Consumers

Parasitized by 
Abbreviata antarctica <Unverified Name>[4]
Abbreviata confusa <Unverified Name>[4]
Abbreviata hastaspicula <Unverified Name>[4]
Abbreviata levicauda <Unverified Name>[4]
Abbreviata tumidocapitis <Unverified Name>[4]
Abbreviata varani <Unverified Name>[4]
Bothridium parvum <Unverified Name>[5]
Haemogregarina breinli <Unverified Name>[5]
Haemogregarina gouldii <Unverified Name>[5]
Haemogregarina johnstoni <Unverified Name>[5]
Haemogregarina varanicola <Unverified Name>[5]
Hastospiculum gouldi <Unverified Name>[4]
Herpetostrongylus varani <Unverified Name>[4]
Kapsulotaenia tidswelli <Unverified Name>[4]
Kapsulotaenia varia <Unverified Name>[4]
Neopolystoma chelodinae <Unverified Name>[4]
Ophidascaris robertsi <Unverified Name>[5]
Raillietascaris varani <Unverified Name>[4]
Skrjabinoptera goldmanae <Unverified Name>[4]
Tanqua tiara <Unverified Name>[4]
Terranova crocodili <Unverified Name>[4]
Wanaristrongylus ctenoti <Unverified Name>[4]

Distribution

Australia (except arid interior), S New Guinea flavirufus: Central Australia in the area of the red soils; westwards to the Canning Stock Route (Western Australia); Terra typica: Bat Caves near Alice Springs, Northern Territory. Terra typica: "Australia;

Photos

Citations

Attributes / relations provided by 1Length–weight allometries in lizards, S. Meiri, Journal of Zoology 281 (2010) 218–226 2Comparative ecology of Varanus in the Great Victoria Desert, Eric R. Pianka, Australian Journal of Ecology (1994) 19, 395-408 3de 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 4Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London 5Species Interactions of Australia Database, Atlas of Living Australia, Version ala-csv-2012-11-19
Ecoregions provided by World Wide Fund For Nature (WWF). WildFinder: Online database of species distributions, ver. 01.06 WWF WildFINDER
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
(default) 45 queries took 3405 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` = 1703835 LIMIT 1111
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (1703835) 221
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (1703835) 331
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (1703835) 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` = (1703835) 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` = (1703835) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 22221
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` = 1703835 AND `EcoregionTaxa`.`ecoregion_id` = `TaxaEcoregions`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcoregions`.`name` ASC 33332
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` = 1703835 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` = 1703835 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` = 1703835 AND `HotspotTaxa`.`hotspot_id` = `TaxaHotspots`.`id`) WHERE 1 = 1 ORDER BY `TaxaHotspots`.`name` ASC 111
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` = 1703835 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` = 1703835 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` = 13210181 ORDER BY `Taxa`.`name` ASC 221
14SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (1696620, 1696619) 221
15SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (1696620, 1696619) 001
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` = 1703835 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
17SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 1703835 AND d.group_id = dg.id ORDER BY dg.distribution45453
18SELECT s.name FROM synonyms s WHERE s.namecode_id = 1703835 ORDER BY s.name001
19SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 1703835 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 = 1703835113361
21SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 1703835 AND pa.geo_id = g.id ORDER BY pa.name10101
22SELECT 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 ('AA0701','AA0702','AA0703','AA1301','AA0704','AA1302','AA1201','AA0802','AA0402','AA0705','AA1202','AA1203','AA1303','AA1304','AA1305','AA1204','AA0706','AA0707','AA1206','AA1207','AA1208','AA1306','AA1307','AA0117','AA1308','AA0409','AA0803','AA1209','AA1210','AA1205','AA1309','AA0709','AA1310')33331
23SELECT `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` = 1703835 ORDER BY `Consumer`.`name` ASC 222
24SELECT `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 (1703831, 1703835) 221
25SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (1703831, 1703835) 331
26SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (1703831, 1703835) 551
27SELECT `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` = 1703835 ORDER BY `Provider`.`name` ASC 25252
28SELECT `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 (1697520, 1697524, 1697559, 1697563, 1697574, 1697586, 1697591, 1697603, 1697618, 1697630, 1697946, 1697967, 1699821, 1699865, 1699902, 1697974, 1700615, 1700766, 1700869, 1701760, 1702390, 1703820, 1703822, 1703832, 1703835) 25251
29SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (1697520, 1697524, 1697559, 1697563, 1697574, 1697586, 1697591, 1697603, 1697618, 1697630, 1697946, 1697967, 1697974, 1699821, 1699865, 1699902, 1700615, 1700766, 1700869, 1701760, 1702390, 1703820, 1703822, 1703832, 1703835) 34341
30SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (1697520, 1697524, 1697559, 1697563, 1697574, 1697586, 1697591, 1697603, 1697618, 1697630, 1697946, 1697967, 1697974, 1699821, 1699865, 1699902, 1700615, 1700766, 1700869, 1701760, 1702390, 1703820, 1703822, 1703832, 1703835) 35351
31SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000016102, 1000016109, 1000016113, 1000016118, 1000016128, 1000016130, 1000008478, 1000041594, 1000041603, 1000041607, 1000041615, 1000018690, 1000018809, 1000010068, 1000010069, 1000014979, 1000019841, 1000020909, 1000021410, 1000022033, 1000022053, 1000022568) 22221
32SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 1703835 ORDER BY name12121
33SELECT `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 (1702344, 1697586, 1703042, 1703043, 1703044, 1703045, 1703048, 1702662, 1703049, 1703822, 1703826, 1696643) 12122
34SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (1696643, 1697586, 1702344, 1702662, 1703042, 1703043, 1703044, 1703045, 1703048, 1703049, 1703822, 1703826) 13131
35SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (1696643, 1697586, 1702344, 1702662, 1703042, 1703043, 1703044, 1703045, 1703048, 1703049, 1703822, 1703826) 17171
36SELECT `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, 26922233, 26922234, 26923755, 26972806) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922233,26922234,26923755,26972806) ASC 661
37SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 114858, 115699, 110526, 111695, 111245) 661
38SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 115699, 110526, 111695, 111245) 001
39SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
40SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (2413, 2336, 1442, 1029, 3951) 551
41SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1019) 110
42SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (2262) 110
43SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
44SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1007) 110
45SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110