1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT 
  TOP 50
  Posts.Id as [Post Link],
  CreationDate,
  ViewCount,
  Score
FROM 
  Posts
  INNER JOIN PostTags ON Posts.Id = PostTags.PostId
  INNER JOIN Tags ON Tags.Id = PostTags.TagId
WHERE 
  LOWER(Tags) like '%hibernate%' AND
  LOWER(Tags.TagName) = 'hibernate'
ORDER BY
  Score DESC,
  ViewCount DESC,
  CreationDate DESC

fork query

edited apr 21 18

created apr 16 18 Dennys Fredericci