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