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