SELECT [Extent1].[Id] AS [Id], [Extent1].[ImageArchiveId] AS [ImageArchiveId], [Extent1].[ImageSequenceNumber] AS [ImageSequenceNumber], [Extent1].[Side] AS [Side], [Extent1].[Condition] AS [Condition], [Extent1].[DistanceFromCentreLineLeft] AS [DistanceFromCentreLineLeft], [Extent1].[DistanceFromCentreLineRight] AS [DistanceFromCentreLineRight], [Extent1].[XCoordTop] AS [XCoordTop], [Extent1].[XCoordBottom] AS [XCoordBottom], [Extent1].[YCoordTop] AS [YCoordTop], [Extent1].[YCoordBottom] AS [YCoordBottom], [Extent1].[MarkerType] AS [MarkerType], [Extent1].[MarkerWidth] AS [MarkerWidth], [Extent1].[MarkerHeight] AS [MarkerHeight], [Extent1].[MarkerColorR] AS [MarkerColorR], [Extent1].[MarkerColorG] AS [MarkerColorG], [Extent1].[MarkerColorB] AS [MarkerColorB], [Extent1].[ShowOnMap] AS [ShowOnMap], [Extent1].[Height] AS [Height], [Extent1].[Width] AS [Width], [Extent1].[LENGTH] AS [LENGTH], [Extent1].[DistanceFromDriver] AS [DistanceFromDriver], [Extent1].[Visibility] AS [Visibility], [Extent1].[Name] AS [Name], [Extent1].[TYPE] AS [TYPE], [Extent1].[Priority] AS [Priority], [Extent1].[ParentAssetId] AS [ParentAssetId], [Extent1].[ImageTimeStamp] AS [ImageTimeStamp], [Extent1].[AssetId] AS [AssetId], [Extent1].[Miles] AS [Miles], [Extent1].[Yards] AS [Yards], [Extent1].[Latitude] AS [Latitude], [Extent1].[Longitude] AS [Longitude], [Extent1].[CameraId] AS [CameraId], [Extent1].[Division] AS [Division], [Extent1].[SubDivision] AS [SubDivision], [Extent1].[Segment] AS [Segment], [Extent1].[TrackId] AS [TrackId], [Extent1].[AssetTypeId] AS [AssetTypeId], [Extent1].[IsCommonTrackAsset] AS [IsCommonTrackAsset], [Extent1].[FamilyId] AS [FamilyId] FROM (SELECT [AssetsWithImageNumbers].[Id] AS [Id], [AssetsWithImageNumbers].[ImageArchiveId] AS [ImageArchiveId], [AssetsWithImageNumbers].[ImageSequenceNumber] AS [ImageSequenceNumber], [AssetsWithImageNumbers].[Side] AS [Side], [AssetsWithImageNumbers].[Condition] AS [Condition], [AssetsWithImageNumbers].[DistanceFromCentreLineLeft] AS [DistanceFromCentreLineLeft], [AssetsWithImageNumbers].[DistanceFromCentreLineRight] AS [DistanceFromCentreLineRight], [AssetsWithImageNumbers].[XCoordTop] AS [XCoordTop], [AssetsWithImageNumbers].[XCoordBottom] AS [XCoordBottom], [AssetsWithImageNumbers].[YCoordTop] AS [YCoordTop], [AssetsWithImageNumbers].[YCoordBottom] AS [YCoordBottom], [AssetsWithImageNumbers].[MarkerType] AS [MarkerType], [AssetsWithImageNumbers].[MarkerWidth] AS [MarkerWidth], [AssetsWithImageNumbers].[MarkerHeight] AS [MarkerHeight], [AssetsWithImageNumbers].[MarkerColorR] AS [MarkerColorR], [AssetsWithImageNumbers].[MarkerColorG] AS [MarkerColorG], [AssetsWithImageNumbers].[MarkerColorB] AS [MarkerColorB], [AssetsWithImageNumbers].[ShowOnMap] AS [ShowOnMap], [AssetsWithImageNumbers].[Height] AS [Height], [AssetsWithImageNumbers].[Width] AS [Width], [AssetsWithImageNumbers].[LENGTH] AS [LENGTH], [AssetsWithImageNumbers].[DistanceFromDriver] AS [DistanceFromDriver], [AssetsWithImageNumbers].[Visibility] AS [Visibility], [AssetsWithImageNumbers].[Name] AS [Name], [AssetsWithImageNumbers].[TYPE] AS [TYPE], [AssetsWithImageNumbers].[Priority] AS [Priority], [AssetsWithImageNumbers].[ParentAssetId] AS [ParentAssetId], [AssetsWithImageNumbers].[ImageTimeStamp] AS [ImageTimeStamp], [AssetsWithImageNumbers].[AssetId] AS [AssetId], [AssetsWithImageNumbers].[Miles] AS [Miles], [AssetsWithImageNumbers].[Yards] AS [Yards], [AssetsWithImageNumbers].[Latitude] AS [Latitude], [AssetsWithImageNumbers].[Longitude] AS [Longitude], [AssetsWithImageNumbers].[CameraId] AS [CameraId], [AssetsWithImageNumbers].[Division] AS [Division], [AssetsWithImageNumbers].[SubDivision] AS [SubDivision], [AssetsWithImageNumbers].[Segment] AS [Segment], [AssetsWithImageNumbers].[TrackId] AS [TrackId], [AssetsWithImageNumbers].[AssetTypeId] AS [AssetTypeId], [AssetsWithImageNumbers].[IsCommonTrackAsset] AS [IsCommonTrackAsset], [AssetsWithImageNumbers].[FamilyId] AS [FamilyId] FROM [dbo].[AssetsWithImageNumbers] AS [AssetsWithImageNumbers]) AS [Extent1] ORDER BY [Extent1].[ImageTimeStamp] ASC
Comments