0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT TOP (50000)

 q.Id,u.DisplayName AS "Asker",
    u.Id AS AskerLink,
    au.DisplayName AS "Answerer",
     au.Id AS AnswererLink,
    null as Link,
    q.Body as QuestionBody,
    q.Title,
    a.Body AS HighestScoringAnswer

       from posts a 
       inner join (select r.Id, r.Title,r.Body,r.OwnerUserId, max(p.Score) Score
               from posts p 
               inner join posts r
               on p.ParentId = r.Id where p.PostTypeId = 2 
               and p.Score >= 0
               group by r.Id, r.Body,r.Title,r.OwnerUserId) q
       on a.ParentId = q.Id
       and a.Score = q.Score
       join Users u ON q.OwnerUserId = u.Id
       JOIN Users au ON a.OwnerUserId = au.Id
      
       
WHERE q.id >##qid##
ORDER BY q.id

fork query

created may 30 22 turboultra