people reached total

5

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/253579/include-the-people-reached-data-in-sede

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

Select Id, OwnerUserId 
                        From Posts 
                       Where PostTypeId = 1 
                       --  And OwnerUserId = ##UserId##
                      Union
                      Select ParentId, OwnerUserId
                        From Posts
                       Where PostTypeId = 2
                         And Id in (select AcceptedAnswerId from Posts)
                         -- And OwnerUserId = ##UserId##
                      Union
                      Select ParentId, OwnerUserId
                        From Posts
                       Where PostTypeId = 2
                         And Score > 5
                         -- And OwnerUserId = ##UserId##
                      Union
                      Select a.ParentId, a.OwnerUserId
                        From Posts a
                             Join Posts q On a.ParentId = q.Id
                       Where a.PostTypeId = 2
                         And a.Score > 0.20 * (select sum(Score) from Posts where ParentId=q.Id)
                         And a.Score > 0
                         -- And a.OwnerUserId = ##UserId##
                      /*Union
                      Select x.ParentId, x.OwnerUserId 
                        From (Select a.ParentId , Rank() Over(Partition By a.ParentId Order By ta.Score Desc) AnswerRank
                                From Posts a
                                     Join Posts ta On ta.ParentId = a.ParentId
                               Where a.PostTypeId = 2
                                 And a.Score > 0
                                 -- And a.OwnerUserId = ##UserId##
                                  ) x
                      Where AnswerRank <= 3*/

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results