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-07-01'
and pp.CreationDate < '2019-07-30' 
and pp.PostTypeId=1
and pp.OwnerUserId in (
  select Id from users uu
  where 1=1
  and uu.Reputation <=20
  and uu.Id in (
    select OwnerUserId from posts
    Where 1=1
    and Id in (
      select ParentId from posts p
      where 1=1
      and p.CreationDate >= '2019-07-01'
      and p.CreationDate < '2019-07-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