| query [long version] | | | ReferenceUUID | LocationUUID | Start_Page | End_Page | PKID | CorrectID | TableID | UUID | LegacyID | LegacyID2 | ReferenceID | ParentReferenceID | ReferenceTypeID | LanguageID | Year | Title | SecondaryTitle | Publisher | PlacePublished | Volume | NumberVolumes | Number | Pages | InPages | Section | Edition | DatePublished | TypeWork | ShortTitle | Figures | StartDate | EndDate | URL | CheatCitation | CheatAuthors | CheatFullAuthors | CheatCitationDetails | CheatSearchReference | Expr1 | Expr2 | FK_TableTypeID | Expr3 | CheatSearchString | Expr4 | PK_LocationID | Location_name | FK_CountryID | Active | Abbreviation | x_location | y_location | map_name | LocationDecimalLatitude | LocationDecimalLongitude | Echelon | FK_SubordID | location_description | height | width | y_rect_coords | x_rect_coords | SW_Bound_Lat | SW_Bound_Long | NE_Bound_Lat | NE_Bound_Long |
| 1 | 2FBCF0D4-487A-413F-9F45-C167F21FA283 | 63865AD4-FD5C-4C4B-A0A3-E46C4A458B2F | [null] | [null] | 23451417 | 23451417 | 19691327 | 2FBCF0D4-487A-413F-9F45-C167F21FA283 | [null] | [null] | 23451417 | 19716967 | 1 | 0 | 2017 | Shore fishes of French Polynesia | [null] | [null] | [null] | 41 | [null] | 3 | 245-278 | [null] | [null] | [null] | 2017 | [null] | [null] | [null] | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 | [null] | Siu et al. 2017 | Siu, Bacchet, Bernardi, Brooks, Carlot, Causse, Claudet, Clua, Delrieu-Trottin, Espiau, Harmelin-Vivien, Keith, Lecchini, Madi-Moussa, Parravicini, Planes, Ponsonnet, Randall, Sasal, Taquet, Williams & Galzin | Siu, 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 | 2601971 | 63865AD4-FD5C-4C4B-A0A3-E46C4A458B2F | 38 | 2601971 | [null] | 12297 | 2601971 | Tuamotu Islands | [null] | 1 | [null] | [null] | [null] | Karta_FP_Tuamotus_isl.PNG | -15.622977373 | -145.635026075 | 3 | 8310 | [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: | - Type=CF_SQL_VARCHAR; Data=[63865AD4-FD5C-4C4B-A0A3-E46C4A458B2F]; Direction=IN; Variable=null
|
Document your Adventure.