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