mysql> select username,domain,last_modified,expires,TIMESTAMPDIFF(SECOND,last_modified,expires) from location where username in (41215500327) order by last_modified desc;
+-------------+----------------+---------------------+---------------------+---------------------------------------------+
| username | domain | last_modified | expires | TIMESTAMPDIFF(SECOND,last_modified,expires) |
+-------------+----------------+---------------------+---------------------+---------------------------------------------+
| 41215500327 | 91.121.XX.X1 | 2011-06-24 16:13:40 | 2011-06-24 16:16:09 | 149 |
| 41215500327 | 91.121.XX.X2 | 2011-06-24 16:13:25 | 2011-06-24 16:15:55 | 150 |
| 41215500327 | 91.121.XX.X3 | 2011-06-24 16:13:10 | 2011-06-24 16:15:40 | 150 |
| 41215500327 | 91.121.XX.X4 | 2011-06-24 16:12:58 | 2011-06-24 16:15:27 | 149 |
| 41215500327 | 91.121.XX.X5 | 2011-06-24 16:12:44 | 2011-06-24 16:15:13 | 149 |
| 41215500327 | 91.121.XX.X6 | 2011-06-24 16:12:31 | 2011-06-24 16:15:00 | 149 |
| 41215500327 | 91.121.XX.X7 | 2011-06-24 16:12:18 | 2011-06-24 16:14:47 | 149 |
| 41215500327 | 91.121.XX.X8 | 2011-06-24 16:12:04 | 2011-06-24 16:14:34 | 150 |
| 41215500327 | 91.121.XX.X9 | 2011-06-24 16:11:50 | 2011-06-24 16:14:20 | 150 |
+-------------+----------------+---------------------+---------------------+---------------------------------------------+
10 rows in set (0.01 sec)
|