Q&A for programming puzzle enthusiasts and code golfers
select id from posts where posttypeid like 1 and closeddate is null --inner join posts on parentid = id