Animalia > Chordata > Actinopterygii > Perciformes > Sciaenidae > Micropogonias > Micropogonias furnieri
 

Micropogonias furnieri (Whitemouth drummer; Whitemouth croaker; West Indian drum; West Indian croaker; Two-belly bashaw; Ronco; Rocando; Mangrove snapper; Hardhead; Golden croaker; Cro-cro; Croaker; Cro cro; Basher; Bashaw)

Synonyms: Micropogon argenteus; Micropogon funieri; Micropogon furnieiri; Micropogon furnieri; Micropogon manni; Micropogonias manni; Micropogonias opercularis; Ophioscion woodwardi; Sciaena opercularis; Umbrina furnieri
Language: Danish; French; Japanese; Mandarin Chinese; Other; Portuguese; Spanish; Sranan; Wayuu

Attributes

Female Maturity [1]  3 years 6 months
Male Maturity [3]  3 years 6 months
Maximum Longevity [1]  7 years
Migration [2]  Oceanodromous

Protected Areas

Name IUCN Category Area acres Location Species Website Climate Land Use
Buenavista Wetland Reserve 778949 Cuba    
Parque Atlantico Mar Chiquita Nature Reserve VI 706059 Cordoba, Argentina  

Prey / Diet

Brevoortia aurea (Brazilian menhaden)[4]
Callinectes sapidus (blue crab)[4]
Cyrtograpsus angulatus[4]
Erodona mactroides[5]
Heleobia australis[4]
Laeonereis acuta[5]
Micropogonias furnieri (Whitemouth drummer)[4]
Neomysis americana (Mysid shrimp)[4]
Nephtys fluviatilis[4]
Palaemonetes argentinus[4]

Prey / Diet Overlap

Competing SpeciesCommon Prey Count
Albula vulpes (Bonefish)1
Alosa pseudoharengus (kyack)1
Amblyraja radiata (Starry ray)1
Ammodytes dubius (offshore sand lance)1
Ariopsis felis (Sea catfish)1
Atherinella brasiliensis (Silverside)1
Brevoortia aurea (Brazilian menhaden)3
Brevoortia tyrannus (Shad)1
Calidris fuscicollis (White-rumped Sandpiper)1
Carcharhinus plumbeus (Thickskin shark)1
Centropomus undecimalis (Thin snook)1
Centropristis striata (Sea bass)1
Charadrius falklandicus (Two-banded Plover)1
Ctenogobius shufeldti (Freshwater goby)1
Cynoscion striatus (Striped weakfish)1
Epinephelus marginatus (Yellowbelly rockcod)1
Genidens barbus (White sea catfish)1
Hippoglossina oblonga (Fourspot flounder)1
Jenynsia multidentata (Rio de la Plata onesided livebearer)1
Larimus fasciatus (Banded drum)1
Leiostomus xanthurus (Spot croaker)1
Leucoraja erinacea (common skate)1
Malacoraja senta (Smooth skate)1
Menticirrhus saxatilis (Northern kingfish)1
Morone americana (Wreckfish)1
Mycteroperca microlepis (Velvet rockfish)1
Myoxocephalus aenaeus (Little sculpin)1
Odontesthes bonariensis (Silverside)1
Odontesthes humensis (Silverside)1
Oligosarcus jenynsii (Pike characin)1
Paralichthys dentatus (fluke)1
Paralichthys orbignyanus6
Podicephorus major (Great Grebe)2
Pomatomus saltatrix (Tailor run)1
Prionotus carolinus (Searobin)1
Prionotus evolans (Striped searobin)1
Pseudopleuronectes americanus (rough flounder)2
Rachycentron canadum (Sergent fish)1
Rhamdia quelen (Catfish)1
Sciaenops ocellatus (Spotted bass)1
Scomber scombrus (Split)1
Scophthalmus aquosus (brill)1
Stenotomus chrysops (Scup)1
Syngnathus fuscus (Northern pipefish)1
Urophycis chuss (Squirrel hake)1
Urophycis regia (Spotted hake)1

Predators

