Something

mysql> EXPLAIN EXTENDED SELECT o.orders_type, o.orders_status, o.orders_id, o.orders_po, o.orders_date, o.orders_customers_po, c.customers_name, o.orders_issue_date, o.orders_requested_date, o.orders_confirmed_date, s.styles_no, os.styles_id, v.vendors_name
    ->   from orders o
    -> inner
    ->   join customers c
    ->     on c.customers_id = o.customers_id
    -> left outer
    ->   join orders_styles os
    ->     on os.orders_id = o.orders_id
    -> left outer
left outer
    ->   join styles s
    ->     on s.styles_id = os.styles_id
    -> left outer
    ->   join vendors v
    ->     on v.vendors_id = s.vendors_id  group by o.orders_id order by o.orders_po desc LIMIT 220,20;
+----+-------------+-------+--------+---------------+-----------+---------+-----------------------------+------+----------+-----------------+
| id | select_type | table | type   | possible_keys | key       | key_len | ref                         | rows | filtered | Extra           |
+----+-------------+-------+--------+---------------+-----------+---------+-----------------------------+------+----------+-----------------+
|  1 | SIMPLE      | o     | index  | customers_id  | orders_po | 4       | NULL                        |   80 | 49707.50 | Using temporary |
|  1 | SIMPLE      | c     | eq_ref | PRIMARY       | PRIMARY   | 4       | revgrp_admin.o.customers_id |    1 |   100.00 |                 |
|  1 | SIMPLE      | os    | ref    | orders_id     | orders_id | 4       | revgrp_admin.o.orders_id    |    3 |   100.00 |                 |
|  1 | SIMPLE      | s     | eq_ref | PRIMARY       | PRIMARY   | 4       | revgrp_admin.os.styles_id   |    1 |   100.00 |                 |
|  1 | SIMPLE      | v     | eq_ref | PRIMARY       | PRIMARY   | 4       | revgrp_admin.s.vendors_id   |    1 |   100.00 |                 |
+----+-------------+-------+--------+---------------+-----------+---------+-----------------------------+------+----------+-----------------+
5 rows in set, 1 warning (0.00 sec)