1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

select top 500
       PostId [Post Link],
       sum(  case when VoteTypeId=2 then 1 else -1 end) Puntaje,
       count(case when VoteTypeId=2 then 1 else null end) Positivos, 
       count(case when VoteTypeId=3 then 1 else null end) Negativos,
       count(*) Total
  from PostFeedback
  left join PostsWithDeleted
    on PostFeedback.PostId = PostsWithDeleted.Id
 where OwnerUserId = ##IdUsuario:int?127##
                    -- IdUsuario: Id del usuario: "Es el ID del autor de las publicaciones votadas. El número se obtiene visitando el perfil del usuario. Aparece en la URL"
 group by PostId
 order by Total desc, Positivos desc, Negativos asc, PostId desc

fork query

edited apr 23 17

created mar 7 17 Mariano