PAGA HASTA EN 12 CUOTAS | ENVIOS A TODO EL PAIS

CARGADOR LENOVO YOGA 65W 20V 4.5A PIN USB 10.5 x 4.0

Marca: HP   EAN: 2104108
CARGADOR LENOVO YOGA 65W 20V 4.5A PIN USB 10.5 x 4.0
$ 29.992

1 cuota de $ 29.992 (PTF: $ 29.992)

3 cuotas de $ 9.997 (PTF: $ 29.992)

6 cuotas de $ 4.999 (PTF: $ 29.992)



Retirá en nuestro local
Moreno 566, Quilmes
Cargador Notebook Lenovo ADLX65NDC2A ADLX65NDC3A ADLX65NLC3A ADLX65NCC3A ADLX65NLC2A ADLX65NCC2A ADLX45NCC3A ADLX45NDC3A ADLX45NLA3A ADP-65XB A PA-1650-37LC
  • Voltaje: 20v
  • Amperaje: 3.25a
  • Potencia: 65w

Presione CTRL+ F para ubicar su modelo

COMPATIBLE CON LOS SIGUIENTES CARGADORES:

ADLX65NDC2A ADLX65NDC3A ADLX65NLC3A ADLX65NCC3A ADLX65NLC2A ADLX65NCC2A ADLX45NCC3A ADLX45NDC3A ADLX45NLA3A ADP-65XB A PA-1650-37LC 45N0254 45N0256, 45N0258, 45N0260, 45N0262, 45N0264, 45N0326, 45N0328, 0A36258, 0A36270, 0A36272, 0A36262, 0A36264, 0A36261, 0A36271, 0A36265, 0A36273, 0A36266, 0A36259, 0A36260, 0A36268, 0A36263, 0A36262, 0A36269, 0A36268, 0A36265, 0A36267, 0A36266 36200124, N0265, 45N0266,, 36200235, 45N0267, 45N0278 36200249, 36200251, 36200253,36200301, 36200303 36200245, 36200246,36200247

Compatible con las siguientes referencias :
00PC757 FRU00PC757
0C19868 FRU0C19868 (slim)
0B47459 FRU0B47459 (slim)
0B56097 FRU0B56097
01FR039 FRU01FR039
01FR050 FRU01FR050

36200124 35008405
36200235 35010096
36200249 35016343
36200251 35026319
36200253 35040862
36200352 35042730
36200607 35046047
36200611 35047236

45N0253 FRU45N0253
45N0254 FRU45N0254
45N0257 FRU45N0257
45N0261 FRU45N0261
45N0262 FRU45N0262
45N0265 FRU45N0265
45N0266 FRU45N0266
45N0267 FRU45N0267
45N0278 FRU45N0278
45N0357 FRU45N0357
45N0359 FRU45N0359
45N0495 FRU45N0495
45N0497 FRU45N0497

4X20E53340 PA-1650-37LF
4X20M73670 PA-1650-37LC

54Y8868 FRU54Y8868 ADP?65FD BB
54Y8964 FRU54Y8964 ADP-65FD B
54Y8983 FRU54Y8983 ADP-65XB A
54Y8999 FRU54Y8999 ADP-65XB AC

ADLX65NCC3A 5A10J46692
ADLX65NDC3A 5A10J46688
ADLX65NLC3A 5A10J75111
ADLX65SLC2A 5A10J75113
ADLX65SDC2A 5A10J75114

SA10J20098 888015007
SA10J20135

45N0256 FRU45N0256 45N0255 FRU45N0255 36200282
45N0260 FRU45N0260 45N0259 FRU45N0259
45N0478 FRU45N0478 45N0477 FRU45N0477 36200283
45N0264 FRU45N0264 45N0263 FRU45N0263 36200284
45N0326 FRU45N0326 45N0325 FRU45N0325
45N0328 FRU45N0328 45N0327 FRU45N0327
45N0480 FRU45N0480 45N0479 FRU45N0479

