mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '6529' order by postid; +--------+----------+----------------+--------+----------------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+----------------+--------+----------------------------------+-------------------------+ | 78069 | 0 | RobertJasiek | 1934 | Rules at Olympics Close to Ikeda | 2008-06-20 16:47:14 | | 78106 | 78069 | John Fairbairn | 3525 | | 2008-06-21 02:53:16 | | 78110 | 78106 | RobertJasiek | 1934 | | 2008-06-21 04:24:06 | | 78114 | 78110 | Bill Spight | 2111 | | 2008-06-21 06:39:53 | | 78127 | 78114 | RobertJasiek | 1934 | | 2008-06-21 09:11:22 | | 78320 | 78069 | RobertJasiek | 1934 | | 2008-06-23 06:49:55 | | 80060 | 78069 | RobertJasiek | 1934 | | 2008-07-17 00:46:29 | | 80074 | 78069 | RobertJasiek | 1934 | | 2008-07-17 08:10:14 | | 85481 | 80074 | RobertJasiek | 1934 | | 2008-09-13 04:10:11 | +--------+----------+----------------+--------+----------------------------------+-------------------------+ 9 rows in set (0.35 sec)