Koha home
User block
SELECT b.biblionumber, i.Barcode, 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(),INTERVAL 250 DAY) <= i.dateaccessioned AND m.isbn IS NOT NULL AND m.isbn != '' GROUP BY biblionumber HAVING isbn != "" LIMIT 400
Quote of the day
Revolution is an inalienable right of mankind. Freedom is an imperishable birthright of all. A rebellion is not a revolution. It may ultimately lead to that end. ~ Bhagat Singh