"Trey" V Neck Sweater Essex Classics

query
RESULTSET	query   AMOUNT FROM_PRICE ROUNDING TERM_SALE_ID TYP
CACHED	false
EXECUTIONTIME	4
SQL	SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=188332 and a.approved='Y' ORDER BY a.term_sale_id desc

query
RESULTSET	query   AMOUNT FROM_PRICE ROUNDING TERM_SALE_ID TYP
CACHED	false
EXECUTIONTIME	0
SQL	SELECT b.typ,b.amount,a.term_sale_id, b.from_price , b.rounding FROM tb_term_sale_entries b LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id) LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id) WHERE b.start_date<= '2026-01-22 13:30:00' AND b.end_date >= '2026-01-22 13:30:00' and (b.store_id=1) and b.style_id=188332 and a.approved='Y' ORDER BY a.term_sale_id desc

$149.00