Animalia > Chordata > Actinopterygii > Perciformes > Trichiuridae > Trichiurus > Trichiurus lepturus
 

Trichiurus lepturus (Atlantic Cutlassfish; Australian hairtail; Common hairtail; Cutlass fish; Cutlassfish; Grey ribbon fish; Hair tail; Hairtail; Large headed hairtail; Largehead hairtail; Large-head ribbonfish; Largeheaded ribbonfish; Pacific cutlassfish; Ribbon fish; Silverfish; Ribbonfish; Large-headed ribbonfish)

Synonyms: Clupea haumela; Trachiurus lepturus; Trichiuris haumela; Trichiurus argenteus; Trichiurus japanicus; Trichiurus japonicus; Trichiurus lajor; Trichiurus lepturus japonicus; Trichiurus malabaricus; Trichiurus nitens; Trichurus lepturus; Trichyurus lepturus
Language: Afrikaans; Albanian; Arabic; Banton; Bengali; Bikol; Bolinao; Burmese; Cantonese; Catalan; Cebuano; Chavacano; Croatian; Danish; Davawenyo; Fijian; Finnish; French; Gen-Gbe; German; Greek; Gujarati; Hiligaynon; Ilokano; Italian; Japanese; Javanese; Kagayanen; Kannada; Kapampangan; Korean; Kuyunon; Makassarese; Malay; Malayalam; Maltese; Mandarin Chinese; Maranao/Samal/Tao Sug; Marathi; Norwegian; Oriya; Other; Pangasinan; Persian; Polish; Portuguese; Romanian; Russian; Serbian; Serer; Somali; Spanish; Susu; Swahili; Swedish; Tagalog; Tamil; Telugu; Turkish; Unknown; Vietnamese; Vili; Visayan; Waray-waray; Wolof

Wikipedia Abstract

The largehead hairtail (also beltfish), Trichiurus lepturus, is a member of the cutlassfish family, Trichiuridae. It is a long, slender fish found throughout the tropical and temperate oceans of the world. The Atlantic, East Pacific and Northwest Pacific populations are also known as Atlantic cutlassfish, Pacific cutlassfish and Japanese cutlassfish, respectively.Largehead hairtails can grow to 2.34 m (7.7 ft) in length, although most only are 1 m (3.3 ft).
View Wikipedia Record: Trichiurus lepturus

Attributes

Adult Weight [1]  6.06 lbs (2.75 kg)
Maximum Longevity [3]  15 years
Migration [2]  Amphidromous

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Archipelago de Colon Biosphere Reserve 34336011 Galapagos Islands, Ecuador  
Everglades and Dry Tortugas Biosphere Reserve   Florida, United States  
Reserva de la Biosfera de Sian Ka'an Biosphere Reserve VI 1312618 Mexico  
Shoalwater and Corio Bays Area Ramsar Site   Queensland, Australia
Sunderban National Park 261613 India  
Tsitsikamma National Park II 34343 Southern Cape, South Africa  
Ujung Kulon National Park II 313466 Java, Indonesia    

Prey / Diet

