ตามจำนวนการดู ไม่จำเป็นต้องใช้ตารางทั้งหมด
s by view count.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT Posts.Id, Posts.Title, Posts.CreationDate, Posts.Score, Posts.ViewCount, Posts.FavoriteCount, Posts.AnswerCount, Posts.Body, Posts.Tags FROM Posts WHERE Posts.PostTypeId = 1 AND Posts.Tags LIKE '%python%' AND Posts.CreationDate >= CURRENT_TIMESTAMP() - 7 AND Posts.AcceptedAnswerId IS NULL ORDER BY ViewCount DESC LIMIT 100