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 = 2377 and tc.comp_id=1
GROUP BY tc.Size_code, tc.Size_desc
Tiempo Consumido: 00:00:00.0156210
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 = 2377 and tc.comp_id=1
GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code
Tiempo Consumido: 00:00:00
GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
tc.itemID4SizeColor,
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 = 2377 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.0155930
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 = 2377
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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d'
Tiempo Consumido: 00:00:00
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT cust_name FROM tbCustomer WHERE cust_id = -1
Tiempo Consumido: 00:00:00
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False'))
Tiempo Consumido: 00:00:00
GBP_LIST: SCATAUX
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT catg_id, catg_desc, catg_webnote1
FROM tbCategoryGroup
WHERE comp_id=1
ORDER by catg_desc asc
Tiempo Consumido: 00:00:00
GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
TC.CAT_ID,
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
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
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
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.0156214
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
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
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
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
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
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
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.0156490
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
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
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.0155928
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
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.1 * tpli.prli_price), 'N', 'de-de'),',00',''),
-- TARJETA 6 CUOTAS
REPLACE(format(convert(decimal(16,0), 1.2 * 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.1 * tpli.prli_price/3), 'N', 'de-de'),',00',''),
-- CUOTA EN 6
REPLACE(format(convert(decimal(16,0), 1.2 * 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 = 2377
Tiempo Consumido: 00:00:00.0625119
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 = 2377
Tiempo Consumido: 00:00:00.0156216
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 = 2377
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 = 'B88778D0-E49F-41DF-B848-963DB6CCA638'
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 = 2377
ORDER BY TPLI.PRLI_PRICE ASC
Tiempo Consumido: 00:00:00.0624842
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 = 2377
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,
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 = 'B88778D0-E49F-41DF-B848-963DB6CCA638'
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 <> '2377' AND TI.SUBCAT_ID = '3821'
Tiempo Consumido: 00:00:00.0937258
|
Retirá en nuestro local
Destacado
