Select Questions for Python with Accepted Answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT top(1) 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 '01-JAN-2024' 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