0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

-- 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

view current version

edited may 3 11

created may 3 11 YOU