Q&A for professional and enthusiast programmers
SELECT C.Id as [Comment Link] ,P.Score ,Length = LEN(C.Text COLLATE Latin1_General_BIN) ,C.Text ,C.CreationDate FROM Comments C JOIN Posts P ON P.Id = C.PostId WHERE P.ClosedDate IS NULL AND C.Text COLLATE Latin1_General_BIN LIKE '%[tT]hank%' AND C.Text COLLATE Latin1_General_BIN LIKE '%[eE]dited%' AND P.Score >= 5 AND LEN(C.Text COLLATE Latin1_General_BIN) <= 50 ORDER BY P.Score DESC, C.CreationDate DESC ;