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,
p2.OwnerUserID,
Users.DisplayName,
p2.Body,
p2.CreationDate,
p2.LastActivityDate,
p2.LastEditDate,
p2.DeletionDate,
p2.ClosedDate,
p2.ViewCount,
p2.FavoriteCount,
p2.CommentCount,
p2.AnswerCount,
p2.AcceptedAnswerID
FROM
  Posts as p
  left outer join Posts as p2 on p2.ParentId=p.Id
  JOIN Users on Users.Id=p2.OwnerUserID
WHERE
p.Title LIKE '%##string?liquibase##%'
/* p.Id=65264640 */
ORDER BY p.Id DESC

fork query

edited jan 20

created jan 5 anonymous