Marshall Islands

Political Hierarchy

Republic of the Marshall Islands

Geographical Hierarchy

All Oceans of the World --> Pacific Ocean --> Western Pacific Ocean --> Micronesia --> Marshall Islands

Coordinates: 7.131474 171.184478

query [long version]
 ReferenceUUIDLocationUUIDStart_PageEnd_PagePKIDCorrectIDTableIDUUIDLegacyIDLegacyID2ReferenceIDParentReferenceIDReferenceTypeIDLanguageIDYearTitleSecondaryTitlePublisherPlacePublishedVolumeNumberVolumesNumberPagesInPagesSectionEditionDatePublishedTypeWorkShortTitleFiguresStartDateEndDateURLCheatCitationCheatAuthorsCheatFullAuthorsCheatCitationDetailsCheatSearchReferenceExpr1Expr2FK_TableTypeIDExpr3CheatSearchStringExpr4PK_LocationIDLocation_nameFK_CountryIDActiveAbbreviationx_locationy_locationmap_nameLocationDecimalLatitudeLocationDecimalLongitudeEchelonFK_SubordIDlocation_descriptionheightwidthy_rect_coordsx_rect_coordsSW_Bound_LatSW_Bound_LongNE_Bound_LatNE_Bound_Long
1B568366D-2D3E-493A-AF7E-3280CF49EFAB43D21EB5-738E-4ED5-9284-769F4B1C0993115132197366961973669619691327B568366D-2D3E-493A-AF7E-3280CF49EFAB[null][null]19736696197054191196914332005Ninety-one new records of fishes from the Marshall Islands[null][null][null]9[null]3115-132[null][null][null]March 2005[null][null][null]2005-03-01 00:00:00.0002005-03-31 00:00:00.000[null]Randall et al. 2005Randall, Myers, Trevor, Johnson, Johnson, Yoshii & GreeneRandall, John E., Robert F. Myers, Michael N. Trevor, Jeanette L. Johnson, Scott R. Johnson, Satoshi Yoshii & Brian D. Greene<em>Aqua, Journal of Ichthyology and Aquatic Biology</em> <b>9</b>(3): 115-132.Ninety-one new records of fishes from the Marshall Islands 259877743D21EB5-738E-4ED5-9284-769F4B1C0993382598777[null]91032598777Marshall Islands[null]1[null][null][null][null]7.131474171.18447839051[empty string][null][null][null][null][null][null][null][null]
22A9A5E06-1DB3-4386-B636-B2C36A97DE3443D21EB5-738E-4ED5-9284-769F4B1C0993[null][null]1972948719729487196913272A9A5E06-1DB3-4386-B636-B2C36A97DE34[null][null]19729487197246991196914331987Annotated checklist of the fishes of Enewetak Atoll and other Marshall Islands. Chapter 27[null][null][null][null][null][null]289-324, 3 pls.[null][null][null]1987[null][null][null]1987-01-01 00:00:00.0001987-12-31 00:00:00.000[null]Randall & Randall 1987Randall & RandallRandall, John E. & Helen A. Randall<em>The natural history of Enewetak Atoll, Vol. II, Biogeography and systematics</em>: 289-324, 3 pls.Annotated checklist of the fishes of Enewetak Atoll and other Marshall Islands. Chapter 27 259877743D21EB5-738E-4ED5-9284-769F4B1C0993382598777[null]91032598777Marshall Islands[null]1[null][null][null][null]7.131474171.18447839051[empty string][null][null][null][null][null][null][null][null]
36AC312BB-1452-4BB9-8A09-3850AE392C1D43D21EB5-738E-4ED5-9284-769F4B1C0993[null][null]1969504219695042196913276AC312BB-1452-4BB9-8A09-3850AE392C1D[null][null]1969504202196914331999Micronesian reef fishes: a comprehensive guide to the coral reef fishes of Micronesia[null]Coral GraphicsBarrigada, Guam[null][null][null]i-vi, 1-330, pls. 1-192[null][null]Third edition, revised and expanded[null][null][null][null]1999-01-01 00:00:00.0001999-12-31 00:00:00.000[null][null]MyersMyers, Robert F.Coral Graphics,Barrigada, Guam. Third edition, revised and expanded Edition: i-vi, 1-330, pls. 1-192.Micronesian reef fishes: a comprehensive guide to the coral reef fishes of Micronesia Third edition, revised and expanded 259877743D21EB5-738E-4ED5-9284-769F4B1C0993382598777[null]91032598777Marshall Islands[null]1[null][null][null][null]7.131474171.18447839051[empty string][null][null][null][null][null][null][null][null]
Query Source:SQL Query
Datasource:LOG
Query:SELECT lr.ReferenceUUID, lr.LocationUUID, lr.Start_Page, lr.End_Page, ref_pk.PKID, ref_pk.CorrectID, ref_pk.TableID, ref_pk.UUID, ref_pk.LegacyID, ref_pk.LegacyID2, r.ReferenceID, r.ParentReferenceID, r.ReferenceTypeID, r.LanguageID, r.Year, r.Title, r.SecondaryTitle, r.Publisher, r.PlacePublished, r.Volume, r.NumberVolumes, r.Number, r.Pages, r.InPages, r.Section, r.Edition, r.DatePublished, r.TypeWork, r.ShortTitle, r.Figures, r.StartDate, r.EndDate, r.URL, r.CheatCitation, r.CheatAuthors, r.CheatFullAuthors, r.CheatCitationDetails, r.CheatSearchReference, loc_pk.PKID AS Expr1, loc_pk.UUID AS Expr2, loc_pk.FK_TableTypeID, loc_pk.CorrectID AS Expr3, loc_pk.CheatSearchString, loc_pk.LegacyID AS Expr4, l.PK_LocationID, l.Location_name, l.FK_CountryID, l.Active, l.Abbreviation, l.x_location, l.y_location, l.map_name, l.GeoCoords.Lat as LocationDecimalLatitude, l.GeoCoords.Long as LocationDecimalLongitude, l.Echelon, l.FK_SubordID, l.location_description, l.height, l.width, l.y_rect_coords, l.x_rect_coords, l.SW_Bound_Lat, l.SW_Bound_Long, l.NE_Bound_Lat, l.NE_Bound_Long FROM Location_join_Reference AS lr INNER JOIN Taxonomer.dbo.PK AS ref_pk ON lr.ReferenceUUID = ref_pk.UUID INNER JOIN Taxonomer.dbo.Reference AS r ON ref_pk.PKID = r.ReferenceID INNER JOIN PK AS loc_pk ON lr.LocationUUID = loc_pk.UUID INNER JOIN Locations AS l ON l.PK_LocationID = loc_pk.PKID WHERE lr.ReferenceUUID IS NOT NULL AND lr.LocationUUID = ? ORDER BY lr.SortOrder
Time:0 ms
CFQUERYPARAMS:
  1. Type=CF_SQL_VARCHAR; Data=[43D21EB5-738E-4ED5-9284-769F4B1C0993]; Direction=IN; Variable=null