0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT pq.Id, pq.PostTypeId, pq.Title, pq.Body, pq.AcceptedAnswerId, pa.Body as AcceptedAnswer 
FROM posts pq JOIN posts pa
ON pq.AcceptedAnswerId = pa.Id
WHERE pq.AnswerCount >= 10  AND CONVERT(VARCHAR(250), pq.Tags) = '<C>' AND
pq.PostTypeId = 1 AND -- Questions
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.Body NOT LIKE '%<img src="%">%'

fork query

edited may 25

created may 25 jon.doe44415