cheesegrits
Support Gopher
BTW, you can see that query if you append &fabrikdebug=1 to the list URL, then look at the getData section of the debug output. You could then copy and paste that query in to phpMyAdmin, remove the "SQL_CALC_FOUND_ROWS DISTINCT", and see how many rows it selects. You'll also have to replace #_ with your J! database prefix on the references to your users table.
-- hugh
-- hugh