StackEx Answers Given timeframe

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

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 (
        'Crou',
        'abielak',
        'Nick Rak',
        'VAS',
        'aurelius',
        'mk_sta',
        'VKR',
        'Nepomucen',
        'coolinuxoid',
        'yyyyahir',
        'A_Suh',
        'PjoterS',
        'Hanx',
        'MaggieO',
        'OhHiMark',
        'mebius99',
        'mario')
       )
     )
  )
)

Enter Parameters

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