1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and independent game developers

select 
    -- p.OwnerUserId as Uid,
    p.Id AS [Post Link]
    -- p.CreationDate,
    -- u.Reputation,
    -- u.DisplayName
  from Posts p left join
       Users u
       on u.Id = p.OwnerUserId 
  where 
    p.PostTypeId = 1
    AND p.Score > 0
    AND u.Reputation < ##RepThreshold?50##
    AND u.Reputation >= 50
    order by p.Id  ASC

view current version

edited sep 11

created sep 3 Franck Dernoncourt