3

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all of your questions that have received any downvotes, sorted by number of downvotes.

Q&A about the site for Drupal developers and administrators

SELECT p.Id     AS [Post Link],
       COUNT(*) AS Downvotes
FROM   Posts p
       INNER JOIN Votes v
         ON p.Id = v.PostId  
WHERE  p.OwnerUserId = ##UserId:int##
       AND v.VoteTypeId = 3

       AND ClosedDate is Null
GROUP  BY p.Id
ORDER  BY Downvotes DESC

fork query

edited sep 8 12 KevinN

created feb 8 12 e