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 = 5 AND a.idDiametro = 1 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Pin
Black
Black
Black
Machine stitched
Adjustable
Black
Black
Anthracite
Machine stitched
Pin
Black
Black
Écrue
Machine stitched
Adjustable
Grey
Beige
Grey
Machine stitched
Adjustable
Dark Blue
Beige
Anthracite
Machine stitched
Adjustable
Dark Brown
Brown
Écrue
Machine stitched
Adjustable
Dark Brown
Brown
Écrue
Machine stitched
Pin
Brown Antique
Beige
Écrue
Machine stitched
Adjustable
Gold
Beige
Écrue
Machine stitched
Adjustable
Orange
Beige
Orange
Machine stitched
Adjustable
Yellow
Beige
Yellow
Machine stitched
Adjustable
Light Blue
Beige
Light Blue
Machine stitched
Adjustable
Green
Beige
Green
Machine stitched
Adjustable
Red
Beige
Red
Machine stitched
Adjustable
Pink
Beige
Pink
Machine stitched
Adjustable
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 = 5 AND a.idDiametro = 2 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Adjustable
Black
Black
Black
Machine stitched
Pin
Black
Black
Anthracite
Machine stitched
Pin
Black
Black
Écrue
Machine stitched
Adjustable
Grey
Beige
Grey
Machine stitched
Adjustable
Dark Blue
Beige
Anthracite
Machine stitched
Adjustable
Dark Brown
Brown
Écrue
Machine stitched
Pin
Dark Brown
Brown
Écrue
Machine stitched
Adjustable
Brown Antique
Beige
Écrue
Machine stitched
Adjustable
Gold
Beige
Écrue
Machine stitched
Adjustable
Orange
Beige
Orange
Machine stitched
Adjustable
Yellow
Beige
Yellow
Machine stitched
Adjustable
Light Blue
Beige
Light Blue
Machine stitched
Adjustable
Green
Beige
Green
Machine stitched
Adjustable
Red
Beige
Red
Machine stitched
Adjustable
Pink
Beige
Pink
Machine stitched
Adjustable
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 = 5 AND a.idDiametro = 3 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Adjustable
Black
Black
Écrue
Machine stitched
Pin
Black
Black
Écrue
Machine stitched
Adjustable
Black
Beige
Black
Machine stitched
Pin
Dark Blue
Beige
Anthracite
Machine stitched
Adjustable
Dark Blue
Beige
Anthracite
Machine stitched
Pin
Burgundy
Beige
Burgundy
Machine stitched
Adjustable
Dark Brown
Brown
Écrue
Machine stitched
Pin
Dark Brown
Brown
Écrue
Machine stitched
Adjustable
Brown Antique
Beige
Écrue
Machine stitched
Adjustable
Brown Antique
Beige
Écrue
Machine stitched
Pin
Gold
Beige
Écrue
Machine stitched
Adjustable
Gold
Beige
Écrue
Machine stitched
Pin
Yellow
Beige
Yellow
Machine stitched
Pin
Yellow
Beige
Yellow
Machine stitched
Adjustable
Light Blue
Beige
Light Blue
Machine stitched
Pin
Light Blue
Beige
Light Blue
Machine stitched
Adjustable
Green
Beige
Green
Machine stitched
Pin
Green
Beige
Green
Machine stitched
Adjustable
Red
Beige
Red
Machine stitched
Pin
Red
Beige
Red
Machine stitched
Adjustable
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 = 5 AND a.idDiametro = 5 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Écrue
Hand stitched
Pin
Black
Beige
Black
Hand stitched
Pin
Black
Beige
Black
Hand stitched
Adjustable
Dark Blue
Beige
Dark Blue
Hand stitched
Adjustable
Dark Brown
Brown
Dark Brown
Hand stitched
Adjustable
Dark Brown
Brown
Écrue
Hand stitched
Adjustable
Dark Brown
Brown
Écrue
Hand stitched
Pin
Brown Antique
Beige
Écrue
Hand stitched
Adjustable
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 = 5 AND a.idDiametro = 6 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Hand stitched
Adjustable
Black
Black
Black
Hand stitched
Pin
Black
Black
Écrue
Hand stitched
Pin
Dark Blue
Beige
Dark Blue
Hand stitched
Adjustable
Dark Brown
Brown
Dark Brown
Hand stitched
Adjustable
Dark Brown
Brown
Écrue
Hand stitched
Pin
Dark Brown
Brown
Écrue
Hand stitched
Adjustable
Brown Antique
Beige
Écrue
Hand stitched
Adjustable