Post and Accepted Answer by language

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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 main site
loading Hold tight while we fetch your results