closed and deleted votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

select 
  posts.title,
  posts.tags,
  users.displayname,
  users.reputation,
  votetypes.name
from 
  posts 
  inner join posttags on posts.id = posttags.postid
  inner join tags on tags.id = posttags.tagid
  inner join votes on votes.postid = posts.id
  inner join users on votes.userid = users.id
  inner join votetypes on votetypes.id = votes.votetypeid
 where 
 tags.tagname in ('f#') and
   posts.closeddate is not null

Enter Parameters

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