0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

select * from 
  
  (
  
    select top 50 --questions
      'Question' as [Type],
      format(creationdate,'MMM d, yyyy') as [Date],
      id as [Post Link],
      Score,
      owneruserid as [User Link]
    from posts 
    where 
      score<-5
      and posttypeid=1
    order by score asc

UNION ALL

    select top 50 --answers
      'Answer' as [Type],
      format(a.creationdate,'MMM d, yyyy') as [Date],
      a.id as [Post Link],
      a.Score,
      a.owneruserid as [User Link]
    from posts q left outer join posts a on q.id=a.parentid
    where 
      a.score<-5
      and a.posttypeid=2
    order by a.score asc
  ) x
    
order by x.score asc

fork query

edited nov 26 anonymous

created sep 6 18 ashleedawg