Lenovo Essential E30 series
Lenovo Essential E31 series
Lenovo Essential E31-70 series
Lenovo Essential B5400 series
Lenovo Essential B50-30 (Model Name 80ES) series
Lenovo Essential B50-30 Touch series
Lenovo Essential B50-45 series
Lenovo Essential B50-70 series
Lenovo Ideapad 300-14isk series
Lenovo Ideapad 300-15isk series
Lenovo Ideapad 300s-14isk series
Lenovo Ideapad 305-14ibd series
Lenovo Ideapad 305-15ibd series
Lenovo Ideapad 500s-14isk series
Lenovo Ideapad B40-80 series
Lenovo Ideapad B50-30 series
Lenovo Ideapad B50-30 Touch series
Lenovo Ideapad B50-45 series
Lenovo Ideapad B50-70 series
Lenovo Ideapad B50-80 series
Lenovo Ideapad B51-80 series
Lenovo Ideapad B490 series
Lenovo Ideapad B490s series
Lenovo Ideapad E40-50 series
Lenovo Ideapad E40-70 series
Lenovo Ideapad E50-80 series
Lenovo Ideapad E41-80 series
Lenovo Ideapad E51-80 series
Lenovo Ideapad G40-80 series
Lenovo Ideapad G50-80 series
Lenovo Ideapad G400 series
Lenovo Ideapad G400s series
Lenovo Ideapad G400s Touch series
Lenovo Ideapad G405 series
Lenovo Ideapad G405s series
Lenovo Ideapad G410 series
Lenovo Ideapad G500 series
Lenovo Ideapad G500s series
Lenovo Ideapad G500s Touch series
Lenovo Ideapad G505 series
Lenovo Ideapad G505s series
Lenovo Ideapad G510 series
Lenovo Ideapad G700 series
Lenovo Ideapad G710 series
Lenovo Ideapad Flex 14 series
Lenovo Ideapad Flex 15 series
Lenovo Ideapad S410 Flex series
Lenovo Ideapad S410p Flex series
Lenovo Ideapad S510 Flex series
Lenovo Ideapad S510p Flex
Lenovo Ideapad S410 Touch series
Lenovo Ideapad S410p Touch series
Lenovo Ideapad S510 Touch series
Lenovo Ideapad S510p Touch series
Lenovo Ideapad S210 series
Lenovo Ideapad S500 series
Lenovo Ideapad S500 Touch series
Lenovo Ideapad S510p series
Lenovo Ideapad S41-35 series
Lenovo Ideapad S41-70 series
Lenovo Ideapad S41-75 series

Lenovo Thinkpad E570 series
Lenovo Thinkpad T540p series
Lenovo Ideapad U41-70 series
Lenovo Ideapad U330 Touch series
Lenovo Ideapad U330p series
Lenovo Ideapad U430 Touch series
Lenovo Ideapad U430p series
Lenovo Ideapad V110-14AST series
Lenovo Ideapad V110-15AST series
Lenovo Ideapad V110-15IKB series
Lenovo Ideapad V110-15ISK series

Lenovo Ideapad V310-14IKB series
Lenovo Ideapad V310-14ISK series
Lenovo Ideapad V310-15IKB series
Lenovo Ideapad V310-15ISK series