Citharichthys spilopterus (Bay Whiff)[6]
Micropogonias furnieri (Whitemouth drummer)[4]
Phalacrocorax brasilianus (Neotropic Cormorant)[7]
Podicephorus major (Great Grebe)[8]
Pontoporia blainvillei (Franciscana)[9]
Sotalia fluviatilis (Tucuxi)[10]
Sotalia guianensis (costero)[11]
Synodus foetens (Soapfish)[12]

Consumers

Parasitized by 
Aponurus laguncula[13]
Aponurus pyriformis[13]
Brachadena pyriformis[13]
Bucephalus varicus[13]
Callitetrarhynchus gracilis[13]
Corynosoma australe[13]
Cucullanellus rodriguesi <Unverified Name>[13]
Cucullanus cassinensis <Unverified Name>[13]
Cucullanus pulcherrimus <Unverified Name>[13]
Dichelyne elongatus <Unverified Name>[13]
Diplomonorchis hopkinsi <Unverified Name>[13]
Diplomonorchis leiostomi[13]
Diplomonorchis micropogoni <Unverified Name>[13]
Dollfusentis chandleri[13]
Encotyllabe spari[13]
Lecithochirium microstomum[13]
Lobatostoma ringens[13]
Macrovalvitrema sinaloense[13]
Monascus filiformis[13]
Neomacrovalvitrema argentinensis <Unverified Name>[13]
Neopterinotrematoides avaginata <Unverified Name>[13]
Opechona chloroscombri <Unverified Name>[13]
Opecoeloides catarinensis <Unverified Name>[13]
Opecoeloides stenosomae <Unverified Name>[13]
Pachycreadium gastrocotylum[13]
Poecilancistrium caryophyllum[13]
Pterinotrematoides mexicanum[13]
Pterobothrium crassicolle[13]
Pterobothrium heteracanthum[13]
Rhamnocercus rhamnocercus[13]
Scolex pleuronectis <Unverified Name>[13]

Distribution

Anguilla; Antigua and Barbuda; Argentina; Aruba; Atlantic Ocean; Atlantic, Southwest; Atlantic, Western Central; Barbados; Brazil; Caribbean Sea; Chile; Colombia; Costa Rica; Cuba; Curaçao Island; Dominica; Dominican Republic; East Brazil Shelf; French Guiana; Grenada; Guadeloupe; Gulf of Mexico; Guyana; Haiti; Humboldt Current; Jamaica; Martinique; Montserrat; Netherlands Antilles; Nicaragua; North Brazil Shelf; Pacific Ocean; Pacific, Southeast; Panama; Patagonian Shelf; Puerto Rico; Saint Kitts and Nevis; Saint Lucia; Saint Vincent & the Grenadines; South Brazil Shelf; Southeast Pacific: Chile.; Suriname; Trinidad and Tobago; US Virgin Islands; Uruguay; Venezuela; Virgin Islands (UK); Western Atlantic: Greater Antilles and from Costa Rica to Argentina (Ref. 9626). Also reported in Nicaragua (Ref. 13613).;

Photos

Citations

