Insert Into NotFound (Path,Type,HTTPRefer) Values (,'file', ) SELECT * FROM RegionalPages WHERE SectionAlias = '#RequestedTemplate#' SELECT TOP 1 URL, RedirType FROM Redirects WHERE (Mapping = OR Mapping = ) AND (Expires Is Null OR Expires > '#DateFormat(now(),"short")#') SELECT * FROM FriendlyURLs WHERE friendlyName = '#RequestedTemplate#' SELECT Courses.CCID, Courses.CourseNum, Discounts.* from Discounts JOIN Courses ON Courses.CCID = Discounts.CCID Where Username = AND StartDate <= '#Dateformat(now(),"m/d/yyyy")# 12:01 AM' Order by EndDate desc SELECT * from checkSponsors WHERE EndDate >= '#Dateformat(now(),"m/d/yyyy")# 23:59:59' SELECT top 1 CCID, Type FROM Courses WHERE ( Replace(CourseNum,' ','') = ) AND (Available = 1 OR CCID IN (SELECT DISTINCT CCID FROM Discounts Where StartDate <= '#Dateformat(now(),"m/d/yyyy")# 12:01 AM' AND EndDate >= '#Dateformat(now(),"m/d/yyyy")# 23:59:59')) SELECT top 1 CCID FROM Courses WHERE Replace(CourseNum,' ','') = AND Available = 1 SELECT * FROM Discounts WHERE CCID = #getSyllabus.CCID# AND Section_Feat = 1 AND StartDate <= '#Dateformat(now(),"m/d/yyyy")# 12:01 AM' AND EndDate >= '#Dateformat(now(),"m/d/yyyy")# 23:59:59' SELECT top 1 * from Categories WHERE Alias = SELECT top 1 Courses.CCID, Discounts.DiscountID FROM Discounts JOIN Courses On Discounts.CCID = Courses.CCID WHERE CourseNum = AND discounts.DiscountID = #ThisDiscountID# AND StartDate <= '#Dateformat(now(),"m/d/yyyy")# 12:01 AM' AND EndDate >= '#Dateformat(now(),"m/d/yyyy")# 23:59:59' #RequestedTemplate# is expired or no longer available. Insert Into NotFound (Path,Type,HTTPRefer,IP,Browser) Values ( ,'CE',, , ) SELECT top 1 * FROM Category WHERE FriendlyName = SELECT top 1 Company.Company, Company_Featured.CID, ProfileParagraph from company_Featured JOIN Company On company.CID = Company_featured.CID Where FriendlyName = SELECT * FROM State Where StateID = OR State = AND Active = 1 AND Countryid = 'US' #RequestedTemplate# is no longer available. Insert Into NotFound (Path,Type,HTTPRefer,IP,Browser) Values ( ,'jobs',, , ) Insert Into NotFound (Path,Type,HTTPRefer,IP,Browser) Values ( ,'template',, ,) The document you requested can not be found.