SELECT *, MAX(history_timestamp) FROM component_history
 GROUP BY id