SELECT title AS city title AS phone FROM clients AS LEFT JOIN SELECT t

SELECT 
 `u`.*,
 `c`.`title` AS `city`,
 `p`.`title` AS `phone`
FROM
 `clients` AS `u`
LEFT JOIN
 (SELECT `title`, `client_id` FROM `clients_contacts` WHERE `type` = 1) AS `c`
 ON
 `u`.`id` = `c`.`client_id`
LEFT JOIN
 (SELECT `title`, `client_id` FROM `clients_contacts` WHERE `type` = 3) AS `p`
 ON
 `p`.`client_id` = `u`.`id`;