Lenovo Ideapad V510-14IKB series
Lenovo Ideapad V510-15IKB series
Lenovo Ideapad Z410 series
Lenovo Ideapad Z510 series
Lenovo Ideapad Z710 series
Lenovo Ideapad Z410 Touch series
Lenovo Ideapad Z510 Touch series
Lenovo Ideapad Z710 Touch series
Lenovo Ideapad Z50-70 Touch series
Lenovo Thinkpad Edge 13 series
Lenovo Thinkpad Edge E431 series
Lenovo Thinkpad Edge E431 (Type 6277)
Lenovo Thinkpad Edge E431 (Type 6886)
Lenovo Thinkpad Edge E531 series
Lenovo Thinkpad Edge E531 (Type 6885)
Lenovo Thinkpad Edge E540 series
Lenovo Thinkpad Edge E550 series
Lenovo Thinkpad Edge L440 series
Lenovo Thinkpad Edge L440 (Type 20AS)
Lenovo Thinkpad Edge L440 (Type 20AT)
Lenovo Thinkpad Edge L540 series
Lenovo Thinkpad Edge L540 (Type 20AU)
Lenovo Thinkpad Edge L540 (Type 20AV)
Lenovo Thinkpad S3 series
Lenovo Thinkpad S431 series
Lenovo Thinkpad S431 (Type 20AX)
Lenovo Thinkpad S431 (Type 20BA)
Lenovo Thinkpad S440 series
Lenovo Thinkpad S440 (Type 20AY)
Lenovo Thinkpad S440 (Type 20BB)
Lenovo Thinkpad S5 series
Lenovo Thinkpad S531 (Type 20B0)
Lenovo Thinkpad S531 (Type 6887)
Lenovo Thinkpad S540 series
Lenovo Thinkpad S540 (Type 20B3)
Lenovo Thinkpad T431 series
Lenovo Thinkpad T431s series
Lenovo Thinkpad T431s (Type 20AA)
Lenovo Thinkpad T431s (Type 20AC)
Lenovo Thinkpad T440 series
Lenovo Thinkpad T440 (Type 20B6)
Lenovo Thinkpad T440 (Type 20B7)
Lenovo Thinkpad T440p (Type 20AN)
Lenovo Thinkpad T440p (Type 20AW)
Lenovo Thinkpad T440s series
Lenovo Thinkpad T440s (Type 20AQ)
Lenovo Thinkpad T440s (Type 20AR)
Lenovo Thinkpad T450 series
Lenovo Thinkpad T540p (Dual Core) series
Lenovo Thinkpad T540p (Dual Core) (Type 20BE)
Lenovo Thinkpad T540p (Dual Core) (Type 20BF)
Lenovo Thinkpad T550 series
Lenovo Thinkpad W550 series
Lenovo Thinkpad Helix series
Lenovo Thinkpad Helix (Type 3697)
Lenovo Thinkpad Helix (Type 3698)
Lenovo Thinkpad Helix (Type 3700)
Lenovo Thinkpad Helix (Type 3701)
Lenovo Thinkpad Helix (Type 3702)
Lenovo Thinkpad X1 Carbon series
Lenovo Thinkpad X1 Carbon (Type 3443) series
Lenovo Thinkpad X1 Carbon (Type 3444) series
Lenovo Thinkpad X1 Carbon (Type 3446) series
Lenovo Thinkpad X1 Carbon (Type 3448) series
Lenovo Thinkpad X1 Carbon (Type 3462) series
Lenovo Thinkpad X1 Carbon (Type 3463) series
Lenovo Thinkpad X1 Hybrid (Type 1286) series
Lenovo Thinkpad X1 Hybrid (Type 1291) series
Lenovo Thinkpad X1 Hybrid (Type 1294) series
Lenovo Thinkpad X230s series
Lenovo Thinkpad X240 series
Lenovo Thinkpad X240 (Type 20AL)
Lenovo Thinkpad X240 (Type 20AM)
Lenovo Thinkpad X240s series
Lenovo Thinkpad X240s (Type 20AJ)
Lenovo Thinkpad X240s (Type 20AK)
Lenovo Thinkpad X250 series
Lenovo Yoga (Type 20C0) series
Lenovo Yoga (Type 20CD) series
Lenovo Yoga 11 series
Lenovo Yoga 11 - 2696 (MAS27SP)
Lenovo Yoga 11S series
Lenovo Yoga 13 series
Lenovo Yoga 13 - 2191 (MAM2SSP)
Lenovo Yoga 2 13 (80AY)
Lenovo Yoga 15 series
Lenovo Yoga 500-14acl series
Lenovo Yoga 500-14ibd series
Lenovo Yoga 500-14ihw series
Lenovo Yoga 500-14isk series
Lenovo Yoga 500-15ibd series
Lenovo Yoga 500-15ihw series
Lenovo Yoga 500-15isk series
Lenovo Flex2 (Mybo)
Lenovo Flex2 Pro-15 (Viper 5A) B/E/N (Freelander/Discovery/Boxster)
Lenovo Flex 3 15XX (Camaro5)
Lenovo Flex 3 Pro-1580
Lenovo Flex 3 1435
Lenovo Flex 3 1470
Lenovo Flex 3 1480
Lenovo Flex 3 1570
Lenovo Flex 3 1580 Ac adapter (cargador) original 65W
Lenovo Edge 2-1580 Tesla (S41)
Lenovo U41 series
Lenovo U31 series
Lenovo Ideapad 500S-15ISK (U51) Gx1 Zx1 Bx1 K/M41 (Macan)
Lenovo Thinkcentre M53 series Tiny (Thinclient)
Lenovo Ideapad G40 70 Notebook
Lenovo Ideapad G40 80
Lenovo Ideapad G50 80
Lenovo Ideapad G400s Notebook
Lenovo Ideapad G400s Touch Notebook
Lenovo Ideapad Z40-70
Lenovo Ideapad Z41-70
Lenovo Ideapad Z51-70
Lenovo Thinkpad E450
Lenovo Thinkpad E450c
Lenovo Thinkpad E455
Lenovo Thinkpad E460
Lenovo Thinkpad E465
Lenovo ThinkPad E470
Lenovo ThinkPad E475
Lenovo Thinkpad E550
Lenovo Thinkpad E550c
Lenovo Thinkpad E555
Lenovo Thinkpad E560
Lenovo Thinkpad E565
Lenovo Thinkpad E570
Lenovo Thinkpad E575
Lenovo Thinkpad Edge E431
Lenovo Thinkpad Edge E440
Lenovo Thinkpad Edge E531
Lenovo Thinkpad Edge E540
Lenovo Thinkpad L440
Lenovo Thinkpad L450
Lenovo Thinkpad L460
Lenovo Thinkpad L540
Lenovo Thinkpad Yoga P40
Lenovo Thinkpad P50s
Lenovo Thinkpad S431
Lenovo Thinkpad S440
Lenovo Thinkpad S531
Lenovo Thinkpad S540
Lenovo Thinkpad T440
Lenovo Thinkpad T440p
Lenovo Thinkpad T440s
Lenovo Thinkpad T450
Lenovo Thinkpad T450s
Lenovo Thinkpad T460
Lenovo Thinkpad T460s
Lenovo Thinkpad T540p
Lenovo Thinkpad T550
Lenovo Thinkpad T560
Lenovo Thinkpad W550s
Lenovo Thinkpad X1 Carbon 20BS 20BT
Lenovo Thinkpad X1 Carbon Type 20A7 20A8
Lenovo Thinkpad X1 Carbon Type 20FB 20FC
Lenovo Thinkpad X1 Carbon Type 34xx
Lenovo Thinkpad X1 Yoga Type 20FQ 20FR
Lenovo Thinkpad X240
Lenovo Thinkpad X250
Lenovo Thinkpad X260
65W Lenovo Thinkpad Yoga 14
Lenovo Thinkpad Yoga 14 20FY
Lenovo Thinkpad Yoga 15
Lenovo Thinkpad Yoga 260
Lenovo Thinkpad Yoga 460
Lenovo Yoga 2 13 Notebook
Quienes vieron este producto también miraron
CARGADOR HP PIN AZUL 65W PIN 4.5X3.0
$ 29.992
HP

