0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select top 5000
  v.postid as [Post Link]
  , 'site://questions/' + CAST(v.postId AS nvarchar) +'|question'  as [Question Link]
  , v.Creationdate
  -- , v.Userid as [User Link] -- user id is null...? 
from votes v
left outer join posts p on p.id = v.postid
where votetypeid = 10
and p.id is null

fork query

edited apr 23 14

created apr 23 14 rene