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 = '4' ) ORDER BY c.c_order DESC