SELECT c.id, c.title, c.instructions, cd.category_id, cat.CategoryName FROM courses AS c, course_detail AS cd, category AS cat WHERE c.id = cd.course_id AND cd.category_id = cat.CategoryId AND c.c_status = '1' AND cat.CategoryStatus = '1' AND c.id IN (SELECT course_id FROM course_detail WHERE category_id = '3' ) ORDER BY c.c_order DESC

COURSE TYPE

Free

Business Management (Short Course)

You are enroling now on free course

Free

Human Resources Management (Short Course)

You are enroling now on a free course

Free

Project Management (Short Course)

You are enroling now on free course

Free

Customer Services (Short Course)

You are enroling on free course now.

Copyright 2017

eLearning College.

All rights are reserved.