Filter Products

Outerware

Material

  • 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] LRG 1812 0.00 -45 3713 LRG [empty string] LRG 708 406
    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] MED 1812 0.00 30 3714 MED [empty string] MED 709 406
    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] XL 1812 0.00 -85 3715 XL [empty string] XL 710 406
    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] 2XL 1812 0.00 5 3716 2XL [empty string] 2XL 711 406
    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 1812 0.00 -4 3717 6 [empty string] 6 712 406
    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 1812 0.00 -5 3718 8 [empty string] 8 713 406
    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 1812 0.00 5 3719 10 Inch [empty string] 10 Inch 714 406
    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 1812 0.00 21 3720 12 [empty string] 12 715 406
    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] SML 1812 0.00 -9 3721 SML [empty string] SML 6751 406
    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] 3XL 1812 0.00 27 3722 3XL [empty string] 3XL 6752 406
    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 406
    2 3