Select Questions for Python with Accepted Answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT pq.Id, pq.PostTypeId, pq.Title, pq.Body, pq.Score, pq.Tags, pq.ViewCount, pq.AcceptedAnswerId, pa.Body as AcceptedAnswer 
FROM posts pq JOIN posts pa
ON pq.AcceptedAnswerId = pa.Id
WHERE
pq.PostTypeId = 1 AND -- Questions
pq.CreationDate BETWEEN '01-JAN-2022' AND '06-DEC-2023' AND -- Time
pq.AcceptedAnswerId IS NOT NULL AND -- Have accepted answer
pq.Id NOT IN (SELECT PostId FROM PostLinks WHERE LinkTypeId = 3) AND -- No duplicate question
pq.Id NOT IN (SELECT RelatedPostId FROM PostLinks WHERE LinkTypeId = 3) AND -- No duplicate question
(pq.Tags LIKE '%<python>%' OR pq.Tags LIKE '%<python-3.x>%' )AND
pq.Body NOT LIKE '%<img src="%">%' AND 
pq.Score > 4

Enter Parameters

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