( ( SELECT COUNT(*) FROM `#__groupjive_users` AS gj WHERE gj.`user_id` = u.`id` AND gj.`group` = GROUP_ID ) > 0 )
Please Log in to join the conversation.
Please Log in to join the conversation.
( ( SELECT COUNT(*) FROM `#__groupjive_users` AS usr INNER JOIN `#__groupjive_groups` AS grp ON grp.`id` = usr.`group` WHERE usr.`user_id` = u.`id` AND grp.`category` = CATEGORY_ID ) > 0 )
Please Log in to join the conversation.
Please Log in to join the conversation.