Q&A for science fiction and fantasy enthusiasts
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