mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '8684' order by postid; +--------+----------+------------------+--------+-------------------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+------------------+--------+-------------------------------------+-------------------------+ | 105641 | 0 | xed_over | 156 | Why do only the white stones break? | 2009-03-22 16:16:52 | | 105645 | 105641 | pwaldron | 1293 | | 2009-03-22 17:39:05 | | 105647 | 105645 | Wasiqi | 5675 | | 2009-03-22 17:59:45 | | 105654 | 105647 | Tom_Waits | 5582 | | 2009-03-22 19:26:14 | | 105669 | 105654 | hman | 4699 | | 2009-03-23 01:04:59 | | 105691 | 105641 | simpkin | 1888 | | 2009-03-23 08:53:31 | | 105699 | 105641 | Sakata | 5603 | | 2009-03-23 10:21:23 | | 105711 | 105669 | snorri | 2159 | | 2009-03-23 13:09:10 | | 105712 | 105641 | snorri | 2159 | | 2009-03-23 13:11:59 | | 105714 | 105712 | Zahlman | 4638 | | 2009-03-23 13:27:30 | | 105779 | 105714 | Andrea | 4642 | | 2009-03-24 02:16:36 | | 105917 | 105779 | daniel_the_smith | 1462 | | 2009-03-24 14:19:04 | | 105919 | 105917 | BaghwanB | 5665 | | 2009-03-24 14:32:34 | | 105927 | 105919 | Zahlman | 4638 | | 2009-03-24 16:30:42 | | 106017 | 105641 | Alakazam | 5636 | | 2009-03-25 17:02:54 | +--------+----------+------------------+--------+-------------------------------------+-------------------------+ 15 rows in set (0.03 sec)