• 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: How to generate a list of users that have ONLY posted on a specific single forum?

RoldanLT

Well-known member
#1
Batch update can't do this unfortunately.
Is it possible to list all members that have ONLY posted on specific single forum?
 

Isil`Zha

Active member
#4
Well, I do have one, but it has as lot of specifics to filter out certain forums and aggregate certain child forums together. I'll have to clean it up for something more generic later this evening.
 

Xon

Well-known member
#5
Well, I do have one, but it has as lot of specifics to filter out certain forums and aggregate certain child forums together. I'll have to clean it up for something more generic later this evening.
I forgot we've got a lot of custom add-ons built into the query :p
 

Isil`Zha

Active member
#6
I forgot we've got a lot of custom add-ons built into the query :p
The bigger issue is our crietera was different. We aggregated child nodes into parent nodes when determining "only posts in this section," and also excluded various other forums (suggestions, announcements, all staff forums, etc.) Also was built out to show every forum with unique posting users, and the count of unique posting users.