display shipping method in Admin orders list

[Guest]

The title tells it all: anybody managed to display the shippind method in

 

I tried to tweak my queries in the orders.php page, with no sucess... I know it's not rocket science, but I cannot retrieve the value from the field called "title" with a class "ot_shipping" in the table "order_total".

 

I'm pulling my hair, because it should be as easy as pulling out the price, which is the value from the same field called "title", with a class "ot_total" in the same table. the problem come from the fact the total , shipping and subtotal are managed as successive records (instead of fields of the same record)

 

here is original query I'm trying to alter:

 

	  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";

 

my ultimate goal would be to place a little blinking gif in front of the order number so I can see at a glance the overnight shipping orders that need to go out quickly. The site gets several hundreds of orders a day and opening every order makes it difficult