- Notebook Lenovo IdeaPad 1 Celeron N5100 128GB SSD 4GB 14” - Eclypse, desafiando la tecnología | Insumos de Informática
...

Notebook Lenovo IdeaPad 1 Celeron N5100 128GB SSD 4GB 14"

CODIGO: 196379312544
Notebook-Lenovo-Ideapad-1

CODIGO: 196379312544 | CODIGO ALTERNATIVO:

$424.925

(Precio especial)

  • Contado Efectivo
  • Tarjeta de Débito
  • Transferencia Bancaria

$ 594.895

(Precio de Lista)

¡Hasta 12 cuotas SIN INTERÉS!


Envío Turbo CABA

  • $ 4.000

Envío a todo el país



En stock

Descripción

Notebook Lenovo IdeaPad 1 82LVOO3YUS


La notebook Lenovo IdeaPad 1 con Celeron N5100, 128GB SSD y 4GB de RAM es ideal para usuarios que buscan una computadora portátil básica y económica para tareas simples del día a día. Está especialmente indicada para:

  • Estudiantes: Perfecta para realizar tareas escolares, navegar por internet y utilizar aplicaciones educativas básicas. Su tamaño compacto y ligero la hace fácil de transportar entre clases. 
  • Usuarios domésticos: Ideal para actividades cotidianas como navegación web, correo electrónico, redes sociales, reproducción de multimedia y tareas de oficina básicas. Su SSD de 128GB proporciona un almacenamiento suficiente para documentos y archivos personales. 
  • Profesionales en movilidad: Para profesionales que necesitan una computadora portátil para tareas simples mientras están en movimiento, como tomar notas, enviar correos electrónicos y realizar videoconferencias. Su diseño ligero y compacto la hace ideal para llevarla consigo durante todo el día. 
  • Profesionales: la notebook Lenovo IdeaPad 1 Celeron N5100, puede ser una excelente opción como una segunda computadora o también para profesionales, para que puedan realizar tareas simples en el hogar o en la oficina, sin incurrir en altos costos.  
Comprá ahora en hasta 12 cuotas sin interés con Visa y Mastercard en Eclypse.

PROCESADOR

  • Intel: Celeron N5100

GRAFICOS

  • Gráficos: Intel HD Graphics

ALMACENAMIENTO

  • SSD: 128GB PCIe M.2 Gen 3.0

MEMORIA

  • Capacidad: 4GB DDR4

PANTALLA

  • Resolución: 1920x1080
  • Tamaño: 14" FHD

SISTEMA OPERATIVO

  • Versión: Windows 11 Home

TECLADO

  • Idioma: English(No posee Ñ)

CONECTIVIDAD

  • Bluetooth
  • Wifi
  • 1 Lector de Tarjeta SD

PUERTOS

  • 1x USB 3.0 C
  • 2x USB 3.0 A
  • 1x Puerto HDMI 2.0
  • 1x Entrada de Aur/Mic

GARANTIA

  • 1 Año
  • Modelo 82LV003YUS
Productos relacionados
[Más info]
Notebook Lenovo IdeaPad 1 Pentium N5030 128GB SSD

Notebook Lenovo IdeaPad 1 Pentium N5030 128GB SSD

$ 431.027

12 cuotas sin interés de
$ 50.287

AGREGAR AL CARRITO
[Más info]
Notebook Lenovo Ideapad 1 15IJL7 Intel N6000 4gb

Notebook Lenovo Ideapad 1 15IJL7 Intel N6000 4gb

$ 453.713

12 cuotas sin interés de
$ 52.933

AGREGAR AL CARRITO
[Más info]
Notebook Lenovo Ideapad 1 15IJL7 Intel N6000 12gb

Notebook Lenovo Ideapad 1 15IJL7 Intel N6000 12gb

$ 518.787

12 cuotas sin interés de
$ 60.525

AGREGAR AL CARRITO
Ver todos los productos de la categoría Procesador



Modo de Diseño: Parámetros Internos del Sitio Web
Ws_ID: 0eeb8df0-4255-4fd7-93e4-dd21aa3fa774
Page_Id: e21975ed-6d7f-4341-a1a7-0456e3731a83
WSU_Id: -1
Parámetros de la Página: ;Notebook-Lenovo-IdeaPad-1-Celeron-N5100-128GB-SSD-4GB-14;ITEM_ID=281;GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774;
Cart Guid: d7073876-8a33-4e24-a2b5-d9a7c5eb07f3

