Listing of those following a club

[USCJ Digital]

Is there a way to print out or create an Excel listing of individuals who are following a club or forum? We want to cross check to see which members of a club have actually chosen to follow the club (or at least the forum tab of the club) vs. those who have not. The scrolling list that is shown on-screen is not a great way to manage this check, and also there are individuals who are following anonymously.

Any insights would be appreciated!

Perhaps I should post this in the "suggestions" forum also ...

[newbie LAC]

SELECT m.name FROM core_follow AS f  LEFT JOIN core_members AS m ON m.member_id=f.follow_member_id WHERE follow_app='forums' AND follow_area='forum' AND follow_rel_id=X;

X is forum ID

SELECT m.name FROM core_follow AS f  LEFT JOIN core_members AS m ON m.member_id=f.follow_member_id WHERE follow_app='core' AND follow_area='club' AND follow_rel_id=Y;

Y is club ID

[USCJ Digital]

@newbie LAC ... Please forgive my ignorance. This looks like code, but I have no idea where this should be inserted/how it should be used in order to accomplish the listing of followers for a club. Could you provide a few more details on the procedure you are suggesting? Thank you!

[newbie LAC]

Go to phpMyAdmin and run above sql-queries

Or go to ACP - Support - SQL Toolbox - Run above sql-queries. For 1st query change X on forum ID. For 2nd query change Y on club ID. 

[USCJ Digital]

I will give that a try ... thank you. Can I do this if I'm on a cloud account?

[Joel R]

Yes

The SQL toolbox is a tool that's built into the ACP and probably purposely dedigned for cloud accounts.