0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
    q.Id AS [Question ID],
    q.Title AS [Question Title],
    q.Body AS [Question Body],
    c.Text AS [Comment Text],
    c.Score AS [Comment Score]
FROM 
    Posts q
JOIN 
    Comments c ON q.Id = c.PostId
WHERE 
    q.PostTypeId = 1 -- Questions
    AND c.Score = (
        SELECT MAX(Score)
        FROM Comments
        WHERE PostId = q.Id
    ) AND q.Id<100
ORDER BY 
    q.ViewCount DESC

fork query

edited jun 8 anonymous

created jul 9 19 Moradnejad