Attributes / relations provided by 1Frimpong, 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. 2Riede, Klaus (2004) Global Register of Migratory Species - from Global to Regional Scales. Final Report of the R&D-Projekt 808 05 081. 330 pages + CD-ROM 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 4Food web of a SW Atlantic shallow coastal lagoon: spatial environmental variability does not impose substantial changes in the trophic structure, Laura Rodríguez-Graña, Danilo Calliari, Daniel Conde, Javier Sellanes, Roberto Urrutia, Mar Ecol Prog Ser 362: 69–83, 2008 5DIET AND FEEDING STRATEGY OF FISHES IN A Ruppia maritima MEADOW, IN THE PATOS LAGOON ESTUARY, BRAZIL, Marcelo Bassols Raseira, Alexandre Miranda Garcia, João Paes Vieira, Fish Communities and Fisheries, SYMPOSIUM PROCEEDINGS, International Congress on the Biology of Fish 2004, pp. 205-214 6Trophic resource partitioning among five flatfish species (Actinopterygii, Pleuronectiformes) in a tropical bay in south-eastern Brazil, A. P. P. Guedes and F. G. Araújo, Journal of Fish Biology (2008) 72, 1035–1054 7Diet of Neotropic cormorant (Phalacrocorax brasilianus) in an estuarine environment, V. Barquete, L. Bugoni, C. M. Vooren, Mar Biol (2008) 153:431–443 8FORAGING ECOLOGY OF THE GREAT GREBE PODICEPHORUS MAJOR IN MAR CHIQUITA LAGOON (BUENOS AIRES, ARGENTINA), María Laura JOSENS, María Susana BÓ and Marco FAVERO, Ardeola 57(1), 2010, 133-141 9FEEDING ECOLOGY OF THE FRANCISCANA (PONTOPORIA BLAINVILLEI) IN MARINE AND ESTUARINE WATERS OF ARGENTINA, Diego Rodríguez, Laura Rivero and Ricardo Bastida, LAJAM 1(1): 77-94, Special Issue 1, 2002 10Insights 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 Bassoi, Aquatic Mammals 2002, 28.1, 38-45 11Feeding 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 12TROPHIC 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 13Gibson, 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) 40 queries took 47 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` = 663112 LIMIT 1112
2SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` = (663112) 15151
3SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` = (663112) 440
4SELECT `Taxalink`.`id`, `Taxalink`.`namecode_id`, `Taxalink`.`location`, `Taxalink`.`link`, `Taxalink`.`name` FROM `taxalinks` AS `Taxalink` WHERE `Taxalink`.`namecode_id` = (663112) 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` = (663112) 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` = (663112) ORDER BY `Missingrel`.`provider` ASC, `Missingrel`.`consumer` ASC 14141
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` = 663112 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` = 663112 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` = 663112 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` = 663112 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` = 663112 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` = 663112 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` = 26850476 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` = 663112 ORDER BY `Zooinst`.`name` ASC, `ZooSpecie`.`infraspecies` ASC 001
15SELECT dg.distribution FROM distribution d, distribution_groups dg WHERE d.namecode_id = 663112 AND d.group_id = dg.id ORDER BY dg.distribution50503
16SELECT s.name FROM synonyms s WHERE s.namecode_id = 663112 ORDER BY s.name10101
17SELECT DISTINCT cn.language, cn.common_name FROM common_names cn WHERE cn.namecode_id = 663112 AND cn.language <> 'English' AND cn.language <> 'unspecified' AND cn.language <> '' order by cn.language54542
18SELECT count(*) as total FROM protectareas pa, protect_taxa pt WHERE pa.id = pt.protect_id AND pt.taxa_id = 663112111
19SELECT * FROM protectareas pa, protect_taxa pt, geographics g WHERE pa.id = pt.protect_id AND pt.taxa_id = 663112 AND pa.geo_id = g.id ORDER BY pa.name221
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` = 663112 ORDER BY `Consumer`.`name` ASC 27272
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 (2572571, 2668202, 905654, 903372, 2586604, 667670, 842309, 2514188, 841672, 2662852, 905153, 1899462, 2525953, 663112, 904138, 914781, 902780, 828790, 2638747, 833964, 2691421, 2669003, 2630106, 900521, 833970, 1046011, 660657) 27272
22SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (660657, 663112, 667670, 828790, 833964, 833970, 841672, 842309, 900521, 902780, 903372, 904138, 905153, 905654, 914781, 1046011, 1899462, 2514188, 2525953, 2572571, 2586604, 2630106, 2638747, 2662852, 2668202, 2669003, 2691421) 35352
23SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (660657, 663112, 667670, 828790, 833964, 833970, 841672, 842309, 900521, 902780, 903372, 904138, 905153, 905654, 914781, 1046011, 1899462, 2514188, 2525953, 2572571, 2586604, 2630106, 2638747, 2662852, 2668202, 2669003, 2691421) 31311
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` = 663112 ORDER BY `Provider`.`name` ASC 882
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 (659602, 1063296, 2576065, 2612422, 2564492, 663112, 1056840, 2466661) 881
26SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (659602, 663112, 1056840, 1063296, 2466661, 2564492, 2576065, 2612422) 19191
27SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (659602, 663112, 1056840, 1063296, 2466661, 2564492, 2576065, 2612422) 441
28SELECT `Missingtaxa`.`id`, `Missingtaxa`.`verified`, `Missingtaxa`.`english_name` FROM `missingtaxa` AS `Missingtaxa` WHERE `Missingtaxa`.`id` IN (1000039977, 1000017699, 1000017720, 1000017777, 1000017966, 1000024569, 1000024571, 1000014964, 1000014995, 1000027367, 1000027393, 1000027404, 1000011488, 1000040548) 14141
29SELECT do.namecode_2 as namecode_id, do.total as total, do.name as name FROM dietoverlap do WHERE do.namecode_1 = 663112 ORDER BY name46461
30SELECT `Taxa`.`record_id`, `Taxa`.`lsid`, `Taxa`.`name`, `Taxa`.`taxon`, `Taxa`.`parent_id`, `Taxa`.`database_id`, `Taxa`.`namecode_id`, `Taxa`.`english_name_cnt`, `Taxa`.`longevity_cnt`, `Taxa`.`species_cnt`, `Taxa`.`endanger_cnt`, `Taxa`.`link`, `Taxa`.`invasive_cnt`, `Taxa`.`kingdom`, `Taxa`.`image_cnt`, `Taxa`.`relation_cnt`, `Taxa`.`range_dbid`, `Taxa`.`tphylum`, `Taxa`.`tclass`, `Taxa`.`torder`, `Taxa`.`tfamily`, `Taxa`.`scrutiny_date`, `Taxa`.`specialist_id`, `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 (658988, 659532, 626283, 666385, 656778, 613676, 659602, 659606, 830693, 659236, 659005, 659006, 830583, 643236, 659275, 662602, 636052, 642870, 627610, 667012, 666183, 626322, 685298, 659372, 659064, 659877, 661141, 661625, 624418, 680477, 659945, 634740, 828790, 659091, 659981, 659982, 618791, 661272, 680262, 660039, 666268, 659438, 659475, 667566, 659132, 660137) 46462
31SELECT DISTINCT `CommonName`.`common_name`, `CommonName`.`namecode_id` FROM `common_names` AS `CommonName` WHERE `CommonName`.`language` = 'English' AND `CommonName`.`namecode_id` IN (613676, 618791, 624418, 626283, 626322, 627610, 634740, 636052, 642870, 643236, 656778, 658988, 659005, 659006, 659064, 659091, 659132, 659236, 659275, 659372, 659438, 659475, 659532, 659602, 659606, 659877, 659945, 659981, 659982, 660039, 660137, 661141, 661272, 661625, 662602, 666183, 666268, 666385, 667012, 667566, 680262, 680477, 685298, 828790, 830583, 830693) 2172174
32SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (613676, 618791, 624418, 626283, 626322, 627610, 634740, 636052, 642870, 643236, 656778, 658988, 659005, 659006, 659064, 659091, 659132, 659236, 659275, 659372, 659438, 659475, 659532, 659602, 659606, 659877, 659945, 659981, 659982, 660039, 660137, 661141, 661272, 661625, 662602, 666183, 666268, 666385, 667012, 667566, 680262, 680477, 685298, 828790, 830583, 830693) 1091092
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` FROM `taxa` AS `Taxa` WHERE `Taxa`.`record_id` IN (26922039, 26922040, 26922057, 26924196, 26924939, 26959948) ORDER BY FIELD(`Taxa`.`record_id`,26922039,26922040,26922057,26924196,26924939,26959948) ASC 662
34SELECT 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, 113120, 112359) 661
35SELECT `Attribute`.`id`, `Attribute`.`namecode_id`, `Attribute`.`value`, `Attribute`.`name`, `Attribute`.`dbid` FROM `attributes` AS `Attribute` WHERE `Attribute`.`namecode_id` IN (109518, 114858, 111274, 113097, 113120, 112359) 000
36SELECT `Biome`.`id`, `Biome`.`name` FROM `biomes` AS `Biome` WHERE 1 = 1 38380
37SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` IN (1444, 4668, 1442, 3527, 2306, 3975, 2283, 4269, 4152, 1134, 3867, 3592, 1029) 13131
38SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1019) 110
39SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1002) 110
40SELECT `Databasis`.`database_name_displayed`, `Databasis`.`record_id`, `Databasis`.`web_site`, `Databasis`.`abstract` FROM `databases` AS `Databasis` WHERE `Databasis`.`record_id` = (1014) 110