View Single Post
  #4  
Old 19 Oct 2015, 20:48
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Originally Posted by Dave View Post
The user table does not have a dateline column, that's why it doesn't work.
You can use: joindate, lastvisit, lastactivity, lastpost.

By the way it's easier to write WHERE usergroupid IN (10, 62) for the first WHERE statement.
Thanks Dave. The options you list won't give me statistics for the users in that group for JUST that time period which is what I'm looking for. Thanks for the response and thanks for the shortcut for usergroup.

--------------- Added 19 Oct 2015 at 20:50 ---------------

Originally Posted by kh99 View Post
I think you want something like this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Thanks for the help. That only gives me a total number for those usergroups which isn't exactly what I'm looking for. I'm trying to get a list of users in those specific user groups along with the number of posts per each user for that time period. I'm not very good at SQL queries (which must be obvious). I appreciate the response.

--------------- Added 19 Oct 2015 at 21:11 ---------------

I've been playing around with it a bit and I've almost got the following to work:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If I take out the "AND (usergroup='10')" line it works but it's for ever user. How do I get it to work for just a single usergroup?
Reply With Quote