-
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1828 0.00 -1 [empty string] [empty string] [empty string] [empty string] 7825 5276 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 5276 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1829 0.00 -8 [empty string] [empty string] [empty string] [empty string] 7846 5289 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 5289 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1807 0.00 1536 [empty string] [empty string] [empty string] [empty string] 8570 6025 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6025 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 2342 0.00 349 [empty string] [empty string] [empty string] [empty string] 10311 7414 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 7414 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1929 0.00 630 [empty string] [empty string] [empty string] [empty string] 8630 6070 CACHED false EXECUTIONTIME 0 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6070 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1930 0.00 -20 [empty string] [empty string] [empty string] [empty string] 8631 6071 CACHED false EXECUTIONTIME 0 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6071 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1888 0.00 525 [empty string] [empty string] [empty string] [empty string] 8580 6035 CACHED false EXECUTIONTIME 4 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6035 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1804 0.00 606 [empty string] [empty string] [empty string] [empty string] 8581 6036 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6036 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1931 0.00 643 [empty string] [empty string] [empty string] [empty string] 8629 6069 CACHED false EXECUTIONTIME 0 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6069 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1891 0.00 542 [empty string] [empty string] [empty string] [empty string] 8582 6037 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6037 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1780 0.00 -40 [empty string] [empty string] [empty string] [empty string] 8563 6013 CACHED false EXECUTIONTIME 0 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6013 2 3 -
query RESULTSET query ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID ATTR1_ORDER ATTR2 ATTR2_ENTRY_ID ATTR2_ORDER FAM FAM_HEX HEX LIST_PRICE ORIGATTR1 ORIGATTR2 ORIGSIZ PICTURE_ID PRICE QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SIZY SKU_ID STYLE_ID 1 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0.00 [empty string] [empty string] [empty string] 1847 0.00 -86 [empty string] [empty string] [empty string] [empty string] 8606 6048 CACHED false EXECUTIONTIME 1 SQL SELECT DISTINCT a.sku_id , max(a.style_id) as style_id , max(d.picture_id) as picture_id , sum(c.qoh+c.qc) as qoh , max(a.scale_entry_id) as scale_entry_id , max(ba.siz) as origSiz , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as sizy , max(CASE WHEN ba.siz_alias IS NULL OR RTRIM(LTRIM(ba.siz_alias)) = '' THEN ba.siz ELSE ba.siz_alias END) as siz , max(ba.size_order) as size_order , max(bb.attr1) as origAttr1 , max(bb.attr1_alias) as attr1_alias , max(CASE WHEN bb.attr1_alias IS NULL OR RTRIM(LTRIM(bb.attr1_alias)) = '' THEN bb.attr1 ELSE bb.attr1_alias END) as attr1 , max(bb.attr1_entry_id) as attr1_entry_id , max(bb.attr1_order) as attr1_order , max(bba.attr1_hex) as hex , max(bbb.attr1_fam) as fam , max(bbb.fam_hex) as fam_hex , max(bc.attr2) as origAttr2 , max(bc.attr2) as attr2 , max(bc.attr2_order) as attr2_order , max(bc.attr2_entry_id) as attr2_entry_id , 0.00 as list_price , 0.00 as price FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries ba WITH (NOLOCK) ON (a.scale_entry_id = ba.scale_entry_id) LEFT JOIN tb_attr1_entries bb WITH (NOLOCK) ON (a.attr1_entry_id = bb.attr1_entry_id) LEFT JOIN tb_attr1_hexes bba WITH (NOLOCK) ON (bb.attr1=bba.attr1) LEFT JOIN tb_attr1_families bbb WITH (NOLOCK) ON (bba.attr1_fam_id = bbb.attr1_fam_id) LEFT JOIN tb_attr2_entries bc WITH (NOLOCK) ON (a.attr2_entry_id = bc.attr2_entry_id) INNER JOIN tb_sku_buckets c WITH (NOLOCK) ON (a.sku_id = c.sku_id) INNER JOIN tb_styles d WITH (NOLOCK) ON (a.style_id = d.style_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE a.style_id IN (?) --AND isNull(ba.siz_alias,'') NOT IN ('NO SHOW','NOSHOW') --AND isNull(bb.attr1_alias,'') NOT IN ('NO SHOW','NOSHOW') AND isNull(a.sell_web,'Y') <> 'N' AND c.store_id = ? GROUP BY a.sku_id SQLPARAMETERS array 1 6048 2 3
