Please Log in to join the conversation.
Your filter doesn't include matching their CB row to the connections table row. You need to add the following.((select count(*) from `xxxx_comprofiler_members` AS m where m.`accepted` = '1' ) > 0 ) but the result return all the users.
m.`referenceid` = u.'id'
SELECT COUNT( * ) FROM `#__comprofiler_members` AS m WHERE m.`referenceid` = u.`id` AND m.`accepted` = 1
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.
Please Log in to join the conversation.