Iqual than Issue 9743 but I have version 1.1.6
In a local server works fine but not in internet server.

wow!!
I test the sql in phpmyadmin (in server) and don't work!!
SELECT DISTINCT mantis_bug_table . * FROM mantis_bug_table WHERE mantis_bug_table.id IN ( ... ) ORDER BY last_updated DESC

I see that is not a mantis issue :)

hey!! I know how solbed
SELECT mantis_bug_table.* FROM mantis_bug_table WHERE mantis_bug_table.id IN ( ... ) ORDER BY last_updated DESC

not "DISTINCT"

"SELECT DISTINCT" is indeed the correct SQL generated for the page; sorting is working correctly on this tracker and on my test machine, both using the code as it is in MantisBT. I would investigate the integrity of your database installation, as the "DISTINCT" keyword should have no effect on the sorting order. Also be sure that you are using the latest available release for you database version, in case you are coming across a bug in MySQL that has been already fixed.

I think the problem comes with the version of MySQL already commented (in other point). My MySQL version is 4.1.21 and it appears to have a bug.
I've been trying without this parameter (DISTINCT) and working fine.
Why is this important parameter?

"DISTINCT" prevents the query from returning "duplicate" row entries because of the mathematical method in which joins (and/or subqueries) are performed and aggregated.

Added a check for this to our installation routines.