01:04:52 SELECT TOP 1 t6.IdNumero as IdCategoria, t6.Nombre as CategoriaNombre, t1.USR_Envase as USRENVASE, t1.USR_Formato as USRFORMATO, t5.PrecioPVP as PrecioPVP, t1.Descripcion as Desc2, t1.Codigo as Codigo, t1.IdNumero as IdNumero,t4.DescripcionES as Chocolate, t4.CodigoChocolate as IdChocolate, t1.WebNombre as Nombre, t1.WebDescripcionCorta as Corta, t1.WebDescripcionLarga as Larga FROM tblProductos as t1
INNER JOIN tblProductosCategoriasWeb as t3 ON t1.IdNumero=t3.IdItemParent
INNER JOIN tbuChocolatesProduccion AS t4 ON t1.USR_Chocolate=t4.IdNumero
INNER JOIN tblTarifasVenta AS t5 ON t1.IdNumero=t5.IdItemParent
INNER JOIN tblCategoriasWeb AS t6 ON t3.CategoriaWeb=t6.IdNumero
WHERE t1.IdEmpresa='2' AND t1.IdNumero='10937'
01:04:52 END SELECT TOP 1 t6.IdNumero as IdCategoria, t6.Nombre as CategoriaNombre, t1.USR_Envase as USRENVASE, t1.USR_Formato as USRFORMATO, t5.PrecioPVP as PrecioPVP, t1.Descripcion as Desc2, t1.Codigo as Codigo, t1.IdNumero as IdNumero,t4.DescripcionES as Chocolate, t4.CodigoChocolate as IdChocolate, t1.WebNombre as Nombre, t1.WebDescripcionCorta as Corta, t1.WebDescripcionLarga as Larga FROM tblProductos as t1
INNER JOIN tblProductosCategoriasWeb as t3 ON t1.IdNumero=t3.IdItemParent
INNER JOIN tbuChocolatesProduccion AS t4 ON t1.USR_Chocolate=t4.IdNumero
INNER JOIN tblTarifasVenta AS t5 ON t1.IdNumero=t5.IdItemParent
INNER JOIN tblCategoriasWeb AS t6 ON t3.CategoriaWeb=t6.IdNumero
WHERE t1.IdEmpresa='2' AND t1.IdNumero='10937'
01:04:52 SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='10937' AND Lengua='3'
01:04:52 END SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='10937' AND Lengua='3'
01:04:52 SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=10937)
01:04:52 END SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=10937)
01:04:52 SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 END SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5614'
01:04:52 END SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5614'
01:04:52 SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 END SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 END SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5614' AND Embalajes='5731' AND Tipo='0'
01:04:52 SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='10937'
01:04:52 END SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='10937'
01:04:52 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='9' AND Lengua='3'
01:04:53 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='9' AND Lengua='3'
01:04:53 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'
01:04:53 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'
01:04:53 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='11'
01:04:53 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='11'
01:04:53 SELECT t2.WebNombre as Nombre,t2.IdNumero as Id FROM tblProductosAlternativos as t1 INNER JOIN tblProductos as t2 ON t1.Producto=t2.IdNumero WHERE t1.IdItemParent='10937'
01:04:53 END SELECT t2.WebNombre as Nombre,t2.IdNumero as Id FROM tblProductosAlternativos as t1 INNER JOIN tblProductos as t2 ON t1.Producto=t2.IdNumero WHERE t1.IdItemParent='10937'
01:04:53 SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='9705'
01:04:53 END SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='9705'
01:04:53 SELECT TOP 5 t1.IdNumero as IdNumero, t1.Codigo as Codigo, t1.Descripcion as Descripcion from tblProductos as t1 INNER JOIN tblProductosCategoriasWeb as t2 ON t1.IdNumero=t2.IdItemParent WHERE t1.IdEmpresa='2' AND t2.CategoriaWeb='9' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
01:04:53 END SELECT TOP 5 t1.IdNumero as IdNumero, t1.Codigo as Codigo, t1.Descripcion as Descripcion from tblProductos as t1 INNER JOIN tblProductosCategoriasWeb as t2 ON t1.IdNumero=t2.IdItemParent WHERE t1.IdEmpresa='2' AND t2.CategoriaWeb='9' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
RECTÁNGULO VENECIA
Código: 9705
Categoría: Fantasía, Sin colorantes
Keywords: Rayas
Deciración en chocolate, formato rectangular de 35x45mm (DESC. LARGA)
Conservación
Temperatura entre 15º y 20ºC
Humedad relativa: inferior a 55%
Evitar la proximidad de olores fuertes
También te puede interesar
CARNAVAL *PEQ*
9024F1SP
RECTANGULO MARMOL 35X45
9714
CUADRADO PRIMAVERA *PEQ*
14949F2SBP
TRIANGULO CRUZADO *PEQ*
10277F206SBP
STICK LECHE 6X140MM
16636