
Owen
By: a guest on Feb 3rd, 2010 | syntax:
None | size: 0.77 KB | hits: 173 | expires: Never
mysql> select borrowernumber, reservedate, biblionumber, priority, timestamp from reserves where biblionumber = 60725 order by priority;
+----------------+-------------+--------------+----------+---------------------+
| borrowernumber | reservedate | biblionumber | priority | timestamp |
+----------------+-------------+--------------+----------+---------------------+
| 24568 | 2009-12-01 | 60725 | 0 | 2010-01-19 20:59:41 |
| 15648 | 2010-01-21 | 60725 | 2 | 2010-01-21 16:42:32 |
| 58015 | 2010-02-03 | 60725 | 3 | 2010-02-03 01:21:10 |
| 398 | 2009-12-18 | 60725 | 421 | 2010-02-03 01:21:10 |
+----------------+-------------+--------------+----------+---------------------+