mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '11249' order by postid; +--------+----------+----------------+--------+---------------------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+----------------+--------+---------------------------------------+-------------------------+ | 142807 | 0 | nchh | 5583 | Universal ruleset | 2010-03-04 17:23:21 | | 142809 | 142807 | xed_over | 156 | | 2010-03-04 17:33:36 | | 142810 | 142807 | nchh | 5583 | | 2010-03-04 17:34:22 | | 142816 | 142807 | RobertJasiek | 1934 | | 2010-03-04 23:08:31 | | 142821 | 142816 | shapenaji | 330 | | 2010-03-05 00:23:18 | | 142822 | 142821 | RobertJasiek | 1934 | | 2010-03-05 00:57:13 | | 142824 | 142807 | Tommie | 162 | | 2010-03-05 01:41:52 | | 142834 | 142807 | Wildclaw | 216 | | 2010-03-05 04:35:04 | | 142838 | 142834 | RobertJasiek | 1934 | | 2010-03-05 05:18:19 | | 142847 | 142838 | Wildclaw | 216 | | 2010-03-05 06:55:47 | | 142848 | 142847 | topazg | 1917 | | 2010-03-05 06:57:42 | | 142849 | 142847 | RobertJasiek | 1934 | | 2010-03-05 07:02:20 | | 142854 | 142807 | topazg | 1917 | | 2010-03-05 07:26:46 | | 142856 | 142854 | RobertJasiek | 1934 | | 2010-03-05 07:37:32 | | 142858 | 142856 | topazg | 1917 | | 2010-03-05 07:39:28 | | 142864 | 142858 | RobertJasiek | 1934 | | 2010-03-05 08:09:05 | | 142885 | 142864 | karaklis | 5478 | | 2010-03-05 11:26:37 | | 142891 | 142885 | RobertJasiek | 1934 | | 2010-03-05 12:23:43 | | 142893 | 142885 | topazg | 1917 | | 2010-03-05 13:18:15 | | 142895 | 142885 | wms | 717 | | 2010-03-05 13:39:19 | | 142897 | 142885 | Bantari | 201 | | 2010-03-05 13:54:15 | | 142899 | 142897 | karaklis | 5478 | | 2010-03-05 14:17:18 | | 142904 | 142899 | Bantari | 201 | | 2010-03-05 15:45:38 | | 142906 | 142834 | shapenaji | 330 | | 2010-03-05 16:53:01 | | 142911 | 142906 | Bantari | 201 | | 2010-03-05 17:13:02 | | 142912 | 142899 | Mef | 160 | | 2010-03-05 17:28:30 | | 142917 | 142911 | shapenaji | 330 | | 2010-03-05 18:09:22 | | 142925 | 142917 | Bantari | 201 | | 2010-03-05 20:45:44 | | 142926 | 142834 | nchh | 5583 | | 2010-03-05 22:41:38 | | 142928 | 142897 | RobertJasiek | 1934 | | 2010-03-05 22:48:25 | | 142929 | 142928 | RobertJasiek | 1934 | | 2010-03-05 23:38:22 | | 142933 | 142906 | Wildclaw | 216 | | 2010-03-06 00:51:46 | | 142937 | 142933 | RobertJasiek | 1934 | | 2010-03-06 01:23:07 | | 142946 | 142937 | TMark | 101 | | 2010-03-06 04:11:23 | | 142977 | 142928 | Bantari | 201 | | 2010-03-06 11:37:57 | | 143010 | 142977 | Harleqin | 2062 | | 2010-03-06 19:43:59 | | 143028 | 142933 | shapenaji | 330 | | 2010-03-06 23:55:26 | | 143032 | 143010 | RobertJasiek | 1934 | | 2010-03-07 00:03:50 | | 143147 | 143032 | Bantari | 201 | | 2010-03-07 21:36:14 | | 143165 | 143147 | RobertJasiek | 1934 | | 2010-03-07 23:30:12 | | 143169 | 143147 | matjet | 5911 | | 2010-03-08 00:11:15 | | 143172 | 143169 | John Fairbairn | 3525 | | 2010-03-08 01:36:05 | | 143176 | 143169 | RobertJasiek | 1934 | | 2010-03-08 02:24:55 | | 143179 | 143176 | RobertJasiek | 1934 | | 2010-03-08 03:15:06 | | 143183 | 143179 | John Fairbairn | 3525 | | 2010-03-08 03:49:49 | | 143184 | 143169 | Mef | 160 | | 2010-03-08 04:10:11 | | 143186 | 143183 | RobertJasiek | 1934 | | 2010-03-08 04:13:10 | | 143187 | 143183 | hanekomu | 4622 | | 2010-03-08 04:14:47 | | 143190 | 143186 | RobertJasiek | 1934 | | 2010-03-08 04:20:11 | | 143195 | 143184 | Bill Spight | 2111 | | 2010-03-08 06:34:55 | | 143197 | 143172 | Bill Spight | 2111 | | 2010-03-08 06:44:32 | | 143202 | 143197 | TMark | 101 | | 2010-03-08 07:54:00 | | 143217 | 143202 | John Fairbairn | 3525 | | 2010-03-08 10:17:01 | | 143221 | 143217 | Bantari | 201 | | 2010-03-08 10:31:19 | | 143223 | 143202 | RobertJasiek | 1934 | | 2010-03-08 10:42:48 | | 143225 | 143221 | Bantari | 201 | | 2010-03-08 11:00:28 | | 143228 | 143223 | RobertJasiek | 1934 | | 2010-03-08 11:50:25 | | 143230 | 143228 | RobertJasiek | 1934 | | 2010-03-08 11:57:48 | | 143234 | 143223 | Hicham | 151 | | 2010-03-08 12:25:17 | | 143236 | 143217 | Bill Spight | 2111 | | 2010-03-08 12:37:12 | | 143238 | 143234 | xed_over | 156 | | 2010-03-08 12:39:09 | | 143241 | 143236 | Harleqin | 2062 | | 2010-03-08 12:50:28 | | 143242 | 143236 | pwaldron | 1293 | | 2010-03-08 13:29:36 | | 143244 | 143242 | shapenaji | 330 | | 2010-03-08 13:39:52 | | 143245 | 143234 | John Fairbairn | 3525 | | 2010-03-08 13:44:00 | | 143260 | 143245 | John Fairbairn | 3525 | | 2010-03-08 15:48:23 | | 143263 | 143230 | Bantari | 201 | | 2010-03-08 15:59:10 | | 143266 | 143244 | Bantari | 201 | | 2010-03-08 16:15:06 | | 143271 | 143260 | Bill Spight | 2111 | | 2010-03-08 16:52:50 | | 143273 | 143234 | Bill Spight | 2111 | | 2010-03-08 17:26:04 | | 143274 | 143266 | Zahlman | 4638 | | 2010-03-08 17:34:24 | | 143275 | 143202 | Zahlman | 4638 | | 2010-03-08 17:51:10 | | 143276 | 143274 | Bantari | 201 | | 2010-03-08 18:02:36 | | 143277 | 143225 | Zahlman | 4638 | | 2010-03-08 18:11:35 | | 143279 | 143276 | Zahlman | 4638 | | 2010-03-08 18:20:47 | | 143284 | 143184 | Zahlman | 4638 | | 2010-03-08 18:39:07 | | 143289 | 142933 | Zahlman | 4638 | | 2010-03-08 18:46:53 | | 143320 | 143238 | RobertJasiek | 1934 | | 2010-03-09 00:34:31 | | 143322 | 143197 | RobertJasiek | 1934 | | 2010-03-09 00:40:29 | | 143323 | 143238 | RobertJasiek | 1934 | | 2010-03-09 00:45:50 | | 143324 | 143273 | RobertJasiek | 1934 | | 2010-03-09 00:56:23 | | 143325 | 143324 | RobertJasiek | 1934 | | 2010-03-09 01:06:08 | | 143344 | 143325 | John Fairbairn | 3525 | | 2010-03-09 05:24:08 | | 143356 | 143344 | RobertJasiek | 1934 | | 2010-03-09 06:41:28 | | 143362 | 143344 | Bill Spight | 2111 | | 2010-03-09 07:57:30 | | 143363 | 143362 | John Fairbairn | 3525 | | 2010-03-09 08:15:03 | | 143365 | 143363 | Bill Spight | 2111 | | 2010-03-09 08:28:32 | | 143377 | 143365 | RobertJasiek | 1934 | | 2010-03-09 09:26:19 | | 143381 | 143320 | wms | 717 | | 2010-03-09 09:56:36 | | 143382 | 143381 | Fedya | 5257 | | 2010-03-09 10:26:01 | | 143390 | 143377 | Bill Spight | 2111 | | 2010-03-09 12:38:03 | | 143403 | 143279 | Bantari | 201 | | 2010-03-09 13:51:04 | | 143406 | 143382 | RobertJasiek | 1934 | | 2010-03-09 14:09:47 | | 143407 | 143277 | Bantari | 201 | | 2010-03-09 14:10:36 | | 143409 | 143406 | RobertJasiek | 1934 | | 2010-03-09 14:13:02 | | 143410 | 143323 | Bantari | 201 | | 2010-03-09 14:20:08 | | 143413 | 143325 | Bantari | 201 | | 2010-03-09 14:25:54 | | 143415 | 143403 | Zahlman | 4638 | | 2010-03-09 14:51:30 | | 143421 | 143415 | Harleqin | 2062 | | 2010-03-09 15:09:38 | | 143422 | 143415 | RobertJasiek | 1934 | | 2010-03-09 15:10:58 | | 143423 | 143406 | Zahlman | 4638 | | 2010-03-09 15:17:29 | | 143443 | 143423 | RobertJasiek | 1934 | | 2010-03-09 23:03:08 | | 143464 | 143443 | Harleqin | 2062 | | 2010-03-10 05:49:31 | | 143528 | 143415 | Bantari | 201 | | 2010-03-10 13:27:50 | | 143532 | 143528 | Javaness | 241 | | 2010-03-10 14:08:35 | | 143558 | 143532 | RobertJasiek | 1934 | | 2010-03-10 21:38:00 | | 143559 | 143532 | RobertJasiek | 1934 | | 2010-03-10 21:46:54 | | 143620 | 143559 | Javaness | 241 | | 2010-03-11 13:12:10 | | 143621 | 143620 | shapenaji | 330 | | 2010-03-11 13:22:39 | | 143623 | 143620 | Bantari | 201 | | 2010-03-11 13:37:57 | | 143627 | 143623 | Y Nishi | 7226 | I agree...but | 2010-03-11 13:59:26 | | 143628 | 143623 | John Fairbairn | 3525 | | 2010-03-11 14:02:10 | | 143630 | 143628 | Koch | 7326 | | 2010-03-11 14:07:43 | | 143632 | 143628 | shapenaji | 330 | | 2010-03-11 14:42:51 | | 143637 | 143627 | Bantari | 201 | | 2010-03-11 15:26:48 | | 143642 | 143558 | Tommie | 162 | J?rgen was a good teacher | 2010-03-11 16:25:57 | | 143675 | 143623 | RobertJasiek | 1934 | | 2010-03-11 23:39:04 | | 143677 | 143642 | RobertJasiek | 1934 | | 2010-03-11 23:55:23 | | 143757 | 143677 | Tommie | 162 | J?rgen | 2010-03-12 15:07:24 | | 143788 | 143757 | RobertJasiek | 1934 | | 2010-03-12 22:59:28 | | 143789 | 143677 | karaklis | 5478 | | 2010-03-12 23:19:33 | | 143803 | 143789 | RobertJasiek | 1934 | | 2010-03-13 02:56:20 | | 143811 | 143803 | John Fairbairn | 3525 | Even 2,389.43 years ago... | 2010-03-13 05:00:02 | | 143981 | 143811 | ferl | 4610 | | 2010-03-14 00:06:37 | | 143991 | 143981 | RobertJasiek | 1934 | | 2010-03-14 03:09:19 | | 144005 | 143991 | John Fairbairn | 3525 | | 2010-03-14 06:08:14 | | 144010 | 144005 | Harleqin | 2062 | | 2010-03-14 07:59:28 | | 144011 | 144005 | RobertJasiek | 1934 | | 2010-03-14 08:00:50 | | 144018 | 144011 | TMark | 101 | | 2010-03-14 08:27:24 | | 144022 | 144018 | Javaness | 241 | | 2010-03-14 08:44:14 | | 144023 | 144022 | RobertJasiek | 1934 | | 2010-03-14 08:47:15 | | 144025 | 144023 | Javaness | 241 | | 2010-03-14 09:02:56 | | 144043 | 144025 | RobertJasiek | 1934 | | 2010-03-14 10:08:47 | | 144054 | 144022 | Harleqin | 2062 | | 2010-03-14 11:07:32 | | 144056 | 144054 | Javaness | 241 | | 2010-03-14 11:20:50 | | 144090 | 144025 | simpkin | 1888 | | 2010-03-14 16:08:31 | | 144096 | 144025 | tealeaf | 91 | | 2010-03-14 16:35:08 | | 144151 | 143202 | LindseyK | 7625 | | 2010-03-15 04:21:52 | | 144152 | 144096 | John Fairbairn | 3525 | | 2010-03-15 04:30:20 | | 144154 | 144151 | RobertJasiek | 1934 | | 2010-03-15 04:43:06 | | 144170 | 144154 | TMark | 101 | | 2010-03-15 07:22:41 | | 144181 | 144154 | Harleqin | 2062 | | 2010-03-15 08:05:23 | | 144183 | 144181 | John Fairbairn | 3525 | | 2010-03-15 08:18:29 | | 144196 | 144183 | RobertJasiek | 1934 | | 2010-03-15 08:54:03 | | 144205 | 144025 | Tommie | 162 | definitions of tactics & strategy | 2010-03-15 09:29:23 | | 144215 | 144205 | Mef | 160 | | 2010-03-15 10:03:28 | | 144225 | 144183 | Harleqin | 2062 | | 2010-03-15 11:47:58 | | 144230 | 144225 | TMark | 101 | | 2010-03-15 12:00:36 | | 144238 | 144154 | LindseyK | 7625 | | 2010-03-15 13:11:49 | | 144276 | 144230 | Harleqin | 2062 | | 2010-03-15 20:15:10 | | 144285 | 144276 | RobertJasiek | 1934 | | 2010-03-15 23:16:25 | | 144300 | 144285 | RobertJasiek | 1934 | Simple Area Rules by Principles | 2010-03-16 02:48:31 | | 144302 | 144276 | John Fairbairn | 3525 | | 2010-03-16 03:00:20 | | 144304 | 144302 | RobertJasiek | 1934 | | 2010-03-16 03:25:52 | | 144305 | 144304 | John Fairbairn | 3525 | | 2010-03-16 03:53:54 | | 144322 | 144305 | RobertJasiek | 1934 | | 2010-03-16 07:13:53 | | 144323 | 144285 | Bill Spight | 2111 | | 2010-03-16 07:16:34 | | 144325 | 144305 | CarlJung | 1759 | | 2010-03-16 07:30:30 | | 144326 | 144323 | John Fairbairn | 3525 | | 2010-03-16 07:36:43 | | 144336 | 144326 | RobertJasiek | 1934 | | 2010-03-16 08:08:49 | | 144340 | 144302 | Bill Spight | 2111 | | 2010-03-16 08:24:34 | | 144354 | 144276 | Bill Spight | 2111 | | 2010-03-16 10:24:22 | | 144357 | 144340 | Harleqin | 2062 | | 2010-03-16 10:46:06 | +--------+----------+----------------+--------+---------------------------------------+-------------------------+ 163 rows in set (0.41 sec)