SELECT * FROM component_history AS ch WHERE 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;