Guest

Owen

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