Tiempo Total de Proceso: 2 Segundos.
Ultimos SQL Ejecutados:
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged
FROM tbWebSiteII_Names
WHERE comp_id=18 AND ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
Tiempo Consumido: 00:00:00.0010011
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.0009987
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT convert (decimal(16,2), dbo.fnGetExchange2('18', 1, 2,1, 0, 0, 0, 'False'))
Tiempo Consumido: 00:00:00.0010011
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],
dbo.fnSTRRemoveSpecialCharacters(TC.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 = 31
WHERE TC.CAT_WEB = 'TRUE'
GROUP BY TC.CAT_ID, 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.0080079
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0060061
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0080083
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 61
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.0070068
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0080078
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0070068
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 86
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.0060061
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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.0080079
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 = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0060061
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_note2 like '%M%' Order By brand_desc
Tiempo Consumido: 00:00:00.0050055
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 = 'f1b68b65-c10e-4126-b085-5d74e97875e6' and Type = 13
ORDER BY [Order]
Tiempo Consumido: 00:00:00.0050045
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 = 'f1b68b65-c10e-4126-b085-5d74e97875e6' and Type = 14
ORDER BY [Order]
Tiempo Consumido: 00:00:00.0050046
GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
tpli.semaphoreValue,
tpli.item_id,
CASE WHEN tpli.item__annotation2 <> '' THEN
tpli.item__annotation2
ELSE
SUBSTRING (tpli.item__WebSite_desc, 1, 100)
END,
tpli.item__annotation1,
tpli.item__code,
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',
REPLACE(format(CAST((tpli.prli_price * 1.25) / 6 AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format',
CASE WHEN tpli.currency_symbol = 'ARS' THEN '$' ELSE tpli.currency_symbol END,
tpli._brand_desc,
convert (decimal(16,2), ttn.tax_percentage) [IVA],
RTRIM(tpli.item__WebSite_desc4SEO),
replace(tpli.item__code,'/','--'),
'http://gbp47.globalbluepoint.com/irion/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli.item__code) + '_400.jpg',
tpli.itst_cant,
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,
REPLACE(format(CAST((tpli.strikeThroughPrice - tpli.prli_price) AS DECIMAL), 'N', 'de-de'),',00','') AS 'Numeric Format',
CASE WHEN tif.wsif_id IS NULL THEN '' WHEN tif.wsif_isActive = 'True' THEN 'avisostockon' ELSE '' END,
(SELECT CASE WHEN EXISTS (SELECT 1 FROM tbItemImages tii WHERE tii.item_id = tpli.item_id) THEN 'SI' ELSE 'NO' END AS tiene_imagen)
FROM tbWebSiteII_ItemsData tpli
INNER JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
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
LEFT JOIN tbWebSiteII_Items_Favorites tif ON tif.comp_id = tpli.comp_id AND tif.ws_id = tpli.ws_id AND tif.item_id = tpli.item_id AND tif.cust_id = -1
WHERE tbn.wssn_is4Sale = 1 AND tpli.prli_id = 31 AND tpli.ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
Tiempo Consumido: 00:00:00.0129816
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 = 'f1b68b65-c10e-4126-b085-5d74e97875e6' and Type = 18
ORDER BY [Order]
Tiempo Consumido: 00:00:00.0050045
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 '%VIENTOS2025%' Order By brand_desc
Tiempo Consumido: 00:00:00.0060358
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 = 'f1b68b65-c10e-4126-b085-5d74e97875e6' and Type = 1
ORDER BY [Order]
Tiempo Consumido: 00:00:00.0060066
GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
tpli.semaphoreValue,
tpli.item_id,
CASE WHEN tpli.item__annotation2 <> '' THEN
tpli.item__annotation2
ELSE
SUBSTRING (tpli.item__WebSite_desc, 1, 100)
END,
tpli.item__annotation1,
tpli.item__code,
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',
REPLACE(format(CAST((tpli.prli_price * 1.25) / 6 AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format',
CASE WHEN tpli.currency_symbol = 'ARS' THEN '$' ELSE tpli.currency_symbol END,
tpli._brand_desc,
convert (decimal(16,2), ttn.tax_percentage) [IVA],
RTRIM(tpli.item__WebSite_desc4SEO),
replace(tpli.item__code,'/','--'),
'http://gbp47.globalbluepoint.com/irion/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli.item__code) + '_400.jpg',
tpli.itst_cant,
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],
REPLACE(format(CAST((tpli.strikeThroughPrice - tpli.prli_price) AS DECIMAL), 'N', 'de-de'),',00','') AS 'Numeric Format',
CASE WHEN tif.wsif_id IS NULL THEN '' WHEN tif.wsif_isActive = 'True' THEN 'avisostockon' ELSE '' END
FROM tbWebSiteII_ItemsData tpli
INNER JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
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
LEFT JOIN tbWebSiteII_Items_Favorites tif ON tif.comp_id = tpli.comp_id AND tif.ws_id = tpli.ws_id AND tif.item_id = tpli.item_id AND tif.cust_id = -1
WHERE tbn.wssn_isNovelty = 1 AND tpli.prli_id = 31 AND tpli.ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
Tiempo Consumido: 00:00:00.0140139
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),
item_WebSite_vendorPage,
REPLACE(format(CAST(tpli.prli_price AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format',
REPLACE(format(CAST((tpli.prli_price * 1.25) / 6 AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format',
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://gbp47.globalbluepoint.com/irion/COMPARA/X/GBPWSTID=f1b68b65-c10e-4126-b085-5d74e97875e6/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,'/','--'),
'http://gbp47.globalbluepoint.com/irion/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli.item__code) + '_400.jpg',
tpli.itst_cant,
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] ,
REPLACE(format(CAST((tpli.strikeThroughPrice - tpli.prli_price) AS DECIMAL), 'N', 'de-de'),',00','') AS 'Numeric Format',
CASE WHEN tif.wsif_id IS NULL THEN '' WHEN tif.wsif_isActive = 'True' THEN 'avisostockon' ELSE '' 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 = 31 AND tpli.ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'
INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id
INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '8bdb902e-fb45-48ba-babf-e9ca527844b3'
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
LEFT JOIN tbWebSiteII_Items_Favorites tif ON tif.comp_id = tpli.comp_id AND tif.ws_id = tpli.ws_id AND tif.item_id = tpli.item_id AND tif.cust_id = -1
WHERE ti.item_outlet = 'true' AND ti.item_web = 'true'
Tiempo Consumido: 00:00:00.1021330
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.0060339
|
Olvide mi clave
Registrarme
Tarjetas de Crédito 
Transferencia Bancaria
Retiro en nuestro local
Envíos a todo el país
