-- ## 4: コメントの一覧 ## --

-- コメントの一覧です。

SELECT
   (CASE author
      WHEN '$USER' THEN 'background: #eff;'
      ELSE 'background: #ffe;'
    END) AS __style__,
   time as time,
   author ,
   ticket as ticket,
   newvalue as description 
  FROM ticket_change
  WHERE field = 'comment'
  ORDER BY time desc