Members who have viewed this thread

[Grig]

If you don't use an ORDER BY clause it uses the default table order, but because it's using MYSQL JOIN's to join different table's together it sort of just "picks one" depending on what's most efficient.

it must think order by join date must be most efficient then .

[Chippiewill]

it must think order by join date must be most efficient then .

If it was last running operations on the user table then yeah, but if it was just looking at the IP table then it'll order by most recently active.

[HotelUser]

Apparently this is a vBulletin feature and not a plugin so instead of sketchily editing files I've made a plugin which alphabetizes the list.

I put it together quickly so if it doesn't work for you give me a shout with your theme & browser.