15:22:49 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='16870'
15:22:49 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='16870'
15:22:49 SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='16870' AND Lengua='3'
15:22:49 END SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='16870' AND Lengua='3'
15:22:49 SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=16870)
15:22:50 END SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=16870)
15:22:50 SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 END SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5615'
15:22:50 END SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5615'
15:22:50 SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 END SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 END SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5615' AND Embalajes='5731' AND Tipo='0'
15:22:50 SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='16870'
15:22:50 END SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='16870'
15:22:50 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='5' AND Lengua='3'
15:22:50 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='5' AND Lengua='3'
15:22:50 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='5'
15:22:50 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='5'
15:22:50 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'
15:22:50 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'
15:22:50 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='16870'
15:22:50 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='16870'
15:22:50 SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='13537'
15:22:50 END SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='13537'
15:22:50 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='5' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
15:22:50 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='5' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
CUADRADO VALENTÍN
Código: 13537
Categoría: San Valentín, Fantasía
Keywords: Rayas
Conservación
Temperatura entre 15º y 20ºC
Humedad relativa: inferior a 55%
Evitar la proximidad de olores fuertes
También te puede interesar
FLECHAZO -3LAM-
20777F398SBP
FEL.ST.VALETÍN *PEQ*
13958F219P
CLASSIC LOVE -3 LAM-
20649F291BP
STICK VALENTIN
13539
ROJA *BOLAS*
9548F236B