((select count(*) from `xxxx_comprofiler_members` AS m where m.`accepted` = '1' ) > 0 ) but the result return all the users.

Your filter doesn't include matching their CB row to the connections table row. You need to add the following.


So your query should look like the below for example.


For userlist query the "u" alias is for Joomlas users table and the "c" alias is for CBs _comprofiler table. This allows access to CB and Joomla data.

[id] isn't a substitution. To get the viewing users user id you need to use [user_id]. referenceid is the user who created the connection request. memberid is the recipient of the connection request. There will be 2 rows for a connection reversing those as needed if you're using cross connections.

Enable debug mode and maximum error reporting in Joomla global configuration and debug the query at the bottom of the page in the query log. You can test the query from the log in phpmyadmin directly to help refine your query. referenceid is the user making the connection so you're querying for connections that 554 has connected to not necessarily users who have connected to 554, which if that's what you're wanting you need to use memberid.