SELECT 
  orders.order_id, 
  orders.order_date,
  extract(day FROM  orders.order_date) AS day,
  extract(month FROM  orders.order_date) AS month,
  extract(year FROM  orders.order_date) AS year,
  orders.order_condition, 
  orders.order_state, 
  order_states.caption, 
  order_conditions.caption, 
  delivery_methods.caption,
  orders.order_cost,
  shipment.warehouse_token, 
  shipment.quantity, 
  item.id_ax, 
  item.name_ax, 
  orders.retail_outlet_warehouse_token
FROM 
  imm.orders
  INNER JOIN  imm.item  ON  (orders.order_id = item.order_id)
  INNER JOIN imm.shipment ON (orders.order_id=shipment.order_id),
  dictionaries.delivery_methods, 
  dictionaries.order_conditions, 
  dictionaries.order_states  
WHERE 
  orders.order_state = order_states.id AND
  orders.delivery_method = delivery_methods.id AND
  order_conditions.id = orders.order_condition AND
  shipment.warehouse_token IN ('АА_Р_01', 'АА_О_12') AND
  orders.order_date >= '2014-12-31';