SELECT * FROM (GNG_CAT_PART NATURAL JOIN GNG_CAT_PART_DESCRIPTION ) NATURAL JOIN GNG_PARTNER WHERE COD_LINGUA_CAT_PART = 'IT' AND ID_UTENTE_PARTNER = 140 GROUP BY ID_CAT_PART ORDER BY WEIGHT_CAT_PART

Partner

Cucine

torchetti cucine

 

Artec cucine

 

Febal cucine

 

Oikos cucine

 

Okite

 

Stone italia

 

Camerette

moretti compact

 

Colombini

 

Colombini/arcadia

 

Colombini/eresem

 

Colombini/golf

 

Ferri mobili

 

Zona giorno - zona notte

Accademia del mobile

 

Cecchini italia

 

Euro design

 

Gam&gam

 

Mercantini

 

Saber

 

Stilema

 

Veneran

 

Vitalyty/colombini

 

Divani

Colombin/sofup

 

Doimo salotti

 

Doimo sofas

 

Complementi

Astor

 

Birex

 

Colombini/idea

 

Doimo idea

 

Emporium

 

Friulsedie

 

Ideal lux

 

Ingenia/bontempi

 

Targhet

 

Tonin casa

 

Reti e materassi

Ennerev

 

Morrfeus