SELECT b.nome as colore, b.chromic_order as ordine1, c.nome as rivestimentoInterno, c.chromic_order as ordine2, d.nome as coloreCucitura, d.chromic_order as ordine3, e.nome as tipoCucitura, f.nome as chiusura, a.texture, a.idDiametro, g.diametro FROM `#__accessori_content` AS a LEFT JOIN #__colori AS b ON a.idColore = b.id LEFT JOIN #__rivestimento_accessori_interno AS c ON c.id = a.idRivestimentoInterno LEFT JOIN #__colori AS d ON a.idColoreCucitura = d.id LEFT JOIN #__tipo_cucitura AS e ON a.idTipoCucitura = e.id LEFT JOIN #__chiusure_type AS f ON a.idChiusura = f.id LEFT JOIN #__diametri_cassa AS g ON a.idDiametro = g.id WHERE a.accessorioId = 42 AND a.idDiametro = 2 AND a.published = 1 ORDER BY ordine1,ordine2,ordine3 ASC