select keyword,dir_name,url,location.center_id,location.course_id,course_info.course_name,center.name,center.logo_name from location,course_info,center where location.keyword like '%%' and location.area like '%%' and location.course_id=course_info.course_id and location.center_id=center.center_id

---