branch_location_view (view)

2,921 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE VIEW branch_location_view AS select
  location.code,
  location_name."name" as location_name,
  branch.code_num as branch_code_num,
  branch_name."name" as branch_name,
  'https://collection-analysis.cincy.pl/current_collection/item_view?_facet=location_code&_facet=item_format&location_code__exact=' || location.code as location_item_view
from
  location
  left outer join location_name on location_name.location_id = location.id
  left outer join branch on branch.code_num = location.branch_code_num
  left outer join branch_name on branch_name.branch_id = branch.id
where
  branch_code_num is not null
order by
  branch_code_num,
  location_name;