Votos de usuarios no registrados por autor, por pregunta

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

with pfb as (
  select PostId, MIN(VoteTypeId) Tipo, count(*) Cant
    from PostFeedback
    left join PostsWithDeleted
      on PostFeedback.PostId = PostsWithDeleted.Id
   where OwnerUserId = 127
   group by PostId, VoteTypeId)

select PostId [Post Link], VoteTypes.Name Voto, Cant
  from pfb
   left join VoteTypes 
     on pfb.Tipo = VoteTypes.Id
 order by PostId

Enter Parameters

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