Tiempo Total de Proceso: 0 Segundos.
Ultimos SQL Ejecutados:
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tc.wsco_id,
tc.wsco_title,
REPLACE(REPLACE(tc.wsco_title,' ','-'),':',''),
tc.wsco_subTitle, tc.wsco_content, tc.wsco_cd, wsco_searchWords
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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE tc.comp_id = 1 AND tcoc.wscoc_id=1 AND tc.wsco_id = 21
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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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
FROM TBCATEGORYGROUP
WHERE comp_id=1 AND catg_webNOTE1 <> 'N'
ORDER BY CAST(catg_webNOTE1 AS INT) 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,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='1' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 49
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='2' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 136
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0155873
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 65
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 148
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 125
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 67
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 151
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 132
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='3' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 100
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 77
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='5' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='6' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 127
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156226
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 85
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156195
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 89
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 147
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='12' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 104
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 109
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 105
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 130
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 107
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 106
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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.cat_id,
TC.cat_WebSite_desc,
dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc)
FROM tbWebSiteII_CategoryData TC
WHERE TC.catg_id='10' AND TC.prli_id = 1
GROUP BY TC.cat_id, TC.cat_WebSite_desc
ORDER BY 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 131
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 97
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0155865
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 90
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 145
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156203
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
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_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 123
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156218
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 126
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc 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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 137
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156521
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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 116
GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order
ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00
GBP_REPLACE:
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,
tc.wsco_cd,
wsco_searchWords
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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'
WHERE tc.comp_id = 1 AND tcoc.wscoc_id=1 AND tc.wsco_id = 21
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 '%SMAX%' and brand_note2 like '%SMAX%' Order By brand_desc
Tiempo Consumido: 00:00:00.0155931
|