CARGADOR HP PIN AZUL 65W PIN 4.5X3.0

CARGADOR HP 65W PIN FINO 4.8X1.7
$ 32.309
HP

CARGADOR HP 65W PIN FINO 4.8X1.7

CARGADOR LENOVO 65W 20V 3.25A PIN 5.5 X 2.5
$ 28.033
LENOVO

CARGADOR LENOVO 65W 20V 3.25A PIN 5.5 X 2.5

CARGADOR DELL 19.5V 4.62A 90W PIN 7.4X5.0
$ 33.794
DELL

CARGADOR DELL 19.5V 4.62A 90W PIN 7.4X5.0

CARGADOR DELL 65W 19.5V 3.34A PIN 4.5X3.0
$ 29.992
DELL

CARGADOR DELL 65W 19.5V 3.34A PIN 4.5X3.0




Tu Solucion en Computación :: Servicio Técnico Oficial de EXO - CX

Powered by GlobalBluePoint© ERP     -    Diseño by NetOne



Modo de Diseño: Parámetros Internos del Sitio Web
Ws_ID: 61651a50-c9fd-4d81-9c9e-3b5efa80712d
Page_Id: 29c74063-da20-462a-b1ba-68c69d737cd1
WSU_Id: -1
Parámetros de la Página: ;CARGADOR-LENOVO-YOGA-65W-20V-45A-PIN-USB-105-x-40;ITEM_ID=918;OR=;H=;CANT=;GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d;
Cart Guid: ff044bd2-b2f9-4305-8645-be25983ef575

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.51
* WebSite Designer *


