X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=ordersatz.php;h=b70b3f0ebd67b83529611f3a5ae6fadcf34c56f7;hp=01b5c09dc718fb54cbc03ae6df5e42550d585243;hb=44602f0fd181b7789ba4c5289d5dd4bc2526c7b1;hpb=46379cd58c55e50a93bf6667d8f8471f87ec753a

diff --git a/ordersatz.php b/ordersatz.php
index 01b5c09..b70b3f0 100644
--- a/ordersatz.php
+++ b/ordersatz.php
@@ -109,7 +109,8 @@ function ordersatz_insert($id)
 {
   global $db;
 
-  $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() FROM metro_artikel",
+  $sql = sprintf("INSERT INTO metro_ordersatz_pos (ordersatz,artikel,sys_user,sys_edit) SELECT %d,id,%s,now() " .
+		 "FROM metro_artikel WHERE removed = 0",
 		 $id, $db->quote($_SESSION['sys']['login']));
 
   $sth = $db->query($sql);