Welcome, | Logout
IMG
Loading..
Selected: Maroon/Blue
8" X 45" Paisley Collection Silk Scarves Maroon-Blue
Item: TS-PAIS-0323-845
QTY:
Item: TS-PAIS-0323-845-M/B
List Price $26.20
Maroon and blue 100% silk, 8" x 45" Paisley patterned wet dyed scarf. Available in black and grey paisley, navy blue and maroon paisley, maroon and blue paisley, and gold and blue paisley. Complimenting tie available. Embroidery and screen printing available - 3" x 3" maximum imprint area. Price shown is for the blank item only and does not include decoration.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = 'TS-PAIS-0323-845') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`
mgctlbxN$MZP mgctlbxV$5.1.14 mgctlbxL$C