Smartwatch Xiaomi Imilab W12 Negro

EAN: 6971085310893

CODIGO: 6971085310893 | CODIGO ALTERNATIVO:

$85.942

(Precio especial)

Contado Efectivo
Tarjeta de Débito
Transferencia Bancaria

$ 103.130

(Precio de Lista)

¡6 cuotas FIJAS sobre PRECIO DE LISTA!

Envío a todo el país

En stock Las imágenes del producto son ilustrativas.

Descripción

El reloj inteligente IMILAB W12 es un dispositivo que ayudará en la vida cotidiana. Es uno de los relojes inteligentes versátiles que ofrece un diseño atractivo y fetiche con un factor de forma más delgado y liviano. Puede cambiar fácilmente los diales para adaptarlos a su estilo y estado de ánimo. Viene con una pantalla TFT 3D HD de 1,32 pulgadas que realmente se destaca entre la multitud. Tiene la resolución de pantalla universal de 360 x 360 píxeles que podemos encontrar en algunos otros relojes inteligentes. Tiene una carcasa de metal de aleación de zinc 10,8 mm más delgada que se siente resistente para el uso diario. Tiene 260 mm x 22 mm x 11 mm de factor de forma que pesa 57 gramos. IMILAB W12 tiene una batería incorporada de 340 mAh, lo que significa que puedes usarla durante mucho tiempo sin recargar. El reloj también ayudará a controlar su salud. Hagas lo que hagas durante el día, Xiaomi iMi W12 siempre controlará su bienestar y rastreará incluso las pequeñas desviaciones de la norma. El reloj puede controlar su condición cardíaca durante todo el día y, por lo tanto, ayudar a controlar su sistema cardiovascular.

Monitor 1.32 HD (360 x 360) con panel táctil TFT y vidrio curvo 3D

Capacidad de la batería: 340 mAh

Duración de la batería: Hasta 30 días

Carga: Magnética

Conectividad Bluetooth: 5.0

Material Caja de metal de aleación de zinc 10,8 mm más delgada

Productos relacionados

[Más info]

Smartwatch Xiaomi Imilab KW66 Negro

$ 50.554

6 cuotas sin interés de
$ 10.111

AGREGAR AL CARRITO

[Más info]

Smartwatch Kieslect K10 Negro

$ 75.831

6 cuotas sin interés de
$ 15.166

AGREGAR AL CARRITO

Ver todos los productos de la categoría Smartwatch

Modo de Diseño: Parámetros Internos del Sitio Web

Ws_ID: 0eeb8df0-4255-4fd7-93e4-dd21aa3fa774

Page_Id: 63be7a70-89e1-42dd-bce2-0cab3d61c3bf

WSU_Id: -1

Parámetros de la Página: ;Smartwatch-Xiaomi-Imilab-W12-Negro;ITEM_ID=599;GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774;

Cart Guid: 647b70e9-8f11-42d4-9153-b501b286166b

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

18.190.176.26

* WebSite Designer *

Tiempo Total de Proceso: 2 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 = 599

Tiempo Consumido: 00:00:00.0099735

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 = 599 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc

Tiempo Consumido: 00:00:00.0518600

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 = 599 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code

Tiempo Consumido: 00:00:00.0698126

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 = 599 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.0369002

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 = 599

Tiempo Consumido: 00:00:00.0129648

GBP_LIST: LISTA_DELIVERY
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT distinct td.dl_id, td.dl_Note, CASE WHEN td.dl_webSiteDecription <> '' THEN SUBSTRING (td.dl_webSiteDecription, 1, 100) ELSE SUBSTRING (td.dl_name, 1, 100) END [descripcion] FROM tbDelivery td where td.dl_id in('9','10','11')

Tiempo Consumido: 00:00:00.0049866

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.0019950

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.0009971

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.0029932

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.0089758

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.0109693

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.0109716

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.0249344

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.0139628

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.0119680

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.0049870

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.0109701

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.0169554

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.0099745

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.0109708

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.0109702

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.0059842

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.0059839

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.0099737

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 = 67 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.0229376

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.0069822

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 = 69 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.0079779

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 = 132 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.0079782

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.0109710

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.0099856

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.0089758

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.0039901

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.0029916

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.0039886

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.0039884

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.0029922

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.0019942

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.0039908

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.0029922

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.0039902

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 = 133 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.0029921

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.0029922

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 = 88 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.0029933

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.0029931

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.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 = 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.0039908

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.0029927

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.0029920

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.0029918

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.0119676

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.0189484

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.0059854

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.0039901

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.0039901

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.0039901

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.0029926

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.0448785

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.0029919

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 = 131 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.0049860

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.0059844

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.0039906

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.0039885

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.0119678

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.0049873

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.0119684

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.0039898

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.0039891

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.0039893

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.0049857

GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_volume, ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_codeAlternative IS NOT NULL AND ti.item_codeAlternative <> '' THEN '«strong»MODELO:«/strong» ' + 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.05 * 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.20 * 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.20 * tpli.prli_price)/6), 'N', 'de-de'),',00',''), REPLACE(format(convert(decimal(16,0), (1.30 * tpli.prli_price)/12), 'N', 'de-de'),',00',''), REPLACE(format(convert(decimal(16,0), 1.20 * 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,'/','--') 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 = 599

Tiempo Consumido: 00:00:00.0408900

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 = 599

Tiempo Consumido: 00:00:00.0099737

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 = 599

Tiempo Consumido: 00:00:00.0009975

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.20 * tpli.prli_price/6), '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 = '647b70e9-8f11-42d4-9153-b501b286166b' 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 <> '599' and ti.subcat_id = '3935'

Tiempo Consumido: 00:00:00.1047156

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.0029915

§NombreCliente§