ตรา Decadist รวบรวมตัวแทนอย่างน้อย 200 คนจากการโหวตโพสต์ในแต่ละปีของ 10 ครั้งล่าสุด ไม่แน่ชัด เราไม่สามารถนับสิ่งต่างๆ ที่ส่งผลกระทบต่อชื่อเสียงได้มากนัก แต่ประมาณนี้เท่านั้น ตรวจสอบ [การอภิปรายเมตา] (https//meta.stackoverflow.com/q/374646/1783163) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Decadist badge Collected at least 200 rep from post votes in each year of the last 10. Not exact, we can't count a lot of things affecting the reputation, but it is about roughly this. Check this [meta discussion](https//meta.stackoverflow.com/q/374646/1783163).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] 
WITH VoteRep AS (SELECT 1 AS VoteTypeId, 2 AS PostTypeId, 15 AS Rep UNION SELECT 2 AS VoteTypeId, 1 AS PostTypeId, 5 AS Rep UNION SELECT 2 AS VoteTypeId, 2 AS PostTypeId, 10 AS Rep UNION SELECT 3 AS VoteTypeId, 1 AS PostTypeId, -2 AS Rep UNION SELECT 3 AS VoteTypeId, 2 AS PostTypeId, -2 AS Rep), Raw AS (SELECT VoteRep.Rep, Posts.OwnerUserId AS UserId, DATEDIFF(yy, Votes.CreationDate, CURRENT_TIMESTAMP()) AS Age FROM Posts, Votes, VoteRep WHERE Votes.PostId = Posts.Id AND Votes.VoteTypeId = VoteRep.VoteTypeId AND Posts.PostTypeId = VoteRep.PostTypeId) SELECT SUM(Rep) AS Rep, Age, UserId FROM Raw GROUP BY UserId, Age HAVING SUM(Rep) >= 200