Jump to content

Listing of those following a club


USCJ Digital

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...