0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

SELECT TOP 1000
    q.Id AS [Question ID],
    q.Title AS [Question Title],
    q.Body AS [Question Body],
    a.Id AS [Accepted Answer ID],
    a.Score AS [Answer Score],
    a.Body AS [Answer Body],
    w.PostId AS [URL]
FROM Posts q
INNER JOIN Posts a ON q.AcceptedAnswerId = a.Id
INNER JOIN PostLinks w ON w.Id = q.ID
WHERE q.Tags LIKE '%<jenkins>%' 
    AND a.Score >= 5
    AND q.CreationDate >= '2000-09-01'
ORDER BY a.Score DESC;

fork query

edited may 20 anonymous

created feb 12 Pun