Selecting the most recent order status...

[Ajeh]

Not sure where you are wanting this to run ... phpMyAdmin or in your Zen Cart Admin ...

This should work in phpMyAdmin ...

select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, 
o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name
from orders_status s, orders o 
where o.orders_status = s.orders_status_id and s.language_id = '1' 
order by o.orders_id DESC;

I added a few fields but you can add more if you need them ...