Something

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_lastFROM   aliases AS a, guids AS g, sessions AS s, servers AS svWHERE  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_stringORDER BY time_first ASC