Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [Extent1].[id] AS [id],
- [Extent1].[created] AS [created],
- [Extent1].[modified] AS [modified],
- [Extent1].[userID] AS [userID],
- [Extent1].[repostID] AS [repostID],
- [Extent1].[commentsCount] AS [commentsCount],
- [Extent1].[isDisableComments] AS [isDisableComments],
- [Extent1].[likeCount] AS [likeCount],
- [Extent1].[dislikeCount] AS [dislikeCount],
- [Extent1].[title] AS [title],
- [Extent1].[isNews] AS [isNews],
- [Extent1].[isApproved] AS [isApproved],
- [Extent1].[approved] AS [approved],
- [Extent1].[isBlocked] AS [isBlocked],
- [Extent1].[blocked] AS [blocked],
- [Extent1].[blockedComment] AS [blockedComment],
- [Extent1].[isDeleted] AS [isDeleted],
- [Extent1].[deleted] AS [deleted],
- [Extent1].[repostText] AS [repostText],
- [Extent1].[topCreated] AS [topCreated],
- [Extent1].[topDeadline] AS [topDeadline],
- [Extent1].[topNum] AS [topNum],
- [Extent1].[sortDate] AS [sortDate],
- [Extent1].[onlyForSubscribers] AS [onlyForSubscribers],
- [Extent1].[typeID] AS [typeID],
- [Extent1].[isGallery] AS [isGallery],
- [Extent1].[lastCommentCreated] AS [lastCommentCreated],
- [Extent1].[viewCount] AS [viewCount],
- [Extent1].[isCompetition] AS [isCompetition],
- [Extent1].[isAudio] AS [isAudio],
- [Extent1].[pollID] AS [pollID],
- [Extent1].[isDisablePP] AS [isDisablePP],
- [Extent1].[isPhotoReport] AS [isPhotoReport],
- [Extent1].[previewID] AS [previewID],
- [Extent2].[id] AS [id1],
- [Extent2].[first] AS [first],
- [Extent2].[last] AS [last],
- [Extent2].[email] AS [email],
- [Extent2].[phone] AS [phone],
- [Extent2].[birthDate] AS [birthDate],
- [Extent2].[site] AS [site],
- [Extent2].[vk] AS [vk],
- [Extent2].[fb] AS [fb],
- [Extent2].[ok] AS [ok],
- [Extent2].[ig] AS [ig],
- [Extent2].[slag] AS [slag],
- [Extent2].[photo] AS [photo],
- [Extent2].[photoThumb] AS [photoThumb],
- [Extent2].[cover] AS [cover],
- [Extent2].[statusText] AS [statusText],
- [Extent2].[whoCanSendMeMessage] AS [whoCanSendMeMessage],
- [Extent2].[whoCanCommentMyPost] AS [whoCanCommentMyPost],
- [Extent2].[whoCanCommentMyNews] AS [whoCanCommentMyNews],
- [Extent2].[newMessageEmailAlert] AS [newMessageEmailAlert],
- [Extent2].[denyMyWallForNotAuthUsers] AS [denyMyWallForNotAuthUsers],
- [Extent2].[isDeleted] AS [isDeleted1],
- [Extent2].[deleted] AS [deleted1],
- [Extent2].[deletedUserComment] AS [deletedUserComment],
- [Extent2].[isBlocked] AS [isBlocked1],
- [Extent2].[blocked] AS [blocked1],
- [Extent2].[blockedDeadline] AS [blockedDeadline],
- [Extent2].[blockedComment] AS [blockedComment1],
- [Extent2].[username] AS [username],
- [Extent2].[showEmail] AS [showEmail],
- [Extent2].[showPhone] AS [showPhone],
- [Extent2].[newPostSubscribersAlertEmail] AS [newPostSubscribersAlertEmail],
- [Extent2].[topPostID] AS [topPostID],
- [Extent2].[virtualWalletBalance] AS [virtualWalletBalance],
- [Extent3].[id] AS [id2],
- [Extent3].[created] AS [created1],
- [Extent3].[modified] AS [modified1],
- [Extent3].[userID] AS [userID1],
- [Extent3].[repostID] AS [repostID1],
- [Extent3].[commentsCount] AS [commentsCount1],
- [Extent3].[isDisableComments] AS [isDisableComments1],
- [Extent3].[likeCount] AS [likeCount1],
- [Extent3].[dislikeCount] AS [dislikeCount1],
- [Extent3].[title] AS [title1],
- [Extent3].[isNews] AS [isNews1],
- [Extent3].[isApproved] AS [isApproved1],
- [Extent3].[approved] AS [approved1],
- [Extent3].[isBlocked] AS [isBlocked2],
- [Extent3].[blocked] AS [blocked2],
- [Extent3].[blockedComment] AS [blockedComment2],
- [Extent3].[isDeleted] AS [isDeleted2],
- [Extent3].[deleted] AS [deleted2],
- [Extent3].[repostText] AS [repostText1],
- [Extent3].[topCreated] AS [topCreated1],
- [Extent3].[topDeadline] AS [topDeadline1],
- [Extent3].[topNum] AS [topNum1],
- [Extent3].[sortDate] AS [sortDate1],
- [Extent3].[onlyForSubscribers] AS [onlyForSubscribers1],
- [Extent3].[typeID] AS [typeID1],
- [Extent3].[isGallery] AS [isGallery1],
- [Extent3].[lastCommentCreated] AS [lastCommentCreated1],
- [Extent3].[viewCount] AS [viewCount1],
- [Extent3].[isCompetition] AS [isCompetition1],
- [Extent3].[isAudio] AS [isAudio1],
- [Extent3].[pollID] AS [pollID1],
- [Extent3].[isDisablePP] AS [isDisablePP1],
- [Extent3].[isPhotoReport] AS [isPhotoReport1],
- [Extent3].[previewID] AS [previewID1],
- [Extent4].[id] AS [id3],
- [Extent4].[first] AS [first1],
- [Extent4].[last] AS [last1],
- [Extent4].[email] AS [email1],
- [Extent4].[phone] AS [phone1],
- [Extent4].[birthDate] AS [birthDate1],
- [Extent4].[site] AS [site1],
- [Extent4].[vk] AS [vk1],
- [Extent4].[fb] AS [fb1],
- [Extent4].[ok] AS [ok1],
- [Extent4].[ig] AS [ig1],
- [Extent4].[slag] AS [slag1],
- [Extent4].[photo] AS [photo1],
- [Extent4].[photoThumb] AS [photoThumb1],
- [Extent4].[cover] AS [cover1],
- [Extent4].[statusText] AS [statusText1],
- [Extent4].[whoCanSendMeMessage] AS [whoCanSendMeMessage1],
- [Extent4].[whoCanCommentMyPost] AS [whoCanCommentMyPost1],
- [Extent4].[whoCanCommentMyNews] AS [whoCanCommentMyNews1],
- [Extent4].[newMessageEmailAlert] AS [newMessageEmailAlert1],
- [Extent4].[denyMyWallForNotAuthUsers] AS [denyMyWallForNotAuthUsers1],
- [Extent4].[isDeleted] AS [isDeleted3],
- [Extent4].[deleted] AS [deleted3],
- [Extent4].[deletedUserComment] AS [deletedUserComment1],
- [Extent4].[isBlocked] AS [isBlocked3],
- [Extent4].[blocked] AS [blocked3],
- [Extent4].[blockedDeadline] AS [blockedDeadline1],
- [Extent4].[blockedComment] AS [blockedComment3],
- [Extent4].[username] AS [username1],
- [Extent4].[showEmail] AS [showEmail1],
- [Extent4].[showPhone] AS [showPhone1],
- [Extent4].[newPostSubscribersAlertEmail] AS [newPostSubscribersAlertEmail1],
- [Extent4].[topPostID] AS [topPostID1],
- [Extent4].[virtualWalletBalance] AS [virtualWalletBalance1],
- [Extent5].[id] AS [id4],
- [Extent5].[name] AS [name],
- [Extent5].[code] AS [code],
- [Extent5].[ord] AS [ord],
- [Extent5].[IsDeleted] AS [isDeleted4],
- [Extent6].[id] AS [id5],
- [Extent6].[data] AS [data],
- [Extent6].[code] AS [code1],
- [Extent6].[guid] AS [guid],
- [Extent6].[data2] AS [data2],
- [Extent6].[data3] AS [data3]
- FROM [dbo].[us_posts] AS [Extent1]
- LEFT OUTER JOIN [dbo].[us_profile] AS [Extent2] ON [Extent1].[userID] = [Extent2].[id]
- LEFT OUTER JOIN [dbo].[us_posts] AS [Extent3] ON [Extent1].[repostID] = [Extent3].[id]
- LEFT OUTER JOIN [dbo].[us_profile] AS [Extent4] ON [Extent3].[userID] = [Extent4].[id]
- LEFT OUTER JOIN [dbo].[us_postTypes] AS [Extent5] ON [Extent1].[typeID] = [Extent5].[id]
- LEFT OUTER JOIN [dbo].[us_resources] AS [Extent6] ON [Extent1].[previewID] = [Extent6].[id]
- WHERE (( NOT ((1 = [Extent1].[isDeleted]) AND ([Extent1].[isDeleted] IS NOT NULL))) AND ( NOT ((1 = [Extent1].[isBlocked])
- AND ([Extent1].[isBlocked] IS NOT NULL))) AND ((([Extent1].[isNews] IS NOT NULL)
- AND ([Extent1].[isApproved] = 1)) OR ([Extent1].[isNews] IS NULL)
- OR ( NOT ((1 = [Extent1].[isNews]) AND ([Extent1].[isNews] IS NOT NULL)))))
- OR (([Extent1].[isGallery] IS NOT NULL) AND ([Extent1].[isApproved] = 1)) OR ([Extent1].[isGallery] IS NULL) OR
- ( NOT ((1 = [Extent1].[isGallery]) AND ([Extent1].[isGallery] IS NOT NULL)))
- go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement