SELECT c.Id AS [Comment Link], c.CreationDate AS [Comment...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Aviation Meta

Q&A about the site for aircraft pilots, mechanics, and enthusiasts

SELECT c.Id AS [Comment Link],
       c.CreationDate AS [Comment Date],
       c.Text AS [Comment Text]
FROM Comments c
JOIN Posts a ON c.PostId = a.Id
JOIN Posts q ON a.ParentId = q.Id
WHERE c.UserId = 21305238
  AND a.OwnerUserId = 256970
  AND a.PostTypeId = 2
  AND q.Tags LIKE '%regex%'
ORDER BY c.CreationDate DESC;

Enter Parameters

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