FILTER

Jackets & Coats

Sort By
Items per page:

  Raintech Rain Jacket Raintech Rain Jacket HORSE PILOT
query
RESULTSET
query
  AMOUNT FROM_PRICE ROUNDING TERM_SALE_ID TYP
CACHED false
EXECUTIONTIME 0
SQL SELECT b.typ,b.amount,b.term_sale_id, b.from_price,b.rounding FROM TB_TERM_SALES A WITH (NOLOCK) inner join TB_TERM_SALE_SETTING B WITH (NOLOCK) on (b.TERM_SALE_ID = a.TERM_SALE_ID) inner join TB_TERM_SALE_STORE C WITH (NOLOCK) on (c.TERM_SALE_ID = a.TERM_SALE_ID) inner join TB_FILTER_GROUP_HEADER D WITH (NOLOCK) on (d.FILTER_GROUP_HEADER_ID = b.FILTER_GROUP_HEADER_ID) inner join TB_FILTER_GROUP_DETAIL E WITH (NOLOCK) on (e.FILTER_GROUP_HEADER_ID = d.FILTER_GROUP_HEADER_ID) WHERE b.start_date<= '2024-11-21 13:18:00' AND b.end_date >= '2024-11-21 13:18:00' AND c.store_id = 1 AND a.approved='Y' AND e.FILTER_VALUE like '%RAIN124%' OR e.FILTER_VALUE like '%HORSE PILOT%'
$190.00

Sort By
Items per page: