From 231c8fb29e4e1cffd5c2c797ca1eb8bc6362d383 Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 6 Oct 2018 13:51:34 +0200
Subject: [PATCH] update items.lastdateseen

---
 update.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 update.sql

diff --git a/update.sql b/update.sql
new file mode 100644
index 0000000..ec84634
--- /dev/null
+++ b/update.sql
@@ -0,0 +1,11 @@
+update items as a
+inner join (
+	select ffzg_inventura.barcode,items.datelastseen,max(ffzg_inventura.date_scanned) as date_scanned
+	from ffzg_inventura
+	join items on items.barcode = ffzg_inventura.barcode
+	group by ffzg_inventura.barcode
+	having datelastseen < max(date_scanned)
+) as b
+on a.barcode = b.barcode
+set a.datelastseen = b.date_scanned ;
+
-- 
2.20.1