mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '7131' order by postid; +--------+----------+------------------+--------+--------------------------------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+------------------+--------+--------------------------------------------------+-------------------------+ | 85519 | 0 | RobertJasiek | 1934 | Strategic Consequences of New WMSG Rules Changes | 2008-09-13 23:38:10 | | 85520 | 85519 | Reed338 | 686 | | 2008-09-14 00:04:22 | | 85523 | 85520 | John Fairbairn | 3525 | | 2008-09-14 02:35:03 | | 85525 | 85523 | Hicham | 151 | | 2008-09-14 04:12:35 | | 85528 | 85519 | kirkmc | 4509 | | 2008-09-14 05:09:33 | | 85534 | 85519 | Fedya | 5257 | | 2008-09-14 07:07:32 | | 85535 | 85528 | RobertJasiek | 1934 | | 2008-09-14 07:14:19 | | 85536 | 85535 | RobertJasiek | 1934 | | 2008-09-14 07:27:52 | | 85539 | 85536 | TMark | 101 | | 2008-09-14 07:52:28 | | 85543 | 85539 | RobertJasiek | 1934 | | 2008-09-14 08:41:45 | | 85549 | 85543 | ferl | 4610 | by the way... | 2008-09-14 11:08:29 | | 85552 | 85549 | RobertJasiek | 1934 | | 2008-09-14 11:59:52 | | 85554 | 85552 | sol.ch | 129 | | 2008-09-14 13:27:16 | | 85589 | 85554 | mdobbins | 670 | | 2008-09-14 22:25:58 | | 85592 | 85549 | RobertJasiek | 1934 | | 2008-09-14 23:04:54 | | 85593 | 85592 | sol.ch | 129 | | 2008-09-14 23:08:41 | | 85641 | 85539 | Bill Spight | 2111 | | 2008-09-15 15:09:07 | | 85658 | 85525 | xela | 1957 | | 2008-09-15 18:09:24 | | 85668 | 85658 | Bill Spight | 2111 | | 2008-09-15 19:08:09 | | 85675 | 85668 | RobertJasiek | 1934 | | 2008-09-16 00:46:29 | | 85678 | 85675 | Harleqin | 2062 | | 2008-09-16 03:07:41 | | 85681 | 85678 | RobertJasiek | 1934 | | 2008-09-16 06:09:34 | | 85695 | 85675 | Bill Spight | 2111 | | 2008-09-16 09:52:44 | | 85698 | 85695 | RobertJasiek | 1934 | | 2008-09-16 10:25:56 | | 85699 | 85519 | Bill Spight | 2111 | | 2008-09-16 10:30:05 | | 85700 | 85698 | Bill Spight | 2111 | | 2008-09-16 10:56:45 | | 85702 | 85700 | Harleqin | 2062 | | 2008-09-16 12:33:37 | | 85705 | 85702 | Bill Spight | 2111 | | 2008-09-16 13:17:05 | | 85708 | 85705 | RobertJasiek | 1934 | | 2008-09-16 14:35:41 | | 85716 | 85708 | Bill Spight | 2111 | | 2008-09-16 16:18:59 | | 85726 | 85716 | RobertJasiek | 1934 | | 2008-09-16 22:27:54 | | 85729 | 85716 | flOvermind | 3247 | | 2008-09-17 01:41:06 | | 85734 | 85729 | RobertJasiek | 1934 | | 2008-09-17 06:10:00 | | 85735 | 85734 | RobertJasiek | 1934 | | 2008-09-17 06:12:48 | | 85741 | 85729 | Bill Spight | 2111 | | 2008-09-17 07:17:09 | | 85746 | 85741 | Harleqin | 2062 | | 2008-09-17 09:25:55 | | 85750 | 85741 | Harleqin | 2062 | | 2008-09-17 09:45:07 | | 85752 | 85750 | RobertJasiek | 1934 | | 2008-09-17 10:11:45 | | 85753 | 85750 | daniel_the_smith | 1462 | | 2008-09-17 10:12:14 | | 85754 | 85741 | flOvermind | 3247 | | 2008-09-17 10:12:20 | | 85755 | 85746 | Bill Spight | 2111 | | 2008-09-17 10:32:26 | | 85756 | 85750 | Bill Spight | 2111 | | 2008-09-17 10:37:40 | | 85757 | 85754 | Bill Spight | 2111 | | 2008-09-17 10:44:37 | | 85760 | 85726 | Bill Spight | 2111 | | 2008-09-17 11:08:36 | | 85762 | 85757 | flOvermind | 3247 | | 2008-09-17 11:34:43 | | 85763 | 85753 | pwaldron | 1293 | | 2008-09-17 11:42:54 | | 85764 | 85754 | RobertJasiek | 1934 | | 2008-09-17 11:53:49 | | 85766 | 85764 | flOvermind | 3247 | | 2008-09-17 12:03:51 | | 85767 | 85766 | RobertJasiek | 1934 | | 2008-09-17 12:05:28 | | 85769 | 85763 | Harleqin | 2062 | | 2008-09-17 12:31:09 | | 85770 | 85769 | flOvermind | 3247 | | 2008-09-17 12:47:21 | | 85772 | 85762 | Bill Spight | 2111 | | 2008-09-17 13:43:42 | | 85780 | 85770 | Harleqin | 2062 | | 2008-09-17 16:46:58 | | 85864 | 85780 | SpongeBob | 2978 | | 2008-09-18 14:02:35 | | 85873 | 85864 | Harleqin | 2062 | | 2008-09-18 16:25:06 | | 85909 | 85769 | SpongeBob | 2978 | | 2008-09-19 03:36:19 | | 85921 | 85909 | Harleqin | 2062 | | 2008-09-19 08:17:54 | | 85924 | 85909 | Bill Spight | 2111 | | 2008-09-19 08:36:04 | | 86158 | 85539 | Nate | 164 | | 2008-09-22 12:01:39 | | 86192 | 85695 | snorri | 2159 | | 2008-09-22 19:28:53 | | 86215 | 86192 | flOvermind | 3247 | | 2008-09-23 02:26:20 | | 86360 | 85539 | SpongeBob | 2978 | | 2008-09-24 12:02:19 | | 86376 | 86360 | RobertJasiek | 1934 | | 2008-09-24 16:26:46 | | 86519 | 86215 | RobertJasiek | 1934 | | 2008-09-26 18:39:23 | | 86520 | 86519 | pwaldron | 1293 | | 2008-09-26 18:45:43 | | 86522 | 85549 | Bill Spight | 2111 | | 2008-09-26 21:17:30 | | 86529 | 86522 | RobertJasiek | 1934 | | 2008-09-27 01:34:18 | | 86542 | 86529 | Bill Spight | 2111 | | 2008-09-27 07:20:03 | | 86553 | 86542 | RobertJasiek | 1934 | | 2008-09-27 11:36:22 | | 86568 | 86553 | flOvermind | 3247 | | 2008-09-27 14:07:36 | | 86571 | 86553 | Harleqin | 2062 | | 2008-09-27 14:31:34 | | 86575 | 86571 | RobertJasiek | 1934 | | 2008-09-27 15:45:07 | | 86594 | 86575 | TMark | 101 | | 2008-09-28 02:46:59 | | 86601 | 86594 | RobertJasiek | 1934 | | 2008-09-28 06:39:48 | | 86602 | 86575 | Bill Spight | 2111 | | 2008-09-28 07:05:40 | | 86605 | 86601 | snorri | 2159 | | 2008-09-28 09:45:32 | | 86606 | 86605 | Bill Spight | 2111 | | 2008-09-28 10:06:44 | | 86612 | 86606 | RobertJasiek | 1934 | | 2008-09-28 12:12:00 | | 86615 | 86612 | Bill Spight | 2111 | | 2008-09-28 12:41:54 | | 86621 | 86615 | RobertJasiek | 1934 | | 2008-09-28 13:29:45 | | 86628 | 86612 | Hsiang | 5473 | | 2008-09-28 15:25:39 | | 86630 | 86628 | Javaness | 241 | | 2008-09-28 15:49:39 | | 86669 | 86628 | RobertJasiek | 1934 | | 2008-09-28 22:14:10 | +--------+----------+------------------+--------+--------------------------------------------------+-------------------------+ 83 rows in set (0.00 sec)