StackEx Answers Given timeframe


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for participants in team and individual sport activities

select count(*) from posts pp
    Where 1=1
    and pp.CreationDate >= '2019-08-01'
    and pp.CreationDate < '2019-08-30' 
    and pp.PostTypeId=1
    --and OwnerUserId in (select Id from users Reputation <=10)
    and Id in (
      select ParentId from posts p
      where 1=1
      and p.CreationDate >= '2019-08-01'
      and p.CreationDate < '2019-08-30' 
      and p.PostTypeId=2 
      and p.owneruserid in (
        select Id from users u where u.DisplayName in (
        'Nick Rak',

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results