0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
  p.Id AS [Post Link],
  'site://q/' + Convert(VarChar(10), p.Id) + '#comment' +  Convert(VarChar(10), p.Id) + '_' + Convert(VarChar(10), c.Id) + '|' + c.Text AS [Comment],
  c.Score AS [Score],
  p.CreationDate AS [Post date],
  c.CreationDate AS [Comment date]
FROM Posts p
INNER JOIN Comments c
ON c.PostId = p.Id
WHERE c.UserId = ##Commenter:int?-1##
  AND p.OwnerUserId = ##QuestionAuthor:int?-1##
  AND c.Text LIKE N'%##Comment containing##%'
ORDER BY c.CreationDate ASC

fork query

edited nov 26 GNU.Supporter

created jul 31 14 Gilles