Tiempo Total de Proceso: 1 Segundos.
Ultimos SQL Ejecutados:
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
CASE WHEN cat_WebSite_NOTE1 <> '' THEN
cat_WebSite_NOTE1
ELSE
'pixel.png'
END [cat_WebSite_NOTE1] ,
CASE WHEN cat_WebSite_desc <> '' THEN
SUBSTRING (cat_WebSite_desc, 1, 100)
ELSE
SUBSTRING (cat_desc, 1, 100)
END [cat_WebSite_desc]
FROM tbCategory
WHERE cat_id = ''
Tiempo Consumido: 00:00:00
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
SUBSTRING (subcataux_desc, 1, 100) [subcataux_desc]
FROM TBSUBCATEGORYAUX
WHERE subcataux_id = ''
Tiempo Consumido: 00:00:00
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
CASE WHEN subcat_WebSite_desc <> '' THEN
SUBSTRING (subcat_WebSite_desc, 1, 100)
ELSE
SUBSTRING (subcat_desc, 1, 100)
END [subcat_WebSite_desc]
FROM tbSubCategory
WHERE subcat_id = '59'
Tiempo Consumido: 00:00:00.0156249
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 TSCA.catg_id, TSCA.catg_desc, TSCA.catg_note2 FROM TBCATEGORYGROUP TSCA WHERE tsca.comp_id='1' ORDER BY TSCA.catg_desc ASC
Tiempo Consumido: 00:00:00
GBP_LIST: CAT2
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT TSCA.catg_id, TSCA.catg_desc FROM TBCATEGORYGROUP TSCA WHERE tsca.comp_id='1' ORDER BY TSCA.catg_desc ASC
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 2 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 1 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00.0156240
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 3 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 7 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 4 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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 [subcat_WebSite_desc]
FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 5 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00
GBP_LIST: CAT1
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] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' ORDER BY tc.cat_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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 81
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 82
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0155912
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 83
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156576
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 85
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0155937
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 69
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156245
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 3
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 12
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156254
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156229
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 86
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 48
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 62
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 4
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 6
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156239
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 10
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 14
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156230
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 13
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156283
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 49
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156288
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 68
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156542
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 71
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156210
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 51
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156332
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 15
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156162
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 53
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156268
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 19
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0155957
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 63
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156259
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
FROM tbSubCategory tc
INNER JOIN vwWebSiteII_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 = 26
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 17
ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC
Tiempo Consumido: 00:00:00.0156254
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
IF (ISNUMERIC ('') <> 1 OR '' = '-1' )
BEGIN
SELECT 'Todas'
END
ELSE BEGIN
SELECT cat_desc FROM tbCategory WHERE cat_id=''
END
Tiempo Consumido: 00:00:00
GBP_LIST: LISTCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @brand_id AS INT
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
-- TOMA LAs VARIABLES DE LA URL
SET @busqueda = ''
IF (ISNUMERIC ('') =1)
BEGIN
SET @brand_id = CAST('' AS INT)
END ELSE BEGIN
SET @brand_id = -1
END
IF (ISNUMERIC ('59') =1)
BEGIN
SET @scat_id = CAST('59' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @sca_id = CAST('' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @cat_id = CAST('' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tbCategory.cat_desc AS s, tbCategory.cat_id AS cat_id, COUNT(tbItem.item_id) AS Cantidad, @scat_id AS subCategoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA
FROM tbItem
INNER JOIN tbWebSiteII_ItemsData
ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id
AND tbItem.item_id = tbWebSiteII_ItemsData.item_id
INNER JOIN tbCategory
ON tbItem.comp_id = tbCategory.comp_id
AND tbItem.cat_id = tbCategory.cat_id
WHERE 1=1
--AND tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0
AND tbWebSiteII_ItemsData.prli_id = 26
AND tbItem.item_web = 1
AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4'
AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND 1 <> 1 ))
AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND ((tbItem.item_desc like '%' + @busqueda + '%') OR
(tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR
(tbItem.item_annotation1 like '%' + @busqueda + '%') OR
(tbItem.item_annotation2 like '%' + @busqueda + '%') OR
(tbItem.item_descHTML like '%' + @busqueda + '%') OR
(tbItem.item_vendorCode like '%' + @busqueda + '%') OR
(tbItem.item_Code like '%' + @busqueda + '%'))))
GROUP BY tbCategory.cat_desc, tbCategory.cat_id, tbCategory.cat_web_order
Tiempo Consumido: 00:00:00.0468762
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
IF (ISNUMERIC ('59') <> 1 OR '59' = '-1')
BEGIN
SELECT 'Todas'
END
ELSE BEGIN
SELECT subcat_desc FROM tbSubCategory WHERE subcat_id= '59'
END
Tiempo Consumido: 00:00:00
GBP_LIST: LISTSCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @brand_id AS INT
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
-- TOMA LAs VARIABLES DE LA URL
SET @busqueda = ''
IF (ISNUMERIC ('') =1)
BEGIN
SET @brand_id = CAST('' AS INT)
END ELSE BEGIN
SET @brand_id = -1
END
IF (ISNUMERIC ('59') =1)
BEGIN
SET @scat_id = CAST('59' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @sca_id = CAST('' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @cat_id = CAST('' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tbSubCategory.subcat_desc AS s, tbSubCategory.subcat_id AS subcat_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA
FROM tbItem
INNER JOIN tbWebSiteII_ItemsData
ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id
AND tbItem.item_id = tbWebSiteII_ItemsData.item_id
INNER JOIN tbSubCategory
ON tbItem.comp_id = tbSubCategory.comp_id
AND tbItem.comp_id = tbSubCategory.comp_id
AND tbItem.cat_id = tbSubCategory.cat_id
AND tbItem.cat_id = tbSubCategory.cat_id
AND tbItem.subcat_id = tbSubCategory.subcat_id
AND tbItem.subcat_id = tbSubCategory.subcat_id
WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0
AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4'
AND tbWebSiteII_ItemsData.prli_id = 26
AND tbItem.item_web = 1
AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id ))
AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND 1 <> 1 ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND ((tbItem.item_desc like '%' + @busqueda + '%') OR
(tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR
(tbItem.item_annotation1 like '%' + @busqueda + '%') OR
(tbItem.item_annotation2 like '%' + @busqueda + '%') OR
(tbItem.item_descHTML like '%' + @busqueda + '%') OR
(tbItem.item_vendorCode like '%' + @busqueda + '%') OR
(tbItem.item_Code like '%' + @busqueda + '%'))))
GROUP BY tbSubCategory.subcat_desc, tbSubCategory.subcat_id, tbSubCategory.subcat_web_order
Tiempo Consumido: 00:00:00.0468738
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
IF (ISNUMERIC ('') <> 1 OR '' = '-1')
BEGIN
SELECT 'Todas'
END
ELSE BEGIN
SELECT brand_desc FROM tbBrand WHERE brand_id= ''
END
Tiempo Consumido: 00:00:00
GBP_LIST: LISTSMARCA
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @brand_id AS INT
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
-- TOMA LAs VARIABLES DE LA URL
SET @busqueda = ''
IF (ISNUMERIC ('') =1)
BEGIN
SET @brand_id = CAST('' AS INT)
END ELSE BEGIN
SET @brand_id = -1
END
IF (ISNUMERIC ('59') =1)
BEGIN
SET @scat_id = CAST('59' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @sca_id = CAST('' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @cat_id = CAST('' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tbBrand.brand_desc, tbBrand.brand_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id as Categoria, @scat_id AS Subcategoria, @sca_id AS SubcategoriaAux, @busqueda as BUSQUEDA
FROM tbItem
INNER JOIN tbBrand
ON tbItem.comp_id = tbBrand.comp_id
AND tbItem.brand_id = tbBrand.brand_id
INNER JOIN tbWebSiteII_ItemsData
ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id
AND tbItem.item_id = tbWebSiteII_ItemsData.item_id
WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0
AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4'
AND tbWebSiteII_ItemsData.prli_id = 26
AND tbItem.item_web = 1
AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id ))
AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND 1 <> 1 ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND ((tbItem.item_desc like '%' + @busqueda + '%') OR
(tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR
(tbItem.item_annotation1 like '%' + @busqueda + '%') OR
(tbItem.item_annotation2 like '%' + @busqueda + '%') OR
(tbItem.item_descHTML like '%' + @busqueda + '%') OR
(tbItem.item_vendorCode like '%' + @busqueda + '%') OR
(tbItem.item_Code like '%' + @busqueda + '%'))))
GROUP BY tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC
Tiempo Consumido: 00:00:00.0625012
GBP_LIST: SPOTS1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT imageName,
CASE WHEN URL <> '' THEN ' href="' + URL + '" '
ELSE ''
END,
openMode
FROM vwWebSiteII_Spots
WHERE ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' and Type = 8
Tiempo Consumido: 00:00:00.0156254
GBP_LIST: LISTA_ARTICULOS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @order as int
DECLARE @brand_id AS INT
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
-- TOMA LAs VARIABLES DE LA URL
SET @busqueda = ''
SET @busqueda = replace(@busqueda, ' ','%') -- Agrega % a los espacios intermedios.
IF (ISNUMERIC ('1') =1)
BEGIN
SET @order = CAST('1' AS INT)
END ELSE BEGIN
SET @order = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @brand_id = CAST('' AS INT)
END ELSE BEGIN
SET @brand_id = -1
END
IF (ISNUMERIC ('59') =1)
BEGIN
SET @scat_id = CAST('59' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @sca_id = CAST('' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('') =1)
BEGIN
SET @cat_id = CAST('' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT
ti.item_made,
tpli.semaphoreValue,
ti.Item_id,
CASE WHEN ti.item_website_desc<>'' THEN
SUBSTRING (ti.item_website_desc, 1, 100)
ELSE
SUBSTRING (ti.item_desc, 1, 100)
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),
ti.item_newness,
ti.item_liquidation,
isnull(item_WebSite_vendorPage,'VACIO'),
convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) [price],
tc.curr_symbol,
tbr.brand_desc,
CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid],
CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked],
CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp47.globalbluepoint.com/lef/COMPARA/X/GBPWSTID=0d3bc506-4ccc-4b43-b8a9-8a22a89680c4/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked],
convert (decimal(16,2), ttn.tax_percentage) [IVA]
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 = 26 AND tpli.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4'
INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id
INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id
LEFT JOIN tbWebSiteII_ItemRates itr ON itr.comp_id = ti.comp_id AND itr.item_id = ti.item_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c ON i4c.item_id = ti.item_id AND i4c.ws_guid = 'caa4703e-8794-4353-b3b4-60345020ae27'
LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4'
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 tpli.itst_LastAvailableInRelalculation » 0
AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND ti.cat_id=@cat_id ))
AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND ti.subcat_id=@scat_id ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND ti.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND ti.brand_id = @brand_id ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND ((ti.item_desc like '%' + @busqueda + '%') OR
(ti.item_WebSite_desc like '%' + @busqueda + '%') OR
(ti.item_annotation1 like '%' + @busqueda + '%') OR
(ti.item_annotation2 like '%' + @busqueda + '%') OR
(ti.item_descHTML like '%' + @busqueda + '%') OR
(ti.item_vendorCode like '%' + @busqueda + '%') OR
(ti.item_Code like '%' + @busqueda + '%'))))
Group by ti.item_made,tpli.semaphoreValue, ti.item_id,item_WebSite_desc,item_desc,
item_code,item_desc,item_vendorCode,ti.brand_id,tbr.brand_desc,item_annotation1,item_annotation2,
item_newness,item_liquidation,item_WebSite_vendorPage,prli_price,curr_symbol,tpli.itst_cant,ti.comp_id,i4c.item_id,ttn.tax_percentage
ORDER BY
CASE WHEN @order=1 THEN tpli.prli_price END ASC,
CASE WHEN @order=2 THEN tpli.prli_price END DESC,
CASE WHEN @order=3 THEN ti.item_WebSite_desc END ASC,
CASE WHEN @order=4 THEN ti.item_WebSite_desc END DESC,
CASE WHEN @order=5 THEN tpli.semaphoreValue END DESC,
tpli.itst_cant DESC
Tiempo Consumido: 00:00:00.0937817
|
info@matroxdigital.com.ar
Lunes a Viernes
8.30 a 12.30hs
16 a 20hs /
Sabado
9 A 13hs
