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 = 13 AND a.idDiametro = 1 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Adjustable
Gold
Beige
Gold
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 = 13 AND a.idDiametro = 2 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Adjustable
Gold
Beige
Gold
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 = 13 AND a.idDiametro = 3 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Machine stitched
Adjustable
Black
Black
Beige
Machine stitched
Pin
Black
Black
Beige
Machine stitched
Pin
Burgundy
Beige
Black
Machine stitched
Pin
Gold
Gold
Gold
Hand stitched
Pin
Gold
Beige
Gold
Machine stitched
Adjustable
Gold
Beige
Gold
Machine stitched
Pin
Gold
Beige
Gold
Hand stitched
Pin
Gold
Beige
Yellow
Machine 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 = 13 AND a.idDiametro = 5 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Hand stitched
Pin
Black
Black
Écrue
Hand stitched
Pin
Burgundy
Beige
Burgundy
Hand stitched
Pin
Gold
Beige
Gold
Hand stitched
Pin
Gold
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 = 13 AND a.idDiametro = 6 AND a.published = 1
ORDER BY ordine1,ordine2,ordine3 ASC
Black
Black
Black
Hand stitched
Pin
Black
Black
Écrue
Hand stitched
Pin
Burgundy
Beige
Burgundy
Hand stitched
Pin
Gold
Beige
Gold
Hand stitched
Pin
Gold
Beige
Écrue
Hand stitched
Pin