select * from category where cat_id = 4 select c.course_name,c.course_summary, cp.course_page_filename from cat_course_lookup ccl inner join course c on ccl.course_id = c.course_id inner join course_page cp on c.course_id = cp.course_id where ccl.cat_id = #get_cat.cat_id# and cp.page_type_id = 1 order by c.course_name