From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 6 Oct 2018 11:51:16 +0000 (+0200)
Subject: list items which need lastdateseen update
X-Git-Url: http://git.rot13.org/?p=koha-dla;a=commitdiff_plain;h=8b9e833c25a77ee9cad036e87e0f7a8fd9a6d541;ds=sidebyside

list items which need lastdateseen update
---

diff --git a/reports.sql b/reports.sql
index ffbeb2e..f616682 100644
--- 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);
+