0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 500
  P.Id, 
  P.CreationDate,
  P.ViewCount,
  P.Title, 
  P.Body, 
  P.Tags, 
  AA.Body as Answer
FROM 
  Posts as P
INNER JOIN 
  Posts AS AA ON AA.id = P.AcceptedAnswerId
WHERE 
  P.AcceptedAnswerId IS NOT NULL AND 
  P.PostTypeId = 1 AND
  -- Set your specific query parameters here
  P.tags LIKE '%<static-analysis>%'
ORDER BY
  P.ViewCount DESC;

fork query

edited nov 13 18

created nov 13 18 anonymous