list items which need lastdateseen update

diff --git a/reports.sql b/reports.sql
index ffbeb2e..f616682 100644 (file)
--- a/reports.sql
+++ b/reports.sql
@@ -6,3 +6,7 @@ select min(date_scanned),max(date_scanned),source_id,count(*) from ffzg_inventur
 -- duplicates
 
 select barcode,min(date_scanned),max(date_scanned),count(*) from ffzg_inventura group by barcode having count(barcode) > 1 ;
+
+-- lastdeteseen to update
+select ffzg_inventura.barcode,itemnumber,count(*),datelastseen,max(date_scanned) from ffzg_inventura join items on items.barcode = ffzg_inventura.barcode group by ffzg_inventura.barcode having datelastseen < max(date_scanned);
+