Marquesas Islands

Political Hierarchy

France --> French Overseas Territories --> French Polynesia --> Marquesas Islands

Geographical Hierarchy

All Oceans of the World --> Europe --> Pacific Ocean --> South Pacific Ocean --> Marquesas Islands

Coordinates: -9.4544444 -139.3888889

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
121E786A2-8087-42CC-897F-21773C35C2D1F914499C-2AF3-4F08-B163-695E2D5A6320[null][null]19731377197313771969132721E786A2-8087-42CC-897F-21773C35C2D1[null][null]19731377197348951196914332000Annotated checklist of the shore fishes of the Marquesas Islands[null][null][null][null][null]661-39[null][null][null][null][null][null][null]2000-01-01 00:00:00.0002000-12-31 00:00:00.000[null]Randall & Earle 2000Randall & EarleRandall, John E. & John L. Earle<em>Occasional Papers of the Bernice P. Bishop Museum</em>(66): 1-39.Annotated checklist of the shore fishes of the Marquesas Islands 2597990F914499C-2AF3-4F08-B163-695E2D5A6320382597990[null]83162597990Marquesas Islands[null]1[null][null][null][null]-9.4544444-139.388888938310[empty string][null][null][null][null]-10.9249755646-141.025851791-7.6184060219-138.3342014
22FBCF0D4-487A-413F-9F45-C167F21FA283F914499C-2AF3-4F08-B163-695E2D5A6320[null][null]2345141723451417196913272FBCF0D4-487A-413F-9F45-C167F21FA283[null][null]2345141719716967102017Shore fishes of French Polynesia[null][null][null]41[null]3245-278[null][null][null]2017[null][null][null]2017-01-01 00:00:00.0002017-12-31 00:00:00.000[null]Siu et al. 2017Siu, Bacchet, Bernardi, Brooks, Carlot, Causse, Claudet, Clua, Delrieu-Trottin, Espiau, Harmelin-Vivien, Keith, Lecchini, Madi-Moussa, Parravicini, Planes, Ponsonnet, Randall, Sasal, Taquet, Williams & GalzinSiu, Gilles, Philippe Bacchet, Giacomo Bernardi, Andrew J. Brooks, Jeremy Carlot, Romain Causse, Joachim Claudet, Éric Clua, Erwan Delrieu-Trottin, Benoit Espiau, Mierelle L. Harmelin-Vivien, Philippe Keith, David Lecchini, Rakamaly Madi-Moussa, Valeriano Parravicini, Serge Planes, Cédric Ponsonnet, John E. Randall, Pierre Sasal, Marc Taquet, Jeffrey T. Williams & René Galzin<em>Cybium</em> <b>41</b>(3): 245-278.Shore fishes of French Polynesia 2597990F914499C-2AF3-4F08-B163-695E2D5A6320382597990[null]83162597990Marquesas Islands[null]1[null][null][null][null]-9.4544444-139.388888938310[empty string][null][null][null][null]-10.9249755646-141.025851791-7.6184060219-138.3342014
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:2 ms
CFQUERYPARAMS:
  1. Type=CF_SQL_VARCHAR; Data=[F914499C-2AF3-4F08-B163-695E2D5A6320]; Direction=IN; Variable=null