Hi Kyle, I already understood what would happen and this code has been perfect to solve the problem:
Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_plugin_privacy` AS p WHERE p.`user_id` = u.`id` AND p.`asset` = 'profile' AND p.`rule` = 0 ) > 0 )
Thanks again for your help. Although the previous post was more than 2 years old, are you still trying to solve this case using a filter?
Best regards
Diego