open programmers questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

select
  p.Id as [Post Link],
  '1. [' + p.title + '](##site##questions' + CAST(p.Id AS nvarchar) + ')' As PostUrl,
  p.title,
  p.Score,
  p.CreationDate as [Created],
  p.ClosedDate as [Closed], 
  p.LastEditDate,
  crt.name,
  count(v.id) as UpVotes
from
  Posts  p
  
inner join PostHistory ph on p.id=ph.PostId 
inner join CloseReasonTypes crt on crt.id=ph.comment
inner join Votes v on p.id=v.PostId


where
  p.PostTypeId = 1 
  and p.ClosedDate is not null
  and p.CreationDate >= '2015-11-09'
  and p.CreationDate <= '2015-12-09'
  and ph.posthistorytypeid=10 
  and v.Votetypeid = 2
  and crt.id<>101
 
 group by p.id, p.title, p.score,p.creationdate,p.closeddate,p.lasteditdate,crt.name
 order by

  p.score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results