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 = 3967 and tc.comp_id=1
GROUP BY tc.Size_code, tc.Size_desc
Tiempo Consumido: 00:00:00.0156426
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 = 3967 and tc.comp_id=1
GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code
Tiempo Consumido: 00:00:00.0156417
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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
INNER JOIN tbsysCurrency c
ON c.curr_id = tpli.curr_id
WHERE tc.item_id = 3967 AND tc.comp_id=1 AND tpli.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id
Tiempo Consumido: 00:00:00.0156271
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],
dbo.fnStrAllTrim(ti.item_code) [item_code],
ti.item_annotation1
FROM tbitem ti
WHERE ti.item_id = 3967
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_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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
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 = 1
WHERE TC.CAT_WEB = 'TRUE' AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156273
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156260
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 71
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.0156262
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156347
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='2565b354-0d67-4df4-9ca2-153c2eb68ade'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 111
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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 117
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 = 1 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade'
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_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_note2 = 'S' OR brand_note2 = 's' Order By brand_desc
Tiempo Consumido: 00:00:00
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),
dbo.fnStrAllTrim(ti.item_code) [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 venta
format(tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio Lista
format(1.28 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio 1 cuota
format(1.07 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio 3 cuotas
format(1.18 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio 3 cuotas x cuota
format(1.18 * tpli.prli_price / 3, 'N', 'de-de') AS 'Numeric Format',
--precio 6 cuotas
format(1.28 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio 6 cuotas x cuota
format(1.28 * tpli.prli_price / 6, 'N', 'de-de') AS 'Numeric Format',
--precio 12 cuotas x cuota
format(1.50 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
--precio 12 cuotas x cuota
format(1.50 * tpli.prli_price / 12, 'N', 'de-de') AS 'Numeric Format',
tc.curr_symbol,
tbr.brand_desc,
tcat.cat_desc,
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],
ti.item_outlet,
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]
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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
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 = 3967
Tiempo Consumido: 00:00:00.0312484
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 = 3967
Tiempo Consumido: 00:00:00.0156271
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 = 3967
Tiempo Consumido: 00:00:00
GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
ti.item_made,
tpli.semaphoreValue,
ti.Item_id,
CASE WHEN ti.item_website_desc<>'' THEN
SUBSTRING (ti.item_website_desc, 1, 50)
ELSE
SUBSTRING (ti.item_desc, 1, 50)
END [item_desc],
SUBSTRING (ti.item_annotation1, 1, 20),
dbo.fnStrAllTrim(ti.item_code) [item_code],
ti.item_vendorCode,
ti.brand_id,
ti.item_annotation2,
SUBSTRING (ti.item_annotation2, 1, 90),
tbn.wssn_isNovelty,
tbn.wssn_is4Sale,
item_WebSite_vendorPage,
/*CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price],*/
format(tpli.prli_price, 'N', 'de-de') AS 'Numeric Format',
tc.curr_symbol,
tbr.brand_desc,
CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp61.globalbluepoint.com/Tecnopolis/COMPARA/X/GBPWSTID=2565b354-0d67-4df4-9ca2-153c2eb68ade/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(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]
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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '6e21a275-9569-4484-a943-f4c39b1cc0f6'
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 <> '3967' and ti.subcat_id = '3916'
Tiempo Consumido: 00:00:00.0312539
|
Stock online: CON STOCK
Obtené un crédito sólo con tu DNI. Consultanos!
Envíos a todo el país.
