SELECT me.*, thing_max_event.* FROM thing me
LEFT JOIN thing_event thing_max_event ON thing_max_event.id = (
  SELECT TOP 1 id FROM thing_event
  WHERE thing_event.thing_id = me.id
  ORDER BY timestamp DESC
)
WHERE ...