select distinct top 15 users.id , DisplayName , Body , po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

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

Enter Parameters

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