La query en si, sería mas o menos:
Código MySQL:
Ver original -> P.product_id,
-> P.product_name,
-> IFNULL(OO.output_order_id
, '-') output_order_id
, -> IFNULL(OO.output_order_stat
, '.') output_order_stat
, -> IFNULL(OD.quantity
, 0) quantity
-> product P
-> output_order_detail OD
ON p.product_id
= OD.product_id
-> output_order OO
ON OD.output_order_id
= OO.output_order_id
-> OD.output_order_id = 1
+-----------------+------------------------------+-----------------+-------------------+----------+
| product_id | product_name | output_order_id | output_order_stat | quantity |
+-----------------+------------------------------+-----------------+-------------------+----------+
| 158-1127 | Cabezal - Unidad de Rotacion | - | . | 0 |
| 170-0494 | Elbow | - | . | 0 |
| 1J-9671 | O-Ring | 1 | Guardado | 1 |
| IMOPROMPRO43431 | Dell Inspiron i5 4gb ram | 1 | Guardado | 1 |
| IMOPROMPRO43432 | Dell Inspiron i7 4gb ram | - | . | 0 |
| IMOPROMPRO43433 | Dell Vostro i7 4gb ram | - | . | 0 |
+-----------------+------------------------------+-----------------+-------------------+----------+