X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=reports.sql;h=f6166820b4d8a314872695f792b808b6278356ff;hb=ea9126977ef1a4972719173ef85a4d60b16fc8e3;hp=ffbeb2efc4ec9535d2100517d233f2dbf1d8862b;hpb=0ef5c7d4aeea5906d34355cd7afb05d676d89ae9;p=koha-dla

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);
+