Do new members post a lot?


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for Joomla! administrators, users, developers and designers

members as (
   select u.Id as Id, 
          min(p.CreationDate) as FirstPostDate
   from Users u join Posts p
   on = p.OwnerUserId
   group by u.Id
posttimes as (
   select m.Id,
          DATEDIFF(hh, m.FirstPostDate, p.CreationDate) as timediff  
   from members m join Posts p
   on m.Id = p.OwnerUserId
sumtimes as (
   select Id,
          sum(case when timediff =0 then 1 else 0 end) firstHourPosts
   from posttimes
   group by Id

select  Id, firstHourPosts from sumtimes

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results