XF 1.5 SQL QUERY: How to generate a list of users that have ONLY posted on a specific single forum?

[rdn]

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

 

[Xon]

I know I've written an SQL query to-do this, but not sure where the heck I put a copy

 

[rdn]

I know I've written an SQL query to-do this, but not sure where the heck I put a copy

Thanks Xon .
I hope you'll find it, I can wait.

 

[Isil`Zha]

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, 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

 

[Isil`Zha]

I forgot we've got a lot of custom add-ons built into the query

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.