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-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 (
        '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