where Blocked='false' and Haspic='true' and Product_Id IN (SELECT `Product_id` FROM `tbl_product_inventory` WHERE `Inventory` > 0) and Brand='Young Versace' GROUP BY `StyleNo` order by id desc LIMIT 0, 15
Since the 1990s, Versace has established itself as an empire of Italian luxury. Super star of Italian haute couture, the elegantly exuberant house has fashion icons, pop stars and royals all in agreement. The Versace logo? The Medusa, in a wink to Greek mythology and the origins of the late Gianni Versace’s homeland. With an undeniable rock’n’roll spirit stitching all collections together, the brand’s children’s line Young Versace is all about fun prints, a lively mix of shapes and colors and reworking the brand’s iconic Greek fret and Medusa motifs in bright, cheerful hues.