SELECT dbo.fnGetZonas(ID_LOTE) as strZonas, Partnumber, nombre_categoria, Cantidad, modelo, nombre_marca, imagen, PrecioVenta, ConditionDescr , isnull(precio_anterior,0) as ValorReal, ISNULL((SELECT TOP (1) stock FROM dbo.TIENDA_PRECIOS WHERE (estado = 0) AND (id_lote = viewLoteDetalle.ID_LOTE) AND (id_tienda = 10)), 0) AS StockBodega, ISNULL ((SELECT SUM(TIENDA_PRECIOS_1.stock) AS Expr1 FROM dbo.TIENDA_PRECIOS AS TIENDA_PRECIOS_1 INNER JOIN dbo.TIENDA_LOTES ON TIENDA_PRECIOS_1.id_lote = dbo.TIENDA_LOTES.id_lote AND TIENDA_PRECIOS_1.id_tienda = dbo.TIENDA_LOTES.id_tienda WHERE (dbo.TIENDA_LOTES.find = 1) AND (TIENDA_PRECIOS_1.estado = 0) AND (TIENDA_PRECIOS_1.id_lote = viewLoteDetalle.ID_LOTE) AND (TIENDA_PRECIOS_1.id_tienda = 41)), 0) AS StockTienda, Margen FROM viewLoteDetalle, ZONAS_LOTES as ZONAS WHERE zl_lote = id_lote AND zl_zona = 209 AND vitrina = 1 AND Cantidad > 0 ORDER BY zl_orden ASC