- => 'SELECT model_id,model_name,model_barcode,model_reserve,model_reserve as item_quantity_to_buy'.
+ => 'SELECT model_id,model_name,model_reserve,model_reserve as item_quantity_to_buy'.
' FROM model'.
' WHERE model_reserve>0 AND NOT EXISTS'.
' FROM model'.
' WHERE model_reserve>0 AND NOT EXISTS'.
- ' (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)',
+ ' (SELECT item_id FROM item LEFT JOIN barcode USING(barcode_id) WHERE barcode.model_id=model.model_id AND status_id=1 AND item_quantity>0 AND item_valid_till=0)',