Q&A about the site for those using, extending or developing Emacs
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 '%+%' AND LEN(Text)<50 AND [p1].[ClosedDate] IS NULL ORDER BY LEN(Text) DESC ) RAR ORDER BY LEN(Text) ASC