Users who have posted more than 24 hours after first post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

select udfp.owneruserid as [User Link], count(p2.id) as futureposts
from (
  select p.owneruserid, min(p.creationdate) as dfp -- Datetime of First Post
  from posts p
  where p.posttypeid < 3 -- Q/A
  group by p.owneruserid
  ) udfp
left outer join posts p2 on
      p2.owneruserid = udfp.owneruserid
  and datediff(hh, udfp.dfp, p2.creationdate) >= 24
  and p2.posttypeid < 3 -- Q/A
group by udfp.owneruserid
having count(p2.id) > 0

Enter Parameters

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