I am now including additional data from Alma: the number of holdings and the number of Summit loans for each title. Relevant SQL: SELECT A."Selector Note" saw_0, A."Location Code" saw_1, A."Normalized Call" saw_2, A."Permanent Call" saw_3, A."MMS ID" saw_4, A."Barcode" saw_5, A."Title" saw_6, A."Publication Date" saw_7, A."Author" saw_8, A."Description" saw_9, A."Material Type" saw_10, A."ISBN" saw_11, A."Last Loan Date" saw_12, A."Not in House" saw_13, A."In House" saw_14, A."Millenium" saw_15, C."Summit Loans" saw_16, B."Number of Holdings" saw_17 FROM ( SELECT 0 s_0, "Physical Items"."Bibliographic Details"."Author" "Author", "Physical Items"."Bibliographic Details"."ISBN" "ISBN", "Physical Items"."Bibliographic Details"."Material Type" "Material Type", "Physical Items"."Bibliographic Details"."MMS Id" "MMS ID", "Physical Items"."Bibliographic Details"."Publication Date" "Publication Date", "Physical Items"."Bibliographic Details"."Title" "Title", "Physical Items"."Holding Details"."Normalized Call Number" "Normalized Call", "Physical Items"."Holding Details"."Permanent Call Number" "Permanent Call", "Physical Items"."Library Unit"."Library Code" s_9, "Physical Items"."Location"."Location Code" "Location Code", "Physical Items"."Physical Item Details"."Barcode" "Barcode", "Physical Items"."Physical Item Details"."Description" "Description", "Physical Items"."Physical Item Details"."Internal Note 2" "Selector Note", "Physical Items"."Physical Item Details"."Last Loan Date" "Last Loan Date", "Physical Items"."Physical Item Details"."Lifecycle" s_15, "Physical Items"."Physical Item Details"."Process Type" s_16, "Physical Items"."Physical Item Details"."Statistics Note 1" "Millenium", "Physical Items"."Loan Measures Post-Migration"."Num of Loans (In House)" "In House", "Physical Items"."Loan Measures Post-Migration"."Num of Loans (Not In House)" "Not in House" FROM "Physical Items" WHERE (("Library Unit"."Library Code" = 'bothell') AND ("Physical Item Details"."Process Type" = 'Missing') AND ("Physical Item Details"."Lifecycle" = 'Active') AND ("Physical Item Details"."Internal Note 2" LIKE 'Selector%')) )A LEFT OUTER JOIN ( SELECT 0 s_0, "Titles"."Bibliographic Details"."MMS Id" s_1, "Titles"."Title Details"."Library Code (Physical)" s_2, "Titles"."Title Measures"."Num of Holdings (Active)" "Number of Holdings" FROM "Titles" WHERE ("Title Details"."Library Code (Physical)" LIKE '%bothell%') ) B ON A."MMS ID" = B.s_1 LEFT OUTER JOIN ( SELECT 0 s_0, "Lending Requests (Resource Sharing)"."Bibliographic Details"."MMS Id" s_1, "Lending Requests (Resource Sharing)"."Location at time of loan"."Library Name (Active)" s_2, "Lending Requests (Resource Sharing)"."Lending Requests Details"."Num of Request Filled" "Summit Loans" FROM "Lending Requests (Resource Sharing)" WHERE ("Location at time of loan"."Library Name (Active)" = 'UW Bothell CC Library') ) C ON A."MMS Id" = C.s_1 ORDER BY saw_0, saw_1, saw_2, saw_3, saw_4, saw_5, saw_6, saw_7, saw_8, saw_9, saw_10, saw_11, saw_12, saw_15