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 Q.CreationDate > CONVERT (datetime, '2014.08.01' , 102)
and (
  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 ) 
    )
  or exists (
    select 1
    from comments C
    where C.PostId = Q.id
    and C.UserId in (1, 811, 115866, 140505 , 141525 , 155160 , 135201 , 50049 , 23354 , 146126 , 98786 , 130213 ) 
  )
  or exists (
    select 1
    from comments C
    join posts A on (C.PostId = A.id and A.parentId = Q.id)
    where C.UserId 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