typo in SQL-Query

diff --git a/SL/Controller/DeliveryPlan.pm b/SL/Controller/DeliveryPlan.pm
index cc74b99210d6d1057a1e41f72dcbc0975f723be2..e741e220484b5414731b6d7f19c0b23394149f78 100644 (file)
--- a/SL/Controller/DeliveryPlan.pm
+++ b/SL/Controller/DeliveryPlan.pm
@@ -127,7 +127,7 @@ sub calc_qtys {
   my %orderitems_by_id = map { $_->id => $_ } @$orderitems;
 
   my $query = <<SQL;
-    SELECT oi.id, doi.qty, doi.qty, doi.unit, doe.delivered
+    SELECT oi.id, doi.qty, doi.unit, doe.delivered
     FROM record_links rl
     INNER JOIN delivery_order_items doi ON (doi.delivery_order_id = rl.to_id)
     INNER JOIN delivery_orders doe ON (doe.id = rl.to_id)