I have read through the "How to make a date ordered CB list with automatic record aging" article, and found lots of tips in it. Now I want to push CB List one step further.. I have a dropdown with values listing how members found the website. To make a grouped list of the choices, I can use this SQL: (dropdown is stored in cb_referrer)
[code:1]SELECT cb_referrer,count(cb_referrer) FROM jos_comprofiler WHERE cb_referrer!='' GROUP BY cb_referrer;[/code:1]
As far as I can see, I only need a 'group by' instead of the 'sort by', filter on cb_referrer 'Is Not NULL', and use 'cb_referrer' and 'COUNT(cb_referrer)' as Fields.

Problems:
1) There is no 'group by', only 'sort by'
2) There is no COUNT to apply to Fields

Is it even remotely possible to do what I want using 1.0-stable? If not, how many changes would be needed? (would it be a small change for 1.1, or a major one for 2.0...)