SELECT 
  orders.order_id, 
  orders.order_condition, 
  orders.ic,
  orders.order_state,
  date(orders.order_date), 
  extract(year FROM  orders.order_date) AS year,
  extract(month FROM  orders.order_date) AS month,
  LEFT (order_goods_item_shipment.warehouse_token, 3) AS TTZ,
  order_goods_item_shipment.quantity, 
  order_goods_item.id_ax, 
  order_goods_item.price, 
 LEFT ( orders.retail_outlet_warehouse_token, 3) AS TTV
FROM 
  imm.orders, 
  imm.order_goods_item_shipment, 
  imm.order_goods_item
  (LEFT JOIN 
(
  SELECT 
  j.entry_timestamp AS aj,
  date(j.entry_timestamp) AS daj 
FROM  
imm.action_journal_order_state 
WHERE
action_journal_order_state.reference_id = orders.order_id))
WHERE 
  order_goods_item_shipment.order_id = orders.order_id AND
  order_goods_item_shipment.order_goods_item_id = order_goods_item.id;