SELECT * FROM component_history AS ch WHERE ch.component_id = (
    -- Suche die IDs fuer den groessten Timestamp pro ID
    SELECT component_id FROM component_history WHERE component_id=ch.component_id ORDER BY history_timestamp DESC LIMIT 1
    )
  AND history_timestamp = (
    -- Suche den groessten Timestamp fuer die ID
    SELECT history_timestamp FROM component_history WHERE component_id=ch.component_id ORDER BY history_timestamp DESC LIMIT 1
    )
  ORDER BY component_id;