09:42:44 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='10645'

09:42:44 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='10645'

09:42:44 SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='10645' AND Lengua='3'

09:42:44 END SELECT TOP 1 WebDescripcionCorta as keywords FROM tblProductosIdiomas WHERE IdItemParent='10645' AND Lengua='3'

09:42:44 SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=10645)

09:42:44 END SELECT TOP 1 Mida FROM tbuFormatos WHERE IdEmpresa=2 AND IdNumero IN (SELECT USR_Formato FROM tblProductos WHERE IdEmpresa=2 AND IdNumero=10645)

09:42:44 SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 END SELECT Peso from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero=''

09:42:44 END SELECT Piezas from tbuFormatos WHERE IdEmpresa='2' AND IdNumero=''

09:42:44 SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 END SELECT Laminas from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 END SELECT PiezasFlowPack from tbuEmbalajesFormato WHERE IdEmpresa='2' AND Formato='' AND Embalajes='' AND Tipo='0'

09:42:44 SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='10645'

09:42:44 END SELECT CategoriaWeb from tblProductosCategoriasWeb WHERE IdItemParent='10645'

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

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