Estados Internos
* cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:1 * prli_id:1 * prof_id:1 * stor_id:1 * item_id:-1 * camp_id:-1 *

Comp_Id: 1
Lang_Id: 2
3.142.98.111
* WebSite Designer *


Tiempo Total de Proceso: 1 Segundos.


Ultimos SQL Ejecutados:


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_web_title, ti.item_web_metaKeywords, CASE WHEN ti.item_web_metaDescription <> '' THEN ti.item_web_metaDescription ELSE 'Arma tu pc con Eclypse! Tienda de computación: Pc Gamer, Insumos para Pc, Notebook Gamer, accesorios y más. Av. Carabobo 135 Flores CABA. ¡Compra ahora!' END FROM tbItem ti WHERE ti.item_id = 281

Tiempo Consumido: 00:00:00

GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.Size_code, tc.Size_desc, '', '' FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 281 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc

Tiempo Consumido: 00:00:00

GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, '', tc.Size_code, tc.color_code FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 281 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code

Tiempo Consumido: 00:00:00.0156519

GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], c.curr_symbol, tc.Item_id FROM vwWebSiteII_itemSizeColor tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.itemID4SizeColor AND tpli.prli_id = 1 AND tpli.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 281 AND tc.comp_id=1 AND tpli.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id

Tiempo Consumido: 00:00:00.0217969


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, CASE WHEN ti.item_web_title <> '' THEN ti.item_web_title ELSE ti.item_desc END [item_desc], ti.item_code, --ti.item_annotation1, CASE WHEN ti.item_annotation1 <>'' THEN ti.item_annotation1 ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc], CASE WHEN ti.item_web_metaDescription <> '' THEN ti.item_web_metaDescription ELSE ti.item_desc END, ti.item_web_metaKeywords FROM tbItem ti WHERE ti.item_id = 281

Tiempo Consumido: 00:00:00.0030229


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged FROM tbWebSiteII_Names WHERE comp_id=1 AND ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'

Tiempo Consumido: 00:00:00


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT cust_name FROM tbCustomer WHERE cust_id = -1

Tiempo Consumido: 00:00:00


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False'))

Tiempo Consumido: 00:00:00.0009967

GBP_LIST: SCATAUX
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CATG_ID, catg_desc FROM TBCATEGORYGROUP WHERE comp_id=1 AND catg_webNOTE1 <> 'N' ORDER BY CAST(catg_webNOTE1 AS INT) asc

