SELECT proj_id,proj_title,cat_slug FROM projects, project_link, project_categories WHERE proj_active = 1 AND lnk_projID = proj_id AND lnk_catID = cat_id AND cat_id = '9' ORDER BY proj_posportfront