0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

-- 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 
  u.reputation < 30 and
  p.score <= 0 and
  LEN(body) < 300 and
  body like '%thank%'
order by 
  BodyLength

fork query

edited feb 9 12 Basiclife

created may 3 11 YOU