ผู้สมัครป้าย Revival สำหรับแท็กบางแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Revival badge candidates for a certain tag.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
SELECT a.Id AS "post_link", a.Score, a.CreationDate FROM Posts AS a WHERE a.PostTypeId = 2 AND EXISTS(SELECT * FROM Posts AS q WHERE q.Id = a.ParentId AND q.PostTypeId = 1 AND a.CreationDate > q.CreationDate + 30 AND Tags LIKE '%<' + LOWER(@tag) + '>%') ORDER BY a.Score DESC, a.CreationDate LIMIT 1000