0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

SELECT top 10 pa.id, pa.body, a.body,pa.posttypeid
  FROM dbo.Posts AS pa
   inner join posts a on pa.acceptedanswerid = a.id
  INNER JOIN dbo.PostTags AS pta
    ON pa.Id = pta.PostId
  INNER JOIN dbo.Tags AS ta
    ON ta.Id = pta.TagId
  WHERE ta.TagName = 'angular' and
  pa.posttypeid = 1
  and a.posttypeid = 2
  
  
  
  group by pa.id,pa.body,a.body,pa.posttypeid,pa.score
  order by pa.score desc

fork query

edited sep 18 19

created sep 18 19 anonymous