+;
+update items set datelastseen = datelastborrowed
+;
+update items
+join old_issues on items.itemnumber=old_issues.itemnumber
+set datelastseen = returndate
+where returndate > datelastseen or datelastseen is null
+;
+update old_issues set timestamp = returndate