1 | 8A095659-80F5-466E-A765-B7FAD980216D | 8C91E1F7-4CCB-4FA8-889D-49172B9205BF | 524 | 528 | 19719849 | 19719849 | 19691327 | 8A095659-80F5-466E-A765-B7FAD980216D | [null] | 115178 | 19719849 | 19722182 | 1 | 0 | 1900 | Contributions to the ichthyology of the tropical Pacific | [null] | [null] | [null] | 52 | [null] | 3 | 493-528, pls. 18-20 | [null] | [null] | [null] | 31 Oct.-6 Nov. | [null] | [null] | [null] | 1900-10-31 00:00:00.000 | 1900-11-06 00:00:00.000 | [null] | Fowler 1900 | Fowler | Fowler, Henry W. | <em>Proceedings of the Academy of Natural Sciences of Philadelphia</em> <b>52</b>(3): 493-528, pls. 18-20. | Contributions to the ichthyology of the tropical Pacific | 5289481 | 8C91E1F7-4CCB-4FA8-889D-49172B9205BF | 38 | 5289481 | [empty string] | [null] | 5289481 | Samoan Islands | [null] | 1 | [null] | [null] | [null] | [null] | -14.2027726459 | -171.37578125 | 5 | [null] | The Samoan Islands or Samoa Islands is an archipelago covering 3,030 km2 (1,170 sq mi) in the central South Pacific, forming part of Polynesia and the wider region of Oceania. The population of the Samoan Islands is approximately 250,000, sharing a common language, Samoan, a culture, known as fa'a Samoa and an indigenous form of governance called fa'amatai.[1]
Today, the islands have two jurisdictions, the independent country of Samoa in the western half of the islands, and the territory of American Samoa comprising the islands to the east. The two regions are separated by 64 km of ocean. Most Samoans are full-blooded and are one of the largest Polynesian populations in the world.[2] | [null] | [null] | [null] | [null] | -14.6416760442 | -172.825976563 | -13.4239724477 | -168.099108887 |
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 |