People helped - public prototype #1

5

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

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 to main site
loading Hold tight while we fetch your results