select datediff(d, se.creationdate, approvaldate) [days t...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select datediff(d, se.creationdate, approvaldate) [days to approve]
     , posttypeid
     , p.id
     , t.tagname
from suggestededits se
inner join posts p on p.id = se.postid
inner join tags t on p.id = wikipostid or p.id = excerptpostid
where p.posttypeid in (4,5)
order by 1 desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results