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

Conceptual design

Services