SELECT
[Extent1].[Id] AS [Id],
[Extent1].[OpticalParameterId] AS [OpticalParameterId],
[Extent1].[SeriesId] AS [SeriesId],
[Extent1].[PhysicianId] AS [PhysicianId],
[Extent1].[ContrastId] AS [ContrastId],
[Extent1].[DicomUid] AS [DicomUid],
[Extent1].[Uid] AS [Uid],
[Extent1].[SopClassUid] AS [SopClassUid],
[Extent1].[FileName] AS [FileName],
[Extent1].[FocalDistance] AS [FocalDistance],
[Extent1].[EntranceDose] AS [EntranceDose],
[Extent1].[Dose] AS [Dose],
[Extent1].[ExternalFilm] AS [ExternalFilm],
[Extent1].[ImagePreview] AS [ImagePreview],
[Extent1].[FileSize] AS [FileSize],
[Extent1].[DateCreation] AS [DateCreation],
[Extent1].[Status] AS [Status],
[Extent1].[DoseIndicator] AS [DoseIndicator],
[Extent1].[DoseIndicatorDeviation] AS [DoseIndicatorDeviation],
[Extent1].[DoseIndicatorResult] AS [DoseIndicatorResult],
[Extent1].[ImageType] AS [ImageType],
[Extent1].[MultiframeTypeId] AS [MultiframeTypeId],
CAST( [Extent1].[FrameRate] AS tinyint) AS [C1],
[Extent1].[CurveTypeId] AS [CurveTypeId],
[Extent1].[HightQuality] AS [HightQuality],
[Extent1].[IsFilm] AS [IsFilm],
[Extent1].[Kv] AS [Kv],
[Extent1].[Ma] AS [Ma],
[Extent1].[Ms] AS [Ms],
[Extent1].[Mas] AS [Mas],
[Extent1].[PostProccesTlsPath] AS [PostProccesTlsPath],
[Extent1].[MaskFrameNumber] AS [MaskFrameNumber],
[Extent1].[IsSubtractionEnabled] AS [IsSubtractionEnabled],
[Extent1].[XSubtractionShift] AS [XSubtractionShift],
[Extent1].[YSubtractionShift] AS [YSubtractionShift],
[Extent1].[Landmark] AS [Landmark],
[Extent1].[Comment] AS [Comment],
[Extent1].[TomoLayerHeight] AS [TomoLayerHeight],
[Extent1].[ImagePixelSpacing] AS [ImagePixelSpacing],
[Extent1].[FluoroKv] AS [FluoroKv],
[Extent1].[FluoroMa] AS [FluoroMa],
[Extent1].[TubeHeat] AS [TubeHeat],
[Extent1].[ReopField] AS [ReopField],
[Extent2].[Id] AS [Id1],
[Extent2].[XOffset] AS [XOffset],
[Extent2].[YOffset] AS [YOffset],
[Extent2].[Scale] AS [Scale],
[Extent2].[CircleShutterId] AS [CircleShutterId],
[Extent2].[RectangleShutterId] AS [RectangleShutterId],
[Extent2].[Window] AS [Window],
[Extent2].[Level] AS [Level],
[Extent2].[Gamma] AS [Gamma],
[Extent2].[LLateralityIsVisible] AS [LLateralityIsVisible],
[Extent2].[RLateralityIsVisible] AS [RLateralityIsVisible],
[Extent2].[LLateralityX] AS [LLateralityX],
[Extent2].[LLateralityY] AS [LLateralityY],
[Extent2].[RLateralityX] AS [RLateralityX],
[Extent2].[RLateralityY] AS [RLateralityY],
[Extent2].[LateralityAngle] AS [LateralityAngle],
[Extent2].[LLateralityTranslatedX] AS [LLateralityTranslatedX],
[Extent2].[LLateralityTranslatedY] AS [LLateralityTranslatedY],
[Extent2].[RLateralityTranslatedX] AS [RLateralityTranslatedX],
[Extent2].[RLateralityTranslatedY] AS [RLateralityTranslatedY],
[Extent2].[ShutterAngle] AS [ShutterAngle],
[Extent2].[Rotate] AS [Rotate],
[Extent2].[Flip] AS [Flip],
[Extent2].[IsInverse] AS [IsInverse],
[Extent2].[Substraction] AS [Substraction],
[Extent2].[MaskFrameNumber] AS [MaskFrameNumber1],
[Extent2].[HorizontalPixelShift] AS [HorizontalPixelShift],
[Extent2].[VerticalPixelShift] AS [VerticalPixelShift],
[Extent2].[Landmark] AS [Landmark1],
[Extent2].[OverlayData] AS [OverlayData],
[Extent3].[Id] AS [Id2],
[Extent3].[X] AS [X],
[Extent3].[Y] AS [Y],
[Extent3].[Radius] AS [Radius],
[Extent3].[Color] AS [Color],
[Extent3].[XTranslated] AS [XTranslated],
[Extent3].[YTranslated] AS [YTranslated],
[Extent4].[Id] AS [Id3],
[Extent4].[X] AS [X1],
[Extent4].[Y] AS [Y1],
[Extent4].[Width] AS [Width],
[Extent4].[Height] AS [Height],
[Extent4].[Color] AS [Color1],
[Extent4].[XTranslated] AS [XTranslated1],
[Extent4].[YTranslated] AS [YTranslated1],
[Extent4].[WidthTranslated] AS [WidthTranslated],
[Extent4].[HeightTranslated] AS [HeightTranslated]
FROM    [dbo].[Image] AS [Extent1]
INNER JOIN [dbo].[ImageOpticalParameters] AS [Extent2] ON [Extent1].[OpticalParameterId] = [Extent2].[Id]
LEFT OUTER JOIN [dbo].[CircleShutter] AS [Extent3] ON [Extent2].[CircleShutterId] = [Extent3].[Id]
LEFT OUTER JOIN [dbo].[RectangleShutter] AS [Extent4] ON [Extent2].[RectangleShutterId] = [Extent4].[Id]