SELECT * FROM categories ca,courses c,virtual_dates vd,virtual_prices vp where ca.category_slug = "allcourses" and c.category_id = ca.id and vd.course_id = c.id order by c.name