where Blocked='false' and Haspic='true' and Product_Id IN (SELECT `Product_id` FROM `tbl_product_inventory` WHERE `Inventory` > 0) and Brand='Dolce and Gabbana' GROUP BY `StyleNo` order by id desc LIMIT 0, 15
Domenico Dolce and Stefano Gabbana are nothing short of masters of Italian fashion. Their brand saw the light of day in 1985, and Dolce & Gabbana have been ruling the fashion podium since, delighting celebrities and fashionistas worldwide with their signature codes. Inspired by its motherhouse, Dolce & Gabbana kids offers the same beautifully-inspired clothing for boys, girls and babies alike. From mini-me pieces, to casual kid’s fashions, Dolce & Gabbana gives kid’s wardrobes a luxurious makeover, all Italiana.