Hi
Thanks for your helpful reply.
So when I choose 'Is on of' and the select multiple choices (the last choice is called 'Authorised Fellowship Member' (see attached), the query is breaking it into 3 different words. Here's the query I get :
Code:
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
Ideas?
krileon
