SELECT CONCAT(‘<a href= »/cgi-bin/koha/catalogue/detail.pl?biblionumber=’,b.biblionumber,' »>Notice</a>’) AS ‘Notice’, b.title AS ‘Titre’, b.author AS ‘Auteur’, MIN(i.withdrawn_on) AS ‘Pilon depuis’, COUNT(i.itemnumber) AS ‘Nb exemplaires’ FROM items i JOIN biblio b ON(i.biblionumber = b.biblionumber) WHERE b.biblionumber IN ( SELECT biblionumber FROM items GROUP BY biblionumber HAVING […]
SQL – Module Catalogue
1 article