About Us
Library News
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 locationid,locationShortName FROM LibPublic.dbo.location WHERE publicDisplay IN (1,2,3) ORDER BY locationShortName 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 c.categoryPublicDisplay=1 AND c.categoryPublicDisplay=1 AND n.newsID IN ('3108') ORDER BY newsReleaseDate DESC
The requested news item was not found.
