{{{#!div class="trac-recent-changes"
{{{#!SQLTable
SELECT name as '항목', author as '작성자', DATE_FORMAT(FROM_UNIXTIME(time / 1000000), '%Y-%m-%d %H:%i') as '시간', IF(CHAR_LENGTH(description) > 75, CONCAT(LEFT(description, 75), '...'), description) as '설명'
FROM (
(SELECT CONCAT('[', type, ':"', id, '"]의 첨부 파일 [attachment:"', filename, ':', type, ':', id, '" ', filename, ']') as name, author, time, description
FROM attachment)
UNION
(SELECT CONCAT('[milestone:"', name, '"]') as name, '' as author, completed as time, description
FROM milestone
WHERE completed != 0)
UNION
(SELECT CONCAT(repository.value, '의 변경사항 [changeset:', rev * 1, '/', repository.value, ' "[', rev * 1, ']"]') as name, author, time, message as description
FROM revision
JOIN repository ON repos = id AND name='name')
UNION
(SELECT CONCAT('티켓 #', id) as name, reporter as author, time, summary as description
FROM ticket)
UNION
(SELECT CONCAT('티켓 #', ticket) as name, author, time, newvalue as description
FROM ticket_change
WHERE field = 'comment')
UNION
(SELECT CONCAT('[wiki:', name, ']') as name, author, time, comment as description
FROM wiki
WHERE author != 'trac')
ORDER BY (UNIX_TIMESTAMP() * 1000000 - time)
) AS X
LIMIT 5
}}}
}}}