Animalia > Chordata > Actinopterygii > Perciformes > Nototheniidae > Trematomus > Trematomus newnesi
 

Trematomus newnesi (Dusky notothen; Dusky rockcod)

Language: French; Mandarin Chinese; Russian; Spanish

Prey / Diet

Bovallia gigantea[1]
Cheirimedon fougneri[2]
Chorismus antarcticus[3]
Djerboa furcipes[1]
Euphausia crystallorophias (ice krill)[4]
Hyperiella dilatata[2]
Hyperiella macronyx[2]
Notocrangon antarcticus[3]
Oradarea bidentata[1]
Paradexamine fissicauda[1]
Pleuragramma antarctica (Antarctic silverfish)[4]
Prostebbingia brevicornis[1]
Prostebbingia gracilis[1]
Trematomus newnesi (Dusky notothen)[2]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Arctocephalus gazella (Antarctic Fur Seal)1
Balaenoptera bonaerensis (Antarctic Minke Whale)2
Chaenocephalus aceratus (Scotian icefish)1
Chaenodraco wilsoni (Spiny icefish)2
Chionodraco hamatus (Crocodile icefish)1
Chionodraco myersi (Myers' icefish)2
Cryodraco antarcticus (Long-fingered icefish)1
Cygnodraco mawsoni (Mawson's dragonfish)2
Dacodraco hunteri (Crocodile icefish)1
Dissostichus mawsoni (Antarctic blenny)1
Gobionotothen gibberifrons (Humped rockcod)3
Gvozdarus svetovidovi (Naked-head toothfish)1
Gymnodraco acuticeps (Ploughfish)2
Harpagifer bispinis (Magellanic spiny plunderfish)2
Leptonychotes weddellii (Weddell Seal)1
Lindbergichthys nudifrons (Yellowfin notie)2
Lobodon carcinophaga (Crabeater Seal)1
Neopagetopsis ionah (Jonah's icefish)1
Pagothenia borchgrevinki (Bald notothen)2
Parachaenichthys georgianus (Antarctic dragonfish)1
Trematomus bernacchii (Emerald notothen)1
Trematomus hansoni (Striped rockcod)2
Trematomus loennbergii (Deepwater notothen)2

Predators

Aptenodytes forsteri (Emperor Penguin)[5]
Leucocarbo atriceps bransfieldensis (Antarctic shag)[6]
Pygoscelis adeliae (Adelie Penguin)[7]
Trematomus newnesi (Dusky notothen)[2]

Consumers

Parasitized by 
Anisakis simplex[8]
Aspersentis megarhynchus[8]
Contracaecum osculatum[8]
Contracaecum radiatum <Unverified Name>[8]
Corynosoma bullosum[8]
Corynosoma hamanni[8]
Corynosoma pseudohamanni[8]
Diphyllobothrium plerocercoid <Unverified Name>[8]
Elytrophalloides oatesi[8]
Genolinea bowersi[8]
Lepidapedon garrardi[8]
Macvicaria georgiana[8]
Macvicaria pennelli[8]
Metacanthocephalus dalmori[8]
Metacanthocephalus johnstoni[8]
Neolebouria antarctica[8]
Neolebouria terranovaensis[8]
Neolepidapedon macquariensis[8]
Onchobothrium antarcticum[8]
Pseudobenedenia nototheniae[8]
Pseudobenedenoides shorti <Unverified Name>[8]
Scolex pleuronectis <Unverified Name>[8]

Distribution

Antarctic; Atlantic Ocean; Atlantic, Antarctic; Elephant Island; Indian Ocean; Indian Ocean, Antarctic; Pacific Ocean; Pacific, Antarctic; Scotia Sea; South Orkney Islands; South Shetland Islands; Southern Ocean: East Antarctic, Weddell Sea, West coast of Antarctic Peninsula, South Shetland Islands, Elephant Island, South Orkney Islands, Mac Robertson, George V, Queen Mary, Adelie Coasts, Davis Sea and Ross Sea.;

Photos

Citations

Attributes / relations provided by 1THE DIETARY COMPOSITION OF SOME ANTARCTIC FISH, MICHAEL G. RICHARDSON, Br. Antarct. Surv. Bull., Nos. 41 & 42, 1975, p. 113-120 2Vacchi M, La Mesa M (1995) The diet of the Antarctic fish Trematomus newnesi Boulenger 1902(Nototheniidae) from Terra Nova Bay, Ross Sea Antarctic Science 7 (1):37-38 3A balanced model of the food web of the Ross Sea, Antarctica, M.H. Pinkerton, S.M. Hanchet, J. Bradford-Grieve, CCAMLR Science, Vol. 17 (2010) 4The role of notothenioid fish in the food web of the Ross Sea shelf waters: a review, M. La Mesa, J. T. Eastman, M. Vacchi, Polar Biol (2004) 27: 321–338 5Food of emperor penguins (Aptenodytes forsteri) in the western Ross Sea, Antarctica, Y. Cherel and G. L. Kooyman, Marine Biology (1998) 130: 335-344 6On the accuracy of the pellet analysis method to estimate the food intake in the Antarctic shag, Phalacrocorax bransfieldensis, Ricardo J. CASAUX, Folia Zool. – 52(2): 167–176 (2003) 7DIET OF ADE&#769;LIE PENGUINS PYGOSCELIS ADELIAE AT SHIRLEY ISLAND, EAST ANTARCTICA, JANUARY 1992, SHARON KENT, JULIAN SEDDON, GRAHAM ROBERTSON & BARBARA C. WIENECKE, Marine Ornithology 26, pp. 7-10 (1998) 8Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London
Images provided by Google Image Search
Weather provided by NOAA METAR Data Access
(default) 38 queries took 24 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` = 669170 LIMIT 1111
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (669170) 221
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (669170) 000
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (669170) 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` = (669170) 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` = (669170) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 12121
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` = 669170 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` = 669170 AND `Emblem`.`political_id` = `TaxaEmblems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEmblems`.`name` ASC 000
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` = 669170 AND `EcosysSpecy`.`ecosystem_id` = `TaxaEcosystems`.`id`) WHERE 1 = 1 ORDER BY `TaxaEcosystems`.`name` ASC 001
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` = 669170 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` = 669170 AND `AzeTaxa`.`azesite_id` = `TaxaAzesites`.`id`) WHERE 1 = 1 ORDER BY `TaxaAzesites`.`name` ASC 000
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` = 669170 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` = 26855934 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` = 669170 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 669170 AND d.group_id = dg.id ORDER BY dg.distribution12121
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 669170 ORDER BY s.name000
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 669170 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language881
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 669170110
19SELECT `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` = 669170 ORDER BY `Consumer`.`name` ASC 22221
20SELECT `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 (2299758, 828752, 841649, 954671, 842310, 842326, 3095363, 2582815, 2644053, 2574534, 909457, 2616825, 2501667, 3095366, 3095367, 2644054, 2586252, 2512347, 2669004, 2504571, 828749, 669170) 22221
21SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (669170, 828749, 828752, 841649, 842310, 842326, 909457, 954671, 2299758, 2501667, 2504571, 2512347, 2574534, 2582815, 2586252, 2616825, 2644053, 2644054, 2669004, 3095363, 3095366, 3095367) 551
22SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (669170, 828749, 828752, 841649, 842310, 842326, 909457, 954671, 2299758, 2501667, 2504571, 2512347, 2574534, 2582815, 2586252, 2616825, 2644053, 2644054, 2669004, 3095363, 3095366, 3095367) 27271
23SELECT `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` = 669170 ORDER BY `Provider`.`name` ASC 661
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 (959701, 1924154, 1060467, 1060468, 2492936, 669170) 661
25SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (669170, 959701, 1060467, 1060468, 1924154, 2492936) 551
26SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (669170, 959701, 1060467, 1060468, 1924154, 2492936) 220
27SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000007373, 1000039242, 1000040732, 1000040015, 1000040729, 1000040734, 1000007466, 1000040733, 1000017528, 1000009099, 1000015466, 1000011488) 12120
28SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 669170 ORDER BY name23230
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`, `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 (834100, 948594, 659263, 666081, 662883, 669216, 669217, 669207, 669218, 669163, 662862, 669164, 669209, 662956, 834127, 662867, 950026, 669219, 662869, 669210, 669165, 669168, 669169) 23231
30SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (659263, 662862, 662867, 662869, 662883, 662956, 666081, 669163, 669164, 669165, 669168, 669169, 669207, 669209, 669210, 669216, 669217, 669218, 669219, 834100, 834127, 948594, 950026) 35351
31SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (659263, 662862, 662867, 662869, 662883, 662956, 666081, 669163, 669164, 669165, 669168, 669169, 669207, 669209, 669210, 669216, 669217, 669218, 669219, 834100, 834127, 948594, 950026) 39391
32SELECT `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, 26922057, 26924196, 26925911, 26959894) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922057,26924196,26925911,26959894) ASC 661
33SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (109518, 114858, 111274, 113097, 113145, 2020778) 661
34SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 111274, 113097, 113145, 2020778) 000
35SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
36SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (3937, 3287, 4090, 2335, 1392, 4050, 1885, 1029) 881
37SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
38SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110