XF 1.5 Query For Users with 0 posts and profile posts

[Brent W]

Hi,

Is there a query I can run that will give me a list of users who have 0 posts but have at least one profile post entry?

 

[Mike]

There's nothing tracked to make this simple. The message_count tracking for the user may work, though it may not be sufficient to say that a user truly has 0 posts (if you have forums that don't count). However, there's no tracking of profile posts. It might be an option to create a temporary table that counts the number of profile posts made by every user (by grouping on user_id) and then you can connect the results here to the 0 posts users and determine who of those has a profile post.