1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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 < ##RepMaxThreshold?100##
    AND u.Reputation >= ##RepMinThreshold?2##
    order by p.Id  ASC

fork query

edited sep 21

created sep 3 Franck Dernoncourt