SELECT marche.descrizione as marca,marche.id_marca as id_marca FROM marche JOIN articoli ON marche.id_marca=articoli.id_marca WHERE tipologia='0' GROUP BY marche.id_marca ORDER BY marche.descrizione ASC 55 DSL BENETTON BENETTON JUNIOR BIKKEMBERGS Blue Bay BYBLOS Carrera CARRERA JUNIOR CARRERA SPORT Christian Dior D&G Daniel Swarovsky Cristal Eyewear Diesel DOLCE & GABBANA EKLISSE' Emporio Armani ESCADA EXTE FERRE' Frankie Morello Giorgio Armani Gucci Hugo Boss ICEBERG JOHN RICHMOND KILLER LOOP Lina Russo LOZZA Marc Jacobs MARK BY JACOBS Max Mara MOSCHINO Ottica Italy Junior Ottica Italy Selection Oxydo PERSOL PIERRE CARDIN Police POLO RALPH LAUREN PRADA PRADA SPORT RALPH RALPH LAUREN RASTERBRILLE Ray Ban RAY BAN JUNIOR Safilo Design SFEROFLEX SMITH OPTICS THF TOM FORD Valentino Vogue

55 DSL BENETTON BENETTON JUNIOR BIKKEMBERGS Blue Bay Carrera Christian Dior Compagnia Di Navigazione D&G Diesel DOLCE & GABBANA EKLISSE' Emporio Armani ESCADA EXTE FERRE' Giorgio Armani Gucci GUCCI JUNIOR Hugo Boss ICEBERG JOHN RICHMOND KILLER LOOP Lina Russo LOZZA LOZZA JUNIOR LUXOTTICA LX Marc Jacobs MARK BY JACOBS Max Mara MISSONI Ottica Italy Junior Ottica Italy Selection Oxydo PERSOL PIERRE CARDIN Police POLO RALPH LAUREN PRADA PRADA SPORT RALPH RALPH LAUREN Ray Ban RAY BAN JUNIOR Safilo Design SEVEN STREET SFEROFLEX SMITH OPTICS THF Valentino Vogue YvesSaintLaurent