SELECT IFNULL(first_name, ``) + CASE WHEN middle_name IS NOT NULL THEN ` ` + middle_name ELSE `` END 
			+ CASE WHEN last_name IS NOT NULL THEN ` ` + last_name ELSE `` END as c_name
			, CASE WHEN b_legal = 0 THEN `ФЛ` WHEN b_legal = 1 THEN `ЮЛ` 
			ELSE `Не определено` END as c_type
			, `+x-xxx-xxx-xx-xx` as tel
FROM `qd3g9_anysend_contacts` AS `c`
ORDER BY `c`.`last_name`, `c`.`first_name`, `c`.`middle_name`