Q&A about the site for people organizing, marketing or licensing open source development projects
DECLARE @UserId int = ##UserId## DECLARE @Offset int = ##Offset## SELECT c.Id, c.CreationDate, c.Score, c.Text, q.Title 'Parent Title', q.Id 'Parent Id' FROM Comments c INNER JOIN Posts q ON q.Id = c.PostId WHERE c.UserId = @UserId AND c.Text LIKE '%monitor%' ORDER BY c.Score DESC OFFSET ##Offset## ROWS FETCH NEXT 100 ROWS ONLY