0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT
  c.Id AS CommentId,
  c.PostId AS PostId,
  c.Text AS CommentText,
  c.CreationDate,
  p.Title AS PostTitle,
  p.Body AS PostBody
FROM
  Comments c
INNER JOIN
  Posts p ON c.PostId = p.Id
WHERE
  (p.Tags LIKE '%httpclient%' OR p.Tags LIKE '%apache-commons%')
  AND p.CreationDate >= '2022-01-01'
ORDER BY
  c.CreationDate DESC;

fork query

edited feb 11 anonymous

created feb 11 jon.doe43791