People helped - public prototype #1

5

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

Select ISNULL(Sum(Cast(ViewCount as BigInt)), 0)
  From Posts pmd
 Where pmd.Id In (Select Id 
                        From Posts 
                       Where PostTypeId = 1 
                         And OwnerUserId = ##UserId##
                      Union
                      Select ParentId
                        From Posts
                       Where PostTypeId = 2
                         And Id in (select AcceptedAnswerId from Posts)
                         And OwnerUserId = ##UserId##
                      Union
                      Select ParentId
                        From Posts
                       Where PostTypeId = 2
                         And Score > 5
                         And OwnerUserId = ##UserId##
                      Union
                      Select a.ParentId
                        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
                        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 sites:
loading Hold tight while we fetch your results