Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.63 KB | None | 0 0
  1. SELECT systementi0_.Id AS Id26_0_, systementi0_.Version AS Version26_0_, systementi0_.Name AS Name26_0_, systementi0_4_.OnCreate AS OnCreate30_0_, systementi0_9_.SystemEntity_OnCreate AS SystemEn2_35_0_, systementi0_9_.SystemEntity_OnValidate AS SystemEn3_35_0_, systementi0_9_.SystemEntity_OnChange AS SystemEn4_35_0_, systementi0_9_.SystemEntity_OnDelete AS SystemEn5_35_0_, systementi0_9_.SystemEntity_OnCloseLifeInterval AS SystemEn6_35_0_, systementi0_10_.ReferenceValueTypeId AS Referenc2_36_0_, systementi0_11_.HierarchicalReferenceValueTypeId AS Hierarch2_37_0_, systementi0_11_.HierarchicalReferenceId AS Hierarch3_37_0_, CASE WHEN systementi0_3_.Id IS NOT NULL THEN 3 WHEN systementi0_2_.Id IS NOT NULL THEN 2 WHEN systementi0_4_.Id IS NOT NULL THEN 4 WHEN systementi0_6_.Id IS NOT NULL THEN 6 WHEN systementi0_11_.Id IS NOT NULL THEN 11 WHEN systementi0_16_.Id IS NOT NULL THEN 16 WHEN systementi0_17_.Id IS NOT NULL THEN 17 WHEN systementi0_20_.Id IS NOT NULL THEN 20 WHEN systementi0_21_.Id IS NOT NULL THEN 21 WHEN systementi0_19_.Id IS NOT NULL THEN 19 WHEN systementi0_10_.Id IS NOT NULL THEN 10 WHEN systementi0_12_.Id IS NOT NULL THEN 12 WHEN systementi0_13_.Id IS NOT NULL THEN 13 WHEN systementi0_14_.Id IS NOT NULL THEN 14 WHEN systementi0_15_.Id IS NOT NULL THEN 15 WHEN systementi0_18_.Id IS NOT NULL THEN 18 WHEN systementi0_1_.Id IS NOT NULL THEN 1 WHEN systementi0_5_.Id IS NOT NULL THEN 5 WHEN systementi0_7_.Id IS NOT NULL THEN 7 WHEN systementi0_8_.Id IS NOT NULL THEN 8 WHEN systementi0_9_.Id IS NOT NULL THEN 9 WHEN systementi0_22_.Id IS NOT NULL THEN 22 WHEN systementi0_.Id IS NOT NULL THEN 0 END AS clazz_0_ FROM [SystemEntityType] systementi0_ LEFT OUTER JOIN [EventType] systementi0_1_ ON systementi0_.Id=systementi0_1_.Id LEFT OUTER JOIN [IntervalEventType] systementi0_2_ ON systementi0_.Id=systementi0_2_.Id LEFT OUTER JOIN [UserDefinedEventType] systementi0_3_ ON systementi0_.Id=systementi0_3_.Id LEFT OUTER JOIN [RestructuringEventType] systementi0_4_ ON systementi0_.Id=systementi0_4_.Id LEFT OUTER JOIN [FilterType] systementi0_5_ ON systementi0_.Id=systementi0_5_.Id LEFT OUTER JOIN [MonoFilterType] systementi0_6_ ON systementi0_.Id=systementi0_6_.Id LEFT OUTER JOIN [ObjectSetType] systementi0_7_ ON systementi0_.Id=systementi0_7_.Id LEFT OUTER JOIN [SystemFunctionType] systementi0_8_ ON systementi0_.Id=systementi0_8_.Id LEFT OUTER JOIN [SystemUnitType] systementi0_9_ ON systementi0_.Id=systementi0_9_.Id LEFT OUTER JOIN [ClassificationPositionType] systementi0_10_ ON systementi0_.Id=systementi0_10_.Id LEFT OUTER JOIN [HierarchicalClassificationPositionType] systementi0_11_ ON systementi0_.Id=systementi0_11_.Id LEFT OUTER JOIN [ClassificationPositionViewType] systementi0_12_ ON systementi0_.Id=systementi0_12_.Id LEFT OUTER JOIN [DocumentType] systementi0_13_ ON systementi0_.Id=systementi0_13_.Id LEFT OUTER JOIN [RealEstateUnitType] systementi0_14_ ON systementi0_.Id=systementi0_14_.Id LEFT OUTER JOIN [ReferenceValueType] systementi0_15_ ON systementi0_.Id=systementi0_15_.Id LEFT OUTER JOIN [HierarchicalReferenceValueType] systementi0_16_ ON systementi0_.Id=systementi0_16_.Id LEFT OUTER JOIN [LinearReferenceValueType] systementi0_17_ ON systementi0_.Id=systementi0_17_.Id LEFT OUTER JOIN [SubjectType] systementi0_18_ ON systementi0_.Id=systementi0_18_.Id LEFT OUTER JOIN [PermissionsSubjectType] systementi0_19_ ON systementi0_.Id=systementi0_19_.Id LEFT OUTER JOIN [PermissionsGroupType] systementi0_20_ ON systementi0_.Id=systementi0_20_.Id LEFT OUTER JOIN [PermissionsNodeType] systementi0_21_ ON systementi0_.Id=systementi0_21_.Id LEFT OUTER JOIN [TaskType] systementi0_22_ ON systementi0_.Id=systementi0_22_.Id WHERE systementi0_.Id=@p0;@p0 = 51
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement