Разобрался :rolleyes:
CONCAT_WS(' ',u.full_name, cu.cf_family ) AS full_name
Весь запрос:
SELECT ei.member_id, m.*, CONCAT_WS(' ',u.full_name, cu.cf_family ) AS full_name
FROM phpfox_destination AS m
LEFT JOIN phpfox_destination_member AS ei
ON(ei.destination_id = m.destination_id AND ei.user_id = 38184)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
LEFT JOIN phpfox_destination_text AS t
ON(t.destination_id = m.destination_id)
JOIN phpfox_user_custom AS cu
ON(cu.user_id = m.user_id)
WHERE m.view_id = 0
ORDER BY m.is_featured DESC, m.time_stamp DESC
LIMIT 5
_____________
Гнусный социопат с комплексом Бога.