SELECT * FROM machine_finder WHERE MachineSoldDate IS NULL AND MachineAging = 1 ORDER BY CASE MachineCategory WHEN 'Compact Utility Tractors' THEN 1 WHEN 'Row Crop Tractors' THEN 2 WHEN 'Utility Tractors' THEN 3 WHEN 'Scraper Tractors' THEN 4 ELSE 5 END
