select * from ss_products p LEFT JOIN ss_crosssell x
ON p.ss_sku = x.ss_sku
where p.ss_productfield12!='DSC' and p.ss_productfield6!='' and p.ss_productfield4!='' and p.ss_productsid in (select ss_childid from ss_crosssell where ss_sku='0023111224') group by p.ss_sku order by p.ss_name limit 4
Schott Zwiesel Tritan Bar Special Sherry , SingleSchott Zwiesel0023111224
Product description:Schott Zwiesel Tritan Crystal composition is the hardest most brilliant crystal glass in the world. Tritan Crystal by Schott Zwiesel will maintain its brilliance and look for the life of the glass. The Tritan Bar Special Sherry is resistant to discoloration, scratching, cloudy appearance, spotting, stains or breakage. Its simple and elegant design makes it perfect for any occasion. 4oz
Schott Zwiesel, the famed German producer based in one of the world's prime glass-manufacturing centers, has led the glass industry for more than 100 years. The company has many industry "first" to its credit, including the first fully automated production of blown glass stemware in 1967. In the 1990's as the industry struggled with the environmental issues of lead and heavy metals, the company was the first glassmaker to produce lead-free crystal glass of superb quality and brilliance.
Tritan, Break Resistant Stemware
Its latest breakthrough is the patented Tritan technique for producing extra-strong crystalline stemware. The process combines a proprietary mix of materials with tempering of vulnerable points to create the most resilient fine stemware in the world.
Schott Zwiesel is a leading producer of high quality crystalline glassware.