Category1 (100)

Forum1 (100)

Sub-Forum11 (100)

Sub-Forum12 (200)

Sub-Sub-Forum121 (100)

Sub-Sub-Forum122 (200)

Sub-Sub-Forum123 (300)

Sub-Forum13 (300)

Forum12 (200)

Forum13 (300)

Forum14 (400)

Sub-Forum41 (100)

Sub-Forum42 (200)

Sub-Forum43 (300)

Category2

Forum21 (100)

Forum22 (200)

Forum23 (300)

Forum24 (400)

Category3

Forum31 (100)

Forum32 (200)

Forum33 (300)

Forum34 (400)

Yes, this is a known problem, but look at it as a possibility.

Is it a problem with SQL WHERE clause to initially get these items ordered before they go to the appropriate places in the tree?

Yes, this is a known problem, but look at it as a possibility.

Is it a problem with SQL WHERE clause to initially get these items ordered before they go to the appropriate places in the tree?

Thank!!!!!