0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

select
  posts.title,
  'http://stackoverflow.com/questions/' + convert(varchar(max), posts.id),
  votetypes.name,
  count(*)
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 votetypes on votetypes.id = votes.votetypeid
 where 
 tags.tagname in ('f#') and
 votetypes.name in ('Deletion', 'Close')
 group by posts.id, posts.title, votetypes.name

fork query

edited apr 30 12 robertpi

created apr 30 12 anonymous