# Get Patron Saved Title Lists With Current Items

**URL:** https://forum.innovativeusers.org/t/get-patron-saved-title-lists-with-current-items/1288
**Category:** Polaris Repository
**Tags:** polaris-patrons, sql, polaris
**Created:** [June 16, 2023, 7:38pm UTC](https://forum.innovativeusers.org/t/get-patron-saved-title-lists-with-current-items/1288 "2023-06-16T19:38:54Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![CyberpunkLibrarian](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/cyberpunklibrarian/32/1168_2.png) [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)
#### Post date: [June 16, 2023, 7:38pm UTC](https://forum.innovativeusers.org/t/get-patron-saved-title-lists-with-current-items/1288/1 "2023-06-16T19:38:54Z")

</div>

This query pulls all of a patron’s Saved Title lists from their PowerPAC account and displays the current titles contained in each list.

```auto
-- Drop your PatronID below
DECLARE @PatronID INT = 42244

SELECT
    DISTINCT br.BrowseTitle AS [Title],
    irrs.Name AS [Saved Title List]

FROM
    Polaris.Polaris.IRRecordStores irrs WITH (NOLOCK)

INNER JOIN
    Polaris.Polaris.IRRecords irr WITH (NOLOCK)
    ON (irr.RecordStoreID = irrs.RecordStoreID)
INNER JOIN
    Polaris.Polaris.IRRecordIndex irri WITH (NOLOCK)
    ON (irr.RecordStoreID = irri.RecordStoreID)
INNER JOIN
    Polaris.Polaris.IRCacheEntries irce WITH (NOLOCK)
    ON (irce.CacheEntryID = irr.CacheEntryID)
LEFT JOIN
    Polaris.Polaris.BibliographicRecords br WITH (NOLOCK)
    on (irce.LocalControlNumber = br.BibliographicRecordID)

WHERE
    irrs.AccountID = @PatronID
AND
    irri.AttributeTypeID = 2
ORDER BY
    irrs.Name,
    br.BrowseTitle

```