0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A 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

fork query

edited jun 18

created jun 18 anonymous