Find Something to Flag 1

2

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

-- Find Something to Flag 1

select top 1000
  LEN(Body) as BodyLength,
  p.id as [Post Link],
  u.id as [User Link],
  u.reputation
from posts p
inner join users u on
  u.id = p.owneruserid
where 
  posttypeid=2 and
  u.reputation < 10 and
  p.score <= 0 and
  LEN(body) < 300 and
  body like '%http://%'
order by 
  BodyLength

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results