10:44:46 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='27023'

10:44:46 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='27023'

10:44:46 SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='27023' AND Lengua='3'

10:44:46 END SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='27023' AND Lengua='3'

10:44:46 SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=27023)

10:44:46 END SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=27023)

10:44:46 SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 END SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5728'

10:44:47 END SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero='5728'

10:44:47 SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 END SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 END SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='5728' AND Embalajes='5729' AND Tipo='0'

10:44:47 SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='27023'

10:44:47 END SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='27023'

10:44:47 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='8' AND Lengua='3'

10:44:47 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='8' AND Lengua='3'

10:44:47 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='8'

10:44:47 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='8'

10:44:47 SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'

10:44:47 END SELECT Nombre from tblCategoriasWeb WHERE IdNumero='9'

10:44:47 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='27023'

10:44:47 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='27023'

10:44:47 SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='19317F384SBP'

10:44:47 END SELECT * FROM TBLproductos where IdEmpresa = '2' AND Codigo='19317F384SBP'

10:44:47 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='8' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()

10:44:47 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='8' AND t1.ECommerce='1' AND t1.Codigo!='' AND t1.Codigo IS NOT NULL ORDER BY NEWID()