CODE EXAMPLE FOR SQL

sql order by case

select 
  `orders`.* 
from 
  `orders` 
order by 
  CASE WHEN orders.status = 11 THEN 999999999 WHEN orders.status = 20 THEN 999999998 ELSE orders.id END DESC