WITH QUESTIONS AS( SELECT Id,Body FROM Posts WHERE PostTy...

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

WITH
QUESTIONS AS(
  SELECT Id,Body FROM Posts 
  WHERE PostTypeId=1 AND AnswerCount >= 10  AND CONVERT(VARCHAR(250), Tags) = '<c>'
  ),
ANSWERs AS(
  SELECT a.Body from Posts as a, Questions as q 
  WHERE a.PostTypeId=2 AND a.ParentID=q.Id
  ),
TOTAL AS(
  SELECT q.* FROM QUESTIONS AS q,ANSWERS as a
  )
SELECT * FROM TOTAL

Enter Parameters

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