0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select a.id as [Post Link], * from posts a
inner join posts p on p.id = a.parentid
where a.posttypeid = 2
and p.closeddate is null
and len(a.body) < 400
and p.acceptedanswerid != a.id
and a.score < ##MaxScore:int?1##
and (a.body like '%stackoverflow%')
and (a.body like '%http:%' or a.body like '%https:%')

fork query

edited jan 2 Pureferret36427

created sep 11 15 durron597