Code:
  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_id, o.customers_name as customers_name, o.payment_method, o.shipping_method, o.date_purchased as date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total" .
                          $new_fields . "
                          from (" . TABLE_ORDERS_STATUS . " s, " .
                          TABLE_ORDERS . " o " .
                          $new_table . ")
                          left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') " . "  order by orders_id DESC limit 5" );
$new_fields . and $new_table . don't look like they belong here - they probably were part of the other code Ajeh took it from.