Sportsmanship

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

-- 1 Question
-- 2 Answer

-- 2 UpMod

--select top 100 * from votes




select
  *
from posts p
join (
  select distinct
    p.id, p.parentid
  from posts p
  join votes v
    on p.id=v.postid
  where 1=1
    and p.posttypeid=2
    and p.owneruserid=1980228
    and p.score>0
    and v.votetypeid=2
) x
  on p.parentid=x.parentid
where 1=1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results