Hello everyone,
I am using a test database of our Library on Koha 19.11.06 (just
auto-upgraded from 19.11.05) on Ubuntu 16.04.6 LTS.
In the process of customizing the OPAC and installing the COverflow plugin
as described at:
https://bywatersolutions.com/education/coverflow-blog-post-update
I have c
Hi Quỳnh,
There were a couple of errors in your query.
Try this:
-
SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title
FROM items i
LEFT JOIN biblioitems m USING (biblioitemnumber)
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
WHERE DATE_SUB(CURDATE(),INTE
Hello Alvaro
Sorry for a late reply. I just found out many emails were sent to my spam
box, including yours.
The new sql code that you sent me works well. Thanks for your help.
Best regards
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long -
3 matches
Mail list logo
