Get all users who writes a response post (also including the post author) to a a set of questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @postId1 as int,@postId2 as int,@postId3 as int,@postId4 as int,@postId5 as int
declare @postId6 as int,@postId7 as int,@postId8 as int,@postId9 as int,@postId10 as int
set @postId1 = 2512683;
set @postId2 = 2512691;
set @postId3 = 2512696;
set @postId4 = 2512698;
set @postId5 = 2512702;
set @postId6 = 2512713;
set @postId7 = 2512717;
set @postId8 = 2512718;
set @postId9 = 2512720;
set @postId10 = 2512723;

select y.Id,y.Reputation,y.CreationDate,y.DisplayName,y.LastAccessDate,y.WebsiteUrl,y.Location,y.AboutMe,y.Views,y.UpVotes,y.DownVotes,y.ProfileImageUrl,y.EmailHash,y.AccountId from 
( select OwnerUserId from Posts where Id = @postId1 or Id = @postId2 or Id = @postId3 or Id = @postId4 or Id = @postId5 or Id = @postId6 or Id = @postId7 or Id = @postId8 or Id = @postId9 or Id = @postId10  
union
select OwnerUserId from Posts where ParentId = @postId1 or ParentId = @postId2 or ParentId = @postId3 or ParentId = @postId4 or ParentId = @postId5 or ParentId = @postId6 or ParentId = @postId7 or ParentId = @postId8 or ParentId = @postId9 or ParentId = @postId10
) x
inner join 
Users y
on x.OwnerUserId = y.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results