01:05:04 SELECT * FROM tblCategoriasWeb
01:05:04 END SELECT * FROM tblCategoriasWeb
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='1' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='1' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='2' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='2' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='3' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='3' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='4' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='4' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='5' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='5' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='6' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='6' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='7' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='7' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='8' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='8' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='9' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='9' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='10' AND Lengua='3'
01:05:04 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='10' AND Lengua='3'
01:05:04 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='11' AND Lengua='3'
01:05:05 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='11' AND Lengua='3'
01:05:05 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='12' AND Lengua='3'
01:05:05 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='12' AND Lengua='3'
01:05:05 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='12' AND Lengua='3'
01:05:05 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='12' AND Lengua='3'
01:05:05 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='13' AND Lengua='3'
01:05:05 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='13' AND Lengua='3'
01:05:05 SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='13' AND Lengua='3'
01:05:05 END SELECT * FROM tblCategoriasWebIdiomas WHERE IdItemParent='13' AND Lengua='3'
01:05:05 SELECT * FROM tbuFormatos
01:05:05 END SELECT * FROM tbuFormatos
01:05:05 SELECT * FROM tbuChocolatesProduccion WHERE CodigoChocolate NOT LIKE '%,%' AND CodigoChocolate!=''
01:05:05 END SELECT * FROM tbuChocolatesProduccion WHERE CodigoChocolate NOT LIKE '%,%' AND CodigoChocolate!=''
01:05:05 SELECT * from tblCategoriasWeb WHERE IdNumero='9' AND IdEmpresa='2'
01:05:05 END SELECT * from tblCategoriasWeb WHERE IdNumero='9' AND IdEmpresa='2'
01:05:05 SELECT
t1.IdNumero as IdNumero, t1.Codigo as Codigo,t1.Descripcion as Descripcion, t2.CategoriaWeb as Categoria
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
t1.IdNumero OFFSET 228 ROWS FETCH NEXT 12 ROWS ONLY
01:05:05 END SELECT
t1.IdNumero as IdNumero, t1.Codigo as Codigo,t1.Descripcion as Descripcion, t2.CategoriaWeb as Categoria
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
t1.IdNumero OFFSET 228 ROWS FETCH NEXT 12 ROWS ONLY
01:05:05 SELECT Codigo FROM tblProductos WHERE IdNumero='28226'
01:05:06 END SELECT Codigo FROM tblProductos WHERE IdNumero='28226'
01:05:06 SELECT Codigo FROM tblProductos WHERE IdNumero='28228'
01:05:06 END SELECT Codigo FROM tblProductos WHERE IdNumero='28228'
01:05:06 SELECT Codigo FROM tblProductos WHERE IdNumero='28230'
01:05:06 END SELECT Codigo FROM tblProductos WHERE IdNumero='28230'
01:05:06 SELECT Codigo FROM tblProductos WHERE IdNumero='28232'
01:05:06 END SELECT Codigo FROM tblProductos WHERE IdNumero='28232'
01:05:06 SELECT Codigo FROM tblProductos WHERE IdNumero='28234'
01:05:06 END SELECT Codigo FROM tblProductos WHERE IdNumero='28234'
01:05:06 SELECT COUNT(*) as total 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
01:05:06 END SELECT COUNT(*) as total 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