select * from `#__virtuemart_orders` where order_status = 'C' order by virtuemart_order_id DESC LIMIT 1