select p.id as [Post Link] from posts p where p.closeddat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

select p.id as [Post Link]
from posts p
where p.closeddate is not null
  and p.answercount > 15
  and p.score > 5
  and not exists (select * from posthistory ph 
                  where ph.postid = p.id 
                    and ph.posthistorytypeid = 14)

Enter Parameters

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