X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=assistants%2Fstats%2Fstock.inc.php;h=b71d0228c5033dfa35f45826417a534c318428e7;hb=acb09ed65891a25d8163b92fe17db5bc78e601b1;hp=8067a77f8f2b71c093f9b0397d80224e3046e6cb;hpb=049a7400bfbbf97a3f5a430bed36668c069db589;p=mirrors%2FSokoMan.git diff --git a/assistants/stats/stock.inc.php b/assistants/stats/stock.inc.php index 8067a77..b71d022 100644 --- a/assistants/stats/stock.inc.php +++ b/assistants/stats/stock.inc.php @@ -1,6 +1,6 @@ 'SELECT room_id,room_name,model_id,model_name,model_barcode,model_price_out,COUNT(item_id),SUM(item_quantity)'. ' FROM item LEFT JOIN model USING(model_id) LEFT JOIN room USING(room_id)'. ' WHERE item_valid_till=0 AND status_id=1'.