select a.coursename as category, (select coursename from cutech_course where c_id = c.subcat_course) as subcategory, c.* from cutech_course a right join cutech_coursemanagement c on a.c_id = c.cat_course where c.status = 1 and c.delete_status=0 and c.course_name='Leak Testing L2 (LT)' limit 1
