http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2708 ------- Comment #3 from nicole.engard@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.