0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT top 1 pa.body
  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
  
  order by pa.score desc

fork query

edited sep 18 19

created sep 18 19 anonymous