1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
| SELECT
'Imagence:Igwsomain:IgwsElements:VersionElements:VersionElement' AS [EntityType] ,
[e0] .[IgwsElementId] AS [ParentId] ,
[e1] .[VersionElementId] AS [pkVersionElementId] ,
[e1] .[IgwsId] AS [IgwsId] ,
[e1] .[VersionType] AS [VersionType] ,
[e1] .[VersionNumber] AS [VersionNumber] ,
[e1] .[Title] AS [Title] ,
[e1] .[Abstract] AS [Abstract] ,
[e1] .[Content] AS [Content] ,
[e1] .[Link] AS [Link] ,
[e1] .[CreationDate] AS [CreationDate] ,
[e1] .[LastModificationDate] AS [LastModificationDate] ,
[e1] .[VisibleDate] AS [VisibleDate] ,
NULL AS [EventLocation] ,
NULL AS [EventSponsor] ,
NULL AS [EventMinutes] ,
NULL AS [EventStartDate] ,
NULL AS [EventEndDate] ,
NULL AS [EventSpeakers] ,
NULL AS [EventProgram]
FROM [VersionElement] AS [e1]
INNER JOIN [IgwsElement] AS [e0]
ON ([e0] .[IgwsElementId] = [e1] .[FK_VersionableElementId] )
WHERE ([e0] .[IgwsElementType] IN ('Article' ) )
And ([e0] .[IgwsElementId] IN ('a57065c4-c384-47dd-8769-86084da91278' ) )
And (([e1] .[VersionElementType] = 'VersionElement' ) )
UNION ALL
SELECT
'Imagence:Igwsomain:IgwsElements:VersionElements:IgwsEventVersion' AS [EntityType] ,
[e0] .[IgwsElementId] AS [ParentId] ,
[e4] .[VersionElementId] AS [pkVersionElementId] ,
[e4] .[IgwsId] AS [IgwsId] ,
[e4] .[VersionType] AS [VersionType] ,
[e4] .[VersionNumber] AS [VersionNumber] ,
[e4] .[Title] AS [Title] ,
[e4] .[Abstract] AS [Abstract] ,
[e4] .[Content] AS [Content] ,
[e4] .[Link] AS [Link] ,
[e4] .[CreationDate] AS [CreationDate] ,
[e4] .[LastModificationDate] AS [LastModificationDate] ,
[e4] .[VisibleDate] AS [VisibleDate] ,
[e4] .[EventLocation] AS [EventLocation] ,
[e4] .[EventSponsor] AS [EventSponsor] ,
[e4] .[EventMinutes] AS [EventMinutes] ,
[e4] .[EventStartDate] AS [EventStartDate] ,
[e4] .[EventEndDate] AS [EventEndDate] ,
[e4] .[EventSpeakers] AS [EventSpeakers] ,
[e4] .[EventProgram] AS [EventProgram]
FROM [VersionElement] AS [e4]
INNER JOIN [IgwsElement] AS [e0]
ON ([e0] .[IgwsElementId] = [e4] .[FK_VersionableElementId] )
WHERE ([e0] .[IgwsElementType] IN ('Article' ) )
And ([e0] .[IgwsElementId] IN ('a57065c4-c384-47dd-8769-86084da91278' ) )
And (([e4] .[VersionElementType] = 'IgwsEventVersion' ) )
UNION ALL
SELECT
'Imagence:Igwsomain:IgwsElements:VersionElements:HtmlTextVersion' AS [EntityType] ,
[e0] .[IgwsElementId] AS [ParentId] ,
[e3] .[VersionElementId] AS [pkVersionElementId] ,
[e3] .[IgwsId] AS [IgwsId] ,
[e3] .[VersionType] AS [VersionType] ,
[e3] .[VersionNumber] AS [VersionNumber] ,
[e3] .[Title] AS [Title] ,
[e3] .[Abstract] AS [Abstract] ,
[e3] .[Content] AS [Content] ,
[e3] .[Link] AS [Link] ,
[e3] .[CreationDate] AS [CreationDate] ,
[e3] .[LastModificationDate] AS [LastModificationDate] ,
[e3] .[VisibleDate] AS [VisibleDate] ,
NULL AS [EventLocation] ,
NULL AS [EventSponsor] ,
NULL AS [EventMinutes] ,
NULL AS [EventStartDate] ,
NULL AS [EventEndDate] ,
NULL AS [EventSpeakers] ,
NULL AS [EventProgram]
FROM [VersionElement] AS [e3]
INNER JOIN [IgwsElement] AS [e0]
ON ([e0] .[IgwsElementId] = [e3] .[FK_VersionableElementId] )
WHERE ([e0] .[IgwsElementType] IN ('Article' ) )
And ([e0] .[IgwsElementId] IN ('a57065c4-c384-47dd-8769-86084da91278' ) )
And (([e3] .[VersionElementType] = 'HtmlTextVersion' ) )
UNION ALL
SELECT
'Imagence:Igwsomain:IgwsElements:VersionElements:ArticleVersion' AS [EntityType] ,
[e0] .[IgwsElementId] AS [ParentId] ,
[e2] .[VersionElementId] AS [pkVersionElementId] ,
[e2] .[IgwsId] AS [IgwsId] ,
[e2] .[VersionType] AS [VersionType] ,
[e2] .[VersionNumber] AS [VersionNumber] ,
[e2] .[Title] AS [Title] ,
[e2] .[Abstract] AS [Abstract] ,
[e2] .[Content] AS [Content] ,
[e2] .[Link] AS [Link] ,
[e2] .[CreationDate] AS [CreationDate] ,
[e2] .[LastModificationDate] AS [LastModificationDate] ,
[e2] .[VisibleDate] AS [VisibleDate] ,
NULL AS [EventLocation] ,
NULL AS [EventSponsor] ,
NULL AS [EventMinutes] ,
NULL AS [EventStartDate] ,
NULL AS [EventEndDate] ,
NULL AS [EventSpeakers] ,
NULL AS [EventProgram]
FROM [VersionElement] AS [e2]
INNER JOIN [IgwsElement] AS [e0]
ON ([e0] .[IgwsElementId] = [e2] .[FK_VersionableElementId] )
WHERE ([e0] .[IgwsElementType] IN ('Article' ) )
And ([e0] .[IgwsElementId] IN ('a57065c4-c384-47dd-8769-86084da91278' ) )
And (([e2] .[VersionElementType] = 'ArticleVersion' ) )
ORDER BY [pkVersionElementId] |
Partager