Q&A for people practicing or interested in Buddhist philosophy, teaching, and practice
SELECT RAR.* FROM ( SELECT TOP 3420 c.Id as [Comment Link], c.[Text] FROM Comments c INNER JOIN Posts p ON c.PostId = p.Id INNER JOIN Posts p1 on p.ParentId = p1.Id WHERE Text LIKE '%thank%' AND LEN(Text)<50 AND [p1].[ClosedDate] IS NULL ORDER BY LEN(Text) DESC ) RAR ORDER BY LEN(Text) ASC