mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '8094' order by postid; +--------+----------+---------------+--------+-------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+---------------+--------+-------------------------+-------------------------+ | 98133 | 0 | entropi | 4833 | bent four in the corner | 2009-01-16 01:00:40 | | 98134 | 98133 | sol.ch | 129 | | 2009-01-16 01:11:47 | | 98136 | 98134 | entropi | 4833 | | 2009-01-16 02:07:13 | | 98139 | 98136 | flOvermind | 3247 | | 2009-01-16 02:44:35 | | 98144 | 98139 | xela | 1957 | | 2009-01-16 03:24:37 | | 98147 | 98144 | Tommie | 162 | coffee <= 15:45 ? | 2009-01-16 04:19:08 | | 98151 | 98139 | entropi | 4833 | | 2009-01-16 05:04:00 | | 98167 | 98151 | Tommie | 162 | | 2009-01-16 06:38:41 | | 98171 | 98167 | entropi | 4833 | | 2009-01-16 06:50:08 | | 98172 | 98171 | Kirby | 5250 | | 2009-01-16 06:52:48 | | 98174 | 98172 | shapenaji | 330 | | 2009-01-16 07:19:00 | | 98203 | 98151 | Bill Spight | 2111 | | 2009-01-16 11:07:02 | | 98353 | 98203 | entropi | 4833 | | 2009-01-17 10:54:08 | | 98360 | 98353 | Bill Spight | 2111 | | 2009-01-17 12:52:59 | | 98376 | 98360 | HermanHiddema | 4121 | | 2009-01-17 15:07:11 | | 98380 | 98376 | sol.ch | 129 | | 2009-01-17 15:53:17 | | 98381 | 98380 | HermanHiddema | 4121 | | 2009-01-17 15:55:38 | | 98382 | 98381 | sol.ch | 129 | | 2009-01-17 15:58:45 | | 98384 | 98382 | HermanHiddema | 4121 | | 2009-01-17 16:03:28 | | 98388 | 98384 | Bill Spight | 2111 | | 2009-01-17 16:20:49 | | 98414 | 98380 | Hicham | 151 | | 2009-01-18 02:59:29 | | 98417 | 98388 | HermanHiddema | 4121 | | 2009-01-18 03:39:27 | | 98470 | 98417 | sol.ch | 129 | | 2009-01-18 12:59:47 | | 98505 | 98470 | Harleqin | 2062 | | 2009-01-18 22:57:59 | | 98516 | 98505 | HermanHiddema | 4121 | | 2009-01-19 02:57:37 | | 98518 | 98516 | RobertJasiek | 1934 | | 2009-01-19 03:30:37 | | 98519 | 98518 | HermanHiddema | 4121 | | 2009-01-19 03:38:25 | | 98520 | 98133 | RobertJasiek | 1934 | | 2009-01-19 03:41:40 | | 98521 | 98520 | RobertJasiek | 1934 | | 2009-01-19 03:47:23 | | 98528 | 98521 | Hicham | 151 | | 2009-01-19 07:12:18 | | 98561 | 98133 | Zahlman | 4638 | | 2009-01-19 10:40:22 | | 98574 | 98561 | RobertJasiek | 1934 | | 2009-01-19 11:44:27 | | 98576 | 98574 | HermanHiddema | 4121 | | 2009-01-19 12:03:50 | | 98586 | 98133 | RobertJasiek | 1934 | | 2009-01-19 14:39:09 | | 98587 | 98586 | HermanHiddema | 4121 | | 2009-01-19 14:45:50 | | 98590 | 98587 | Harleqin | 2062 | | 2009-01-19 15:10:22 | | 98591 | 98590 | HermanHiddema | 4121 | | 2009-01-19 15:26:03 | | 98593 | 98591 | RobertJasiek | 1934 | | 2009-01-19 15:41:21 | | 98594 | 98593 | HermanHiddema | 4121 | | 2009-01-19 15:49:10 | | 98617 | 98594 | RobertJasiek | 1934 | | 2009-01-19 23:04:35 | | 98621 | 98617 | HermanHiddema | 4121 | | 2009-01-20 01:02:45 | | 98622 | 98621 | RobertJasiek | 1934 | | 2009-01-20 01:25:17 | | 98625 | 98622 | HermanHiddema | 4121 | | 2009-01-20 02:18:14 | | 98629 | 98625 | entropi | 4833 | | 2009-01-20 03:23:24 | | 98630 | 98629 | HermanHiddema | 4121 | | 2009-01-20 03:31:32 | | 98631 | 98630 | RobertJasiek | 1934 | | 2009-01-20 03:39:10 | | 98632 | 98630 | entropi | 4833 | | 2009-01-20 03:40:56 | | 98633 | 98631 | HermanHiddema | 4121 | | 2009-01-20 04:09:39 | | 98641 | 98633 | RobertJasiek | 1934 | | 2009-01-20 05:37:35 | | 98645 | 98641 | HermanHiddema | 4121 | | 2009-01-20 06:22:48 | | 98650 | 98645 | RobertJasiek | 1934 | | 2009-01-20 07:00:13 | | 98653 | 98650 | HermanHiddema | 4121 | | 2009-01-20 07:08:53 | | 98656 | 98653 | RobertJasiek | 1934 | | 2009-01-20 07:17:52 | | 98660 | 98656 | HermanHiddema | 4121 | | 2009-01-20 07:27:17 | | 98680 | 98660 | RobertJasiek | 1934 | | 2009-01-20 09:04:26 | | 98683 | 98680 | HermanHiddema | 4121 | | 2009-01-20 09:16:13 | | 98704 | 98683 | RobertJasiek | 1934 | | 2009-01-20 10:31:37 | | 98724 | 98704 | HermanHiddema | 4121 | | 2009-01-20 11:12:00 | | 98852 | 98650 | RobertJasiek | 1934 | | 2009-01-21 02:15:08 | | 98853 | 98852 | RobertJasiek | 1934 | | 2009-01-21 02:20:04 | | 98854 | 98853 | HermanHiddema | 4121 | | 2009-01-21 02:27:48 | | 98856 | 98854 | HermanHiddema | 4121 | | 2009-01-21 02:40:42 | | 98864 | 98856 | RobertJasiek | 1934 | | 2009-01-21 04:52:46 | | 98866 | 98864 | RobertJasiek | 1934 | | 2009-01-21 05:11:17 | | 98868 | 98864 | HermanHiddema | 4121 | | 2009-01-21 05:17:13 | | 98874 | 98868 | RobertJasiek | 1934 | | 2009-01-21 06:08:04 | | 98875 | 98874 | RobertJasiek | 1934 | | 2009-01-21 06:11:37 | | 98877 | 98875 | HermanHiddema | 4121 | | 2009-01-21 06:22:05 | | 98970 | 98877 | Zahlman | 4638 | | 2009-01-21 15:58:00 | +--------+----------+---------------+--------+-------------------------+-------------------------+ 69 rows in set (0.04 sec)