Tiempo Consumido: 00:00:00.0020329

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='1' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0019665

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 121 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 51 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0019666

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 49 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0014358

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0025037

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 47 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0029928

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 46 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0019948

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 48 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0010997

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 55 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='2' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 54 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 52 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 53 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 65 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 70 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0155923

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 125 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 68 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='3' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 59 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 100 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 77 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 58 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 72 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 73 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 56 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156469

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='5' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 112 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 113 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156175

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='6' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 127 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 83 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 57 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 85 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 89 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='9' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 74 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 96 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='11' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 102 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='12' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 104 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 109 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 105 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 130 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 107 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 106 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 108 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='10' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 97 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 115 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 128 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 90 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 110 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 118 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 126 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 99 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0155992

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 119 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 1 AND tmp2.ws_id='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 116 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0155958


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TI.ITEM_MADE, TPLI.SEMAPHOREVALUE, TI.ITEM_ID, --TI.ITEM_CODEALTERNATIVE, CASE WHEN TI.ITEM_CODEALTERNATIVE <> '' THEN '| «B»MODELO«/B»: ' + TI.ITEM_CODEALTERNATIVE ELSE ' ' END, CASE WHEN TI.ITEM_WEBSITE_DESC<>'' THEN SUBSTRING (TI.ITEM_WEBSITE_DESC, 1, 75) ELSE SUBSTRING (TI.ITEM_DESC, 1, 75) END [ITEM_DESC], SUBSTRING (TI.ITEM_ANNOTATION1, 1, 18), DBO.FNSTRALLTRIM(TI.ITEM_CODE) [ITEM_CODE], TI.ITEM_VENDORCODE, TI.BRAND_ID, TI.ITEM_ANNOTATION1, TI.ITEM_ANNOTATION2, SUBSTRING (TI.ITEM_ANNOTATION2, 1, 100), TI.ITEM_DESCHTML, TBN.WSSN_ISNOVELTY, TBN.WSSN_IS4SALE, ITEM_WEBSITE_VENDORPAGE, REPLACE(FORMAT(CONVERT(DECIMAL(16,0), TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.99 * TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.25 * TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.99 * TPLI.PRLI_PRICE/2), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.15 * TPLI.PRLI_PRICE/3), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.15 * TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.25 * TPLI.PRLI_PRICE/6), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.40 * TPLI.PRLI_PRICE/12), 'N', 'DE-DE'),',00',''), REPLACE(FORMAT(CONVERT(DECIMAL(16,0), 1.40 * TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), TC.CURR_SYMBOL, TBR.BRAND_DESC, TCAT.CAT_DESC, TSUB.SUBCAT_DESC, TCAT.CAT_ID, TSUB.SUBCAT_ID, CONVERT (DECIMAL(16,0), TTN.TAX_PERCENTAGE) [IVA], REPLACE(TI.ITEM_CODE,'/','--') --REPLACE(FORMAT(CAST(ISNULL(TPLI.STRIKETHROUGHPRICE,'0') AS INT), 'N', 'DE-DE'),',00','') AS 'NUMERIC FORMAT', --CASE WHEN CONVERT(DECIMAL(16,2), ISNULL(TPLI.STRIKETHROUGHPRICE,'0')) » CONVERT(DECIMAL(16,2), TPLI.PRLI_PRICE) THEN 'TRUE' ELSE 'FALSE' END [PRECIOTACHADOMOSTRAR] FROM TBITEM TI INNER JOIN TBWEBSITEII_ITEMSDATA TPLI ON TPLI.COMP_ID = TI.COMP_ID AND TPLI.ITEM_ID = TI.ITEM_ID AND TPLI.PRLI_ID = 1 AND TPLI.WS_ID = '0EEB8DF0-4255-4FD7-93E4-DD21AA3FA774' INNER JOIN TBSYSCURRENCY TC ON TC.CURR_ID = TPLI.CURR_ID INNER JOIN TBBRAND TBR ON TI.BRAND_ID = TBR.BRAND_ID INNER JOIN TBCATEGORY TCAT ON TCAT.CAT_ID = TI.CAT_ID INNER JOIN TBSUBCATEGORY TSUB ON TSUB.SUBCAT_ID = TI.SUBCAT_ID LEFT JOIN TBWEBSITEII_ITEMS_NOVELTYAND4SALE TBN ON TBN.COMP_ID = TI.COMP_ID AND TI.ITEM_ID = TBN.ITEM_ID AND TBN.WS_ID = '0EEB8DF0-4255-4FD7-93E4-DD21AA3FA774' LEFT JOIN TBITEMTAXES TIT ON TIT.ITEM_ID=TI.ITEM_ID AND TIT.COMP_ID=TI.COMP_ID LEFT JOIN TBTAXNAME TTN ON TTN.TAX_ID=TIT.TAX_ID AND TTN.COMP_ID=TIT.COMP_ID AND TTN.TAX_CLASS=1 WHERE TI.ITEM_ID = 281

Tiempo Consumido: 00:00:00.0156217

GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tii.itimg_id ,ti.item_desc FROM tbItemImages tii INNER JOIN tbItem ti ON ti.item_id = tii.item_id WHERE tii.item_id = 281

Tiempo Consumido: 00:00:00


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, ti.subcat_id FROM tbitem ti WHERE ti.item_id = 281

Tiempo Consumido: 00:00:00

GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 50) ELSE SUBSTRING (ti.item_desc, 1, 50) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 20), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation2, SUBSTRING (ti.item_annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00','') END [price], REPLACE(format(convert(decimal(16,0), 1.40 * tpli.prli_price/12), 'N', 'de-de'),',00',''), tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp83.globalbluepoint.com/eclypse/COMPARA/X/GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_website_desc), 1, 100) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc] , REPLACE(ti.item_code,'/','--') FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 1 AND tpli.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'd7073876-8a33-4e24-a2b5-d9a7c5eb07f3' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE ti.item_web = 'true' AND ti.item_id <> '281' and ti.subcat_id = '3992'

Tiempo Consumido: 00:00:00.0312423

GBP_LIST: MARCAS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT brand_id, brand_desc FROM tbBrand WHERE brand_note like '%SMAX%' and brand_note2 like '%SMAX%' Order By brand_desc

Tiempo Consumido: 00:00:00