คำตอบที่ได้รับคะแนนต่ำสุด 50 ข้อของฉันสำหรับคำถามที่ไม่มีคำตอบที่ยอมรับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
My 50 Lowest Rated Answers On Questions With No Accepted Answer.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
SELECT p.Id AS "post_link", COALESCE(p.LastEditDate, p.CreationDate) AS MostRecentChange, (SELECT COUNT(v.Id) FROM Votes AS v INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id WHERE vt.Name = 'UpMod' AND v.PostId = p.Id) AS UpVotes, (SELECT COUNT(v.Id) FROM Votes AS v INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id WHERE vt.Name = 'DownMod' AND v.PostId = p.Id) AS DownVotes, p.Score FROM Posts AS p INNER JOIN PostTypes AS pt ON pt.Id = p.PostTypeId INNER JOIN Posts AS p2 ON p.ParentId = p2.Id WHERE pt.Name = 'Answer' AND p.OwnerUserId = @UserId AND p2.AcceptedAnswerId IS NULL ORDER BY p.Score, p.LastEditDate DESC LIMIT 50