Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 4.32 KB | None | 0 0
  1. SELECT systemunit0_.Id AS Id19_, systemunit0_.Version AS Version19_, systemunit0_.IsDeleted AS IsDeleted19_, systemunit0_.DefaultName AS DefaultN5_19_, systemunit0_.SystemEntityTypeId AS SystemEn6_19_, systemunit0_.SystemUnitTypeId AS SystemU27_19_, systemunit0_.TheStart AS TheStart19_, systemunit0_.TheEnd AS TheEnd19_, systemunit0_.InitiatorId AS Initiato7_19_, systemunit0_.isActual AS isActual19_, systemunit0_.isPrimary AS isPrimary19_, systemunit0_.ClassificationPositionViewTypeId AS Classif30_19_, systemunit0_.ClassificationPositionId AS Classif31_19_, systemunit0_.DocumentTypeId AS Documen32_19_, systemunit0_.InformationSpaceUnitTypeId AS Informa33_19_, systemunit0_.OrderedSystemUnitIndex AS Ordered34_19_, systemunit0_.OrderedSystemUnitTypeId AS Ordered35_19_, systemunit0_.ClassificationPositionTypeId AS Classif36_19_, systemunit0_.HierarchicalClassificationPositionTypeId AS Hierarc37_19_, systemunit0_.ReferenceValueTypeId AS Referen38_19_, systemunit0_.HierarchicalReferenceValueTypeId AS Hierarc39_19_, systemunit0_.HierarchicalClassificationPositionId AS Hierarc40_19_, systemunit0_.HierarchicalReferenceValue_ParentId AS Hierarc41_19_, systemunit0_.LinearReferenceValueTypeId AS LinearR42_19_, systemunit0_.SubjectTypeId AS Subject43_19_, systemunit0_.PermissionsSubjectTypeId AS Permiss44_19_, systemunit0_.PermissionsGroupTypeId AS Permiss45_19_, systemunit0_.Userlogin AS Userlogin19_, systemunit0_.PermissionsNodeTypeId AS Permiss47_19_, systemunit0_.UserFileTypeId AS UserFil48_19_, systemunit0_.ClassDiscriminator AS ClassDis2_19_ FROM [SystemEntity] systemunit0_ INNER JOIN [Attribute] attributes1_ ON systemunit0_.Id=attributes1_.SystemUnitId INNER JOIN [FeatureValue] featureval2_ ON attributes1_.Id=featureval2_.FeatureAttributeId LEFT OUTER JOIN [VALUE] value3_ ON featureval2_.ValueId=value3_.Id INNER JOIN [Attribute] attributes4_ ON systemunit0_.Id=attributes4_.SystemUnitId INNER JOIN [Attribute] attributes5_ ON systemunit0_.Id=attributes5_.SystemUnitId WHERE systemunit0_.ClassDiscriminator IN ('18', '14', '13', '8', '7', '16', '17', '5', '2', '24') AND ((featureval2_.TheStart IS NULL OR featureval2_.TheStart<='634454756660097107') AND (featureval2_.TheEnd IS NULL OR featureval2_.TheEnd>'634454756660097107') AND attributes5_.AttributeTypeId=14 AND value3_.SystemEntityId=86234 AND (attributes4_.TheStart IS NULL OR attributes4_.TheStart<='634454756660097107') AND (attributes4_.TheEnd IS NULL OR attributes4_.TheEnd>'634454756660097107') AND attributes4_.AttributeTypeId=14 AND  NOT (EXISTS (SELECT systementi6_.Id FROM [SystemEntity] systementi6_ INNER JOIN [Attribute] attributes7_ ON systementi6_.Id=attributes7_.SystemUnitId INNER JOIN [FeatureValue] featureval8_ ON attributes7_.Id=featureval8_.FeatureAttributeId WHERE attributes7_.AttributeTypeId=14 AND attributes7_.Id=attributes4_.Id AND (featureval8_.TheStart IS NULL OR featureval8_.TheStart<='634454756660097107') AND (featureval8_.TheEnd IS NULL OR featureval8_.TheEnd>'634454756660097107'))) OR (attributes5_.TheStart IS NULL OR attributes5_.TheStart<='634454756660097107') AND (attributes5_.TheEnd IS NULL OR attributes5_.TheEnd>'634454756660097107') AND attributes5_.AttributeTypeId=14 AND  NOT (EXISTS (SELECT systementi9_.Id FROM [SystemEntity] systementi9_ INNER JOIN [Attribute] attributes10_ ON systementi9_.Id=attributes10_.SystemUnitId INNER JOIN [FeatureValue] featureval11_ ON attributes10_.Id=featureval11_.FeatureAttributeId WHERE attributes10_.AttributeTypeId=14 AND attributes10_.Id=attributes5_.Id AND (featureval11_.TheStart IS NULL OR featureval11_.TheStart<='634454756660097107') AND (featureval11_.TheEnd IS NULL OR featureval11_.TheEnd>'634454756660097107'))) AND (attributes4_.TheStart IS NULL OR attributes4_.TheStart<='634454756660097107') AND (attributes4_.TheEnd IS NULL OR attributes4_.TheEnd>'634454756660097107') AND attributes4_.AttributeTypeId=14 AND  NOT (EXISTS (SELECT systementi12_.Id FROM [SystemEntity] systementi12_ INNER JOIN [Attribute] attributes13_ ON systementi12_.Id=attributes13_.SystemUnitId INNER JOIN [FeatureValue] featureval14_ ON attributes13_.Id=featureval14_.FeatureAttributeId WHERE attributes13_.AttributeTypeId=14 AND attributes13_.Id=attributes4_.Id AND (featureval14_.TheStart IS NULL OR featureval14_.TheStart<='634454756660097107') AND (featureval14_.TheEnd IS NULL OR featureval14_.TheEnd>'634454756660097107')))) AND systemunit0_.SystemUnitTypeId=14
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement