[thelist] SQL .. is there a better way ?

[rudy]

> If anyone wants to hash it out in IRC [1].. a few of us are there

hi michele

i went into the channel, said hi to the half dozen bots, and left

i looked at your sql and it looks okay to me

without seeing your data, i'd guess that you could probably get the counts
from the first result set, and not even bother with the second

assuming you know how to loop through query results more than once

if you must generate the counts in the query along with the details, that
can be done with a UNION but it's ugly, and then you have to skip over the
counts when printing the details


rudy