0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

select distinct top 15
  users.id
, DisplayName
, Body
, posts.CreationDate

  from Posts

left join ReviewTasks rt 
on posts.Id = rt.PostId

left join ReviewTaskResults rtr
on rt.Id = rtr.ReviewTaskId

left join users
on posts.OwnerUserId = users.id

where 
  RejectionReasonId = 2 
  and body not like '%<%>%'
  and body is not null
  and body <> ''

order by posts.CreationDate desc

fork query

edited jan 24

created jan 24 anonymous