Mysql Order / Sort by before Group by Issue resolved

By using this query the issue is resolved:

Query Example:

SELECT * FROM ( select * from `my_table` order by timestamp desc ) as my_table_tmp group by catid order by nid desc;