item_in_transit_view (view)

7,707 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW item_in_transit_view AS select
  item.item_record_num,
  item.record_last_updated as item_record_last_update,
  item.barcode,
  date(item_message.in_transit_julianday) as in_transit_date,
  item_message.in_transit_days,
  item_message.transit_from,
  item_message.transit_to,
  item.agency_code_num,
  item.location_code,
  item.checkout_date,
  item.due_date,
  item.item_format,
  item.item_status_code,
  item.price_cents,
  item.item_callnumber,
  item.bib_record_num,
  item.volume_record_num,
  item.volume_record_statement,
  date(hold.placed_julianday) as date_hold_placed,
  date(hold.expires_julianday) as date_hold_expires,
  item_message.has_in_transit_too_long
from
  item
  join hold on hold.item_record_num = item.item_record_num
  join item_message on item_message.item_record_id = item.item_record_id
where
  item.item_status_code = 't';