a2a4c131fff529b81bfffcfbb609f9f14f46a574
3 "Nakoupit: Došlo úplně (Urgent WishList)"
4 => 'SELECT model_id,model_name,model_barcode,model_reserve,model_reserve as item_quantity_to_buy'.
6 ' WHERE model_reserve>0 AND NOT EXISTS'.
7 ' (SELECT item_id FROM item WHERE model.model_id=item.model_id AND status_id=1 AND item_quantity>0 AND item_valid_till=0)',
8 "Nakoupit: Dochází (WishList)"
9 => 'SELECT model_id,model_name,model_barcode,model_reserve,'.
10 ' COUNT(item_id),SUM(item_quantity),model_reserve-SUM(item_quantity) as item_quantity_to_buy'.
11 ' FROM item LEFT JOIN model USING(model_id)'.
12 ' WHERE item_valid_till=0 AND status_id=1'.
14 ' HAVING SUM(item_quantity)<model_reserve'.
15 ' ORDER BY model_id;',
This page took 0.339897 seconds and 3 git commands to generate.