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