16:52:15 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='19756'
16:52:15 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='19756'
16:52:15 SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='19756' AND Lengua='3'
16:52:15 END SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='19756' AND Lengua='3'
16:52:15 SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=19756)
16:52:16 END SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=19756)
16:52:16 SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 END SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5458'
16:52:16 END SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5458'
16:52:16 SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 END SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 END SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5458' AND Embalajes='5729' AND Tipo='0'
16:52:16 SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='19756'
16:52:16 END SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='19756'
16:52:16 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='2' AND Lengua='3'
16:52:16 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='2' AND Lengua='3'
16:52:16 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='2'
16:52:16 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='2'
16:52:16 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='5'
16:52:16 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='5'
16:52:16 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='19756'
16:52:16 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='19756'
16:52:16 SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='14888F23SBP'
16:52:16 END SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='14888F23SBP'
16:52:16 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='2' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
16:52:16 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='2' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()
OJOS AMOR
Código: 14888F23SBP
Categoría: Infantil, San Valentín
Keywords: Corazón
Conservación
Temperatura entre 15º y 20ºC
Humedad relativa: inferior a 55%
Evitar la proximidad de olores fuertes
También te puede interesar
CORBATAS PAPA *PEQ*
14048F231SBP
FANTASMAS -- LA NOVA 20127F85SBP
14898F85SP
JUGADOR FUTBOL 3 *PEQ*
20133F340BP
JUGADOR FUTBOL 2 *PEQ*
15477F340BP
MARGARITAS -- PEQ --
19015F361SBP