Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DATE_FORMAT(items.datelastseen, '%d/%m/%Y') as 'Date Last Seen', (TO_DAYS(curdate())-TO_DAYS(items.datelastseen)) AS 'Days not seen for', items.itype as 'Item Type', items.itemcallnumber, items.barcode, biblio.title, biblio.author
- FROM items
- LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
- WHERE (TO_DAYS(curdate())-TO_DAYS(items.datelastseen)) > '3'
- AND LEFT(items.itemcallnumber,3) NOT IN ("RES","REL")
- ORDER BY items.datelastseen DESC, biblio.title ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement