โพสต์ที่โหวตโดยตัวแทนไม่เพียงพอที่สุดของฉัน ไม่จำเป็นต้องใช้ตารางทั้งหมด
My most insufficient-rep voted posts.It is not neccessary to use all the tables.
 PostFeedback:  Id [ number]  PostId [ number]  IsAnonymous [ boolean]  VoteTypeId [ number]  CreationDate [ time] 
SELECT Id AS "post_link", Score, (SELECT COUNT(Id) FROM PostFeedback AS v WHERE p.Id = v.PostId AND v.VoteTypeId = 2) AS Upmods, (SELECT COUNT(Id) FROM PostFeedback AS v WHERE p.Id = v.PostId AND v.VoteTypeId = 3) AS Downmods FROM Posts AS p WHERE p.OwnerUserId = '##UserId##' ORDER BY (SELECT COUNT(Id) FROM PostFeedback AS v WHERE p.Id = v.PostId AND v.VoteTypeId IN (2, 3)) DESC LIMIT 500