Questions with comments that contain 'belongs on'

0

Please login or register to vote for this query.

(click on this box to dismiss)

possible migration candidates

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

select top 50 postid as [Post Link], posts.creationdate, max(text)
from comments
inner join posts
on posts.id = postid
where posttypeid = 1
and text like '%belongs on%' COLLATE SQL_Latin1_General_CP1_CI_AS
and posts.closeddate is null
group by postid, posts.creationdate
order by posts.creationdate asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results