A "fix" for this if you want to incur a performance hit, is to create another table. Insert the original select statement into it, then insert the alt-select into it.
Then, select ALL the links from this new table, in the &build_sort_order order.
All the links should then be sorted properly.
You need to then delete this table, or erase it's data. Since a link should only be in any category once, you shouldn't get any errors, but you could always insert the alt-links one-by-one checking for errors.
There are other "logical" ways to do it, but this is the quick and dirty one.
http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/
Then, select ALL the links from this new table, in the &build_sort_order order.
All the links should then be sorted properly.
You need to then delete this table, or erase it's data. Since a link should only be in any category once, you shouldn't get any errors, but you could always insert the alt-links one-by-one checking for errors.
There are other "logical" ways to do it, but this is the quick and dirty one.
http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/