0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

SELECT
p2.Id,
p.Id AS [Post Link],
p.Title,
p.OwnerUserID,
Users.DisplayName,
p2.Body,
p.CreationDate,
p.LastActivityDate,
p.LastEditDate,
p.DeletionDate,
p.ClosedDate,
p.ViewCount,
p.FavoriteCount,
p.CommentCount,
p.AnswerCount,
p.AcceptedAnswerID
FROM
  Posts as p
  JOIN Users on Users.Id=p.OwnerUserID
  left outer join Posts as p2 on p2.ParentId=p.Id
WHERE
p.Title LIKE '%##string?liquibase##%'
/* p.Id=65264640 */
ORDER BY p.Id DESC

fork query

edited jan 20

created jan 5 anonymous