0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for musicians, students, and enthusiasts

SELECT 
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.CreationDate AS QuestionCreationDate,
    q.Score AS QuestionScore,
    a.Id AS AnswerId,
    a.Body AS AnswerBody,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore
FROM 
    Posts q
    JOIN Posts a ON q.Id = a.ParentId
WHERE 
    q.Tags LIKE '%<gitlab>%'
    AND a.Score = (
        SELECT MAX(Score)
        FROM Posts
        WHERE ParentId = q.Id
    )
ORDER BY 
    q.CreationDate DESC;

fork query

created mar 18 Tan.Le