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

XF 1.5 Query For Users with 0 posts and profile posts

Discussion in 'XenForo Questions and Support' started by BamaStangGuy, Oct 17, 2016 at 5:37 PM.

  1. BamaStangGuy

    BamaStangGuy Well-Known Member


    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?
  2. Mike

    Mike XenForo Developer Staff Member

    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.

Share This Page