TOPIC: Event List ordering

Hi,

I'm trying to alter the default order of the event list module.
I'd like it to order first by fields hot_event or top_event and then by begin, I put "r.hot_event DESC, r.begin ASC" and it doesn't work as expected, doesn't show any event.
Can I accomplish it by any means or should I rely on the filter panel?

Thanks
Carlos

It's a.hot_event not r. (Different table in the join)

Kind regards,

Yves

Thanks a lot, my bad...