suggested edits where suggestor doesn't exist as user.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

select
  se.creationdate,
  se.id as [Suggested Edit Link],
--  se.OwnerUserId as editorUserID,
--  editorU.displayname,
  p.id as [Post Link]
from
  suggestededits as se
  left join posts as p on p.id = se.postid
--  left join users as editorU on editorU.id = se.OwnerUserId
where
  1 = 1
--  and editorU.id is null
--  and se.OwnerUserId is not null
  and se.OwnerUserId is null
  and se.creationdate > DATEADD(week, -2, getdate()) 
order by
  se.creationdate desc

Enter Parameters

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