daterecieved) from inventorytransactions where producttypeind = 'F ' and inventorytransactions. (select top 1 (quantitypurchased - quantitysold) from inventorylocation where producttypeind = 'F' and inventorylocation.productid = emid and inventorylocation.locationid = orders.locationid) onhand, domain not in ( 'Remake ')) as discount_reason, order_detail.eyesize, order_detail.bridgesize, order_detail.a, order_detail.b, order_detail.ed, order_detail.templelength, WHEN 'KLiiK:denmark - Westgroupe ' THEN 'Westgroupe ' WHEN 'FYSH UK - Westgroupe ' THEN 'Westgroupe ' WHEN 'Superflex - Westgroupe ' THEN 'Westgroupe ' WHEN 'Hart-New York Eye ' THEN 'Medicaid ' WHEN 'Via Roma Collection ' THEN 'Medicaid - NYE ' WHEN 'Titan next generaton nylor ' THEN 'Silhouette ' WHEN 'Titan Next Generation ' THEN 'Silhouette ' WHEN 'Titan Dynamics ' THEN 'Silhouette ' WHEN 'SuperFlex Kids Collection ' THEN 'SuperFlex ' WHEN 'SuperFlex Collection ' THEN 'SuperFlex ' WHEN 'SPX Signia Nylor ' THEN 'Silhouette ' WHEN 'Silhouette Radiance ' THEN 'Silhouette ' WHEN 'Shapelite ' THEN 'Silhouette - Adidas '

WHEN 'Rec Specs Collection ' THEN 'Liberty Sport ' WHEN 'Performance Youth ' THEN 'Silhouette - Adidas ' WHEN 'Oakley Frame ' THEN 'Oakley Ophthalmic ' WHEN 'LT Collection ' THEN 'Lightec Collection ' WHEN 'Delta 1A US ' THEN 'Lightec Collection ' WHEN 'SPX Signia Carbon ' THEN 'Silhouette ' WHEN 'Liberty Sport Sun Performance Collection ' THEN 'Liberty Sport ' WHEN 'Jubilee Collection ' THEN 'Medicaid - NYE ' WHEN 'Jelly Bean Collection ' THEN 'Medicaid - Jelly Bean ' WHEN 'Illusion Nylor ' THEN 'Silhouette ' WHEN 'Focus Collection ' THEN 'Medicaid - Focus ' WHEN 'F8 Collection ' THEN 'Liberty Sport ' WHEN 'Titan Minimal Art Collection ' THEN 'Silhouette ' WHEN 'Titan Elements ' THEN 'Silhouette ' WHEN 'Titan Dynamics Half Rim ' THEN 'Silhouette ' WHEN 'FYSH UK Collection ' THEN 'FYSH UK - Westgroupe/Eyewear ' WHEN 'streamlite ' THEN 'Silhouette - Adidas ' WHEN 'SPX Connection ' THEN 'Silhouette ' WHEN 'Silhouette Collection ' THEN 'Silhouette ' WHEN 'Performance Sport Golf ' THEN 'Silhouette - Adidas ' WHEN 'Performance Sport ' THEN 'Silhouette - Adidas ' WHEN 'Op-Ocean Pacific Kids Collection ' THEN 'Op-Ocean Pacific Collection ' WHEN 'Oakley Polarized ' THEN 'Oakley Sunglasses ' WHEN 'Nepenthe 3 ' THEN 'Koali Collecton ' WHEN 'Lite Fit Youth ' THEN 'Silhouette - Adidas ' WHEN 'Lite Fit ' THEN 'Silhouette - Adidas ' WHEN 'Lazair ' THEN 'Silhouette - Adidas ' WHEN 'Inspired 2D ' THEN 'Silhouette - Adidas ' WHEN 'Copenhagen 3 ' THEN 'OGA Collection ' WHEN 'Compose ' THEN 'Silhouette - Adidas ' WHEN 'Boulevard Boutique New Dawn Collection ' THEN 'Medicaid - NYE ' WHEN 'Baseline Collection ' THEN 'Safety Frames ' WHEN 'Titan Accent Flora ' THEN 'Silhouette ' WHEN 'Titan Minimal Art Pulse ' THEN 'Silhouette '

WHEN 'Polaroid Premiu Collection ' THEN 'Polaroid Premium Collection ' WHEN 'Titan Dynamics Nylor ' THEN 'Silhouette ' WHEN 'Titan Next Generation III ' THEN 'Silhouette ' WHEN 'Minimal X Kids ' THEN 'Silhouette '

Westgroupe superflex