SELECT pq.Id, pq.PostTypeId, pq.Title, pq.Body, pq.Accept...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

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) = 'Java' 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="%">%'

Enter Parameters

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