BUG:
If you use the Admin Queue on a query in Raiser's Edge, then if you use that query in a list in NetCommunity the record count will always be zero in NetCommunity.
This remains true even if you take the query out of the queue. There is no indication on the list that it was "once queued, and so now won't work in NetCommunity".
WORKAROUND:
So far the only solution is to create a new copy of the query, and use the new query in a new list in NetCommunity.