Teclado Logitech Multi Device K780
EAN: 097855121783
CODIGO: 097855121783 | CODIGO ALTERNATIVO:
$ 104.865
(Precio especial)
- Contado Efectivo
- Tarjeta de Débito
- Transferencia Bancaria
Precio sin impuestos nacionales $ 94.900
$ 177.221
(Precio de Lista)
¡No esperes más! Llevátelo en 18 cuotas
Envío a todo el país
En stock
Las imágenes del producto son ilustrativas.
Descripción
El teclado Logitech K780 multi device es una herramienta versátil y moderna pensada para quienes trabajan con varios dispositivos al mismo tiempo. Gracias a su tecnología Easy-Switch, permite alternar fácilmente entre hasta tres dispositivos, ya sea una computadora, un smartphone o una tablet. Esta funcionalidad lo convierte en una excelente opción para usuarios multitarea que buscan eficiencia y conectividad sin complicaciones.
Además, el teclado Logitech K780 presenta un diseño elegante, con teclas redondeadas y silenciosas que ofrecen una experiencia de escritura cómoda y fluida. Su soporte integrado permite colocar el teléfono o la tablet en posición ideal para leer o escribir, haciendo más práctico el trabajo desde cualquier lugar. Su compatibilidad multiplataforma incluye Windows, Mac, Android y iOS, lo que lo transforma en un accesorio realmente completo.
Usos del teclado Logitech K78
El teclado Logitech K780 es ideal para quienes trabajan con varios dispositivos a la vez, como profesionales que alternan entre la notebook, el celular y la tablet para tareas laborales o creativas. Así, escribir un correo desde el teléfono y luego continuar en la PC es tan simple como presionar un botón.
Por otro lado, también resulta perfecto para quienes desean un teclado de alta calidad en su escritorio o estudio. Su conectividad por Bluetooth o receptor USB Unifying lo hace práctico para cualquier entorno, y su diseño compacto ayuda a mantener el espacio ordenado y funcional.
Características
- Tecnología Easy-Switch: cambia entre 3 dispositivos con solo un botón
- Compatible con Windows, Mac, Android y iOS
- Soporte integrado para celulares y tablets
- Conexión Bluetooth o por receptor USB Unifying
- Teclas silenciosas, redondeadas y de respuesta cómoda
Además, el teclado Logitech K780 funciona con dos pilas AAA que brindan una duración de hasta 24 meses, lo que reduce la necesidad de reemplazos frecuentes. Su diseño robusto pero liviano lo hace fácil de transportar, mientras que su base antideslizante proporciona estabilidad en cualquier superficie.
TIPO DE TECLADO
- Multidispositivo inalámbrico (Bluetooth USB Unifying)
LAYOUT
- QWERTY en español (con tecla Ñ)
COMPATIBILIDAD
- Windows, macOS, Chrome OS, Android, iOS y iPadOS
CONEXIÓN
- Bluetooth Smart (BLE) /
- USB receptor Logitech Unifying
TECLAS
- Cóncavas, perfil bajo y silenciosas
EASY-SWITCH
- Alternancia entre 3 dispositivos
SOPORTE INTEGRADO
- Para smartphones y tablets
ALIMENTACIÓN
- 2 pilas AAA (incluidas)
DURACIÓN DE BATERÍA
- Hasta 24 meses
DIMENSIONES
- 380 x 158 x 8-22 mm
PESO
- 875 g (con baterías)
COLOR
- Negro con detalles en blanco
Productos relacionados
Teclado Mecanico Hyperx Origins TKl Switch Aqua
$ 167.783
18 cuotas fijas de
$ 15.753
Teclado MSI Vigor Gk50 Low Profile F.F.
$ 100.831
18 cuotas fijas de
$ 9.467
Teclado+Mouse Inalambrico Logitech MK220
$ 26.736
18 cuotas fijas de
$ 2.510
Combo Corsair k55+Harpoon rgb (Teclado+Mouse)
$ 181.496
18 cuotas fijas de
$ 17.040
|
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: ;Teclado-Logitech-Multi-Device-K780;ITEM_ID=892;GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774; |
| Cart Guid: 6ceb90ec-1351-4165-bbb0-8bbc743d2556 |
|
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 |
| 216.73.216.171 |
| * 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 = 892 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 = 892 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 = 892 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code Tiempo Consumido: 00:00:00.0155919 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 = 892 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.0156513 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 = 892 Tiempo Consumido: 00:00:00 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 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 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 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 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 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 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 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 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 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 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.0156202 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 = 136 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 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 = 148 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 = 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 = 80 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 = 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 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.0156220 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 = 151 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 = 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 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.0156164 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.0155913 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.0156211 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 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 = 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 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.0155877 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 = 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 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.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 = 147 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.0155867 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.0156198 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.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 = 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 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 = 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 = 145 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 = 123 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 = 137 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.0156335 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], dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation1, -- oculta o muestra boton compra CASE WHEN ti.item_annotation1 = '' THEN 'block' ELSE 'none' END, -- oculta o muestra boton preventa CASE WHEN ti.item_annotation1 <> '' THEN 'block' ELSE 'none' END, 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',''), -- Precio especial REPLACE(format(convert(decimal(16,0), 1.05 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 1 cuota REPLACE(format(convert(decimal(16,0), 1.41 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 12 cuotas PTF REPLACE(format(convert(decimal(16,0), (1.13 * tpli.prli_price)/3), 'N', 'de-de'),',00',''), -- Precio 3 cuotas cuota REPLACE(format(convert(decimal(16,0), 1.13 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 3 cuotas PTF REPLACE(format(convert(decimal(16,0), 1.22 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 6 cuotas PTF REPLACE(format(convert(decimal(16,0), (1.22 * tpli.prli_price)/6), 'N', 'de-de'),',00',''), -- Precio 6 cuotas cuota REPLACE(format(convert(decimal(16,0), (1.41 * tpli.prli_price)/12), 'N', 'de-de'),',00',''), -- Precio 12 cuotas cuota REPLACE(format(convert(decimal(16,0), 1.69 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio de lista REPLACE(format(convert(decimal(16,0), 1.69 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 18 cuotas REPLACE(format(convert(decimal(16,0), (1.69 * tpli.prli_price)/18), 'N', 'de-de'),',00',''), -- Precio 18 cuotas cuota REPLACE(format(convert(decimal(16,0), 1.31 * tpli.prli_price), 'N', 'de-de'),',00',''), -- Precio 9 cuotas REPLACE(format(convert(decimal(16,0), (1.31 * tpli.prli_price)/9), 'N', 'de-de'),',00',''), -- Precio 9 cuotas cuota 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(convert(decimal(16,0), tpli.prli_priceNOTaxes), 'N', 'de-de'),',00',''), CASE WHEN tcat.cat_id IN ('52', '53', '65', '70', '125', '80', '67', '68', '132') THEN 'true' ELSE 'false' END, CASE WHEN ti.item_liquidationPlus = 'True' THEN 'none' ELSE 'block' END 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 = 892 Tiempo Consumido: 00:00:00.0156142 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 = 892 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 = 892 Tiempo Consumido: 00:00:00.0156213 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, -- oculta o muestra boton compra CASE WHEN ti.item_annotation1 = '' THEN 'block' ELSE 'none' END, 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.69 * tpli.prli_price/18), '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,'/','--'), REPLACE(format(convert(decimal(16,0), tpli.prli_priceNOTaxes), 'N', 'de-de'),',00',''), CASE WHEN ti.item_liquidationPlus = 'True' THEN 'none' ELSE 'block' END 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 = '6ceb90ec-1351-4165-bbb0-8bbc743d2556' 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 <> '892' and ti.subcat_id = '3853' Tiempo Consumido: 00:00:00.0468580 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 |
|
|