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 like '%<status-%'
and Q.ClosedDate is null
and Q.CreationDate > CONVERT (datetime, '2014.08.01' , 102)

Enter Parameters

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