Error!

MySQL Error: Unknown column 'total' in 'order clause'
SQL Statement: select count(*) as total_records from (SELECT 1 FROM contents JOIN user_tracking_current on contents.id=user_tracking_current.object_id WHERE user_tracking_current.object_type = 'content' and contents.magazine_id = 5 and (contents.content_type_id = 2487 or contents.content_type_id=2486 or contents.content_type_id = 2492) group by contents.id ORDER BY total desc ) as t