-
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] MED 358 0.00 2830 3868 MED [empty string] MED 1855 827 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] SML 358 0.00 4923 3869 SML [empty string] SML 1856 827 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] LRG 358 0.00 338 3870 LRG [empty string] LRG 1857 827 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] XL 358 0.00 -432 3871 XL [empty string] XL 1858 827 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] 2XL 358 0.00 -685 3872 2XL [empty string] 2XL 1859 827 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] 3XL 358 0.00 51 3873 3XL [empty string] 3XL 1860 827 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] 2 358 0.00 -145 3874 2 [empty string] 2 1861 827 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] 4 358 0.00 -144 3875 4 [empty string] 4 1862 827 9 [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 358 0.00 -288 3876 6 [empty string] 6 1863 827 10 [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 358 0.00 -406 3877 8 [empty string] 8 1864 827 11 [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 358 0.00 -20 3878 10 Inch [empty string] 10 Inch 1865 827 12 [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 358 0.00 -21 3879 12 [empty string] 12 1866 827 13 [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] 14 358 0.00 -142 3880 14 [empty string] 14 1867 827 14 [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] 16 358 0.00 -2 3881 16 [empty string] 16 1868 827 15 [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] 4XL 358 0.00 153 3882 4XL [empty string] 4XL 7546 827 16 [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] 5XL 358 0.00 1021 3883 5XL [empty string] 5XL 7547 827 17 [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] 6XL 358 0.00 619 3884 6XL [empty string] 6XL 8303 827 CACHED false EXECUTIONTIME 3 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 827 2 3