Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT cms_usergroups.title
FROM (((cms_users
INNER JOIN cms_user_usergroup_map
ON cms_users.id = cms_user_usergroup_map.user_id)
INNER JOIN cms_usergroups
ON cms_user_usergroup_map.group_id = cms_usergroups.id)
INNER JOIN cms_comprofiler
ON cms_users.id = cms_comprofiler.user_id)
WHERE cms_users.id = [cb:userdata field="user_id" user="#displayed" /];
Please Log in to join the conversation.