SELECT DISTINCT a.alias_string,
       MIN(s.time_first) AS time_first,
       MAX(IF(s.time_last IS NULL, sv.last_update, s.time_last)) AS time_last
FROM   aliases AS a, guids AS g, sessions AS s, servers AS sv
WHERE  s.alias_key=a.alias_key
       AND s.guid_key=g.guid_key
       AND s.server_key=sv.server_key
       AND g.guid_string='62fde01ce33c80158d228bb2fe73f25e'
GROUP BY alias_string
ORDER BY time_first ASC