Abralia andamanica[4]
Acanthopagrus latus (Yellow-finned black porgy)[4]
Acetes americanus (aviu shrimp)[5]
Acetes chinensis (northern mauxia shrimp)[6]
Acropoma japonicum (Blackmouth splitfin)[4]
Alepes kleinii (Sharp-bellied scad)[4]
Ammodytes personatus (Pacific sandlance)[6]
Anchoa hepsetus (Broad-striped anchovy)[7]
Brachydeuterus auritus (burrito)[8]
Bregmaceros nectabanus (Australian codlet)[4]
Bregmaceros rarisquamosus (Bigeye codlet)[4]
Calanus sinicus[6]
Decapterus maruadsi (White-tipped mackerel scad)[6]
Doryteuthis pealeii (longfin inshore squid)[7]
Encrasicholina heteroloba (Shorthead anchovy)[4]
Engraulis japonicus (Japanese anchovy)[6]
Equulites lineolatus (lined ponyfish)[4]
Ethmalosa fimbriata (Bonga shad)[8]
Euphausia pacifica (Pacific krill)[6]
Euprymna berryi (humming-bird bobtail squid)[4]
Gilvossius setimanus[5]
Harengula clupeola (Sardine)[7]
Harengula jaguana (Guiana harring)[7]
Illex argentinus (Argentine Shortfin Squid)[9]
Jaydia lineata (Cardinal fish)[6]
Johnius belangerii (River perch)[6]
Latreutes anoplonyx (medusa shrimp)[6]
Leptochela gracilis (lesser glass shrimp)[6]
Oratosquilla oratoria[4]
Palaemon gravieri (Chinese ditch prawn)[6]
Pristipomoides aquilonaris (Wenchman)[7]
Pseudeuphausia latifrons[6]
Sardinella jussieu (Mauritian sardinella)[4]
Sardinella maderensis (Madeiran sardinella)[8]
Sarotherodon melanotheron (blackchin tilapia)[8]
Stolephorus commersonnii (Commerson's anchovy)[4]
Thryssa dussumieri (Long anchovy)[4]
Thryssa hamiltonii (Northern anchovy)[4]
Thryssa setirostris (Orangemouth thryssa)[4]
Trichiurus lepturus (Atlantic Cutlassfish)[6]
Upeneus parvus (Goatfish)[7]
Uroteuthis chinensis[4]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Acropoma japonicum (Blackmouth splitfin)2
Argyrosomus hololepidotus (Southern meagre)2
Caranx hippos (Yellow cavalli)4
Caranx ruber (Bar jack)2
Carcharhinus plumbeus (Thickskin shark)2
Ceryle rudis (Pied Kingfisher)2
Chirocentrus nudus (smooth wolf herring)2
Citharichthys stampflii (Smooth flounder)2
Cleisthenes herzensteini (pointhead flounder)2
Cynoglossus joyneri (Red tongue sole)2
Cynoglossus senegalensis (large tonguesole)2
Cynoscion arenarius (Sand seatrout)3
Cynoscion nothus (Silver weakfish)2
Eleotris senegalensis (Sleeper goby)3
Elops lacerta (Atlantic ladyfish)3
Eucinostomus melanopterus (Flagfin mojarra)2
Globicephala melas (Long-finned Pilot Whale)2
Hemichromis fasciatus (Banded jewelfish)2
Hepsetus odoe (Pike characid)2
Isurus oxyrinchus (Short-finned mako)2
Larimichthys polyactis (Yellowfish)3
Lophius litulon (Anglerfish)2
Paralichthys olivaceus (Olive flounder)2
Pellonula leonensis (Guinean sprat)2
Polydactylus quadrifilis (Threadfin)3
Pomadasys jubelini (burro)2
Pomatomus saltatrix (Tailor run)3
Pseudotolithus elongatus (Niger corb)3
Pseudotolithus senegalensis (Ladyfish)3
Schilbe intermedius (Butter catfish)4
Scomberomorus cavalla (Spanish mackerel)3
Scomberomorus niphonius (Spotted Spanish mackerel)2
Sphyraena afra (Guinean barracuda)4
Sphyraena guachancho (Sockeye)2
Squatina dumeril (Atlantic angelshark)2
Strongylura senegalensis (Senegal needlefish)3
Synodus foetens (Soapfish)5
Trachinotus teraia (Shortfin pompano)2
Trichiurus margarites (hairtail)13
Zeus faber (European john dory)2

Predators

Acanthocybium solandri (Wahoo fish)[10]
Cynoscion guatucupa (Stripped weakfish)[11]
Cynoscion nothus (Silver weakfish)[7]
Delphinus capensis (Long-beaked Common Dolphin)[12]
Harpadon nehereus (Bombay duck)[13]
Istiophorus platypterus (Atlantic sailfish)[14]
Katsuwonus pelamis (White bonito)[15]
Lutjanus synagris (Walliacke)[16]
Macrodon ancylodon (Yellow mouth salmon)[17]
Muraenesox cinereus (Dagger-tooth pike-conger)[18]
Rhizoprionodon acutus (Yellow dog shark)[19]
Rhizoprionodon lalandii (Sharpnose shark)[20]
Scomberomorus niphonius (Spotted Spanish mackerel)[21]
Scomberomorus sierra (Mexican sierra)[22]
Selene peruviana (Jack)[22]
Sotalia fluviatilis (Tucuxi)[23]
Sotalia guianensis (costero)[24]
Stenella attenuata (Pantropical Spotted Dolphin)[25]
Synodus foetens (Soapfish)[26]
Terapon jarbua (Tiger-perch)[27]
Trichiurus lepturus (Atlantic Cutlassfish)[6]
Trichiurus margarites (hairtail)[4]
Tursiops truncatus (Bottlenosed Dolphin)[12]
Zeus faber (European john dory)[28]

Consumers

Parasitized by 
Amplicaecum singhi <Unverified Name>[29]
Angusticaecum singhi <Unverified Name>[29]
Anisakis simplex[29]
Aponurus megaloporus <Unverified Name>[29]
Bolbosoma scomberomori[29]
Bucephalopsis scombropsis <Unverified Name>[29]
Callitetrarhynchus gracilis[29]
Callitetrarhynchus speciosus[29]
Camallanus carangis <Unverified Name>[29]
Camallanus dollfusi <Unverified Name>[29]
Camallanus marinus <Unverified Name>[29]
Camallanus trichiuris <Unverified Name>[29]
Cloeoascaris trichiuri <Unverified Name>[29]
Ectenurus trichiuri <Unverified Name>[29]
Erilepturus trichiuri <Unverified Name>[29]
Floriceps saccatus[29]
Heptachona sindica <Unverified Name>[29]
Heteronybelinia estigmena[29]
Indocucullanus trichiurisi <Unverified Name>[29]
Lecithochirium acutum <Unverified Name>[29]
Lecithochirium branchialis[29]
Lecithochirium fusiforme[29]
Lecithochirium holocentri <Unverified Name>[29]
Lecithochirium microstomum[29]
Lecithochirium trichiuri <Unverified Name>[29]
Lecithocladium pagrosomi <Unverified Name>[29]
Lecithocladium parviovum <Unverified Name>[29]
Musculovesicula trichiuri <Unverified Name>[29]
Octoplectanocotyla trichiuri <Unverified Name>[29]
Opechona pyriforme <Unverified Name>[29]
Otobothrium cysticum[29]
Plerurus carangis <Unverified Name>[29]
Plerurus digitatus[29]
Plerurus hainanensis <Unverified Name>[29]
Plerurus longicaudatus <Unverified Name>[29]
Plerurus spatulocirrus <Unverified Name>[29]
Plerurus trichiuri <Unverified Name>[29]
Prodistomum orientalis[29]
Pterobothrium heteracanthum[29]
Pterobothrium interruptum <Unverified Name>[29]
Pulchrascaris secunda <Unverified Name>[29]
Scolex pleuronectis <Unverified Name>[29]
Sterrhurus branchialis <Unverified Name>[29]
Terranova trichiuri[29]
Tubulovesicula anguillae <Unverified Name>[29]
Tubulovesicula angusticauda[29]

Distribution

Aegean Sea; Agulhas Current; Albania; Algeria; Andaman Sea; Angola; Anguilla; Antigua and Barbuda; Arabian Sea; Argentina; Aruba; Atlantic Ocean; Atlantic, Eastern Central; Atlantic, Northeast; Atlantic, Northwest; Atlantic, Southeast; Atlantic, Southwest; Atlantic, Western Central; Australia; Bahamas; Bahrain; Bangladesh; Barbados; Bay of Bengal; Belize; Benguela Current; Benin; Bosnia and Herzegovina; Brazil; Brunei Darussalam; Calauag Bay; California Current; Cambodia; Cameroon; Canary Current; Cantabrian Sea; Caribbean Sea; Carigara Bay; Cayman Islands; Celtic-Biscay Shelf; Chiku River; China; Colombia; Congo, Dem. Rep. of the; Congo, Republic of; Cook Islands; Coral Sea and GBR; Costa Rica; Croatia; Cuba; Curaçao Island; Cyprus; Côte d'Ivoire; Davao Gulf; Denmark; Djibouti; Dominica; Dominican Republic; East Brazil Shelf; East Central Australian Shelf; East China Sea; East Timor; Ecuador; Egypt; El Salvador; Equatorial Guinea; Erhjen River; Eritrea; Fiji Islands; France; French Guiana; Gabon; Galician Shelf; Gambia; Ghana; Gibraltar; Great Barrier Reef; Greece; Grenada; Guadeloupe; Guatemala; Guinea; Guinea Current; Guinea-Bissau; Gulf of Aden; Gulf of Aqaba; Gulf of California; Gulf of Mexico; Gulf of Oman; Gulf of Thailand; Guyana; Haiti; Honduras; Hong Kong; Iberian Coastal; India; Indian Ocean; Indian Ocean, Eastern; Indian Ocean, Western; Indonesia; Indonesian Sea; Iran (Islamic Rep. of); Iraq; Ireland; Israel; Italy; Jamaica; Japan; Jordan; Kenya; Korea, Dem. People's Rep; Korea, Republic of; Kuroshio Current; Kuwait; Lagonoy Gulf; Laguna de Términos; Lebanon; Liberia; Libyan Arab Jamahiriya; Lingayen Gulf; Madagascar; Malaysia; Malta; Manila Bay; Martinique; Mauritania; Mauritius; Mediterranean Sea; Mediterranean and Black Sea; Mexico; Monaco; Montserrat; Morocco; Mozambique; Myanmar; Namibia; Netherlands Antilles; New Caledonia; Nicaragua; Nigeria; North Australian Shelf; North Brazil Shelf; Northeast U.S. Continental Shelf; Norway; Oman; Ormoc Bay; Pacific Central-American Coastal; Pacific Ocean; Pacific, Eastern Central; Pacific, Northwest; Pacific, Southeast; Pacific, Southwest; Pacific, Western Central; Pakistan; Panama; Panguil Bay; Papua New Guinea; Patagonian Shelf; Peng-hu Island; Persian Gulf; Peru; Peru-Galapagos Waters; Philippines; Portugal; Puerto Rico; Qatar; Ragay Gulf; Red Sea; Ryukyu Islands; Réunion; Saint Kitts and Nevis; Saint Lucia; Saint Vincent & the Grenadines; Samar Sea; San Miguel Bay; San Pedro Bay; Sao Tomé and Principe; Saudi Arabia; Sea of Japan; Senegal; Serbia and Montenegro; Sierra Leone; Singapore; Slovenia; Sogod Bay; Solomon Islands; Somali Coastal Current; Somalia; Sorsogon Bay; South Africa; South Brazil Shelf; South China Sea; Southeast U.S. Continental Shelf; Southwest Australian Shelf; Spain; Sri Lanka; Sudan; Sulu-Celebes Sea; Suriname; Sweden; Syrian Arab Republic; Taiwan; Tanzania, United Rep. of; Tayabas Bay; Thailand; Throughout tropical and temperate waters of the world. <i>Trichiurus japonicus</i> which was originally described from Japan as <i>Trichiurus lepturus japonicus</i> was synonymized with <i>Trichiurus lepturus</i>. Another nominal species synonymized wit; Throughout tropical and temperate waters of the world. <i>Trichiurus japonicus</i> which was originally described from Japan as <i>Trichiurus lepturus japonicus</i> was synonymized with <i>Trichiurus lepturus</i>. Another nominal species synonymized with <i>Trichiurus lepturus</i> is <i>Trichiurus nitens</i> from the eastern Pacific Ocean (California to Peru).; Togo; Tonga; Trinidad and Tobago; Tunisia; Turkey; Turks and Caicos Is.; US Virgin Islands; USA (contiguous states); United Arab Emirates; United Kingdom; Vanuatu; Venezuela; Viet Nam; Virgin Islands (UK); West Central Australian Shelf; Western Sahara; Yellow Sea; Yemen; Ébrié Lagoon;

Photos

Citations

Attributes / relations provided by 1de Magalhaes, J. P., and Costa, J. (2009) A database of vertebrate longevity records and their relation to other life-history traits. Journal of Evolutionary Biology 22(8):1770-1774 2Myers, P., R. Espinosa, C. S. Parr, T. Jones, G. S. Hammond, and T. A. Dewey. 2006. The Animal Diversity Web (online). Accessed February 01, 2010 at animaldiversity.org 3Frimpong, E.A., and P. L. Angermeier. 2009. FishTraits: a database of ecological and life-history traits of freshwater fishes of the United States. Fisheries 34:487-495. 4Feeding ecology of hairtail Trichiurus margarites and largehead hairtail Trichiurus lepturus in the Beibu Gulf, the South China Sea, YAN Yunrong (颜云榕), HOU Gang (侯刚), CHEN Junlan (陈骏岚), LU Huosheng (卢伙胜), JIN Xianshi (金显仕), Chinese Journal of Oceanology and Limnology, Vol. 29 No. 1, P. 174-183, 2011 5Food of Northwest Atlantic Fishes and Two Common Species of Squid, Ray E. Bowman, Charles E. Stillwell, William L. Michaels, and Marvin D. Grosslein, NOAA Technical Memorandum NMFS-NE-155 (2000) 6Feeding habits and ontogenetic diet shift of hairtail fish (Trichiurus lepturus) in East China Sea and Yelow Sea, ZHANG Bo, Marine Fisheries Research, Vol. 25, No. 2, 2004 7TROPHIC RELATIONSHIPS OF DEMERSAL FISHES IN THE SHRIMPING ZONE OFF ALVARADO LAGOON, VERACRUZ, MEXICO, Edgar Peláez-Rodríguez, Jonathan Franco-López, Wilfredo A. Matamoros, Rafael Chavez-López, and Nancy J. Brown-Peterson, Gulf and Caribbean Research Vol 17, 157–167, 2005 8Comparative analysis of trophic structure and interactions of two tropical lagoons, M.C. Villanueva, P. Lalèyè, J.-J. Albaret, R. Laë, L. Tito de Morais and J. Moreau, Ecological Modelling, Vol. 197, Issues 3-4 , 25 August 2006, P. 461-477 9CephBase - Cephalopod (Octopus, Squid, Cuttlefish and Nautilus) Database 10Diet of Wahoo, Acanthocybium solandri, from the Northcentral Gulf of Mexico, JAMES S. FRANKS, ERIC R. HOFFMAYER, JAMES R. BALLARD, NIKOLA M. GARBER, and AMBER F. GARBER, Proceedings of the 60th Gulf and Caribbean Fisheries Institute November 5 - 9, 2007 Punta Cana, Dominican Republic, p. 353-362 11Seasonal variation in the diets of bluefish, Pomatomus saltatrix (Pomatomidae) and striped weakfish, Cynoscion guatucupa (Sciaenidae) in southern Brazil: implications of food partitioning, Flavia M. Lucena, Teodoro Vaske, Jr., Jim R. Ellis & Carl M. O’Brien, Environmental Biology of Fishes 57: 423–434, 2000. 12Insights on small cetacean feeding habits in southeastern Brazil, Marcos César de Oliveira Santos, Sergio Rosso, Roberta Aguiar dos Santos, Silvia Helena Bulizani Lucato, and Manuela Bassio, Aquatic Mammals 2002, 28.1, 38-45 13The Food and Feeding Habits of the Bombay Duck, Harpodon nehereus (Ham.) in the River Matlah (Bengal), T. V. R. Pillay, Proc. Nat. Inst. Sci. India, no. 19, p. 427-435 (1953) 14Dietary composition of the sailfish Istiophorus platypterus (Shaw & Nodder, 1792) from Parangipettai, southeast coast of India, V. Ravi and V. Sekar, J. Mar. Biol. Ass. India, 52 (1) : 102 - 104, January - June 2010 15THE FOOD OF YELLOWFIN AND SKIPJACK TUNAS IN THE EASTERN TROPICAL PACIFIC OCEAN, FRANKLIN G. ALVERSON, INTER-AMERICAN TROPICAL TUNA COMMISSION Bulletin, Vol. VII, No. 5 (1963) 16Doncel, Oscar, and Jorge Paramo. "Food habits of the lane snapper, Lutjanus synagris (Perciformes: Lutjanidae), in the north zone of the Colombian Caribbean/Habitos alimenticios del pargo rayado, Lutjanus synagris (Perciformes: Lutjanidae), en la zona norte del Caribe colombiano." Latin American Journal of Aquatic Research 38.3 (2010): 413+. Academic OneFile. Web. 15 July 2014. 17FOOD AND FEEDING HABITS OF KING WEAKFISH, Macrodon ancylodon (BLOCH & SCHNEIDER, 1801) CAUGHT IN THE SOUTHERN COAST OF BRAZIL (LAT, 29° TO 32°S), Anastácio Afonso JURAS & Noriyoshi YAMAGUTI, Bolm Inst. oceanogr., S Paulo, 33(2):149-157, 1985 18"Seasonal and Growth Variation of Feeding Habit of Conger Eel (Muraenesox cinereus) in East China Sea", ZHANG Ya-zhou, ZHU Wen-bin, LI Peng-fei, Journal of Zhejiang Ocean University (Natural Science) 2010-03 19Food composition and distribution of elasmobranches on the shelf and upper slope of the Eastern Central Atlantic., Patokina F.A., Litvinov F.F., ICES CM 2005/N:26 20Feeding of the Brazilian sharpnose shark Rhizoprionodon lalandii (Müller & Henle, 1839) from southern Brazil, By H. Bornatowski, M. R. Heithaus, V. Abilhoa and M. F. M. Corrêa, J. Appl. Ichthyol. (2012), 1–5 21Feeding Habits of Japanese Spanish Mackerel in the Central and Western Waters of the Seto Inland Sea, Tatsu Kishida, Bull. Nansei Reg. Fish. Res. Lab. No. 20, 1986 22Diet Composition of Fish Species from the Southern Continental Shelf of Colombia, R.H. López-Peralta and C.A.T. Arcila, Naga, WorldFish Center Quarterly (Vol. 25, No. 3 & 4) July-Dec 2002, p. 23-29 23Sotalia fluviatilis, Vera M. F. da Silva and R. C. Best, MAMMALIAN SPECIES No. 527, pp. 1-7 (1996) 24Feeding habits of the Guiana dolphin, Sotalia guianensis (Cetacea: Delphinidae), in Norte Bay, southern Brazil, FÁBIO G. DAURA-JORGE, LEONARDO L. WEDEKIN and PAULO C. SIMÕES-LOPES, SCI. MAR., 75(1), March 2011, 163-169 25Feeding Habits of the Pantropical Spotted Dolphin, Stenella attenuata, off the Eastern Coast of Taiwan, Ming-Chih Wang, William A. Walker, Kwang-Tsao Shao and Lien-Siang Chou, Zoological Studies 42(2): 368-378 (2003) 26ECOLOGY OF INSHORE LIZARDFISH, Synodus foetens, IN THE NORTHERN GULF OF MEXICO, Sarah Ann Branson Jeffers, Master of Science thesis, University of West Florida, 2007 27Stomach content analysis of Terapon jarbua (Forsskal) from Parangipettai coast, South East Coast of India, Manoharan J, Gopalakrishnan A, Varadharajan D, Thilagavathi B and Priyadharsini S, Adv. Appl. Sci. Res., 2012, 3(5):2605-2621 28Jung Hwa Choi, Bong Jun Sung, Dong Woo Lee, Jong Bin Kim, Taeck Yun Oh and Jung Nyun Kim, Feeding Habits of Yellow Goose Fish Lophius litulon and John Dory Zeus faber in the South Sea of Korea, Fish Aquat Sci 14(4), 435-441, 2011 29Gibson, D. I., Bray, R. A., & Harris, E. A. (Compilers) (2005). Host-Parasite Database of the Natural History Museum, London
Abstract provided by DBpedia licensed under a Creative Commons License
Weather provided by NOAA METAR Data Access
(default) 42 queries took 64 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` = 667622 LIMIT 1111
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (667622) 17171
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (667622) 330
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (667622) 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` = (667622) 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` = (667622) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 32321
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` = 667622 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` = 667622 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` = 667622 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` = 667622 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` = 667622 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` = 667622 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` = 26854537 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` = 667622 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 667622 AND d.group_id = dg.id ORDER BY dg.distribution23323312
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 667622 ORDER BY s.name12121
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 667622 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language2082082
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 667622111
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 667622 AND pa.geo_id = g.id ORDER BY pa.name771
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` = 667622 ORDER BY `Consumer`.`name` ASC 39391
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 (658871, 2299758, 842297, 2586604, 2622783, 623136, 659671, 904117, 2593509, 659027, 2561661, 658905, 658916, 2687970, 2520933, 905153, 658939, 659366, 659066, 2691758, 2510848, 2543698, 2630106, 659427, 659429, 658971, 666274, 667520, 833970, 1046011, 833976, 660657, 661494, 834174, 667622, 637250, 2662471, 833973, 667639) 39392
22SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (623136, 637250, 658871, 658905, 658916, 658939, 658971, 659027, 659066, 659366, 659427, 659429, 659671, 660657, 661494, 666274, 667520, 667622, 667639, 833970, 833973, 833976, 834174, 842297, 904117, 905153, 1046011, 2299758, 2510848, 2520933, 2543698, 2561661, 2586604, 2593509, 2622783, 2630106, 2662471, 2687970, 2691758) 1971976
23SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (623136, 637250, 658871, 658905, 658916, 658939, 658971, 659027, 659066, 659366, 659427, 659429, 659671, 660657, 661494, 666274, 667520, 667622, 667639, 833970, 833973, 833976, 834174, 842297, 904117, 905153, 1046011, 2299758, 2510848, 2520933, 2543698, 2561661, 2586604, 2593509, 2622783, 2630106, 2662471, 2687970, 2691758) 63631
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` = 667622 ORDER BY `Provider`.`name` ASC 41412
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 (904327, 662520, 1060987, 1060995, 675151, 635275, 666008, 659547, 659208, 669883, 683264, 900878, 659683, 1050868, 659293, 666746, 661554, 659708, 1924171, 904692, 901906, 659751, 666902, 904261, 669789, 662088, 1061852, 1061238, 1061521, 658954, 1924198, 647588, 660015, 612027, 688595, 659491, 659495, 659501, 667622, 658459, 904343) 41412
26SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (612027, 635275, 647588, 658459, 658954, 659208, 659293, 659491, 659495, 659501, 659547, 659683, 659708, 659751, 660015, 661554, 662088, 662520, 666008, 666746, 666902, 667622, 669789, 669883, 675151, 683264, 688595, 900878, 901906, 904261, 904327, 904343, 904692, 1050868, 1060987, 1060995, 1061238, 1061521, 1061852, 1924171, 1924198) 1651654
27SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (612027, 635275, 647588, 658459, 658954, 659208, 659293, 659491, 659495, 659501, 659547, 659683, 659708, 659751, 660015, 661554, 662088, 662520, 666008, 666746, 666902, 667622, 669789, 669883, 675151, 683264, 688595, 900878, 901906, 904261, 904327, 904343, 904692, 1050868, 1060987, 1060995, 1061238, 1061521, 1061852, 1924171, 1924198) 26261
28SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000040594, 1000016303, 1000016403, 1000023022, 1000023446, 1000016950, 1000016960, 1000016989, 1000017018, 1000017456, 1000024991, 1000025061, 1000018802, 1000019055, 1000026085, 1000026117, 1000026154, 1000026184, 1000026187, 1000026966, 1000015028, 1000027379, 1000028402, 1000028407, 1000028409, 1000028413, 1000028415, 1000011261, 1000020898, 1000011488, 1000029425, 1000029702) 32321
29SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 667622 ORDER BY name1481481
30SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 667622 AND do.total > 1 ORDER BY name40401
31SELECT `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 (675151, 659181, 658881, 657377, 659236, 903058, 659644, 661776, 681685, 670193, 661781, 666676, 659671, 666733, 668084, 659715, 901524, 666906, 661534, 684837, 635688, 680047, 659946, 667315, 610582, 661642, 659091, 659414, 659415, 672699, 658963, 658971, 668120, 658349, 666306, 663822, 660657, 667612, 637250, 667639) 40402
32SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (610582, 635688, 637250, 657377, 658349, 658881, 658963, 658971, 659091, 659181, 659236, 659414, 659415, 659644, 659671, 659715, 659946, 660657, 661534, 661642, 661776, 661781, 663822, 666306, 666676, 666733, 666906, 667315, 667612, 667639, 668084, 668120, 670193, 672699, 675151, 680047, 681685, 684837, 901524, 903058) 2272275
33SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (610582, 635688, 637250, 657377, 658349, 658881, 658963, 658971, 659091, 659181, 659236, 659414, 659415, 659644, 659671, 659715, 659946, 660657, 661534, 661642, 661776, 661781, 663822, 666306, 666676, 666733, 666906, 667315, 667612, 667639, 668084, 668120, 670193, 672699, 675151, 680047, 681685, 684837, 901524, 903058) 56562
34SELECT `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, 26924222, 26958443) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922057,26924196,26924222,26958443) ASC 662
35SELECT 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, 113106, 112110) 661
36SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 111274, 113097, 113106, 112110) 001
37SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
38SELECT `Image`.`id`, `Image`.`title`, `Image`.`category`, `Image`.`credit`, `Image`.`filename`, `Image`.`taxa_id`, `Image`.`order`, `Image`.`database_id` FROM `images` AS `Image` WHERE `Image`.`taxa_id` = 667622 ORDER BY `Image`.`order` ASC LIMIT 4111
39SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (1442, 1443, 1444, 3885, 1342, 3495, 3592, 3808, 1027, 3698, 3787, 3573, 3502, 3566, 1616, 4444, 4151, 4074, 4161, 4147, 3526, 3478, 2129, 3867, 1132, 2423, 4049, 3310, 1029) 29291
40SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1019) 110
41SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1007) 110
42SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110