It probably would be easier to use a userlist for that. The below should work.
Filters
Advanced
Parameters > Display
Show Blocked: Yes
Show Unapproved: Yes
Show Unconfirmed: Yes
Note this will only work if you're viewing the userlist as a moderator.
As for your question regarding CB Query Field you'd use the below to loop and display query data for example.
Query
Code:
SELECT *
FROM `jos_comprofiler` AS cb
INNER JOIN `jos_users` AS u
ON u.`id` = cb.`id`
WHERE cb.`approved` = 2
LIMIT 50
Display
Output: Multiple Rows
Columns: Multiple Columns
Row:
Code:
<div>[column_username] - [column_email]</div>
This for example should show rejected users username and email in a div per user.
krileon
