SELECT * FROM ...

##</code><code>##

  SELECT DISTINCT item_id, color FROM ...