Most controversial posts on the site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

set nocount on 

select
  top 100
  p.ParentId,
  p.Title,
  p.ViewCount,
  t.TagName
from Posts p
  join PostTags pt on pt.PostId = p.Id
  join Tags t on t.Id = pt.TagId
where t.TagName in ('kubernetes', 'k8s', 'docker')
and DATEDIFF(day, GETDATE(), p.CreationDate) < 180
order by ViewCount desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results