Get Best Questions to remember

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

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

SELECT top 10 pa.Id --, p.ParentId
  FROM dbo.Posts AS pa
  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.ParentId in

(SELECT top 10 p.Id --, p.ParentId
  FROM dbo.Posts AS p
  INNER JOIN dbo.PostTags AS pt
    ON p.Id = pt.PostId
  INNER JOIN dbo.Tags AS t
    ON t.Id = pt.TagId
  WHERE t.TagName = 'angular' 
  order by score desc)
  
  order by score desc

Enter Parameters

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