• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 SQL Query Help

Ark Royal

Active member
#1
Can anyone help me and provide me with an SQL Query that will allow me to see when members of a particular user group last made a post?

Many Thanks
 

Mouth

Well-known member
#2
select username, from_unixtime(last_activity) from xf_user where find_in_set('xx',secondary_group_ids) <> 0 order by last_activity desc;

..... replace xx with the usergroup id you want to check against
 
#6
If the users in question have the desired usergroup as a secondary_group_id... this example is selecting members in user group 9 and showing their last post time:

Code:
SELECT user.username, MAX(post.post_date) AS last_post_date FROM xf_user AS user
LEFT JOIN xf_post AS post ON(post.user_id = user.user_id)
WHERE FIND_IN_SET(9, user.secondary_group_ids) GROUP BY post.user_id ORDER BY last_post_date DESC;
This is fairly basic. It's not checking to see if that last post is soft-deleted or moderated, for example, and the date is output as a UNIX time format value.