[Koha-bugs] [Bug 2708] Checked out items saying available

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2708





------- Comment #3 from nicole.engard at liblime.com  2008-10-22 02:55 -------
Some examples from Joe:


mysql> select biblio.title, biblio.author, items.* from items LEFT JOIN biblio
on (biblio.biblionumber=items.biblionumber) where barcode="55500000000381";
+---------------------------+-------------------+------------+--------------+------------------+----------------+-----------------+--------------+------------+-------+------------------+----------------------+------------------+--------------+-------+------------+---------+----------+----------+----------------+--------+----------+----------+------------+-----------+---------------+---------+---------------------+----------+--------+-----------+---------+-------+-----------+------+----------+--------------------+-----------+------------+
| title                     | author            | itemnumber | biblionumber |
biblioitemnumber | barcode        | dateaccessioned | booksellerid | homebranch
| price | replacementprice | replacementpricedate | datelastborrowed |
datelastseen | stack | notforloan | damaged | itemlost | wthdrawn |
itemcallnumber | issues | renewals | reserves | restricted | itemnotes |
holdingbranch | paidfor | timestamp           | location | onloan | cn_source |
cn_sort | ccode | materials | uri  | itype    | more_subfields_xml | enumchron
| copynumber |
+---------------------------+-------------------+------------+--------------+------------------+----------------+-----------------+--------------+------------+-------+------------------+----------------------+------------------+--------------+-------+------------+---------+----------+----------+----------------+--------+----------+----------+------------+-----------+---------------+---------+---------------------+----------+--------+-----------+---------+-------+-----------+------+----------+--------------------+-----------+------------+
| Organizational behavior : | Nelson, Debra L., |      25412 |        19163 |  
         19163 | 55500000000381 | 2007-06-10      | NULL         | TXT        |
 NULL |             NULL | 2008-06-10           | NULL             | 2008-09-02
  |  NULL |          0 |       0 |        0 |        0 | BUS 350        |  
NULL |     NULL |     NULL |       NULL | NULL      | NULL          | NULL    |
2008-09-02 09:20:25 | NULL     | NULL   | NULL      | BUS_350 | TXT   | NULL   
  | NULL | TEXTBOOK | NULL               | NULL      | NULL       |
+---------------------------+-------------------+------------+--------------+------------------+----------------+-----------------+--------------+------------+-------+------------------+----------------------+------------------+--------------+-------+------------+---------+----------+----------+----------------+--------+----------+----------+------------+-----------+---------------+---------+---------------------+----------+--------+-----------+---------+-------+-----------+------+----------+--------------------+-----------+------------+
1 row in set (0.00 sec)


mysql> select ccode,count(*) from items WHERE biblionumber=19163 GROUP BY ccode
;
+-------+----------+
| ccode | count(*) |
+-------+----------+
| RES   |        1 |
| T     |        2 |
| TXT   |       51 |
+-------+----------+
3 rows in set (0.00 sec)

mysql> select homebranch,count(*) from items WHERE biblionumber=19163 GROUP BY
homebranch ;
+------------+----------+
| homebranch | count(*) |
+------------+----------+
| LCC        |        1 |
| TXT        |       53 |
+------------+----------+
2 rows in set (0.00 sec)

mysql> select location,count(*) from items WHERE biblionumber=19163 GROUP BY
location ;
+----------+----------+
| location | count(*) |
+----------+----------+
| NULL     |       54 |
+----------+----------+
1 row in set (0.00 sec)

mysql> select itype,count(*) from items WHERE biblionumber=19163 GROUP BY itype
;
+----------+----------+
| itype    | count(*) |
+----------+----------+
| R        |        1 |
| RH2      |        1 |
| TEXTBOOK |       52 |
+----------+----------+
3 rows in set (0.00 sec)




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.