Health & Wellness
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 nc.nc_categoryID_fk IN ('20') AND c.categoryPublicDisplay=1 ORDER BY newsReleaseDate DESCError: 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 5 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 (Categories LIKE '%,20,%') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) ORDER BY ed.TheDate ASCBack to Topics & Online Resources
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 nc.nc_categoryID_fk IN ('20') AND c.categoryPublicDisplay=1 ORDER BY newsReleaseDate DESCError: 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 5 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 (Categories LIKE '%,20,%') AND CONVERT(VARCHAR(10),ed.TheDate,120)>=CONVERT(VARCHAR(10),GETDATE(),120) ORDER BY ed.TheDate ASCBack to Topics & Online Resources
Resources marked with a 
can be accessed without a library card using your zip code on the AZ State Library Website.
Alt HealthWatch- Curious about herbal remedies, acupuncture, reflexology, or other complementary, holistic, traditional, or integrated medicine? Read and print articles and research studies here.AZ State Library Access
Gale Virtual Reference Library- Doing research? Got homework? Need information? Dig in to this printable library of thousands of eBooks and encyclopedia articles on almost every subject, from arts to biographies to business plans to health and medicine to science and technology. You can email or download, too! Check here for books like the Gale Encyclopedia of Medicine and the Encyclopedia of Drugs, Alcohol, and Addictive Behavior, plus many books on specific health and medicine matters.
Health Source Consumer Edition- Browse through magazines, pamphlets, and books about many different aspects of health and wellness.AZ State Library Access
MedLine Plus- Get reliable, up-to-date health information in over forty languages direct from the National Library of Medicine.
PubMed - Delve deeper into biomedical research with literature from a variety of trustworthy sources.
RHIN - Multilingual health information for refugees and the people who care for them.