Q&A about the site for gardeners and landscapers
SELECT p.Id AS QuestionID, p.Title AS QuestionTitle, p.Body AS QuestionBody, a.Body AS AnswerBody, p.Tags AS QuestionTags, p.Score AS QuestionVotes, p.ViewCount AS QuestionViews, p.CreationDate AS QuestionCreationDate, p.AnswerCount AS AnswerCount, p.CommentCount AS CommentCount, p.FavoriteCount AS FavoriteCount, p.ClosedDate AS ClosedDate FROM Posts p, Posts a WHERE p.PostTypeId = 1 AND p.AcceptedAnswerId IS NOT NULL AND p.AcceptedAnswerId = a.Id AND p.Tags LIKE '%<pca>%' AND p.Title LIKE '%?' ORDER BY p.Score DESC