display the roles(s) for a User in the Manage > Users table

[hellboy1975]

[hellboy1975]

this one is tricky, as the relationships are stored in another table, rather than serialised in a column in the users table. This means generating a list of users involved on extra select for each row in the table - a somewhat costly exercise

Possible alternatives:

• the Users table used could be based on a select on user_club and then joins to users. Grouping then used to display single User rows
• Re-write the relationship used for users to clubs to serialise these in the Users record.

I think the second is probably a simpler approach, and as the User to Club relationship is a simple one, and often only <5 records, a viable approach