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
A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It's a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity. ~ Jimmy Carter