ความคืบหน้าของป้าย Illuminator/Refiner/Explainer (ผู้ใช้ทั้งหมด) ผู้ใช้ไซต์ของคุณสำหรับซีรีส์ป้าย Illuminator มานานเพียงใดแล้ว?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Illuminator/Refiner/Explainer badge progress (all users). How far along are the users on your site for the Illuminator badge series?It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT a.OwnerUserId AS "user_link", COUNT(*) AS "count" FROM Posts AS a LEFT OUTER JOIN Posts AS q ON a.ParentId = q.Id WHERE q.PostTypeId = 1 AND q.ClosedDate IS NULL AND a.PostTypeId = 2 AND a.Score >= 1 AND COALESCE(q.OwnerUserId, -1) != a.OwnerUserId AND EXISTS(SELECT 1 FROM PostHistory AS ph WHERE ph.PostHistoryTypeId IN (4, 5) AND ph.PostId = a.ParentId AND ph.UserId = a.OwnerUserId AND ABS(CAST((JULIANDAY(a.CreationDate) - JULIANDAY(ph.CreationDate)) AS INT)) < 12) GROUP BY a.OwnerUserId HAVING COUNT(*) >= @min_qualifying_answers ORDER BY 'count' DESC LIMIT @max_results