-
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] T0 1816 0.00 97 3898 T0 [empty string] T0 8529 5986 2 [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] T1 1816 0.00 69 3899 T1 [empty string] T1 8530 5986 3 [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] T2 1816 0.00 195 3900 T2 [empty string] T2 8531 5986 4 [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] T4 1816 0.00 201 3901 T4 [empty string] T4 8532 5986 5 [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] 6 1816 0.00 202 3902 6 [empty string] 6 8533 5986 6 [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] 8 1816 0.00 202 3903 8 [empty string] 8 8534 5986 7 [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] 10 1816 0.00 119 3904 10 Inch [empty string] 10 Inch 8535 5986 8 [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] 12 1816 0.00 24 3905 12 [empty string] 12 8536 5986 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 5986 2 3
