0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Top 1000 Posts by Tags

SELECT TOP 1000
    --ROW_NUMBER() OVER(ORDER BY Score DESC) AS [#], 
    --q.Id AS [Post Link],
    q.Id as post_id,
    q.Title as Post_Title,
    q.Score as Score,
    q.Body as QuestionBody,
    max(a.Body) as AnswerBody
FROM
    Posts q
    inner Join Posts as a ON a.ParentId = q.Id
WHERE
    LOWER(q.Tags) LIKE LOWER('%##tag##%') and q.AnswerCount > 20 and a.posttypeid = 2
GROUP BY q.Id, q.Title, q.Score, q.Body
ORDER BY
    Score DESC;

fork query

edited apr 17 19

created apr 14 19 anonymous