Les Pommettes
Les Pommettes
Clu Maille Burnt Umber Sweater with Silk$475.00
Mes Demoiselles Rainbow Boxy Sweater$455.00
Nili Lotan Dolman V-Neck Sweater in Grey$390.00
Ramy Brook Raven Maxi Cardigan$475.00
Echo Texture Ruana Wrap in Black$95.00
Mes Demoiselles Jadis Knitted Cardigan$345.00
Echo Texture Ruana Wrap in Grey$95.00
Clu Draped Side Cardigan in Taupe$245.00
Wilt Shrunken Crop Sweatshirt in Tan$135.00
Mes Demoiselles Jimmy Knitted Jacket$625.00
Echo Ruana Wrap with Faux Fur Collar in Cream$75.00
Clu Hooded Sweatshirt with Cotton Trim in Grey/Blue$315.00
Nili Lotan Stripe Georgica Hoodie$310.00
Nili Lotan Bias Pullover$455.00
Mes Demoiselles Jimmy Knitted Jacket in Pink$625.00
Clu Chantilly Lace Trimmed Heather Cardigan$255.00
Wilt Textured Big Backslant Sweater$230.00
Wilt Taupe Asymmetrical Drape Sweatshirt$140.00
Nili Lotan U-Neck Pullover$465.00
Nili Lotan Dolman V-Neck Sweater in Black$390.00
Clu Cardigan in Grey with Silk Detailing$325.00
Wilt French Terry Crop Shrunken Raglan Sweatshirt in White$135.00
Humanoid Hold Knitted Cardigan$545.00
Clu Ruffle Trim Cardigan in Dusty Rose$260.00
Humanoid Him Cardigan in Curry$470.00
Humanoid Hint Sweater$425.00

select distinct p.products_image, pd.products_name, p.products_image, pd.products_name, p.products_id, p.products_sort, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products_sort, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where (p.products_status = 1) and p2c.categories_id != 70 and p.products_id = p2c.products_id and products_sort.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (p2c.categories_id = '25') and products_sort.cPath = '25' GROUP BY p.products_id order by products_sort.sortBy ASC