SELECT categories.CategoryID, categories.CategoryName, categories.Alias, COUNT(courses.Title) AS NumCourses FROM categories LEFT OUTER JOIN courses ON categories.CategoryID = courses.CategoryID WHERE (categories.CategoryID > 0) AND (courses.Available = 1) AND ((courses.IsOnline = 1) OR (Courses.IsBook = 1) OR (Courses.IsVideo = 1)) GROUP BY categories.CategoryName, categories.Alias, categories.CategoryID ORDER BY categories.CategoryName SELECT Count(ID) AS num FROM Courses WHERE Available = 1 SELECT TOP 3 courses.Title, courses.AudioURL, courses.CourseNum, courses.rev, courses.Subhead, Courses.CCID, Courses.ID, Courses.Hours, Courses.Cost, Courses.IsOnline, Courses.IsBook, Courses.IsVideo, Courses.ICN, Courses.Advanced, Courses.JCAHO, Courses.Magnet, Courses.LoadDate, Courses.EBP, Courses.RevDate , categories.* FROM categories LEFT OUTER JOIN courses ON categories.CategoryID = courses.CategoryID WHERE Available = 1 ORDER BY courses.LoadDate Desc SELECT Discounts.DiscountPrice, Discounts.TagLine, courses.AudioURL, Discounts.Type, courses.Title, courses.CourseNum, courses.rev, courses.Subhead, Courses.CCID, Courses.ID, Courses.Hours, Courses.Cost, Courses.IsOnline, Courses.Ebp, Courses.Jcaho, Courses.Magnet, Courses.Advanced, Courses.ICN, Courses.IsBook, Courses.IsVideo, Courses.LoadDate, Courses.RevDate , categories.* FROM Discounts LEFT OUTER JOIN courses ON courses.CCID = Discounts.CCID JOIN Categories ON categories.categoryID = courses.CategoryID WHERE StartDate <= '#DateFormat(now(),"m/d/yyyy")# 12:01 AM' AND EndDate > '#DateFormat(now(),"m/d/yyyy")# 23:59:59' AND Discounts.Section_feat = 1

#Application.SiteName#

Continuing Education, Unlimited CEs, Self-Study Courses, State Certificate Courses, State-Required Continuing Education Courses, and more!

Save Time & Money! Keep all your contact hours in one place! Sign up for our Unlimited CE program, where, for the one time price of #DollarFormat(UnlimitedPrice)#, you can take any of our Online Continuing Education Courses, 1.5 contact hours or less, and all state-specific mandatory modules for free for 1 year. All other online courses are 50% off.

#application.IntroPar#

Unlimited CE Courses, Continuing Education Credits, State-Mandated Continuing Education Courses, Instant Certificates, Audio CE, and more!

Featured CE Course

Course ID

Course Title

Media Type

#CourseNum##LCASE(rev)#
No CE #NumberFormat(Hours,'_._')# hr s