SELECT DISTINCT item_id, color FROM ...