select top 50000 * from (select PostId, count(id) as NoOf...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arqade Meta

Q&A about the site for passionate videogamers on all platforms

select top 50000 *
from (select PostId, count(id) as NoOfEdits
     from PostHistory
     where PostHistoryTypeId = 5
     group by PostId) as t
right outer join (select p.*, u.UpVotes,u.DownVotes, u.Views, u.Reputation
from (select * from Posts
      where  CAST(CreationDate as date) BETWEEN '20220731' and '20220806') as p
      join Users as u on p.OwnerUserId = u.Id
      where PostTypeId = 1 and
            Body is not null and
            AnswerCount is not null and 
            ClosedDate is null and 
            CommunityOwnedDate is null) as j on t.PostId = j.Id 
           
order by CreationDate desc

Enter Parameters

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