FILTER

Sweaters & Sweatshirts

Sort By

Items per page:

Take Me To The Barn Crewneck Sweater

Take Me To The Barn Crewneck Sweater KASTEL DENMARK

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding FROM tb_styles a INNER JOIN TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID INNER JOIN TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID INNER JOIN TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID INNER JOIN TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID INNER JOIN TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID WHERE e.start_date<= '01/22/2026 23:59:00' AND e.end_date >= '01/22/2026 23:59:00' AND f.store_id=1 AND a.style_id=200705 AND d.approved='Y'

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding FROM tb_styles a INNER JOIN TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID INNER JOIN TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID INNER JOIN TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID INNER JOIN TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID INNER JOIN TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID WHERE e.start_date<= '01/22/2026 23:59:00' AND e.end_date >= '01/22/2026 23:59:00' AND f.store_id=1 AND a.style_id=200705 AND d.approved='Y'

Sailor Blue with Black

Sailor Blue with Black "Equestrian" Crewneck Sweater KASTEL DENMARK

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding FROM tb_styles a INNER JOIN TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID INNER JOIN TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID INNER JOIN TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID INNER JOIN TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID INNER JOIN TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID WHERE e.start_date<= '01/22/2026 23:59:00' AND e.end_date >= '01/22/2026 23:59:00' AND f.store_id=1 AND a.style_id=197336 AND d.approved='Y'

query
	AMOUNT	FROM_PRICE	ROUNDING	TERM_SALE_ID	TYP

SELECT e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding FROM tb_styles a INNER JOIN TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID INNER JOIN TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID INNER JOIN TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID INNER JOIN TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID INNER JOIN TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID WHERE e.start_date<= '01/22/2026 23:59:00' AND e.end_date >= '01/22/2026 23:59:00' AND f.store_id=1 AND a.style_id=197336 AND d.approved='Y'

Sort By

Items per page: