1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select top 50 Title, acceptedanswerid, 'http://stackoverflow.com/questions/' + CAST(Id AS nvarchar)
from Posts
where CreationDate != CommunityOwnedDate
and postTypeId = 1
and answerCount > 20
and commentCount > 10
and favoriteCount > 10
and closedDate is null
and parentid is null
and title is not null
and lastEditDate is not null
and lastActivityDate is not null
group by id,title, acceptedanswerid

view current version

edited nov 11 13

created nov 5 13 Paul Sweatte