Weighted Activity Gauge สำหรับ Scifi ไม่จำเป็นต้องใช้ตารางทั้งหมด
Weighted Activity Gauge for Scifi.It is not neccessary to use all the tables.
 SuggestedEdits:  Id [ number]  PostId [ number]  CreationDate [ time]  ApprovalDate [ time]  RejectionDate [ time]  OwnerUserId [ number]  Comment [ text]  Text [ text]  Title [ text]  Tags [ text]  RevisionGUID [ other] 
SELECT DISTINCT pt.Name AS PostType, p.Id AS "post_link", p.CreationDate, p.Score, COALESCE(p.ViewCount, p2.ViewCount) AS "view_count", 3 - p.PostTypeId AS Weight FROM Posts AS p LEFT JOIN PostTypes AS pt ON p.PostTypeId = pt.Id LEFT JOIN Posts AS p2 ON p.ParentId = p2.Id JOIN PostTags AS ptag ON p.Id = ptag.PostId OR p2.Id = ptag.PostId JOIN Tags AS t ON t.Id = ptag.TagId WHERE t.TagName IN ('comics', 'marvel-comics', 'dc-comics') AND p.OwnerUserId = '##UserID:string##'