Tiempo Total de Proceso: 1 Segundos.


Ultimos SQL Ejecutados:

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

Tiempo Consumido: 00:00:00.0079545

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

Tiempo Consumido: 00:00:00.0090013

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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 918 AND tc.comp_id=1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id

Tiempo Consumido: 00:00:00.0159336


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, CASE WHEN ti.item_website_desc<>'' THEN ti.item_website_desc ELSE ti.item_desc END [item_desc], ti.item_code, ti.item_annotation1 FROM tbitem ti WHERE ti.item_id = 918

Tiempo Consumido: 00:00:00.0009960


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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d'

Tiempo Consumido: 00:00:00.0009689


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


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, catg_webnote1 FROM tbCategoryGroup WHERE comp_id=1 ORDER by catg_desc asc

Tiempo Consumido: 00:00:00.0020253

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.CAT_ID, CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (TC.cat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.cat_desc, 1, 50) END [cat_WebSite_desc], CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.cat_desc), 1, 50) END [cat_WebSite_desc], 'ico-ferreteria.png' FROM TBCATEGORY TC INNER JOIN tbWebSiteII_CategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.prli_id = 1 WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id='1' AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' GROUP BY TC.CAT_ID, TC.cat_WebSite_NOTE1, TC.cat_WebSite_desc, TC.cat_desc, tc.cat_web_order ORDER BY tc.cat_web_order ASC, 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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029938

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029915

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029941

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029906

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029631

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0029963

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0019947

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0020007

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0019622

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0019943

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order 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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0019941

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 76 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0020240

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 82 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0020239

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='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 62 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC

Tiempo Consumido: 00:00:00.0040187


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, 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), ti.item_code, ti.item_vendorCode, ti.brand_id, ti.item_annotation1, REPLACE(ti.item_annotation2, Char(10), '«br/»'), SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, -- PRECIO ESTANDAR REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), convert(decimal(16,0), tpli.prli_price), -- MERCADOPAGO format(1.0760 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 1 CUOTA format(1.10 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 3 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- TARJETA 6 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- TARJETA 12 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- CUOTA EN 3 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/3), 'N', 'de-de'),',00',''), -- CUOTA EN 6 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/6), 'N', 'de-de'),',00',''), -- CUOTA EN 12 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/1), 'N', 'de-de'),',00',''), tc.curr_symbol, tbr.brand_desc, CASE WHEN tcat.cat_WebSite_desc <> '' THEN tcat.cat_WebSite_desc ELSE tcat.cat_desc END, --tcat.cat_desc, CASE WHEN tsub.subcat_WebSite_desc <> '' THEN tsub.subcat_WebSite_desc ELSE tsub.subcat_desc END, --tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], REPLACE(ti.item_code,'/','--'), CASE WHEN ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND (ti.item_isForAssociation='false' OR ti.item_annotation1 like '%@@GRISAR%' ) THEN 'True' ELSE 'False' END [grisar_boton], CASE WHEN (tpli.itst_cant «= 0) THEN 0 ELSE CAST(tpli.itst_cant AS INT) END, tpli.itst_LastAvailableInRelalculation, REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR], CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 END, (SELECT TOP 1 CASE WHEN ((tpli2.item_imageChecksum <> 0 and tpli2.item_imageChecksum is not NULL) or vwsiii.item_id IS NULL) THEN 'http://gbp83.globalbluepoint.com/pcq/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_800.jpg' ELSE vwsiii.imageCodeOrURL END AS item_img FROM tbitem tpli2 LEFT JOIN vwWebSiteII_ItemsImages AS vwsiii ON vwsiii.item_id = tpli2.item_id AND vwsiii.imageType » 2 WHERE tpli2.item_id = tpli.item_id) 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = 918

