EZ Packable Vest TKEQ

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 '%VESTEZ%' OR e.FILTER_VALUE like '%TKEQ%'

$115.00