SELECT c.id, c.name, c.middle_name, c.surname, c.information, c.service_id, c.subscription_status, c.expire_date, l.name, s.name
FROM clients c
INNER JOIN locations l ON c.location_id = l.id
INNER JOIN services s ON c.service_id = s.id
WHERE c.status =1