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

Ws_ID: 0f922c0d-5e5e-4694-ba90-7de9a0efec58

Page_Id: e524c091-a01b-463d-8279-155f00d9b1e8

WSU_Id: -1

Parámetros de la Página: ;GBPWSTID=0f922c0d-5e5e-4694-ba90-7de9a0efec58;

Cart Guid: de1376ac-d6d1-4b86-a495-57fb661a80e6

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:4 * prof_id:1 * stor_id:1 * item_id:-1 * camp_id:-1 *

Comp_Id: 1

Lang_Id: 2

18.191.239.123

* WebSite Designer *

Tiempo Total de Proceso: 4 Segundos.

Ultimos SQL Ejecutados:

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_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 = '0f922c0d-5e5e-4694-ba90-7de9a0efec58'

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_NOTE1, 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] 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 = 4 WHERE TC.CAT_WEB = 'TRUE' AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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.0156217

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156353

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order 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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order 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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order 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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156208

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156242

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156204

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' 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_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156255

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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 60 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order 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 = 4 AND tmp2.ws_id='0f922c0d-5e5e-4694-ba90-7de9a0efec58' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 63 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00

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 '%M%' Order By brand_desc

Tiempo Consumido: 00:00:00

GBP_LIST: SPOTS1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, URL, Note, Type, openMode FROM vwWebSiteII_Spots WHERE ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' and Type = 13 ORDER BY [Order]

Tiempo Consumido: 00:00:00

GBP_LIST: SPOTS1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' and Type = 18 ORDER BY [Order]

Tiempo Consumido: 00:00:00.0156230

GBP_LIST: BODY_NOV
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, 18), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation2, SUBSTRING ( ti.item_annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else format(tpli.prli_price, 'N', 'de-de') END [price], CASE WHEN tc.curr_symbol = 'ARS' THEN '$' ELSE tc.curr_symbol END, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid], CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked], CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp67.globalbluepoint.com/grapes/COMPARA/X/GBPWSTID=0f922c0d-5e5e-4694-ba90-7de9a0efec58/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,'/','--'), format(convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')), 'N', 'de-de'), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR] FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 4 AND tpli.ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'de1376ac-d6d1-4b86-a495-57fb661a80e6' 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 tbn.wssn_isNovelty = 1 AND ti.item_web = 'true'

Tiempo Consumido: 00:00:00.0937535

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], ti.item_annotation1, 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, ti.item_WebSite_leading, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') ELSE format(tpli.prli_price, 'N', 'de-de') END [price], --tc.curr_symbol, CASE WHEN tc.curr_symbol = 'ARS' THEN '$' ELSE tc.curr_symbol END, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid], CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked], CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp67.globalbluepoint.com/grapes/COMPARA/X/GBPWSTID=0f922c0d-5e5e-4694-ba90-7de9a0efec58/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,'/','--'), format(convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')), 'N', 'de-de'), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR] FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 4 AND tpli.ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'de1376ac-d6d1-4b86-a495-57fb661a80e6' 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 tbn.wssn_is4Sale = 1 and ti.item_web = 1

Tiempo Consumido: 00:00:00.0781253

GBP_LIST: SPOTS1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' and Type = 19 ORDER BY [Order]

Tiempo Consumido: 00:00:00.0156263

GBP_LIST: SPOTS1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' and Type = 2 ORDER BY [Order]

Tiempo Consumido: 00:00:00.0156314

GBP_LIST: BODY_NOV
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.wsco_id, tc.wsco_title, tc.wsco_subTitle, tc.wsco_content, wsco_searchWords, tcoc.wscoc_id FROM tbWebSiteII_Content tc INNER JOIN tbWebSiteII_ContentClass tcoc ON tc.comp_id = tcoc.comp_id AND tc.wscoc_id = tcoc.wscoc_id AND tcoc.ws_id = '0f922c0d-5e5e-4694-ba90-7de9a0efec58' WHERE tc.comp_id = 1 AND (tcoc.wscoc_id=1) ORDER BY tc.wsco_order desc

Tiempo Consumido: 00:00:00

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 '%S%' Order By brand_desc

Tiempo Consumido: 00:00:00

Novedades

Adaptador Apple Thunderbolt 3 USB-C a Thunderbolt

Adaptador 2.5" SATA a Dual M2 2280 SATA QNAP QDA-A

Adaptador 2.5" U2 a M2 2280 NVME QNAP QDA-UMP

Nas 4 Bahias Sobremesa QNAP TS-464 4GB RAM 2.5 GbE

Case Expansion 4 Slot M.2 NVMe con SoftRAID OWC Ex

Ofertas

STJJ5000400 Disco LaCie Rugged MINI 5TB - USB 3.0

NOTICIAS

Patch Cord fibra óptica - Cables de fibra óptica

Adaptadores Apple Thunderbol 3 a Thunderbolt 2

Seagate Ironwolf - Seagate Exos