Nanini Branch Library

Regularly Scheduled Events

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT categoryID,categoryName FROM LibPublic.dbo.enm_categories WHERE categoryEvents=1 ORDER BY categoryNameError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT TOP 2000 e.EventID AS eventID,e.Title AS eventTitle,e.Description AS eventDescription,e.OngoingDescrip AS eventOngoingDescription,ed.EventDateID AS eventOccurrenceID,ed.Categories,ed.LocationID,CONVERT(VARCHAR(10),ed.TheDate,120) AS startDate,ed.StartHour,ed.StartMin,ed.EndHour,ed.EndMin,ed.AdditionalDescription AS eoDescription,ed.EventRoom AS eoEventRoom,ed.CommunityLocation AS eoCommunityLocation,ed.RegInfo AS eoRegReq,ed.NewsID AS newsID,l.LocationShortName FROM event_date ed LEFT JOIN event e ON e.EventID=ed.EventID LEFT JOIN Location l ON l.LocationID=ed.LocationID WHERE (ed.LocationID LIKE '11') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) AND e.Ongoing=1 ORDER BY Title ASC

Upcoming Events

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT categoryID,categoryName FROM LibPublic.dbo.enm_categories WHERE categoryEvents=1 ORDER BY categoryNameError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT TOP 8 e.EventID AS eventID,e.Title AS eventTitle,e.Description AS eventDescription,e.OngoingDescrip AS eventOngoingDescription,ed.EventDateID AS eventOccurrenceID,ed.Categories,ed.LocationID,CONVERT(VARCHAR(10),ed.TheDate,120) AS startDate,ed.StartHour,ed.StartMin,ed.EndHour,ed.EndMin,ed.AdditionalDescription AS eoDescription,ed.EventRoom AS eoEventRoom,ed.CommunityLocation AS eoCommunityLocation,ed.RegInfo AS eoRegReq,ed.NewsID AS newsID,l.LocationShortName FROM event_date ed LEFT JOIN event e ON e.EventID=ed.EventID LEFT JOIN Location l ON l.LocationID=ed.LocationID WHERE (ed.LocationID LIKE '11') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) ORDER BY TheDate ASC

Contact This Branch

7300 N. Shannon Rd.
Tucson, AZ 85741
(520) 594-5365

Google map
Printer-friendly map (PDF)
Bus Routes: 16, 61, 102 & 103 come to Ina/Shannon
Sun Shuttle

Branch Manager, Kristi Bradford, 520.594.5370

Connect with us on Twitter and Facebook!

Branch Hours

Mon 10am-8pm
Tues 10am-8pm
Wed 10am-8pm
Thu 10am-8pm
Fri 10am-5pm
Sat 9am-5pm
Sun 1pm-5pm

More about this branch
Meeting rooms, computers, history, and more.

Book Drop

Our book drop is located to the right of the entrance.

What's Happening at Nanini Branch?

Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT newsID FROM enm_news n INNER JOIN enm_newsType t ON t.newsTypeID=n.newsTypeID_fk LEFT JOIN (enm_news_location nl LEFT JOIN location l ON nl.nl_locationID_fk=l.LocationID) ON nl.nl_newsID_fk=newsID LEFT JOIN (enm_news_categories nc LEFT JOIN enm_categories c ON c.categoryID=nc_categoryID_fk) ON nc.nc_newsID_fk=newsID LEFT JOIN enm_newsImages ni ON ni.ni_newsID_fk=n.newsID LEFT JOIN (enm_users iu LEFT JOIN LibStaff.dbo.userProfiles ip ON ip.profileID=iu.userProfileID_fk) ON iu.userID=n.newsInsertUserID_fk LEFT JOIN (enm_users iu2 LEFT JOIN LibStaff.dbo.userProfiles ip2 ON ip2.profileID=iu2.userProfileID_fk) ON iu2.userID=n.newsUpdateUserID_fk WHERE (CONVERT(VARCHAR(10),newsReleaseDate,120)<=CONVERT(VARCHAR(10),GETDATE(),120) OR newsReleaseDate IS NULL) AND (CONVERT(VARCHAR(10),newsExpirationDate,120)+' 23:59:59'>=GETDATE() OR newsExpirationDate IS NULL) AND newsApproved=1 AND nl.nl_locationID_fk IN ('11') AND c.categoryPublicDisplay=1 ORDER BY newsReleaseDate desc
Pima County Website