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