Post and Accepted Answer by language

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT 
  p.Id,
  p.AcceptedAnswerId,
  p.CreationDate,
  p.OwnerUserId,
  p.Tags,
  p.Title,
  p.Body AS Question,
  a.Body AS Answer
  FROM POSTS p INNER JOIN POSTS a ON p.AcceptedAnswerId = a.Id
  WHERE 
  p.Tags LIKE '%python%'
  AND p.PostTypeId = 1 
  AND a.PostTypeId = 2
  AND p.AcceptedAnswerId IS NOT NULL
  AND p.DeletionDate IS NULL;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results