Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT DISTINCT ue.*, u.*, '' AS 'NA'
FROM jos_users u
JOIN jos_user_usergroup_map g
ON g.`user_id` = u.`id`
JOIN jos_comprofiler ue
ON ue.`id` = u.`id`
...............
Please Log in to join the conversation.
SELECT DISTINCT ue.*, u.*, '' AS 'NA'
FROM adf1t_users u
JOIN adf1t_user_usergroup_map g
ON g.`user_id` = u.`id`
JOIN adf1t_comprofiler ue
ON ue.`id` = u.`id`
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND g.group_id IN (2, 21, 17, 18)
AND ((ue.`cb_rank2` = 'Authorised') OR (ue.`cb_rank2` = 'Fellowship') OR (ue.`cb_rank2` = 'Member'))
AND ( `cb_group` = 'Jobseeker' )
ORDER BY `firstname` ASC
LIMIT 0, 20
Please Log in to join the conversation.
Please Log in to join the conversation.