Tiempo Consumido: 00:00:00.0877607

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

Tiempo Consumido: 00:00:00.0059849


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

Tiempo Consumido: 00:00:00

GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpli.item__made, tpli.semaphoreValue, tpli.Item_id, SUBSTRING (tpli.item__WebSite_desc, 1, 50), SUBSTRING (tpli.item__annotation1, 1, 20), dbo.fnStrAllTrim(tpli.item__code) [item_code], tpli.item__vendorCode, tpli._brand_id, tpli.item__annotation2, SUBSTRING (tpli.item__annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, REPLACE(format(CAST(tpli.prli_price AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', tpli.currency_symbol, tpli._brand_desc, CASE WHEN i4c.item_id = tpli.item_id THEN '«a href=http://gbp83.globalbluepoint.com/pcq/COMPARA/X/GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(tpli.item__WebSite_desc), 1, 100), REPLACE(dbo.fnStrAllTrim(tpli.item__code),'/','--'), (SELECT TOP 1 CASE WHEN ((tpli2.item_imageChecksum <> 0 and tpli2.item_imageChecksum is not NULL) or vwsiii.item_id IS NULL) THEN 'http://gbp83.globalbluepoint.com/pcq/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_250.jpg' ELSE vwsiii.imageCodeOrURL END AS item_img FROM tbitem tpli2 LEFT JOIN vwWebSiteII_ItemsImages AS vwsiii ON vwsiii.item_id = tpli2.item_id AND vwsiii.imageType » 2 WHERE tpli2.item_id = tpli.item_id) FROM tbItemAdditional tia INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tia.comp_id AND tpli.item_id = tia.item_id_1 AND tpli.prli_id = 1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' INNER JOIN tbSubCategory tsub ON tsub.subcat_id = tpli.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = tpli.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = tpli.item_id and i4c.ws_guid = 'ff044bd2-b2f9-4305-8645-be25983ef575' LEFT JOIN tbItemTaxes tit ON tit.item_id=tpli.item_id AND tit.comp_id=tpli.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 tia.item_id = 918 ORDER BY tpli.prli_price ASC

Tiempo Consumido: 00:00:00.0568454


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

Tiempo Consumido: 00:00:00.0009690

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, REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), tc.curr_symbol, tpli._brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp83.globalbluepoint.com/pcq/COMPARA/X/GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d/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,'/','--'), (SELECT TOP 1 CASE WHEN vwsiii.imageCodeOrURL IS NULL THEN 'http://gbp83.globalbluepoint.com/pcq/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_250.jpg' ELSE vwsiii.imageCodeOrURL END AS item_img FROM tbitem tpli2 LEFT JOIN vwWebSiteII_ItemsImages AS vwsiii ON vwsiii.item_id = tpli2.item_id AND vwsiii.imageType » 2 WHERE tpli2.item_id = tpli.item_id), REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR], CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'ff044bd2-b2f9-4305-8645-be25983ef575' 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 <> '918' and ti.subcat_id = '3965'

Tiempo Consumido: 00:00:00.0718054