Questions with AcceptedAnswer for specific Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

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

SELECT 
  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 '%<testability>%'
ORDER BY
  P.ViewCount DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results