select services.*,categories.categories AS CAT from services,categories where services.status=1 and services.categories_id=3 and services.id=10 and services.categories_id=categories.id group by services.id order by services.id desc

Multi family housing