lrdevries

SELECT
  b.containernumber,
  b.state,
  b.pickuptime,
  b.reference,
  l.name,
  ct.displayname,
  b2.pin AS usedFor
FROM tos.booking b
JOIN tos.location l