select count(1) from posts Q where Q.PostTypeId = 1 and Q...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A about the Stack Exchange Network

select 
count(1)
from 
  posts Q
where
Q.PostTypeId = 1
and Q.tags like '%<feature-request>%'
and Q.tags not like '%<status-%'
and Q.ClosedDate is null
and not exists (
  select 1 
  from posts A 
  where A.parentid = Q.id
  and A.OwnerUserId in (1, 811, 115866, 140505 , 141525 , 155160 , 135201 , 50049 , 23354 , 146126 , 98786 , 130213 ) 
  )

Enter Parameters

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