CB List total records do not match database total records

I have a list of users with the only filter as follows:
`cb_activemember`= 4

This gives a Total Records result as 4448

But when I do the following search of the comprofiler table in phpMyAdmin
SELECT * FROM `jos_comprofiler` WHERE `cb_activemember` = 4

This gives a records total of 4477

There is a difference of 29 records. Originally I had a single User Group chosen in "User Groups to Include in List" (the only group that should have this value in the field) to represent this total, but even if I choose ALL User Groups, this discrepancy does not change. How can I account for this difference?

Using most current version of CB for Joomla 2.5.28

boyjahq wrote: I have a list of users with the only filter as follows:
`cb_activemember`= 4

This gives a Total Records result as 4448

But when I do the following search of the comprofiler table in phpMyAdmin
SELECT * FROM `jos_comprofiler` WHERE `cb_activemember` = 4

This gives a records total of 4477

There is a difference of 29 records. Originally I had a single User Group chosen in "User Groups to Include in List" (the only group that should have this value in the field) to represent this total, but even if I choose ALL User Groups, this discrepancy does not change. How can I account for this difference?

Using most current version of CB for Joomla 2.5.28

Users displayed in CB User lists are only those that are enabled and approved/confirmed.

So I am guessing that the differences you are seeing are caused by this.

Is there a way to search this in phpMyAdmin? Can I simultaneously search jos_comprofiler for those records where `cb_activemember`= 4 while also finding the corresponding users in whatever table shows whether they are not enabled and approved/confirmed?

You can allow your userlist to display unconfirmed, etc.. users by adjusting the parameters under Parameters > Display while editing your userlist. Querying the database directly is not going to be accurate unless you understand the relationship between _comprofiler and _users, their columns for filtering enabled users, and the joins. Best way to query phpmyadmin directly and get the same results as a userlist is to enable debug mode, navigate to your userlist on frontend, then grab its query from the query log.