LB Supporter Metrics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT
Posts.Id,
Posts.Title,
Posts.OwnerUserID,
Users.DisplayName,
Posts.Body,
Posts.CreationDate,
Posts.LastActivityDate,
Posts.LastEditDate,
Posts.DeletionDate,
Posts.ClosedDate,
Posts.ViewCount,
Posts.FavoriteCount,
Posts.CommentCount,
Posts.AnswerCount,
Posts.AcceptedAnswerID
FROM
  Posts
  JOIN Users on Users.Id=Posts.OwnerUserID
WHERE
  Posts.CreationDate > '2019-01-01' AND
  (Posts.Title LIKE '%##text?liquibase##%')
ORDER BY Posts.Id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results