All pastes #2104831 Raw Edit

Anonymous

public text v1 · immutable
#2104831 ·published 2012-01-21 20:12 UTC
rendered paste body
mysql> select *, FROM_UNIXTIME(timestamp) AS 'when' FROM pts5050log WHERE timestamp >= 1327176285 order by timestamp DESC;
+------+--------+---------+--------+--------+----------------+---------------+------------+---------------------+
| id   | better | matcher | winner | amount | betterip       | matcherip     | timestamp  | when                |
+------+--------+---------+--------+--------+----------------+---------------+------------+---------------------+
| 3683 |      7 |     308 |    308 |     10 | 145.116.*.155  | 86.10.193.237 | 1327176294 | 2012-01-21 14:04:54 |
| 3682 |      7 |     308 |      7 |     10 | 145.116.*.155  | 86.10.193.237 | 1327176292 | 2012-01-21 14:04:52 |
| 3681 |      7 |     308 |      7 |     10 | 145.116.*.155  | 86.10.193.237 | 1327176290 | 2012-01-21 14:04:50 |
| 3680 |      7 |     308 |      7 |     10 | 145.116.*.155  | 86.10.193.237 | 1327176288 | 2012-01-21 14:04:48 |
| 3679 |      7 |     308 |      7 |     10 | 145.116.*.155  | 86.10.193.237 | 1327176285 | 2012-01-21 14:04:45 |
+------+--------+---------+--------+--------+----------------+---------------+------------+---------------------+
5 rows in set (0.00 sec)