select count(*) from posts as q where PostTypeId=1 AND Cl...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

-- Enter Query Title
-- Enter Query Description
select count(*) from posts as q
where PostTypeId=1
AND ClosedDate is null
and AcceptedAnswerId <> ''
OR 
(select Count(*) from posts as a where PostTypeId=2 and ParentId=q.id and Score>0) > 1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results