Q&A for professional and enthusiast programmers
SELECT * FROM Comments c INNER JOIN Posts p ON p.Id = c.Id WHERE Text LIKE '+1%' AND LEN(Text)<50 ORDER BY LEN(Text) ASC