Please improve my fetched forumlist by MySQL

[ThorstenA]

I have profile field values connected with forums and depending which profile field a viewer has ("I am driving porsche"), he sees the connected forum with subforums ("Porsche" "-- Porsche Discussion" "-- Porsche 911") on top of the forum list.

Instead of

General Forums
-- Discussion
Porsche
-- Porsche Discussion
-- Porsche 911 ...

He sees

Porsche
-- Porsche Discussion
-- Porsche 911
General Forums
-- Discussion ...

The script searches for lots of profile fields and depending on them puts the for the user most interesting on the top. The script also takes user behavior into consideration:

• subscribed forums
• moderated forums
• forums where you read threads
• forums where you posted

All these forums are on the top, depending whether they might be of interest for the user or not.

In Mysql I can easily query all this together and get the perfect forum order for me instead of doing all this sorting stuff in the cache forum php list which maybe is not made for things like this.