SELECT a.*, b.*,
(SELECT max(date_call) from call_history WHERE client_id = a.id) as last_call,
(SELECT call_date from call_remind WHERE client_id = a.id) as call_remind
FROM clients a
INNER JOIN contacts b
WHERE
a.user_id = 208
AND
a.id = b.client_id