mysql> select postid, parentid, username, userid, title, from_unixtime(dateline) from vb_post where threadid = '497' order by postid; +--------+----------+----------------+--------+---------------------------------------+-------------------------+ | postid | parentid | username | userid | title | from_unixtime(dateline) | +--------+----------+----------------+--------+---------------------------------------+-------------------------+ | 5083 | 0 | Sekuhara | 360 | Counting territories | 2006-07-05 13:55:54 | | 5084 | 5083 | dorkon | 361 | re: Counting territories | 2006-07-05 14:36:55 | | 5085 | 5084 | malweth | 119 | | 2006-07-05 15:17:09 | | 5087 | 5085 | Ronaldo9 | 336 | | 2006-07-05 15:29:25 | | 5088 | 5087 | Andreas | 204 | | 2006-07-05 16:05:33 | | 5090 | 5088 | kex | 240 | | 2006-07-05 23:40:58 | | 5091 | 5083 | yolka | 359 | | 2006-07-06 03:08:12 | | 5092 | 5091 | DrStraw | 221 | | 2006-07-06 05:17:59 | | 5093 | 5083 | zinger | 315 | | 2006-07-06 05:20:13 | | 5336 | 5092 | Andrei Sokolov | 374 | | 2006-07-13 10:56:39 | | 5337 | 5336 | smurf | 239 | | 2006-07-13 11:23:36 | | 5344 | 5337 | gohst | 258 | | 2006-07-13 13:25:43 | | 5347 | 5336 | DrStraw | 221 | Reply to Andrei Sokolov | 2006-07-13 13:33:59 | | 5349 | 5344 | xed_over | 156 | | 2006-07-13 13:38:16 | | 5357 | 5349 | gohst | 258 | | 2006-07-13 16:27:41 | | 5360 | 5357 | xed_over | 156 | | 2006-07-13 17:06:33 | | 5373 | 5336 | kex | 240 | | 2006-07-14 03:54:19 | | 5374 | 5347 | Andrei Sokolov | 374 | | 2006-07-14 04:17:03 | | 5375 | 5344 | Andrei Sokolov | 374 | | 2006-07-14 05:05:02 | | 5376 | 5375 | smurf | 239 | | 2006-07-14 05:16:53 | | 5380 | 5376 | Andrei Sokolov | 374 | | 2006-07-14 06:05:58 | | 5381 | 5336 | zinger | 315 | | 2006-07-14 06:12:45 | | 5382 | 5380 | DrStraw | 221 | | 2006-07-14 06:16:35 | | 5383 | 5382 | Andrei Sokolov | 374 | | 2006-07-14 07:23:10 | | 5384 | 5381 | Andrei Sokolov | 374 | | 2006-07-14 08:05:01 | | 5387 | 5384 | Trevoke | 220 | | 2006-07-14 08:15:13 | | 5388 | 5384 | zinger | 315 | | 2006-07-14 08:23:27 | | 5389 | 5388 | Hicham | 151 | Go Area Scoring | 2006-07-14 09:09:00 | | 5391 | 5376 | gohst | 258 | | 2006-07-14 10:15:47 | | 5403 | 5391 | Andrei Sokolov | 374 | | 2006-07-14 14:06:14 | | 5413 | 5403 | gohst | 258 | | 2006-07-14 16:16:41 | | 5417 | 5413 | xed_over | 156 | | 2006-07-14 18:31:50 | | 5418 | 5413 | DrStraw | 221 | | 2006-07-14 18:32:47 | | 5429 | 5417 | Andrei Sokolov | 374 | | 2006-07-15 07:25:20 | | 5431 | 5429 | DrStraw | 221 | | 2006-07-15 08:35:14 | | 5437 | 5431 | xed_over | 156 | | 2006-07-15 10:05:18 | | 5438 | 5388 | Andrei Sokolov | 374 | | 2006-07-15 10:34:07 | | 5439 | 5437 | Andrei Sokolov | 374 | | 2006-07-15 10:58:55 | | 5465 | 5437 | Andrei Sokolov | 374 | | 2006-07-16 03:57:14 | | 5478 | 5465 | toastcrumb | 253 | | 2006-07-16 10:50:12 | | 5479 | 5478 | DrStraw | 221 | | 2006-07-16 11:00:59 | | 5487 | 5478 | xed_over | 156 | | 2006-07-16 15:44:41 | | 5489 | 5478 | Andrei Sokolov | 374 | | 2006-07-17 02:04:35 | | 5492 | 5418 | zinger | 315 | | 2006-07-17 05:48:10 | | 5494 | 5492 | Andrei Sokolov | 374 | | 2006-07-17 06:33:14 | | 5497 | 5494 | malweth | 119 | | 2006-07-17 07:30:22 | | 5500 | 5494 | DrStraw | 221 | | 2006-07-17 07:39:38 | | 5502 | 5374 | Javaness | 241 | | 2006-07-17 08:00:32 | | 5503 | 5500 | Andrei Sokolov | 374 | | 2006-07-17 09:01:50 | | 5505 | 5503 | zinger | 315 | | 2006-07-17 09:30:06 | | 5507 | 5503 | Hicham | 151 | | 2006-07-17 10:02:23 | | 5508 | 5507 | xed_over | 156 | | 2006-07-17 11:28:25 | | 5510 | 5508 | malweth | 119 | | 2006-07-17 12:28:58 | | 5511 | 5510 | Hicham | 151 | | 2006-07-17 13:41:07 | | 5512 | 5511 | xed_over | 156 | | 2006-07-17 14:59:36 | | 5513 | 5512 | Hicham | 151 | | 2006-07-17 15:33:17 | | 5517 | 5489 | toastcrumb | 253 | | 2006-07-17 17:38:59 | | 5519 | 5517 | NeoNemesis | 380 | | 2006-07-17 17:46:11 | | 5525 | 5517 | xed_over | 156 | | 2006-07-17 20:24:32 | | 5529 | 5517 | Andrei Sokolov | 374 | | 2006-07-17 23:56:58 | | 5531 | 5529 | malweth | 119 | | 2006-07-18 01:51:02 | | 5532 | 5508 | Javaness | 241 | | 2006-07-18 02:26:33 | | 5534 | 5508 | Andrei Sokolov | 374 | | 2006-07-18 05:47:58 | | 5536 | 5532 | DrStraw | 221 | | 2006-07-18 06:10:18 | | 5538 | 5536 | Javaness | 241 | | 2006-07-18 07:21:21 | | 5545 | 5538 | erislover | 372 | | 2006-07-18 12:13:44 | | 5553 | 5529 | toastcrumb | 253 | | 2006-07-18 15:13:06 | | 5570 | 5553 | Andrei Sokolov | 374 | | 2006-07-19 02:56:00 | | 5571 | 5570 | Javaness | 241 | | 2006-07-19 03:47:36 | | 5572 | 5571 | malweth | 119 | | 2006-07-19 05:42:51 | | 5573 | 5572 | Javaness | 241 | | 2006-07-19 06:20:02 | | 5574 | 5573 | malweth | 119 | | 2006-07-19 06:50:17 | | 5575 | 5574 | Javaness | 241 | | 2006-07-19 07:00:52 | | 5580 | 5575 | malweth | 119 | | 2006-07-19 10:19:26 | | 5717 | 5545 | Mef | 160 | | 2006-07-27 00:16:06 | | 5718 | 5580 | Mef | 160 | | 2006-07-27 00:18:02 | | 5727 | 5717 | erislover | 372 | | 2006-07-27 07:25:25 | | 5801 | 5727 | Mef | 160 | | 2006-07-28 22:46:31 | | 5804 | 5801 | Andrei Sokolov | 374 | | 2006-07-29 04:07:35 | | 5805 | 5804 | DrStraw | 221 | | 2006-07-29 05:17:43 | | 5808 | 5805 | Andrei Sokolov | 374 | | 2006-07-29 08:26:14 | | 5810 | 5801 | erislover | 372 | | 2006-07-29 09:50:10 | | 5812 | 5808 | DrStraw | 221 | | 2006-07-29 10:33:50 | | 5868 | 5812 | Hicham | 151 | | 2006-07-31 09:15:32 | | 5874 | 5868 | DrStraw | 221 | | 2006-07-31 10:43:51 | | 5878 | 5874 | Hicham | 151 | my 2 cents... | 2006-07-31 12:01:06 | | 5916 | 5878 | kex | 240 | | 2006-08-01 05:39:10 | | 5925 | 5916 | Trevoke | 220 | | 2006-08-01 06:48:04 | | 5944 | 5916 | Wildclaw | 216 | | 2006-08-01 09:32:38 | | 5966 | 5868 | Mef | 160 | | 2006-08-01 18:24:08 | | 5968 | 5812 | funkyj | 411 | westerners keeping good company | 2006-08-01 18:54:59 | | 5969 | 5347 | funkyj | 411 | strawman argument | 2006-08-01 19:32:32 | | 5971 | 5969 | gohst | 258 | | 2006-08-01 20:24:32 | | 5975 | 5969 | Mef | 160 | | 2006-08-01 20:42:24 | | 5976 | 5969 | erislover | 372 | | 2006-08-01 22:17:25 | | 5978 | 5976 | funkyj | 411 | | 2006-08-02 01:16:30 | | 5985 | 5978 | Trevoke | 220 | | 2006-08-02 06:05:07 | | 6004 | 5978 | Andrei Sokolov | 374 | | 2006-08-02 09:55:04 | | 6012 | 6004 | funkyj | 411 | | 2006-08-02 11:36:54 | | 6014 | 6004 | Nate | 164 | | 2006-08-02 11:43:40 | | 6016 | 6014 | DrStraw | 221 | | 2006-08-02 11:50:48 | | 6019 | 5381 | funkyj | 411 | | 2006-08-02 12:02:49 | | 6020 | 6014 | erislover | 372 | | 2006-08-02 12:09:02 | | 6034 | 6016 | Mef | 160 | | 2006-08-02 14:24:17 | | 6037 | 6034 | Hicham | 151 | Keep it friendly, please. | 2006-08-02 14:55:51 | | 6043 | 6037 | funkyj | 411 | | 2006-08-02 16:30:44 | | 6044 | 5083 | funkyj | 411 | Hmm, where is the FAQ for this on SL? | 2006-08-02 16:36:07 | | 6487 | 6044 | Lio | 430 | | 2006-08-09 14:35:04 | | 6491 | 6487 | xed_over | 156 | | 2006-08-09 15:28:47 | | 6492 | 6487 | Wildclaw | 216 | | 2006-08-09 15:51:04 | | 6494 | 6492 | Lio | 430 | | 2006-08-09 17:15:16 | | 6497 | 6494 | Wildclaw | 216 | | 2006-08-09 18:30:12 | | 6499 | 5090 | funkyj | 411 | | 2006-08-09 19:06:13 | | 6503 | 5487 | funkyj | 411 | scoring equivalence explained. | 2006-08-09 19:58:25 | | 6504 | 5971 | funkyj | 411 | | 2006-08-09 20:07:38 | | 6506 | 6497 | Lio | 430 | | 2006-08-10 01:39:14 | | 6522 | 6506 | xed_over | 156 | | 2006-08-10 06:22:58 | +--------+----------+----------------+--------+---------------------------------------+-------------------------+ 117 rows in set (0.05 sec)