1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select row_number() over (order by p.id),
  p.id AS [Post Link], p.tags
from posts p
inner join votes v
  on p.id = v.postid
inner join posttags pt
  on p.id = pt.postid
inner join tags t
  on pt.tagid = t.id
where v.votetypeid = 6
  and p.closeddate is null
  and t.tagname = ##Tag:string?tagname##
  and p.viewcount < 100

fork query

edited feb 14 14

created feb 14 14 bluefeet